Question: Using the problem description and data from the text, construct a profit model in Excel for each of the problems listed below and use the

 Using the problem description and data from the text, construct a

Using the problem description and data from the text, construct a profit model in Excel for each of the problems listed below and use the models to answer the questions. Use Goal-Seek in Excel to find the break-even points Zoe Garcia is the manager of a small office support business that supplies copying, binding, and other services for local companies. Zoe must replace a worn-out copy machine that is used for black and white copying. Two machines are being considered, and each of these has a monthly lease cost plus a cost for each page that is copied. Machine 1 has a monthly lease cost of $600, and there is a cost of $0, 010 per page copied. Machine 2 has a monthly lease cost of $400, and there is a cost of $0, 015 per page copied. Customers are charged $0.05 per page for copies. A.) What is the break even-point for each machine? B.) If Zoe expects to make 10,000 copies per month, what would be the cost for each machine? C.) If Zoe expects to make 30,000 copies per month, what would be the cost for each machine

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 Finance Questions!