can you help answer question 2 with the right calculatuons?

VE on a due way u agruveau sus proucis. 2. Choice Hotels' production manager proposes allocating overhead by direct labor hours instead, since the different models require different amounts of labor. How much overhead would be allocated to each guest room (per unit and in total) using this method? Show all supporting calculations. of The Five HeartbeatsProject 3 Choice Hotels Workbook 2201 final (1) - Last Modified: February 11. Sanita Spencer $ Data Review View Help General Wrap Test Merge & Center Alignment $ % -99 DE SEXE A O Conditional Format as Cell Insert Delete Format Sort & Find & Formatting Table Styles Filter -Select- Cells Editing Styles No. Overhead Costs Type Cost Choice Hotels Sales, Production, and Cost Information Standard Guest Presidential Room Type Junior Suite Room Suite Volume 150 110 2 5 Price $140,000 $240,000 $1,050,000 Unit costs Direct $20,000 $92,000 $310,000 materials Direct labor $54,000 $85,000 $640,000 Depreciation Maintenance Purchasing $3.200.000 $1,800,000 $320,000 Inspection $850,000 Indirect trials S490,000 Manufacturing $30,000 $30,000 $30,000 Supervision $1,700,000 overhead $190,000 Supplies Total manufacturing webol Total unit cost $114,000 $207,000 S8.550.000 $980000 Unit gross profit $26.000 $33,000 $70,000 Note: Manufacturing overhead costs are fixed. They do not very with the volume of manufacturing Direct labor 1200 1.300 $45.00 9.00 $65.38 $107.74 Rate per hour Balance Sheet Cash Flow cost and Investing budget and forecast Calibri General -AASE 12 E Wrap Text B Merge & Center - $ % board Font Alignment Number C D E F G Choice Hotels has contracted with a mid-size furniture manufacturer for the production of guestroom furniture for three models of guest rooms: the standard guest room, Junior Suite, and Presidential Suite. The Standard Guest Room comes with basic furniture, bathroom plan, and amenities. It sells for $140,000 to franchise hotels The Junior Suite model is larger and includes an enhanced furniture selection, opgraded bathroom fixtures, more Comfortable bedding. The guest room is considered an upgrade from the standard guestroom model. The Junior Suite sells for $240,000 to franchise hotels. The Presidential Suite model is a custom-made guest room with floors and walls constructed from specialty wood. The drapes are made from the traditional flax-based canvass. It has the look and feel of a room in the White House, with modern comforts and security. The Presidential Suite sells for $1,050,000 to franchise hotels. Workers who build the Presidential Suite are specialized craftsmen. They earn twice the hourly rate of those working on the Standard Guest Room and Junior Suite models. The labor rate is fully burdened to include benefits. Most of Choice Hotels' guest room sales come from the Standard Guest Room and the Junior Suite, but sales of the Presidential Suite model have been growing. The company's sales, production, and cost information for last 11 year is provided to the right. Instructions income StatementB alance Sheet Cash Flow Cost and Investing Budget and F E O Type here to search 0 a $ - e w VE on a due way u agruveau sus proucis. 2. Choice Hotels' production manager proposes allocating overhead by direct labor hours instead, since the different models require different amounts of labor. How much overhead would be allocated to each guest room (per unit and in total) using this method? Show all supporting calculations. of The Five HeartbeatsProject 3 Choice Hotels Workbook 2201 final (1) - Last Modified: February 11. Sanita Spencer $ Data Review View Help General Wrap Test Merge & Center Alignment $ % -99 DE SEXE A O Conditional Format as Cell Insert Delete Format Sort & Find & Formatting Table Styles Filter -Select- Cells Editing Styles No. Overhead Costs Type Cost Choice Hotels Sales, Production, and Cost Information Standard Guest Presidential Room Type Junior Suite Room Suite Volume 150 110 2 5 Price $140,000 $240,000 $1,050,000 Unit costs Direct $20,000 $92,000 $310,000 materials Direct labor $54,000 $85,000 $640,000 Depreciation Maintenance Purchasing $3.200.000 $1,800,000 $320,000 Inspection $850,000 Indirect trials S490,000 Manufacturing $30,000 $30,000 $30,000 Supervision $1,700,000 overhead $190,000 Supplies Total manufacturing webol Total unit cost $114,000 $207,000 S8.550.000 $980000 Unit gross profit $26.000 $33,000 $70,000 Note: Manufacturing overhead costs are fixed. They do not very with the volume of manufacturing Direct labor 1200 1.300 $45.00 9.00 $65.38 $107.74 Rate per hour Balance Sheet Cash Flow cost and Investing budget and forecast Calibri General -AASE 12 E Wrap Text B Merge & Center - $ % board Font Alignment Number C D E F G Choice Hotels has contracted with a mid-size furniture manufacturer for the production of guestroom furniture for three models of guest rooms: the standard guest room, Junior Suite, and Presidential Suite. The Standard Guest Room comes with basic furniture, bathroom plan, and amenities. It sells for $140,000 to franchise hotels The Junior Suite model is larger and includes an enhanced furniture selection, opgraded bathroom fixtures, more Comfortable bedding. The guest room is considered an upgrade from the standard guestroom model. The Junior Suite sells for $240,000 to franchise hotels. The Presidential Suite model is a custom-made guest room with floors and walls constructed from specialty wood. The drapes are made from the traditional flax-based canvass. It has the look and feel of a room in the White House, with modern comforts and security. The Presidential Suite sells for $1,050,000 to franchise hotels. Workers who build the Presidential Suite are specialized craftsmen. They earn twice the hourly rate of those working on the Standard Guest Room and Junior Suite models. The labor rate is fully burdened to include benefits. Most of Choice Hotels' guest room sales come from the Standard Guest Room and the Junior Suite, but sales of the Presidential Suite model have been growing. The company's sales, production, and cost information for last 11 year is provided to the right. Instructions income StatementB alance Sheet Cash Flow Cost and Investing Budget and F E O Type here to search 0 a $ - e w