Question

Excel SIM: First-Stage Allocation to Activity Cost Pools Help 1. Assign Overhead Costs to Activity Cost Pools OBS FILE HOME DESERT Festtage Allocation to Activity Cost Pools Excel PAGE LAYOUT FORMULAS DATA REVIEW 7 - X VIEW Alignment Number Conditional Formatas C oord B27 The following information care dintr est verhead Chocolates by lock for the current year e Activity Cost Pools Product Development Indirect factory w Other en de Factory 12 General Administrate Department 13 Admistrative was and series 14 Office equipment deprecation 15 Admistrative property and insurance 17 Marketing Department 18 Mark Wapes and salaries 19 in een 21 Use the data to completita fint 22 when completing the to , co Allocation to Acy costo formules piste Sheet1 Attempts) 7/10

Answer 1

	A	B	C	D	A+B+C+D
	Customer orders	product Development	customer Relation	others	Total
Indirect Factory Wages	400000*50% =200000	400000*30% =120000	400000*15% =60000	400000*5% =20000	400000
Factory Equipment Depreciation	150000*55% =82500	150000*30% =45000	150000*0% =0	150000*15% =22500	150000
Factory Utilities	120000*59% =70800	120000*34% =40800	120000*0% =0	120000*7% =8400	120000
Factory property tax and insurance	75000*57% =42750	75000*33% =24750	75000*0% =0	75000*10% =7500	75000
Administration Wages and salaries	275000*20% =55000	275000*10% =27500	275000*40% =110000	275000*30% =82500	275000
Office Equipment Depreciation	40000*32% =12800	40000*16% =6400	40000*15% =6000	40000*37% =14800	40000
Administration property tax and insurance	60000*0% =0	60000*0% =0	60000*0% =0	60000*100% =60000	60000
Marketing wages and salaries	150000*20% =30000	150000*10% =15000	150000*40% =60000	150000*30% =45000	150000
Selling Expenses	100000*32% =32000	100000*16% =16000	100000*15% =15000	100000*37% =37000	100000

Thanks........