Stanley Manufacturing Company, which sold $16,000$ units of product at $$20$ per unit, collected the following information regarding three different levels of production.

Required

a$.$ Complete the spreadsheet below.

Spreadsheet Tip

Explore the power of formulas by copying cells A$10$:D$29$ and cell H$2$ into the scratchpad area below. There you will be able to modify the given information $($currently in cells B$11$:D$12,$ B$14$:D$14$ and H$2)$ and see the resulting changes. You will need to modify any formulas in which you used a $"$$$"$ to reflect the new cell reference and the formulas for "Sales" to reference the new location of cell H$2.$

Use the Open Excel in New Tab button to launch this question.

When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.