how do I solve this problem?

B C D E T TASK #1 CALCULATE PDOHR Manufacturing overhead budget for the year: Amount Material handling for production runs S 63,000 Depreciation, machinery 226,000 Maintenance, machinery 34,000 Depreciation, taxes and insurance on factory building 95,000 Engineering 105,000 Machine setups 80,000 Testing and inspections 65,000 Miscellaneous manufacturing overhead costs 75,000 Total budgeted manufacturing overhead costs 743,000 Direct Labor Budget for the year: Hours Economy Model 40,000 10 hours x 4000 units Premium Model 2,400 12 hours x 200 units Lite Commercial Model 27,000 15 hours x 1800 units Total direct labor hours budget 69,400 Predetermined OH Application Rate Check: $10.71A B C D E G H J K TASK #2 PRODUCT LINE PRODUCTION REPORT - ECONOMY MODEL Total Units for the Year: Units Started BB, units EB, units Completed Legend: Economy Model 4,000 75 80 3,995 | BB = Beginning Balance % Complete as to Direct Materials 100% 100% 100% EB = Ending Balance % Complete as to Conversion 50% 50% 100% Total Dollars for the Year: DM Conversion In Beg. Balance, WIP 30,000.00 $ 15,264.77 Added to WIP during the year 1,600,000.00 $ 1,627,224.42 Product-Line Production Report Economy Model 1. Physical flow of units Directions: Physical Units E17 = C4 Work in process, BB E18 = B4 Units started during year Total units to account for E21 = E4 Units complete and transferred out during Year E22 = D4 Work in process, EB Hint: E19 and E23 should be equal. Total units accounted for 2. Calculation of equivalent units % of Completion % of Completion Equivalent Units Physical Units For DM For Conversion Direct Material Conversion Directions: B28 = E17 Work in process, BE B29 = E18 Units started during year C28 = C5 Total units to account for D28 = C6 Units completed and transferred out during year Work in process, EB B32 = E21; C32 = E5; D32 = E6; E32 = B32 x C32; F32 = B32 x D32 833 = E22; C33 = D5; D33 = D6; E33 = B33 x C33; F33 = B33 x D33 Total units accounted for Total equivalent units E35 = E32 + E33; F35 = F32 + F33 3. Computation of unit costs Direct Material Conversion Total Work in process, $ in BB Directions: Costs incurred during Year D38 = B9; E38 = C9; F38 = D38 + E38 Total costs to account for is D39 = B10; E39 = C10; F39 = D39 + E39 Equivalent units D41 = E35; E41 = F35 Costs per equivalent unit D42 = D40/D41; E42 = E40/E41; F42 = D42 + E42A B C D E G H TASK #2 PRODUCT LINE PRODUCTION REPORT - ECONOMY MODEL Total Units for the Year: Units Started BB, units EB, units Completed Legend: Economy Model 4,000 75 80 3,995 | BB = Beginning Balance % Complete as to Direct Materials 100% 100% 100% EB = Ending Balance % Complete as to Conversion 50% 50% 100% Total Dollars for the Year: DM Conversion In Beg. Balance, WIP 30,000.00 $ 15,264.77 Added to WIP during the year 1,600,000.00 $ 1,627,224.42 Work in process, $ in BB Directions: Costs incurred during Year D38 = B9; E38 = C9; F38 = D38 + E38 Total costs to account for $ D39 = B10; E39 = C10; F39 = D39 + E39 $ Equivalent units D41 = E35; E41 = F35 Costs per equivalent unit D42 = D40/D41; E42 = E40/E41; F42 = D42 + E42 Check F42 = 807.06 4. Analysis of total costs Costs of goods completed and transferred out during Year Directions: Cost remaining in EB work-in-process inventory E45 = E32 x F42 Direct material: Conversion: E47 = E33 x D42 Total cost of EB work-in-process E48 = F33 x E42 E49 = E47 + E48 Check: Cost of goods transferred out E51 = E45 Cost of EB work-in-process inventory E52 = E49 Total costs accounted for E53 = E51 + E52 Check F53 = $3,272,489.19TASK #2 PRODUCT LINE PRODUCTION REPORT - PREMIUM MODEL Total Units for the Year: Units Started BB, units EB, units Completed Legend Premium Model 200 4 5 199 BB = Beginning Balance % Complete as to Direct Materials 100% 100% 100% EB = Ending Balance % Complete as to Conversion 50% 50% 100% Total Dollars for the Year: DM Conversion In Beg. Balance, WIP 3,600.00 $ 976.95 Added to WIP during the year 180,000.00 97,450.29 Directions: Product-Line Production Report E45 = E32 x F42 Premium Model 1. Physical flow of units E47 = E33 x D42 Physical Units E48 = F33 x E42 Work in process, BB E51 = E45 Units started during year E52 = E49 Total units to account for Check E53 = $282,027.23 Units complete and transferred out during Year E21 = E4 Work in process, EB E22 = D4 Total units accounted for Hint: E19 and E23 should be equal. 2. Calculation of equivalent units Directions: % of Completion % of Completion Equivalent Units B28 = E17 Physical Units For DM For Conversion Direct Material Conversion B29 = E18 Work in process, BB C28 = C5 D28 = C6 Units started during year Total units to account for B32 = E4; C32 = E5; D32 = E6 Units completed and transferred out during year B33 = D4; C33 = D5; D33 = D6 Work in process, E Total units accounted for E35 = E32 + E33; F35 = F32 + F33 Check E35 = 204; F35 = 201.50 Total equivalent 3. Computation of unit costs Direct Material Conversion Total Work in process, $ in BE Directions: D38 = B9; E38 = C9; F38 = D38 + E38 Costs incurred during Year Total costs to account for - $ - $ D39 = B10; E39 = C10; F39 = D39 + E39 Equivalent units D41 = E35; E41 = F35 Costs p valent unit Check F42 = 1388.47Tables Illustrations Add-ins Charts Tours Sparklines Filters Links X TASK #2 PRODUCT LINE PRODUCTION REPORT - PREMIUM MODEL A B C D E F G H TASK #2 PRODUCT LINE PRODUCTION REPORT - PREMIUM MODEL Total Units for the Year: Units Started BB, units EB, units Completed Legend: Premium Model 200 4 5 199 BB = Beginning Balance % Complete as to Direct Materials 100% 100% 100% EB = Ending Balance % Complete as to Conversion 50% 50% 100% Total Dollars for the Year: DM Conversion In Beg. Balance, WIP 3,600.00 $ 976.95 Added to WIP during the year 180,000.00 $ 97,450.29 Total equivalent units Check CSJ - 204, 15J - 201.JU 3. Computation of unit costs Direct Material Conversion Total Work in process, $ in BB Directions: Costs incurred during Year D38 = B9; E38 = C9; F38 = D38 + E38 Total costs to account for -$ -$ D39 = B10; E39 = C10; F39 = D39 + E39 Equivalent units D41 = E35; E41 = F35 Costs per equivalent unit Check F42 = 1388.47 4. Analysis of total costs Costs of goods completed and transferred out during Year Cost remaining in EB work-in-process inventory: Direct material: Conversion: Total cost of EB work-in-process Check: Cost of goods transferred out Cost of EB work-in-process inventory Total costs accounted forTASK #2 PRODUCT LINE PRODUCTION REPORT - LITE COMMERICAL MODEL Total Units for the Year: Units Started BB, units EB, units Completed Legend: Lite Commercial Model 1,800 35 38 1,797 BB = Beginning Balance % Complete as to Direct Materials 100% 100% 100% EB = Ending Balance % Complete as to Conversion 50% 50% 100% Total Dollars for the Year: DM Conversion In Beg. Balance, WIP 52,500.00 $ 10,685.34 Added to WIP during the year 2,700,000.00 $ 1,098,147.51 Product-Line Production Report Lite Commercial 1. Physical flow of units Physical Units Directions: Work in process, BB Units started during year Total units to account for Hint: E19 and E23 should equal 1835 Units complete and transferred out during Year Work in process, EE Total units accounted for 2. Calculation of equivalent units %% of Completion % of Completion Equivalent Unit Physical Units For DM For Conversion Direct Material Conversion Directions: Work in process, BB Units started during year Total units to account for Units completed and transferred out during year E35 = 1835 and F35 = 1816 Work in process, EB Total units accounted for Total equivalent units 3. Computation of unit costs Direct Material Conversion Total Work in process, $ in BE Directions: Costs incurred during Year Total costs to account for Check F40 = $3,861,332.85 Equivalent units Costs per equivalent unit Check F42 = $2,110.59