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: Started- Ending Completed and Transferred Out- Beginning 1. 2 Prepare an equivalent units schedule. The schedule should follow the format below; you add additional information if you would like. (Remember that the schedule is for units of trucks not plastic and wheels.) Whole Units (Actual) Direct Materials Direct Materials Conversion Equivalent Units Plastic Wheels Xxx xxX Costs Beginning Start/Completed Completed/Transferred Out xxx Ending Total Xxx 3. Calculate the total cost and the cost per equivalent unit for the direct materials plastic 4. Calculate the total cost and the cost per equivalent unit for the direct materials wheels. 5. Calculate the predetermined overhead rate 6. Determine the total conversion cost by using the predetermined rate and the direct labor rate Then determine the conversion cost per truck by taking the number out four decimals and then rounding to the nearest cent. 7. Determine the unit cost per truck to the nearest cent 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 Determine the amounts for the following. Show calculations for credit. 9. al Ending Work-in-Process Inventory in Units AND Dollars b) Ending Finished Goods Inventory in Units AND Dollars c) Cost of Goods Sold d) Over/Under Applied Manufacturing Overhead e) Show and calculate an Income Statement f) Gross Profit Bl Net Income 10. Prepare the necessary Journal Entries related to the manufacturing cycle for this accounting period