Problem 5-19A Basic CVP Analysis; Graphing [LO1, LO2, LO4, LO6] Shirts Unlimited
ID: 2484975 • Letter: P
Question
Problem 5-19A Basic CVP Analysis; Graphing [LO1, LO2, LO4, LO6]
Shirts Unlimited operates a chain of shirt stores that carry many styles of shirts that are all sold at the same price. To encourage sales personnel to be aggressive in their sales efforts, the company pays a substantial sales commission on each shirt sold. Sales personnel also receive a small basic salary.
The following worksheet contains cost and revenue data for Store 36. These data are typical of the company's many outlets:
The company has asked you, as a member of its planning group, to assist in some basic analysis of
its stores and company policies.
Calculate the annual break-even point in dollar sales and in unit sales for Store 36.
Prepare a CVP graph showing cost and revenue data for Store 36 from zero shirts up to 30,000 shirts sold each year. Clearly indicate the break-even point on the graph. (Use the line tool to draw 3 lines (Total Sales, Fixed Expenses, Total Expenses). Each line should only contain the two endpoints. Use the point tool (Break Even Point) to plot the Break Even Point. For your graph to grade correctly, you must enter the exact coordinates for each endpoint and the Break Even Point. To enter the exact coordinates for each point, double click on the point and enter the exact values for x and y.)
If 18,000 shirts are sold in a year, what would be Store 36's net operating income or loss? (Input the amount as a positive value.)
The company is considering paying the store manager of Store 36 an incentive commission of $3 per shirt (in addition to the salespersons' commissions). If this change is made, what will be the new break-even point in dollar sales and in unit sales?
Refer to the original data. As an alternative to (4) above, the company is considering paying the store manager a $3 commission on each shirt sold in excess of the break-even point. If this change is made, what will be the store’s net operating income or loss if 39,500 shirts are sold in a year? (Input the amount as a positive value.)
Refer to the original data. The company is considering eliminating sales commissions entirely in its stores and increasing fixed salaries by $168,000 annually. If this change is made, what will be the new break-even point in dollar sales and in unit sales in Store 36?
Shirts Unlimited operates a chain of shirt stores that carry many styles of shirts that are all sold at the same price. To encourage sales personnel to be aggressive in their sales efforts, the company pays a substantial sales commission on each shirt sold. Sales personnel also receive a small basic salary.
The following worksheet contains cost and revenue data for Store 36. These data are typical of the company's many outlets:
Explanation / Answer
1 Break Even Point = Fixed Cost/ Contribution Per Unit Contribution per unit = 35-17 $18 Break Even Point = 360000/18 20000 Break Even Point = 20000 units In Dollar 20000*35 $700,000 Break Even Point in dollar is $ 700000 3 If 18000 shirts are sold Per Unit Total Selling Price 35 630000 Variable cost 17 306000 Contribution 18 324000 Total Fixed Costs 360000 Net Operating Income -36000 4 If variable cost increases by $ 3 contribution will be 35-17-3 = $15 Break Even Point = 360000/15 24000 Units Break Even Point in dollars 24000*35 $840,000