help me out with parts 5-9 please

Using a spreadsheet and based on the information provided in the next section, complete the following requirements: Determine the started and completed units by using the following formula: 1. Started - Ending = Completed and Transferred Out - Beginning 2. Prepare an equivalent units sched ule. The schedule should follow the format below; you may add additional information if you would like. (Remember that the schedule is for units of drones.) Whole Equivalent Units Units Direct Materials (Actual) Direct Materials- Conversion Aluminum Motor and Costs Propellers Beginning Start/Completed Completed/Transferred Out Ending Total XXX XXX XXX Xxx XXX XXX XXX XXX XXX XXX XXX XXX XXX XXX XXX XXX 3. Calculate the total cost and the cost per equivalent unit for the direct materials aluminum. 4. Calculate the total cost and the cost per equivalent unit for the direct materials motor and propellers. 5. Calculate the predetermined overhead rate. 6. Determine the total conversion cost by using the predetermined rate and the direct labor rate. drone. Then determine the conversion cost per 7. Determine the unit cost per drone. 8. Prepare a Cost of Production report. This report should show all costs transferred into Work-in- Process and the costs transferred to Finished Goods by using the Equivalent Units Schedule. This process uses FIFO costing. 9. Determine the amounts for the following. a) Ending Work-in-Process Inventory in Units AND Dollars b) Ending Finished Goods Inventory in Units AND Dollars Cost of Goods Sold d) Over/Under Applied Manufacturing Overhead e) Show and calculate an Income Statement Over or Under applied COGS f) g) Gross Profit h) Net Income The finished goods account has the following Information Beginning Finished Goods Ending Finished Goods O drones 2,900 drones 12,000 drones were sold at $39.00 each and the tax rate is 35% Requirement 1 Units Started (4000-200)4 15200 Units Completed and Transferred out 14900 () Units Beginnine ) Units Ending 300 0 14900 14900 Requirement 2 Equivalent Units Direct Materials- Motor and Propellers Direct Materials-Aluminium Conversion costs Physical units % UNITS % e.u e.u Units to account for Units in Beginning WIP Units started (4000-200) 4 0 15200 Total units to acount for 15200 Units accounted for: 100 % 100 % 100 % 14900 Transferred to FG (15200-300) 14900 14900 100% 14900 300 Ending Inventory in Process 300 0% 0 45% 135 Total units acccounted for 15200 15200 14900 15035 Requirement 3 Beginning Direct materials-Aluminium cost 0 (e) Purchase (4000 2.28) 9120 ) Ending cost (200*2.28) 456 Cost of Direct Materials-Aluminum consumed 8,664 Equivalent units Cost per equivalent unit (8664/15200) 15200 0.57 Requirement 4 Beginning Direct materials-Motors (+) Purchase (15200* 1) 15200 (-) Ending cost 0 Cost of Direct Materials- Motors consumed 15,200 Beginning Direct materials-Propellers 0 (+) Purchase (60800*0.1) 6080 ) Ending cost Cost of Direct Materials- Propellers consumed 6,080 $ Total cost of Direct Materials- Motors and Propellers 21,280 Equivalent units 14900 $ Cost per equivalent unit (21280/14900) 1.02 Using a spreadsheet and based on the information provided in the next section, complete the following requirements: Determine the started and completed units by using the following formula: 1. Started - Ending = Completed and Transferred Out - Beginning 2. Prepare an equivalent units sched ule. The schedule should follow the format below; you may add additional information if you would like. (Remember that the schedule is for units of drones.) Whole Equivalent Units Units Direct Materials (Actual) Direct Materials- Conversion Aluminum Motor and Costs Propellers Beginning Start/Completed Completed/Transferred Out Ending Total XXX XXX XXX Xxx XXX XXX XXX XXX XXX XXX XXX XXX XXX XXX XXX XXX 3. Calculate the total cost and the cost per equivalent unit for the direct materials aluminum. 4. Calculate the total cost and the cost per equivalent unit for the direct materials motor and propellers. 5. Calculate the predetermined overhead rate. 6. Determine the total conversion cost by using the predetermined rate and the direct labor rate. drone. Then determine the conversion cost per 7. Determine the unit cost per drone. 8. Prepare a Cost of Production report. This report should show all costs transferred into Work-in- Process and the costs transferred to Finished Goods by using the Equivalent Units Schedule. This process uses FIFO costing. 9. Determine the amounts for the following. a) Ending Work-in-Process Inventory in Units AND Dollars b) Ending Finished Goods Inventory in Units AND Dollars Cost of Goods Sold d) Over/Under Applied Manufacturing Overhead e) Show and calculate an Income Statement Over or Under applied COGS f) g) Gross Profit h) Net Income The finished goods account has the following Information Beginning Finished Goods Ending Finished Goods O drones 2,900 drones 12,000 drones were sold at $39.00 each and the tax rate is 35% Requirement 1 Units Started (4000-200)4 15200 Units Completed and Transferred out 14900 () Units Beginnine ) Units Ending 300 0 14900 14900 Requirement 2 Equivalent Units Direct Materials- Motor and Propellers Direct Materials-Aluminium Conversion costs Physical units % UNITS % e.u e.u Units to account for Units in Beginning WIP Units started (4000-200) 4 0 15200 Total units to acount for 15200 Units accounted for: 100 % 100 % 100 % 14900 Transferred to FG (15200-300) 14900 14900 100% 14900 300 Ending Inventory in Process 300 0% 0 45% 135 Total units acccounted for 15200 15200 14900 15035 Requirement 3 Beginning Direct materials-Aluminium cost 0 (e) Purchase (4000 2.28) 9120 ) Ending cost (200*2.28) 456 Cost of Direct Materials-Aluminum consumed 8,664 Equivalent units Cost per equivalent unit (8664/15200) 15200 0.57 Requirement 4 Beginning Direct materials-Motors (+) Purchase (15200* 1) 15200 (-) Ending cost 0 Cost of Direct Materials- Motors consumed 15,200 Beginning Direct materials-Propellers 0 (+) Purchase (60800*0.1) 6080 ) Ending cost Cost of Direct Materials- Propellers consumed 6,080 $ Total cost of Direct Materials- Motors and Propellers 21,280 Equivalent units 14900 $ Cost per equivalent unit (21280/14900) 1.02