CH 05 Handout.xlsx -...

0936b3f2dca64c192b3d619713e6bf3482f9d791.xlsx ACC 211 BYRNE
Exercise 5-1 The Effect of Changes in Sales Volume on Net Operating Income [LO5-1]
Data inputs for Whirly Corporation’s most recent month is shown below.
Selling price per unit $ 35.00
Variable expense per unit $ 20.00
Total fixed expenses $ 135,000
1
Create a Contribution Format Income Statement if 10,000 units are sold.
Page 1 of 7
2
How does NOI change if sales increase by 100 units? Decrease by 100 units, or totaled 9,000 units?
-
Exercise 5-2 Prepare a Cost-Volume-Profit (CVP) Graph in Excel [LO5-2]
Karlik Enterprises distributes a single product wwith the fiollowing data inputs
Selling price per unit $ 28.00
Variable expense per unit $ 20.00
Total fixed expenses $ 24,000
Max Units 8,000
1
Prepare a cost-volume profit graph in Excel for the company up to a sales volume of 8,000 units