Finance statement questions

profileNoJudgement
CHHvsMARCostandInvestingCharts.pdf

Room Type Standard 

Guest Room Junior Suite

Presidential  Suite

Type Cost

Volume 150 110 25 Depreciation $3,200,000  Price $140,000  $240,000  $1,050,000  Maintenance $1,800,000 

Unit costs Purchasing $320,000 

Direct materials $30,000  $92,000  $310,000  Inspection $850,000 

Direct labor $54,000  $85,000  $640,000  Indirect  materials

$490,000 

Manufacturing $30,000  $30,000  $30,000  Supervision $1,700,000  overhead Supplies $190,000 

Total unit cost $114,000  $207,000  $980,000  Total 

manufacturing  overhead cost

$8,550,000 

Unit gross profit $26,000  $33,000  $70,000 

Direct labor hours 1,200 1,300 5,940

Rate per hour $45.00  $65.38  $107.74 

Choice Hotels’ controller developed the following data for use in activity‐based costing: Complete the calculations to help you answer the questions below

Manufacturing overhead Amount Cost driver Standard Guest 

Room Junior Suite

Presidential  Suite

Total Square Feet Cost per square 

foot Standard Guest 

room Junior Suite

Presidential  Suite

Check

Depreciation $3,200,000  Square feet 50,000 30,000 30,000 110,000  $              29.09   $             1,454,545   $          872,727   $         872,727   $         3,200,000 

Maintenance $1,800,000  Direct labor 

hours 180,000 143,000 148,500 471,500  $                3.82   $                 687,169   $          545,917   $         566,914   $         1,800,000 

Purchasing $320,000  # of purchase 

orders 2,500 1,500 9,000 13,000  $              24.62   $                   61,538   $            36,923   $         221,538   $            320,000 

Inspection $850,000  # of inspections 1,000 850 3,500 5,350  $            158.88   $                 158,879   $          135,047   $         556,075   $            850,000 

Indirect $490,000  Units 

manufactured 150 110 25 285  $        1,719.30   $                 257,895   $          189,123   $           42,982   $            490,000 

Supervision $1,700,000  # of inspections 1,000 850 3.5 1,854  $            917.18   $                 917,184   $          779,606   $              3,210   $         1,700,000 

Supplies $190,000  Units 

manufactured 150 110 25 285  $            666.67   $                 100,000   $            73,333   $           16,667   $            190,000 

Total $8,550,000  234,800 176,420 191,054 492,274 3,490  $        3,637,209.02   $ 2,632,676.38   $2,280,113.60   $         8,550,000 

Overhead Costs

Note : Manufacturing overhead costs are fixed. They  do not vary with the volume of manufacturing  activity.

Choice Hotels Sales, Production, and Cost Information