Question

Required information Chapter 4: Applying Excel The Chapter 4 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text on pages. Part 1 of 2 Chapter 4: Applying Excel: Excel Worksheet (Part 1 of 2) eBook Download the Applying Excel form and enter formulas in all cells that contain question marks. Enter formulas in the cells that contain question marks. For example, in cell C17 enter the formula "=B8*B10". Print After entering formulas in all of the cells that contained question marks, verify that the calculated numbers match the numbers in the Review Problem. References Check your worksheet by reducing the direct labor-hours for the Deluxe model in cell B10 from 5 to 2. The Deluxe model's unit product cost under traditional costing should now be $74.00 and the ABC unit product cost should be $143.89. If you do not get these results, fmd the errors in your worksheet and correct them. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save." You will use this worksheet to answer the questions in Part 2.

Answer 1

1)Estimated total manufacturing overhead, a = 550000
Estimated total amount of the allocation base, b = 2000*5+10000*4=50000 DLHs
Pre-determined overhead rate, a/b = 11 per DLH
2)	Deluxe	Tourist
Direct labor hours per unit, a	5 DLHs	4 DLHs
Predetermined overhead rate, b	11 per DLH	11 per DLH
Manufacturing overhead applied per unit, a*b	55	44
3)	Deluxe	Tourist
Direct Materials	25	17
Direct Labor	60	48
Manufacturing overhead applied	55	44
Traditional unit product cost	140	109
4)
Activities	Esti. OH cost	T. Exp. Activity	Activity rate
Labor related	80000	50000	1.6	per DLH
Machine setups	150000	5000	30	PER setup
Production orders	70000	400	175	per order
General factory	250000	40000	6.25	per MH
5)		Deluxe		Tourist
Activities	Activity rate	Exp. Activity	Amount	Exp. Activity	Amount
Labor related	1.6	10000	16000	40000	64000
Machine setups	30	3000	90000	2000	60000
Production orders	175	100	17500	300	52500
General factory	6.25	12000	75000	28000	175000
Total overhead cost assigned, a			198500		351500
Number of units produced, b			2000		10000
ABC overhead cost per unit, a/b			99.25		35.15
6)	Deluxe	Tourist
Direct Materials	25	17
Direct Labor	60	48
ABC overhead cost per unit	99.25	35.15
ABC unit product cost	184.25	100.15