Break Even Analysis Example 2. Conduct a break even analysis for the below example. (complete the caculations in the yellow cells) Products Product Prices Quantity Product Cost Tee shirts: $ 15.00 1900 $ 6.00 Hats: $ 5.00 700 $ 2.00 Avg Price: Avg Cost: Tee Shirts Hats Sales: Variable Cost (COGS): Gross Margin: Total $ $ $ . . . $ $ Fixed Costs Rent Utilities Insurance Salaries Internet Other fixed costs $ $ $ IS S $ 2,000.00 500.00 200.00 3,000.00 100.00 450.00 Sub total of Fixed Costs $ EBIT $ 6,250.00 12,950.00 Other fixed costs 450.00 EBIT Sub total of Fixed Costs $ $ Interest $ EBT $ Taxes (34%) $ Net Income $ 6,250.00 12,950.00 500.00 12,450.00 4,233.00 8,217.00 Break even Quantity: Break even Price: Bumple 1. Create an income statement in excel where the sales growth rate and inflation are Independent variables. Caculate the value for the yellow cells) Assume the following - Products are: Tee Shirts $ 15.00 1900 sold Hats $ 5.00 700 sold -Yearly Sales growth is -Yearly inflation is 2.50% - COGS is 40% of sales 2017 2018 Sales COGS: Gross Margint 2013 $ 32.000.00 $ 12,000.00 $ 13.200.00 1). What is the dollar value of your gross margin projection for 2016? Fored Costs Rent Utilities Insurance Salaries Internet Other fixed costs $ 2,000.00 $ 500.00 $ 200.00 $ 3.000.00 $ 100.00 $ 450.00 2. What is the difference between variable and fored costs? Sub total of Fixed Costs $ 6.250.00 $ 12.950.00 Interest $ 500.00 $ 12.450.00 Tanes (54%) S 4,233.00 Net Income $ 17.00 Page 1 of 2 US Insurance Salaries Internet Other fixed costs $ $ $ $ 200.00 3.000.00 100.00 450.00 2). What is the difference between variable and fixed costs? Sub total of Fixed Costs $ 6,250.00 EBIT $ 12.950.00 Interest S 500.00 EBT $ 12,450.00 Taxes (34%) $ 4.233.00 Net Income $ 3.217.00 Return on sales (ROSI: 25.7% 3.) does your ROS ratio show a positive or negative trend in the business? Break Even Analysis Example 2. Conduct a break even analysis for the below example. (complete the caculations in the yellow cells) Products Product Prices Quantity Product Cost Tee shirts: $ 15.00 1900 S 6,00