1 Manning Cassey Computers (MCC) pla nto produce and sell 1,600 computers for $720 each in the next 2 fiscal year. The company's cost data follow. 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. 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. \begin{tabular}{|l|l|l|} \hline 31 & \multicolumn{1}{|c|}{ Sales Revenue Income Statement } \\ \hline 32 & Cost of Goods Manufactured and Sold \\ \hline 33 & Net income & \\ \hline 34 & & \\ \hline 35 & & \\ \hline \end{tabular}