Please help!

E Task 1 Skylar Cab, the CEO, has asked you to meet with each product-line sales manager before meeting with him to get their feedback on the activity-based costing results. You have a lot of work to do before meeting with each sales manager. The first step will be to compute the predetermined Manufacturing Overhead (MOH) application rate using direct labor hours as the cost driver Action Items To complete this task, use the Challenge 3 Student Template. Calculate the predetermined MOH application rate using direct labor hours as the cost driver. TASK #3 ACTIVITY-BASED COSTING OVERHEAD ALLOCATION Manufacturing overhead budget for the year Material handling for production runs (per setup)S Depreciation, machinery Maintenance, machinery Depreciation, taxes and insurance on factory buildin Engineering Machine setups Testing and inspections Miscellaneous manufacturing overhead costs Total budgeted manufacturing overhead costs Amount 63,000 226,000 34,000 95,000 105,000 80,000 65,000 75,000 743,000 Activity Cost Pool Batch unit-Machining unit-Machining Cost Driver # of m a teri a l orders #Of Machine hours #Of Machine hours Facility Leve Square Footage Product Sustaining Batch Product Sustaining Facility Level #of Engineering hours # of material orders #Of Engineering hours Square Footage Consumption Ratios Total Activity Cost Pools 1)Unit-Machining 2) Batch 3) Product Sustaining )Facility Level Cost Driver # of machine hours # of setups # of engineering hours Square footage Economy Model 4296 52% Premium Model Lite-Commerical Model 108 5% 9% 1696 4396 45% 436 100 10096 100% 100 41% Consumption Ratio, % Total Units Per Unit Cost Directions: Complete the yellow highlighted areas Cel D23: add the depreciation machinery and maintenance machinery MOH costs to obtain the total overhead assigned to Pool #1. machinery; Maintenance, machinery 4,000 200 Hint: The amount in D27 is the sum of D24 athrough D26 and should match the amount in cel D23 Total Check F24 527.30 1 2: Materials & Setups Use the same patten for Pools 2 through 4. 4,000 200 1,800 Total 0% 50 3: Engineering, Testing & In 4,000 200 Total 4: Depreciation, taxes, and insur; Misc. MOH 4,000 200 1,800 Total 50 Total of four pools Hint: Should be the same as the total above in cell C12 Total MOH Total MOH Per Unit Grand Total Economy: Cell c51 -F24 F30+F36+F42 Follow the same pattern for Premium and Lite-Commerical Economy 4,000 Cel E54 should be the sane as the total above in ce D47