Question: A HOMEWORK SHOULD DONE ON EXCEL, could u please helpp, i really need your help solvers!!! Ce blow information for Costo Luxury Fund and build
Ce blow information for Costo Luxury Fund and build factory-made, premium wood for home All are of white ook. Its Indented maturing for the year 2017 a fos. Overhead Cost Pools Amont (3) Purchasing -15.00 Handling materials SOKKI Prolotion (uttimilling, 132.000 Setting up marlines 85.000 Ingin GO Inventory coatrol (ww materials and find goods) 80.000 Utilities 100.00 For the last Luxury Furniture has been cluingwhead to product caters of material cont. For the year 2017, materials.cost of $50.000 ure budete Jim Briche manager of luxury Furniture, recently directed his commit. Bab Block, to implement the activity based contrate that he repeatedly proponed. At Jim Brichtequest, Rob and the production comman identify the following costs and their age for the previosly bleed wethouder pool Overhead Cost Pools Activity Cox Drivers Fxpected Use of Cost Drivers Purchase Number of orders Handling materiale Number of iones 5.500 Productiou (cuttm inilling, finishing) Dinc labor hours 65.000 Setting up mich Number of 1,200 Inspecting Number of spection 4.700 Inventory control mw materials and finished) Numbraceapourite 30,00 Utilities Square feet occupied to Debble Steln, sales manager, medan seder for 12 luery annutes from Thomslutetior Design At De request, Bob pares con estimates is percing 12 arties so Debbie ca amit a contact price per armoire to Thom's. He mases the following data for the production of 12 armoire DM C DL Cost (5) DE. How Number of Purdu. Orders Number of Material Movie Number of Machine Se Number of loptice Number of Component Number of Suste et copied 3.700 1.000 200 3 32 4 20 65.00 320 Q-) What is the unit manufacturing cost per armoire de traditional conting? Q-6) What is the unit manufacturing per armoire der the proposed city bad costing! Use below information for Question 7 to 10 Jane Boforan operates a bed and breakfast heel in stala Miche. Depreciation on the hotel is $60.000 per year Jone employs maintenance person at an amal salary of $11.000 and a chaing pesat antal salary of $24,00KL Teal estate than $10.200 per year. The rooms at an average price of $125 per person per tight including breakfast. Other costs are laundry and doing crvice at a cost of 8102 per person per night and the cost of food which $57 per person per night. Q.7) Determine the sales rewe Janes to break even Q-8) Determine the ber of rentals Jane bedste mataget et income of $50.00 (Do NOT round the rest number to inw Refer to the comides for the calculation of The Net Income Qu9) Jane is condering changing the businesses. She comes installing ditional cleaning chines which will decrean landry and cleaning service pet prop by 83. However, the percention cod will increase by $4.070, Tetermine the ember of rentak dane needs to be even if the dangers are made. Do NOT round the Ta.. to integram.) Q.10) Determine the number of root which Jane would be indifferent to the current and proposed but models (Do NOT rond the realmberto Integer Hint Chedere come firs Ce blow information for Costo Luxury Fund and build factory-made, premium wood for home All are of white ook. Its Indented maturing for the year 2017 a fos. Overhead Cost Pools Amont (3) Purchasing -15.00 Handling materials SOKKI Prolotion (uttimilling, 132.000 Setting up marlines 85.000 Ingin GO Inventory coatrol (ww materials and find goods) 80.000 Utilities 100.00 For the last Luxury Furniture has been cluingwhead to product caters of material cont. For the year 2017, materials.cost of $50.000 ure budete Jim Briche manager of luxury Furniture, recently directed his commit. Bab Block, to implement the activity based contrate that he repeatedly proponed. At Jim Brichtequest, Rob and the production comman identify the following costs and their age for the previosly bleed wethouder pool Overhead Cost Pools Activity Cox Drivers Fxpected Use of Cost Drivers Purchase Number of orders Handling materiale Number of iones 5.500 Productiou (cuttm inilling, finishing) Dinc labor hours 65.000 Setting up mich Number of 1,200 Inspecting Number of spection 4.700 Inventory control mw materials and finished) Numbraceapourite 30,00 Utilities Square feet occupied to Debble Steln, sales manager, medan seder for 12 luery annutes from Thomslutetior Design At De request, Bob pares con estimates is percing 12 arties so Debbie ca amit a contact price per armoire to Thom's. He mases the following data for the production of 12 armoire DM C DL Cost (5) DE. How Number of Purdu. Orders Number of Material Movie Number of Machine Se Number of loptice Number of Component Number of Suste et copied 3.700 1.000 200 3 32 4 20 65.00 320 Q-) What is the unit manufacturing cost per armoire de traditional conting? Q-6) What is the unit manufacturing per armoire der the proposed city bad costing! Use below information for Question 7 to 10 Jane Boforan operates a bed and breakfast heel in stala Miche. Depreciation on the hotel is $60.000 per year Jone employs maintenance person at an amal salary of $11.000 and a chaing pesat antal salary of $24,00KL Teal estate than $10.200 per year. The rooms at an average price of $125 per person per tight including breakfast. Other costs are laundry and doing crvice at a cost of 8102 per person per night and the cost of food which $57 per person per night. Q.7) Determine the sales rewe Janes to break even Q-8) Determine the ber of rentals Jane bedste mataget et income of $50.00 (Do NOT round the rest number to inw Refer to the comides for the calculation of The Net Income Qu9) Jane is condering changing the businesses. She comes installing ditional cleaning chines which will decrean landry and cleaning service pet prop by 83. However, the percention cod will increase by $4.070, Tetermine the ember of rentak dane needs to be even if the dangers are made. Do NOT round the Ta.. to integram.) Q.10) Determine the number of root which Jane would be indifferent to the current and proposed but models (Do NOT rond the realmberto Integer Hint Chedere come firs
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
