Hi, I need help solving this. If you could please add an explanation to how you got that answer. for example like ( 2 * 2 = 4 )

E F G Manning Cassey Computers (MCC) plans to produce and sell 1,600 computers for $720 each in the next fiscal year. The company's cost data follow. 1,600 5 720 Components from wholesaler 480 per computer Assembly labor 15 per hour Manufacturing space rent 3,000 per month Utilities 600 per month Janitorial services 480 per month Depreciation of equipment 3,840 per year Labor time per computer 2 hours 1 15 12 Required a. Complete the spreadsheet to calculate the cost of goods manufactured and the cost per unit for MCC. Use formulas in the schedule so that the cost of goods manufactured will automatically be calculated as 15 you change the number of units sold. 15 Spreadsheet Tip Explore the power of formulas by copying cells A18:H33 into the scratchpad area below. There you will be able to modify the information currently in cells A18, D43, D44, D46:D48, D53, and E49 and see the resulting changes. You will need to modify the formulas in the "per unit" calculations to reflect the new cell 16 1 reference for units manufactured and sold. 18 units manufactured and sold 19 20 Schedule of Cost of Goods Manufactured per unit 21 Direct Materials Used (Variable) X = Direct Labor (Variable) X Manufacturing Overhead: 24 Manufacturing Space Rent (Fixed) 12 X Utilities (Fixed) 12 x 26 Janitorial Services (Fixed) 12 x 27 Depreciation of Equipment (Fixed) 28 Cost of Goods Manufactured 29 30 Income Statement 31 Sales Revenue X 32 Cost of Goods Manufactured and Sold 33 Net Income 3A