I am working on a problem in Managerial Accounting 15th edition, Chapter 5 Problem 2E. I need to create a CVP graph for the first part of the question - in the solution the CVP graph is shown but it does not include instructions on how to create the CVP graph in Excel (which I need to do). In the text book it is question 5-2 on page 218

Exercise 5-2 (Page 218)

Karlik Enterprises distributes a single product whose selling price is $24 and whose variable expense is $18 per unit. The companys monthly fixed expense is $24,000.

Required:

1) Prepare a cost-volume-profit graph for the company up to a sales level of 8,000 units.

Thanks for your help!

Jen