Question: For 22a in the 2-way data table I get the same value in every cell (as shown below). This is after going to calculation options

For 22a in the 2-way data table I get the same value in every cell (as shown below). This is after going to calculation options and switching from manuel to automatic. Can you help me fix this to get the correct answer?
22. 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 the annual profit. That is, find annual profit for each for these combinations of copiers rented and daily demand.
For 22a in the 2-way data table I get the same value

Edit View Insert Format Tools Data Window Help OFF me Insert Draw Page Layout Formulas Data Review View Tell me fx V V V *** A-O Define Name - Text sert unction AutoSum Recently Financial Logical Used Dati Lookup & Math & Trig Act Tim More Functions Create from Sel Date & Time 37 xx (=TABLE(813,814) A 8 C E Copy shop inputs $1,200 arly rental cos Other monthly fanden $500 1200 $1,000 1200 Caper cov $1,500 Change copy 1200 $2,000 Days per year 3 1000 100000 $1,300 detalles dately demanding the Fe graph Mas 10 Copies o 13 Pro model Copierstad 14 d 16 Coplesale 16 pros M Pa 21 WN tal 1 1 BEX Q A Z 2 $5,000 $400 50.03 50.30 365 12 100000 W S # 3 Oly Demand E D D $ 4 C m 20 R LL F F 1 $1,200 1200 1200 1200 5 G Copiers rented 2 1200 1200 1200 1200 T 6 G H 1200 1200 1200 1200 1200 1200 2200 1200 Y 7 H U 8

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!