Use Microsoft excel to solve the following problem. Insert screenshots of your excel spreadsheet to provide answers and explain your reasoning. If use any equations for cells, provide that information in your solution.

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 $462 monthly lease with a $0.024 per page cost up to 500 pages, and then $0.017 per page after the 1^st 500 pages.
• Machine 2 has a $565 monthly lease with a $0.015 per page cost up to 500 pages, and then $0.009 per page after the 1^st 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 $0.05 per copy. Based on this, which machine do you recommend?