plsase help with these. In excel using formulas

this is the layout for question 1

this is the lauour dir question 2

THANK YOU

Assignment Questions 1. Determine the best base for allocating plant-administration costs. 2. Calculate the ABC costs for each product on a per-box basis. 3. What do these results tell you about activity-based costing versus costing based on standard volume or direct materials plus direct labor? 4. What changes, if any, should management make to Zauner's pricing strategy? B M 3 4 D 1 The case presents five potential allocation bases for assigning the company's 5300,000 in plantation costs. Using the five years of data presented in care Exhibit 4, 2 you should hypothesie which potential base would be the best choice. To make this decision, you need to look for the best correlation coefficient or regression ft. You need to show your support below, uning Excel (insert-cut scatter) 5 61. Determine the best allocation base for allocating plant-administration costs. Anewer Question there and show support for your choice below. 8 9 10 11 13 16 Exhibit 4 Plant Personnel Number or Customers 1300 15 16 2003 17 2002 E 2001 15 2000 20 1999 21 Total Amin Cost 5300,000 $295.000 525. SZK0.000 $20.000 Ending Inventory Cost 390,000 $80,000 SN.000 550.000 576,000 Total Direct Labor Cast 5520,000 5515.100 5555 $10.000 S500 of Plant Capacity Used 70.00 75.00% 1250 1100 NDO 600 119 112 110 9000 95 11. Cute the Acts for each productos probas 7. Answer Question 2 here and show rapport below 3 4 Base Information (Exhibit) Ornaments Ben Zauner Ornaments Calculations of ABC Costs Small Specialty 430.000 100 000 100.000 35.000 50.000 100.000 10 11 12 13 Activity Base inted within the case Estimated MOIS led with the case Activity Rate Estimated se wted within different exhibit) Small Large Specialty DIV. 14 15 Production Scheduling 16 Machine Setup 19 Deprecation 11 Plant Depreciation 19 Quality Inspection 20 Packing 21 Pt Admiration 33 exhibit b) Mb CE Exhibit) Exhibit shi se Large Specialty DIVA 25 20 23 29 Why Product Production that Man Supe in Den Plant Deprem Quality Inspection Packing Plan Air Wanity Bu produced MOM 3 2 33 14 MOR H 27 38 Tata ABC Question Question Question Question Assignment Questions 1. Determine the best base for allocating plant-administration costs. 2. Calculate the ABC costs for each product on a per-box basis. 3. What do these results tell you about activity-based costing versus costing based on standard volume or direct materials plus direct labor? 4. What changes, if any, should management make to Zauner's pricing strategy? B M 3 4 D 1 The case presents five potential allocation bases for assigning the company's 5300,000 in plantation costs. Using the five years of data presented in care Exhibit 4, 2 you should hypothesie which potential base would be the best choice. To make this decision, you need to look for the best correlation coefficient or regression ft. You need to show your support below, uning Excel (insert-cut scatter) 5 61. Determine the best allocation base for allocating plant-administration costs. Anewer Question there and show support for your choice below. 8 9 10 11 13 16 Exhibit 4 Plant Personnel Number or Customers 1300 15 16 2003 17 2002 E 2001 15 2000 20 1999 21 Total Amin Cost 5300,000 $295.000 525. SZK0.000 $20.000 Ending Inventory Cost 390,000 $80,000 SN.000 550.000 576,000 Total Direct Labor Cast 5520,000 5515.100 5555 $10.000 S500 of Plant Capacity Used 70.00 75.00% 1250 1100 NDO 600 119 112 110 9000 95 11. Cute the Acts for each productos probas 7. Answer Question 2 here and show rapport below 3 4 Base Information (Exhibit) Ornaments Ben Zauner Ornaments Calculations of ABC Costs Small Specialty 430.000 100 000 100.000 35.000 50.000 100.000 10 11 12 13 Activity Base inted within the case Estimated MOIS led with the case Activity Rate Estimated se wted within different exhibit) Small Large Specialty DIV. 14 15 Production Scheduling 16 Machine Setup 19 Deprecation 11 Plant Depreciation 19 Quality Inspection 20 Packing 21 Pt Admiration 33 exhibit b) Mb CE Exhibit) Exhibit shi se Large Specialty DIVA 25 20 23 29 Why Product Production that Man Supe in Den Plant Deprem Quality Inspection Packing Plan Air Wanity Bu produced MOM 3 2 33 14 MOR H 27 38 Tata ABC