Question

In: Finance

Manufacturing overhead Amount Cost driver Standard Guest Room Junior Suite Presidential Suite Depreciation $3,200,000 Square feet...

Manufacturing overhead Amount Cost driver Standard Guest Room Junior Suite Presidential Suite
Depreciation $3,200,000 Square feet 50,000 30,000 30,000
Maintenance $1,800,000 Direct labor hours 180,000 143,000 148,500
Purchasing $320,000 # of purchase orders 2,500 1,500 9,000
Inspection $850,000 # of inspections 1,000 850 3,500
Indirect $490,000 Units manufactured 150 110 25
materials
Supervision $1,700,000 # of inspections 1,000 850 3.5
Supplies $190,000 Units manufactured 150 110 25

6. Why are the costs different between the traditional method and the activity-based method?

7. At the current selling price, is the company covering its true cost of production of the Presidential Suite? Briefly discuss.

8. What should price should Choice Hotels charges for the Presidential Suite?

9. Assume that the Presidential Suite has the same profit margin as the Standard Guest Room. What should its selling price be? Show all calculations.

10. What should Choice Hotels do if the quantity of the Presidential Suite Guest Rooms sold at the new price falls to 10 per year?

11. What should Choice Hotels do if the price of the Presidential Suite cannot exceed $1,050,000?

12. At a selling price of $1,050,000 each, what is the breakeven unit volume for the Presidential Suite?

13. What are the lessons learned from this case?

Solutions

Expert Solution

6. In traditional method a single rate is applied to total overhead costs of a manufacturing unit or a manufacturing division or a cost center. The rate may be based on direct labor hour/machine hour / unit of output etc.

Using traditional methods, Overhead costs to Standard Guest Room, Junior suit and Presidential suits would have been allocated using a single rate of Dollar per direct labor hour

Under the activity based costing method, costs are allocated to activity cost pools (like purchasing, inspection, maintenance etc) based on the cost driver which may be different for different activity. Overheads are allocated to products   based on the resources consumed.

Activity Cost Pool

Cost Driver

Maintenance

Direct Labor hour

Depreciation

Square feet

purchasing

# of purchase order

Inspection

# of inspection

Indirect materials

Units manufactured

Supervision

# of inspection

Supplies

Units manufactured

Instead of one rate, seven rates are used to allocated overhead costs to products based on activity level or resources consumed

Activity based costing reflects more accurate cost allocation

7. Cost of Presidential   suite:

Activity Cost Pool

Total Cost

Allocated to Presidential Suite

Calculation

Maintenance

$1,800,000

$       566,914

(1800000/(180000+143000+148500))*148500

Depreciation

$3,200,000

$       872,727

(3200000/(50000+30000+30000))*30000

purchasing

$320,000

$       221,538

(320000/(2500+1500+9000))*9000

Inspection

$850,000

$            1,605

(850000/(1000+850+3.5))*3.5

Indirect materials

$490,000

$          42,982

(490000/(150+110+25))*25

Supervision

$1,700,000

$            3,210

(1700000/(1000+850+3.5))*3.5

Supplies

$190,000

$          16,667

(190000/(150+110+25))*25

TOTAL

$8,550,000

$1,725,644

Units manufactured=25

Cost per unit manufactured=1725644/25=$69,026

Amount to be charged =Cost +Profit percentage

Assuming 30% on cost;

Price to be charged=69026*1.3=$89,733


Related Solutions

Manufacturing overhead Amount Cost driver Standard Guest Room Junior Suite Presidential Suite Depreciation $3,200,000 Square feet...
Manufacturing overhead Amount Cost driver Standard Guest Room Junior Suite Presidential Suite Depreciation $3,200,000 Square feet 50,000 30,000 30,000 Maintenance $1,800,000 Direct labor hours 180,000 143,000 148,500 Purchasing $320,000 # of purchase orders 2,500 1,500 9,000 Inspection $850,000 # of inspections 1,000 850 3,500 Indirect $490,000 Units manufactured 150 110 25 materials Supervision $1,700,000 # of inspections 1,000 850 3.5 Supplies $190,000 Units manufactured 150 110 25 Total $8,550,000 234,800 176,420 191,054 Calculate the cost of one Presidential Suite using...
Angie Manufacturing uses a standard cost system in which manufacturing overhead is applied to units of...
Angie Manufacturing uses a standard cost system in which manufacturing overhead is applied to units of product on the basis of standard machine-hours. At standard, each unit of product requires one machine-hour to complete. The standard variable overhead is $1.75 per machine-hour and Budgeted Fixed Manufacturing Costs are $300,000 per year. The denominator level of activity is 150,000 machine-hours, or 150,000 units. Actual data for the year were as follows: Actual variable overhead cost $ 211,680 Actual fixed manufacturing overhead...
The standard variable overhead cost rate for Harris Manufacturing is $30.00 per unit. Budgeted fixed overhead...
The standard variable overhead cost rate for Harris Manufacturing is $30.00 per unit. Budgeted fixed overhead cost is $38,700. Harris Manufacturing budgeted 4,300 units for the current period and actually produced 4,400 finished units. What is the fixed overhead volume​ variance? Assume the allocation base for fixed overhead costs is the number of units expected to be produced. A. $900 favorable B. $3,000 favorable C. $3,000 unfavorable D. $900 unfavorable
Data 4 Allocation base Machine-hours 5 Estimated manufacturing overhead cost $448,000 6 Estimated total amount of...
Data 4 Allocation base Machine-hours 5 Estimated manufacturing overhead cost $448,000 6 Estimated total amount of the allocation base 70,000 machine-hours 7 Actual manufacturing overhead cost $436,600 8 Actual total amount of the allocation base 77,000 Machine hours a) What is the predetermined overhead rate? (Round your answer to 2 decimal places.)        (b) By how much is the manufacturing overhead underapplied or overapplied? Either print or make a copy of your worksheet in your workbook before proceeding. You will...
Job Cost Sheet Job Number Date  Initiated Item Date completed Direct Matarials Direct Labor Manufacturing Overhead Amount...
Job Cost Sheet Job Number Date  Initiated Item Date completed Direct Matarials Direct Labor Manufacturing Overhead Amount Hours Rate Amount Hours Rate Amount Cost Summary Direct Materials Direct Labor Manufacturing Overhead Total Product Cost Unit Product Cost QUESTION 1 Step 1 You work for Thunderduck Custom Tables Inc. This is the first month of operations. The company designs and manufactures specialty tables. Each table is specially customized for the customer. This month, you have been asked to develop and manufacture two...
Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows:
Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows:  Direct materials: 5 pounds at $8.00 per pound$40.00       Direct labor: 2 hours at $14 per hour28.00       Variable overhead: 2 hours at $5 per hour10.00       Total standard cost per unit$78.00     The planning budget for March was based on producing and selling 25,000 units. However, during March the company actually produced and sold 30,000 units...
Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows
  Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows:     Direct material: 5 pounds at $8.00 per pound $ 40.00 Direct labor: 4 hours at $15 per hour   60.00 Variable overhead: 4 hours at $5 per hour   20.00 Total standard variable cost per unit $ 120.00   The company also established the following cost formulas for its selling...
Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows:
  Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows:     Direct material: 6 pounds at $8.00 per pound $ 48.00 Direct labor: 3 hours at $14 per hour   42.00 Variable overhead: 3 hours at $5 per hour   15.00 Total standard variable cost per unit $ 105.00   The company also established the following cost formulas for its selling...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT