The Phoenix Resort has recently converted to an Activity Based Cost System. The
ID: 2571936 • Letter: T
Question
The Phoenix Resort has recently converted to an Activity Based Cost System. The owner was willing to make the costly conversion in order to obtain more accurate income data for each profit center and make better business decisions.
The Profit Centers are Hotel Operations, Food Service, Gift Shop, Tours, and Gas/Convenience Store.
The new cost system has four direct cost pools and six indirect cost pools. The indirect costs have been traced to the following activities: General Administration, Record Keeping, Purchases, Facilities, Marketing, and Maintenance. The Resort uses an Actual Costing System rather than a Normal Costing System. The following indirect cost activity data was collected for the first quarter.
Activity
General
Administration
Record Keeping
Purchases
Facilities
Marketing
Maintenance
Cost Pool
$75,324
$6,872
$5,001
$27,900
$25,000
$13,119
Cost Driver
Facilities Modified*
Journal Entries
Purchase Orders
Square Feet
Sales Dollars
Repair Orders
*Because Hotel Operations is by far the largest, it will get half the cost. The remainder is allocated as follows: Food Service 2/5, Gas/Convenience Store 2/5, Gift Shop 1/10, and Tours 1/10.
First Quarter Financial & Activity Data
Direct Costs Or Revenue
Hotel
Operations
Food Service
Gas/Convenience Store
Gift Shop
Tours
Sales
$264,842
$132,421
$92,319
$57,096
$29,222
Cost of Sales
N/A
$59,372
$43,899
$23,838
N/A
Employee Salary
$108,922
$8,222
$10,080
$4,200
$6,120
Supervision
$32,000
$29,812
$22,883
$15,818
$15,818
Permits and Other
$8,488
$3,919
$552
$109
$3,900
Journal Entries
2,017
1,268
916
158
97
Purchase Orders
103
97
88
22
4
Square Feet
18,000
4,000
3,500
600
50
Repair Orders
558
212
46
2
112
Requirements:
Create a quarterly Income Statement for the resort as a whole.
Create one quarterly Income Statement that show each profit center and the resort as a whole.
Activity
General
Administration
Record Keeping
Purchases
Facilities
Marketing
Maintenance
Cost Pool
$75,324
$6,872
$5,001
$27,900
$25,000
$13,119
Cost Driver
Facilities Modified*
Journal Entries
Purchase Orders
Square Feet
Sales Dollars
Repair Orders
Explanation / Answer
Cost assignment statement -- Activity based costing Cost driver Hotel operations Food service Gas/ convenence store Gift Shop Tours Activity Cost pool Name Units Cost per Units cost Units cost Units cost Units cost Units cost Unit General Administration 75324 Facilities modified 50% 37662 20% 15065 20% 15065 5% 3766 5% 3766 Record keeping 6872 Journal entries 4456 1.54219 2017 3111 1268 1955 916 1413 158 244 97 150 Purchases 5001 Purchase orders 314 15.92675 103 1640 97 1545 88 1402 22 350 4 64 Facilities 27900 Square feet 26150 1.066922 18000 19205 4000 4268 3500 3734 600 640 50 53 Marketing 25000 Sales dollars 575900 0.04341 264842 11497 132421 5748 92319 4008 57096 2479 29222 1269 Maintenance 13119 Repair orders 930 14.10645 558 7871 212 2991 46 649 2 28 112 1580 T o t a l 153216 80986 31572 26270 7507 6881 Quarterly income statement for the resort as a whole Costs and Revenue Amount Sales 575900 Direct costs: Cost of Sales 127109 Employee Salary 137544 Supervision 116331 Permits and Other 16968 Total direct costs 397952 Gross margin 177948 Indirect costs: General Administration 75324 Record keeping 6872 Purchases 5001 Facilities 27900 Marketing 25000 Maintenance 13119 Total indirect costs 153216 Net operating income 24732 Quarterly income statement for the resort as a whole Costs and Revenue Hotel operations Food service Gas/Convenience store Gift Shop Tours Amount Store Sales 264842 132421 92319 57096 29222 575900 Direct costs: Cost of Sales 0 59372 43899 23838 0 127109 Employee Salary 108922 8222 10080 4200 6120 137544 Supervision 32000 29812 22883 15818 15818 116331 Permits and Other 8488 3919 552 109 3900 16968 Total direct costs 149410 101325 77414 43965 25838 397952 Gross margin 115432 31096 14905 13131 3384 177948 Indirect costs: General Administration 37662 15065 15065 3766 3766 75324 Record keeping 3111 1955 1413 244 149 6872 Purchases 1640 1545 1402 350 64 5001 Facilities 19205 4268 3734 640 53 27900 Marketing 11497 5748 4008 2479 1268 25000 Maintenance 7871 2991 649 28 1580 13119 Total indirect costs 80986 31572 26271 7507 6880 153216 Net operating income 34446 -476 -11366 5624 -3496 24732
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.