You are thinking of opening a small copy shop and rent a copier. It costs you $$1,000$ to rent a copier for a year and it costs you $$0\mathrm{.}03$ per copy to operate the copier. Other fixed costs of running the store amount to $$150$ per month. You are planning to charge $$0\mathrm{.}10$ per copy. You are open $365$ days per year. A copier can make up to $80,000$ copies per year.

$($a$)$ Given these assumptions, what level of daily demand will enable you to break even? $($b$)$ Calculate the annual profits for specified $($in this template$)$ daily demands and graph them. Please include a seperate formula for each part of the spreadsheet for completion. Problem $1$

You are thinking of opening a small copy shop and rent a copier. It costs you $$1,000$ to rent a copier for a year and it costs you $$0\mathrm{.}03$ per copy to operate the copier. Other fixed costs of running the store amount to $$150$ per month. You are planning to charge $$0\mathrm{.}10$ per copy. You are open $365$ days per year. A copier can make up to $80,000$ copies per year.

$($a$)$ Given these assumptions, what level of daily demand will enable you to break even? $($b$)$ Calculate the annual profits for specified $($in this template$)$ daily demands and graph them. Please provide formula for each cell.