Microsoft Excel**

Sun Sports Inc. has several kiosks in large and medium-sized shopping malls selling various styles of men's and women's sports hats, all at the same price. In addition to the regular salary, the company pays a good commission to its salespeople in order to be diligent and proactive in sales. The following selling price and cost information is representative of each of the kiosks individually. Data per hats. Sales Price $25 Variable Cost Cost per Hat $10 Sales Commission $3.25 Total Variable Cost $13.25 Anual Costs Fixed Costs Salaries $36,000 Kiosk Lease $24,000 Advertisement $52,000 Total Fixed Costs $112.000 The company wants to review its policies and provide additional incentives to boost sales. Provides management with the following analysis of its stores: 1. Find the breakeven point in units and dollars of sale of a kiosk. (10 points) 2. Prepare a cost-volume-profit graph that shows the revenues and costs of a kiosk from 0 to 30,000 hats and the breakeven point. (5 points) 3. Present the net operating results (net profit or loss) if 9,000 hats are sold per year. (10 points) 4. The company is evaluating the possibility of offering a commission of $ 1.50 per hat sold to the kiosk supervisor (in addition to the sales commissions paid to vendors at the kiosk). Determine the new breakeven point in sales dollars and units sold if this commission is added. (5 points) 5. Instead of the commission of $ 1.50 per hat sold above, another alternative that the company wishes to evaluate is to offer the supervisor only $ 1.50 for each hat sold in excess of the breakeven point. If only this commission is applied, what would the net operating result (net profit or loss) be if 12,000 hats are sold per year? (10 points) Another third alternative, in lieu of the above, is to eliminate sales commissions entirely and increase fixed salaries by an additional $ 16,000 annually. a. present the breakeven point in dollars and units of sale for this alternative. (5 points) b. Explain whether or not you would recommend this alternative and why. (5 points)