Please help with the Less Fixed Costs Please help with the Less Fixed Costs

Cell Styles

$f_x||=D{16}^{**}D3$

$\backslash$table$[[$B$,$C$,$D$],[$Lorenzo$\text{'}$s Data$],[$Selling price,,$$7\mathrm{.}50],[$Variable Costs,,$],[$Cost for paper, per unit,$$0\mathrm{.}70,],[$Cost for printing, per unit,$$1\mathrm{.}10,],[$Cost for film, per unit,$$0\mathrm{.}60,],[$Total Variable Costs,,$$2\mathrm{.}40],[$Contribution Margin,,$$5\mathrm{.}10],[$Fixed Costs,,$],[$Staff salaries,$$48,000\mathrm{.}00,],[$Other operating costs,$$12,120\mathrm{.}00,],[$Total Fixed Costs,,$$60,120\mathrm{.}00],[$Breakeven Sales Units,,$11788\mathrm{.}24],[$Target Profit Goal,,$$88,411\mathrm{.}76]]$

Cell Styles

$f_x||=D{16}^{**}D3$

$\backslash$table$[[$B$,$C$,$D$],[$Lorenzo$\text{'}$s Data$],[$Selling price,,$$7\mathrm{.}50],[$Variable Costs,,$],[$Cost for paper, per unit,$$0\mathrm{.}70,],[$Cost for printing, per unit,$$1\mathrm{.}10,],[$Cost for film, per unit,$$0\mathrm{.}60,],[$Total Variable Costs,,$$2\mathrm{.}40],[$Contribution Margin,,$$5\mathrm{.}10],[$Fixed Costs,,$],[$Staff salaries,$$48,000\mathrm{.}00,],[$Other operating costs,$$12,120\mathrm{.}00,],[$Total Fixed Costs,,$$60,120\mathrm{.}00],[$Breakeven Sales Units,,$11788\mathrm{.}24],[$Target Profit Goal,,$$88,411\mathrm{.}76]]$

$\backslash$table$[[$Lorenzo$\text{'}$s Poster Shop Contribution Margin Income Statement$],[$Sales$,,$$ $88,411\mathrm{.}80],[$Less Variable Costs:,,$],[$Paper$,$$ $8,251\mathrm{.}77,],[$Printing$,$$ $12,967\mathrm{.}06,],[$Film$,$$ $7,072\mathrm{.}94,],[$Total Variable Cost:,,$ $28,291\mathrm{.}78],[$Contribution Margin,,$ $60,120\mathrm{.}00],[$Less Fixed Costs,,$[$Insert formula$]],[$Operating Income,,$[$Insert formula$]]]$

Cell Styles

$f_x||=D{16}^{**}D3$

$\backslash$table$[[$B$,$C$,$D$],[$Lorenzo$\text{'}$s Data$],[$Selling price,,$$7\mathrm{.}50],[$Variable Costs,,$],[$Cost for paper, per unit,$$0\mathrm{.}70,],[$Cost for printing, per unit,$$1\mathrm{.}10,],[$Cost for film, per unit,$$0\mathrm{.}60,],[$Total Variable Costs,,$$2\mathrm{.}40],[$Contribution Margin,,$$5\mathrm{.}10],[$Fixed Costs,,$],[$Staff salaries,$$48,000\mathrm{.}00,],[$Other operating costs,$$12,120\mathrm{.}00,],[$Total Fixed Costs,,$$60,120\mathrm{.}00],[$Breakeven Sales Units,,$11788\mathrm{.}24],[$Target Profit Goal,,$$88,411\mathrm{.}76]]$