need to make an excel sheet

Instructions: Please prepare the Cost of Goods Manufacturing Schedule and Income Statement for the project below. Your answers must be in Excel Spreadsheet format and should be submitted on Canvas. You must name the file with your last name, first name and project name. i.e. Diala_Lucy_Cost_of_Goods_Manufactured Project_Fall2021 Project Question: The Ramos Company Beginning of 2019 End of 2019 Direct materials inventory 43,000 30,000 Work-in-process inventory 21,000 23.000 Finished-goods inventory 25,000 32,000 Purchases of direct materials 45,000 Direct manufacturing labor 18.000 Indirect manufacturing labor 18.000 Plant insurance 12,000 Depreciation plant, building, and equipment 11.000 Repairs and maintenance plant 3.000 Marketing, distribution, and customer-service costs 82.000 General and administrative costs 20,000 Required: 1. Prepare a schedule for the cost of goods manufactured for 2019. 2. Revenues for 2019 were $350 million. Prepare the income statement for 2019. *Note that all balances are reported in thousands. So to input a revenue of $350 million in the schedule, you input 350,000. Important Formulas To calculate Direct Materials Used (DMU) Beginning Inventory (BegInv) + Purchases (Pure) - Ending Inventory (EndInv) =Direct Materials Used (DMU) To calculate Total Manufacturing Costs (TMC) Direct Materials Used (DMU) + Direct Labor (DL) + Manufacturing Overhead (MO) = Total Manufacturing Costs (TMC) To calculate Cost of Goods Manufactured (COGM) Beginning Work in Process (BegWIP) + TMC incurred in period = TMC to account for Ending Work in Process (EndWIP) =Cost of Goods Manufactured (COGM) To calculate Cost of Goods Sold (COGS) Beginning Inventory (BegInv) +COGM - Ending Inventory (End Inv) = Cost of Goods Sold (COGS)