Inputs Yearly rental cost Other monthly fixed costs Cost per copy Charge per copy Days per...

 

Transcribed Image Text:

Inputs Yearly rental cost Other monthly fixed costs Cost per copy Charge per copy Days per year Months per year Copies per copier per year Profit model Copiers rented (trial value) Daily demand (trial value) Copies made Annual profit $5,000 $400 $0.03 $0.10 365 12 100,000 3 1000 300,000 $1,200 Part (a) Use two-way data table (copies rented along the top, daily demand along the side) Use conditional formatting to highlight negative numbers and positive numbers in the table. 1 1,200 3 5 500 1000 1500 2000 -2800 -2800 -2800 -2800 Part (b) Create a Break-even example. Copiers Rented Daily Demand Copies Made Annual Profit 3 0 2 -2025 -800 -800 -800 -7025 1200 1200 1200 -12025 750 3200 3200 -17025 -4250 5200 5200 Part (c) Write your observations of what the data in the two-way table means and why this is important analysis information. Inputs Yearly rental cost Other monthly fixed costs Cost per copy Charge per copy Days per year Months per year Copies per copier per year Profit model Copiers rented (trial value) Daily demand (trial value) Copies made Annual profit $5,000 $400 $0.03 $0.10 365 12 100,000 3 1000 300,000 $1,200 Part (a) Use two-way data table (copies rented along the top, daily demand along the side) Use conditional formatting to highlight negative numbers and positive numbers in the table. 1 1,200 3 5 500 1000 1500 2000 -2800 -2800 -2800 -2800 Part (b) Create a Break-even example. Copiers Rented Daily Demand Copies Made Annual Profit 3 0 2 -2025 -800 -800 -800 -7025 1200 1200 1200 -12025 750 3200 3200 -17025 -4250 5200 5200 Part (c) Write your observations of what the data in the two-way table means and why this is important analysis information.

Answer rating: 100% (QA)

Part a TwoWay Data Table with Conditional Formatting Data Table Copies Rented Daily Demand Copies Copies Made Yearly Annual Profit 1 500 182500 2800 1... View the full answer