Manning. Cassey Computers (MCC) plans to produce and sell 1,600 computers for 5720 each in the next fiscal year. The company's cost data follow. 2 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 3. you change the number of units sold. 5. 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 6 reference for units manufactured and sold. resulting changes Ynul will nanaw