Hello,

I need help understanding how to plot this profit graph in Excel - they show the finished graph in textbook solutions but not info on how to create the graph in Excel. Thanks!

Managerial Accounting 15th Addition

Exercise 5-3 (Page 218)

Jaffre Enterprises distributes a single product whose selling price is $16 and whose variable expense is $11 per unit. The companys fixed expense is $16,000 per month.

Required:

1) Prepare a profit graph for the company up to a sales level of 4,000 units.