ACC 333 Excel Assmt 9-51- Exce FILE HOME INSERT PAGE LAYOUT FORMULASDATA REVEW V A1 Given Data PO9-51: 5Year 2 cost estimates: Estimated Estimated Cost Recommended Cost Driver 7Activity Cost Driver Activity S 54,000 200 orders Number of orders Number of production runs Pounds of materials used Processing orders 9 Setting up production 10 Handling materials 11 Machine depreciation and maintenance Machine hours 12 Performing quality control 13 Packing 14 Total estimated cost 216,000 100 runs 360,000 120,000 pounds 288,000 12,000 hours Number of inspections Number of units 72,000 45 inspections 144,000 480,000 units 16 Cost driver volumes in January, Year 2: Institutional Standard Silver 60,000 24,000 19 Number of units produced 20 Direct materials costs 21 Direct labor-hours 22 Number of orders 23 Number of production runs 24 Pounds of material 25 Machine-hours 26 Number of inspections 27 Units shipped $ 39,000 24,000 15,000 450 3,000 15,000 580 6,000 60,000 24,000 9,000 29 Additional Information: 30 Estimated direct labor-hours for Year 2 7,500 Actual labor cost per hour Given PO9-51 P09-5