Question: please solve on excel using solver. Jerry, the manager of a small printing company, needs to replace a worn out copy machine. He is considering

please solve on excel using solver. Jerry, the

please solve on excel using solver.

Jerry, the manager of a small printing company, needs to replace a worn out copy machine. He is considering two machines; each has a monthly lease cost and a cost per page that is copied: Machine 1 has a $372 monthly lease with a 3.1 cents per page cost up to 500 pages, and then 2.3 cents per page after the 1st 500 pages. Machine 2 has a $548 monthly lease with a 1.9 cents per page cost up to 500 pages, and then 1.2 cents per page after the 1st 500 pages. Jerry knows the break-even point is more than 500 pages for each machine. Determine the break-even point (per month) in terms of the number of copies for each machine if Jerry charges customers 5.0 cents per copy. Based on this, which machine do you recommend

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 General Management Questions!