Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need hlep with the break evn point Inputs Yearly rental cost $5,000 Other monthly fixed costs $400 Cost per copy $0.03 Charge per copy

I need hlep with the break evn point

image text in transcribed
Inputs Yearly rental cost $5,000 Other monthly fixed costs $400 Cost per copy $0.03 Charge per copy $0.10 Days per year 365 Months per year 12 Copies per copier per year 100,000 Profit model Copiers rented (trial value) 3 Daily demand (trial value) 1000 Copies made 300,000 Annual profit $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,200 2 3 4 5 500 -2800 -2025 -7025 -12025 -17025 1000 -2800 -800 1200 750 -4250 1500 -2800 -800 1200 3200 5200 2000 -2800 -800 1200 3200 5200 Part (b) Create a Break-even example. Copiers Rented 3 Daily Demand Copies Made Annual Profit 0 Part (c) Write your observations of what the data in the two-way table means and why this is important analysis information

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Economics Methods And Techniques

Authors: Chandra Kant Singh

1st Edition

9353147018, 9789353147013

More Books

Students also viewed these Economics questions

Question

Armed conflicts.

Answered: 1 week ago

Question

Pollution

Answered: 1 week ago