Question: You are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs $0.03 per copy to operate the copier. Other fixed costs of running the store will amount to $400 per month. You plan to charge an average of $0.10 per copy, and the store will be open 365 days per year. Each copier can make up to 100,000 copies per year.
a. For one to five copiers rented and daily demands of 500, 1000, 1500, and 2000 copies per day, find annual profit. That is, find annual profit for each of these combinations of copiers rented and daily demand.
b. If you rent three copiers, what daily demand for copies will allow you to break even. (I need to understand how to input this data into excel and come up with the right numbers). I know this question has been asked on here but none of the answers explain how to make a two-way data table in excel for part a, which is what I need to do)