$2$ Required

$3$

Complete the spreadsheet. Be sure to use formulas that will automatically calculate profitability if fixed cost, variable cost, or sales volume is changed.

$4$

$5$ Spreadsheet Tips

Similar to basic math rules, the order of calculation within a formula is multiplication and division before addition

$6$ and subtraction. Therefore, if you wish to subtract variable cost from selling price and multiply the difference by units sold, the formula must be $=(B9-B15{)}^{**}C12.$

The quickest way to get the correct formulas in the area of C$14$ to G$22$ is to place the proper formula in cell C$14$ and then copy this formula to the entire block of C$14$:G$22.$ However, the formulas must use the $ around the cell addresses

$7$

to lock either the row or the column, or both. For example, the formula $=2^{**}$$$A$$$14$ can be copied to any other cell and the cell reference will remain $A14$ because the $ symbol locks the row and column. Likewise, $A$14$ indicates that only the column is locked, and $A$$$14$ indicates that only the row is locked.

$($Ungraded$)$ You can explore the power of formulas by copying cells A$9$:G$22$ into cells A$29$:G$42$ of the scratchpad area

$8$

below. There you can explore how changes to the given information $($now in cells B$29,$ A$34$:B$42,$ and C$32$:G$32)$ are automatically reflected in the calculation of profitability. Since your formulas were created using the $ symbol, you will need to modify the formula in cell C$34$ and then copy this formula to the entire block of C$34$:G$32.$