NB.

Breakeven point in unit sales ( the three cell with small red allow at the corner use excels ROUNDUP formula)

the rest use regular excel formula

The Lids national chain of hat stores carry many styles of hats that are all sold at the same Required: price. To encourage sales personnel to step up their sales efforts, the company pays a Lids is a fairly new company. The company has asked you, as a member of its planning group, generous sales commission on each hat sold. Sales personnel also receive a small basics to assist in some basic analysis of its stores and company policies. = The following table contains cost and revenue data for the Serenade store. These data ar 1. Calculate the annual break-even point in dollar sales and in unit sales for the Serenade store. typical of the company's many outlets: Selling price $ 31.85 Variable expenses Breakcon Awwin Saas = $ = $ Invoice cost $ 9.00 Sales Commission 7.00 Breakeren in Uw Sales 16.00 Contribution Margin $ 15.85 2. If 19,000 hats are sold in a year, what will be the Serenade store's operating income or loss? Fixed Expenses (annually) ( Advertising $ 80,000 Rent 150,000 Salaries 70,000 Operating income (loss) $ 300,000 3. The company is considering paying the Serenade store manager an incentive commission of $2 Part 2 per hat (in addition to the salesperson's commissions). If this change is made, what will be the new Thats sold 19.000 break-even point in dollar sales and in unit sales? - Part 3 Eraakaran Fawnin sales $ 2.00 Manager commission Part 4 Increased fixed salaries Reduction in Commissions Bekecenfwn Uw Sals $ 107,000 7.00 4. Refer to the original data. The company is considering eliminating sales commissions entirely in its stores and increasing Fixed salaries by $107.000 annually. If this change is made, what will be the new break-even point in dollar sales and in unit sales in the Serenade store? Eneareer Faitasala : - Breakeren Awwi Uw Sacs Part 5 - Targeted After-tax profit Income tax rate $ 250,000 25% 5. Refer to the original data. Determine the total sales dollars the company would have to achieve to earn an after-tax profit of $250,000 given that their income tax rate is 25%? Also, at this level of sales, what would be the company's Margin of Safety and Margin of Safety%? Tota/Saesirtaya atar-tayot 250.000 = Maryi Sakar = - 1 = Maryi Saray