I NEED HELP WITH PART 7 A AND B

THANKS!!

Classic Coffee Company Best friends, Nathan and Cody, decided to start their own business which would bring great coffee from all over the world to their local community. Together they have formed Classic Coffee Company, or CCC (assume their coffee shop is located a few miles from our college campus). Nathan is selecting and making the coffee they serve. Cody manages the front and back office; selling coffee to customers, paying employees, and running ads for the coffee shop. Last year, the company sold 45,000 units and had the below sales and cost figures. Sales Variable Costs Contribution Margin Fixed Costs Income Before Taxes Income Tax Net Income $135,000.00 $ 40,500.00 $ 94,500.00 $ 49,980.00 $ 44,520.00 $ 13,356.00 $ 31,164.00 The team have been in business for a year. With competition rising in the coffee industry, they know that another challenging and competitive year lies ahead of them. They are considering two alternatives and have hired you to help them make some important business decisions. Classic Coffee Company Alternative 1- Bakery Facing stiff competition from other coffee and beverage shops, Classic Coffee Company (CCC) is considering expanding its products to include bakery items. CCC would now experience higher average sales amounts per customer since beverage sales may be accompanied with food sales. This would, however, increase the company's variable costs since it would need to purchase the food items from outside vendors. The following data pertains to adding the bakery option: Total sales in the number of units would increase 25% with the added bakery option. The average sales price per unit would increase from the current $3.00 to $5.00 when food sales are added to the coffee shop. The variable cost per unit would increase to $2.50 per unit to account for the added cost of bakery items. There would be an increase in fixed costs of $25,000 for advertising to inform the public of this change. Alternative 2 - Drive Thru CCC is thinking about having a drive-thru installed. Having this amenity would help the coffee shop increase its customer base, allowing them to reach a greater number of customers. This added convenience would permit CCC to slightly increase the price of its average coffee and would not increase the per unit variable costs for the company. The following data pertains to adding the drive-thru option: This alternative is exclusive of alternative 1 Total sales in the number of units would increase by 140% from last year. The construction of the drive-thru would increase fixed costs by $129,420 - which represents one-time construction and installation costs. This alternative would allow CCC to increase their average sales price to $3.20 a cup of coffee and their variable cost per unit would remain the same at $0.90 per unit . Project Requirements A & B: A) Required Calculations - Use the posted Excel workbook tab 1 to enter your answers for the following calculations. ** Work must be shown for calculations in order to receive full credit** 1.) Compute the company's contribution margin under the 2 proposed scenarios (Alternative 1 - Bakery and Alternative 2 - Drive-thru). Compute the contribution margin both in total dollars and dollar per unit. 2.) Compute the company's contribution margin ratio under all both scenarios. (Note: DO NOT round the CMR for accurate calculations in the following questions) You may find it easier to use formulas in excel as it will use the entire figure in the formula calculation. 3.) Compute the break-even point both in units and in sales dollars under both alternatives. 4.) If the company wishes to generate target operating income of $80,000 (which after-tax would be $56,000), what is the amount of sales that needs to be generated? How many sales units will then need to be served? Prepare a contribution margin (CVP) Income Statement for this step and verify that your after-tax net income in fact equals $56,000 for both three scenarios. 5.) Assume that the company expects customer sales to decline by 20% next year. There will be no change in sales prices. Prepare forecasted financial results for next year following the format of the contribution margin (CVP) income statement for each of the three scenarios (assume a 30% tax rate). 6.) Assume that the company expects customer sales to increase by 20% next year. There will be no change in sales prices. Prepare forecasted financial results for next year following the format of the contribution margin (CVP) income statement for each of the three scenarios (assume a 30% tax rate). 7.) Compute the Profit Margin and Return on Assets for both alternatives assuming average total assets are $300,000 for bakery and $400,000 total assets for the drive-thru. Industry averages are 20% profit margin and 15% ROA B) Summary Report - Use the posted Excel Workbook tab 2 to complete your report. Comparing your calculations from alternative 1 and alternative 2 - which alternative do you recommend to Nathan and Cody? Why? The company can only pick one of the alternatives, due to the time and resources involved, so you will need to make a compelling case to support your decision. Be sure to identify any assumptions used in your analysis. If you use any outside sources, be sure to include cite the resource (you may use tab 3 for works cited if necessary). Your summary report will need to state your choice for either alternative 1 OR 2 and include substantive support for your recommendation. The report needs to be typed and be at least 4 paragraphs, and must include financial analysis from Part A. Alternative 2 - Drive-Thru ALT 1 ALT 2 1a) 248.400 Correct Correct 2 2 Contribution Margin - Total 4 pts Alternative 1 - Bakery $ 140,625 Show your work here: Sales: $281250 Variable Costs: -$140625 CM: 140625 $ Show your work here: Sales: $345600 Variable costs: -597200 CM: 248,400 1b) 2.50 2.30 Correct correct Contribution Margin - Per Unit 4 pts 2 2 $ Show your work here: Unit Sales: 95 Unit VC: -2.50 Unit CM: $2.50 $ Show your work here: Unit sales: $3.20 Unit VC: -$0.90 Unit CM: $2.30 2) Correct Correct 2 2 Contribution Margin Ratio: 4 pts Round % to 3 decimal places 50.00% Show your work here: : Unit CM: $2.50 Unit Selling Price: Divided by $5 CM Ratio: 50.00% 71.875% Show your work here: Unit CM: $2.30 Unit selling Price: divided by $3.20 CM ratio: 71.875% 3a) 29,992 78,000 Break-Even Point in UNITS: 4 pts Correct correct 2 2 Show your work here: Fixed costs: $74980 Unit CM: divided by $2.50 Break even Units: 29992 Show your work here: Fixed costs: S179400 Unit CM: divided by $2.30 Break even Units: 78,000 3b) Correct Correct 2 2 Break-Even Point in Sales DOLLARS: 4 pts 149,960 Show your work here: Fixed Costs: $74980 CM ratio: divided by 50.00% Break even point in $: 149,960 249.600 Show your work here: Fixed costs: S179400 CM ratio: divided by 71.875% Break even point in: $249,600 4a) 360,904 Correct Correct 1 1 Sales Dollars needed to earn target income of $80,000 ($56,000 net) 2 pts **Round to nearest dollar (NO DECIMALS) $ 309,960.00 Show your work here: Fixed costs: $74980 Target net income: + $80,000 154980 CM ratio: divided by 50% Sales dollars: $309,960.00 Show your work here Fixed costs: $179400 Target net income: +$80,000 259400 CM ratio: divided by 71.875% Sales dollars: $360904 4b) 61992 112.783 Correct Correct 1 1 Sales UNITS needed to earn target income of $80,000 ($56,000 net) Show your work here: 2 pts Fixed costs: $74980 **Round to nearest whole unit (no decimals) Target net income: +$80,000 Show your work here: Fixed costs: S179400 Target net income: +$80,000 154980 259400 CM Unit: divided by 2.50 Sales units: 61992 CM unit: divided by 2.30 Sales units: 112783 309,960 $ 0.25 0.25 360,904 101,504 154,980 S 0.5 0.5 154.980 $ 259,400 0.25 0.25 4c) CVP Income Statement to prove income: 4pts Sales & Variable costs $ $ Contribution Margin $ Fixed Costs $ Operating Income $ Income Taxes $ Net Income S 74,980 179,400 Correct correct Correct correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct 0.25 $ $ 0.25 80,000 0.25 0.25 80,000 24,000 56,000 0.25 0.25 $ $ 24,000 56,000 0.25 0.25 5) CVP Income Statement - Sales decline 20% 6pts Sales $ Variable costs $ 225,000 $ 276,480 0.5 0.5 112.500 $ 77.760 Correct correct Correct Correct Correct Correct 0.5 0.5 112.500 $ 0.25 0.25 74.980 S 198,720 179,400 19,320 Correct Correct 0.5 Contribution Margin S Fixed Costs $ Operating Income $ Income Taxes $ 0.5 37,520 S Correct Correct 0.25 0.25 Correct Correct 0.5 0.5 11,256 $ 26,264 $ 5,796 13,524 Net Income $ Correct Correct 0.5 0.5 Alternative 1 - Bakery Alternative 2 - Drive-Thru ALT 1 ALT 2 6) CVP Income Statement - Sales increase 20% Opts Sales $ 337,500 S 414,720 0.5 0.5 Variable Costs $ 168,750 116,640 0.5 0.5 168,750 S 0.25 Correct Correct Correct correct Correct Correct Correct Correct Correct Correct 0.25 74.980 $ 0.5 Contribution Margin $ Fixed Costs $ Operating Income $ Income Taxes $ Net Income $ 0.5 93.770 298,080 179,400 118,680 35,604 83,076 S 0.25 0.25 $ Correct Correct 0.5 0.5 28,131 65,639 S Correct Correct 0.5 0.5 7a) Incorrect Incorrect Profit Margin 2 pts Round percentage to 2 decimal places i.e. 12.15% You must put % sign CONTRIBUTION: 140.625 (-) FIXED COST: 74,980 NET PROFIT: 65,645 CONTRIBUTION: 248,000 (-) FIXED COST: 179,400 NET PROFIT: 69,000 PROFIT MARGIN: 23.34 % PROFIT MARGIN: 19.97 % 7a) Incorrect Incorrect 0 0 Return on Assets 2 pts Round percentage to 2 decimal places i.e. 12.15% You must put % sign NET PROFIT: 65,645 AVERAGE ASSET: 300,000 NET PROFIT: 69,000 AVERAGE ASSET: 400,000 RETURN ON ASSETS: 21,88 % RETURN ON ASSETS: 17.25 % Part A 40