Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help on getting the Profit Margin and Return on Assets (arrows being pointed to). For Profit Margin its suppose to be 16.85% For
I need help on getting the Profit Margin and Return on Assets (arrows being pointed to).
The Great Tamale Alternative 2 - Restaurant Nathan and Cody notice there is stiff competition in the food cart and food truck industries and therefore are considering opening a traditional restaurant. Opening a restaurant would have many advantages and disadvantages, the company can expect fixed costs to increase by $125,000 a year to cover rent, equipment, furniture, salaries and other costs This alternative is exclusive of alternative 1 -so use the original financial information from page 1 (also shown below) to calculate the effects of opening a restaurant. $217,875.00 46,687.50 171,187.50 90,000.00 81,187.50 25,980.00 $55,207.50 Sales Variable costs Contribution margin Fixed costs Income before taxes Income taxes (32% rate) Net income This alternative would allow GT to increase their plate prices to $14.50 and would increase the variable cost per unit by $2.50. Assume plate sales remain at 31,125. Compute the company's new contribution margin under this alternative Compute the contribution margin both in total dollars and per unit. 1.) 2.) Compute the company's contribution margin ratio under both scenarios. (Note: Do not round the CMR for accurate calculations in the following questions). 3.) Compute the break-even point in sales dollars under each scenario. How many plates will need to be sold under each situation to break-even? Alternative 2 Requirements (continued) 4.) If the company wishes each scenario, food cart and restaurant, to generate target income $250,000, what is the amount of sales that needs to be generated? How many plates will then need to be sold? Prepare a contribution margin statement for this step and verify that your before tax income is $250,000 (after-tax net income in fact equals $170,000) for both the food cart and restaurant. 5) Assume that the company expects sales to decline by 20% next year. There will be no change in plate price. Prepare forecasted financial results for next year following the format of the contribution margin income statement as shown above with columns for each of the two types (assume a 32% tax rate, and that any loss before taxes yields a 32% tax savings). 6) Assume that the company expects sales to increase by 20% next year. There will be no change in plate price. Prepare forecasted financial results for next year following the format of the contribution margin income statement as shown above with columns for each of the two types (assume 32% tax rate, and that any loss before taxes yields a 32% tax savings). 7.) Identify at least two advantages and disadvantages of having a brick-and- mortar restaurant versus a food truck. If sales greatly decrease/or increase which alternative has the greatest change in net income? 8.) Since no advertising budget is available under this alternative, what are some creative and low-cost methods the company could employ to help advertise the change to a restaurant? %) Compute the Profit Margin and Return on Assets for each scenario assuming average total assets of $900,000. Industry averages are 15% and 7% respectively. Food Cart Restaurant 31125 Alternative 2 Plates: $217,875.00 46,687.50 $124,500.00 $326,812.50 $171,187.50 Contribution Margin Total Dollars: Unit Selling Price Unit Variable Price: Contribution Margin Per Unit: Contribution Margin Ratio: Fixed Cost: Break Even Point in Dollars: Break Even Point in Units: $7.00 0,000.00 $215,000.00 $114,545.45 $296,904.76 $16,363.64 20476.19048 $642,142.86 44286 $432,727.27 Target Net Income in Dollars Target Net Income in Units Income Before Taxes 20% Sales Decrease 20% Variable Cost Contribution Margin Fixed Cost: Income Before Taxes Income Taxes Net Income 20% Sales Increase 20% Variable Cost: Contribution Margin: Fixed Cost: Income Before Taxes Income Taxes Net Income $99,600.00 $37,350.00 90, $46,950.00 000.00$215,000.00 $46,450.00 $14,864.00 $31,926.00 S261,450.00 $56,025.00 $541,575.00 $149,400.00 $205,425.00$392,175.00 90,000.00$215,000.00 115,42500$177,175.00 $56,696.00 $120,479.00 $78,489.00 Net Income 217,875.00 $451,312.50 0.2533907057 Profit Margin Average Total Assets Return on Assests $0.06 For Profit Margin its suppose to be 16.85%
For Return on Assets is suppose to be 8.45%
please help!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started