As a recently hired MBA intern, you are working in a consulting capacity to provide an analysis for Al Dente's Italian Restaurant. A financial income Statement is presented below:
Sales $4,640,560
Cost of sales (all variable) $2,679,008
Gross Margin $1,961,553 Operating expenses:
Variable $478,117
Fixed $367,521
Total operating expenses: $845,638
Administative expenses (all fixed) $970,725
Net operating income $145,190
This income statement presents the sales, expenses and pre-tax operating income for a local eating facility. At Al Dente, the average meal cost for lunches and dinners are $20 and $40 respectively. Al Dente serves both lunch and dinner 300 days per year and serves twice as many lunches as dinners. As the MBA intern you are to prepare a managerial accounting focused report to the owners of Al Dente's Italian Restaurant, to include the following
1. Prepare a contribution margin income statement using the given financial data. Use the following format: in an Excel Spreadsheet with Calculations and formulas shown
Sales
Variable costs
Cost of sales
Operating
Total variable costs
Contribution margin
Fixed costs
Operating Administrative
Total fixed costs
Net operating income
2. Compute the break-even volume of the number of lunches and dinners. Assume that the CM% for each meal category is the same as the average CM% as calculated in #1. Hint: To solve a break even sales mix, use the horizontal formula: Net operating income = ($Sales – $Variable costs) – $fixed costs Net operating income = $CM – $fixed costs At Breakeven, NOI = $0 Therefore, $CM = $ Fixed costs Now solve for the unit $CM for each item. Let X be the number of dinners, 2X the number of lunches. $CM is the combined total of the $CM for dinners, and the $CM for lunches.
3. Using the CM income statement format, verify that your calculated break-even volume for lunches and dinners results in a NOI of zero (hint: in your prepared CM statement from #1, breakout the Sales dollars into subcategories lunch and dinner as shown below, using the values of X for in the # of meals cells). Present the entire CM statement at the BE level.
4. The owner of the restaurant is thinking of increasing sales through additional advertising, which he will incur as an administrative expense. The proposed additional advertising campaign will cost $25,000. He anticipates that the additional advertising expense will result in an additional 6 lunches and 3 dinners on average, per day. Illustrate the impact on NOI assuming the changes above (hint: show a revised CM statement). Hint: for this type of ‘whatif’, compare the additional contribution margin impact on NOI given the change in units and change in fixed costs
1. Contribution Margin Income Statement
Sales (A) = $4,640,560
Variable costs
Cost of sales (B) = $2,679,008
Operating (C) = $478,117
Total variable costs (D) = $3,157,125 [(B) + (C)]
Contribution margin (E) = $1,483,435 [(A) - (D)]
Fixed costs
Operating (F) = $367,521
Administrative (G) = $970,725
Total fixed costs (H) = $1,338,246 [(F) + (G)]
Net operating income = $145,189 [(E) - (H)]
As a recently hired MBA intern, you are working in a consulting capacity to provide an analysis for Al Dente's Italian R...
MBA 6100 Case Study 1 Spring 2019 Block 2 As a recently hired MBA intern, you are working in a consulting capacity to provide an analysis for Al Dente's Italian Restaurant. A financial income Statement is presented below: Sales $4,856,400 Cost of sales (all variable) $2,803,613 Gross Margin $2,052,788 Operating expenses: Variable $500,355 Fixed $384,615 Total operating expenses: $884,970 Administative expenses (all fixed) $1,015,875 Net operating income $151,943 This income statement presents the sales, expenses and pre-tax operating income for...
MBA 6100 Case Study 1 Spring 2019 Block 2 As a recently hired MBA intern, you are working in a consulting capacity to provide an analysis for Al Dente's Italian Restaurant. A financial income Statement is presented below: Sales $4,640,560 Cost of sales (all variable) $2,679,008 Gross Margin $1,961,553 Operating expenses: Variable $478,117 Fixed $367,521 Total operating expenses: $845,638 Administative expenses (all fixed) $970,725 Net operating income $145,190 This income statement presents the sales, expenses and pre-tax operating income for...
As a recently hired MBA intern, you are working in a consulting capacity to provide an analysis for Al Dente's Italian Restaurant. A financial income Statement is presented below: Sales $2,698,000 Cost of sales (all variable) $1,557,563 Gross Margin $1,140,438 Operating expenses: Variable $277,975 Fixed $213,675 Total operating expenses: $491,650 Administative expenses (all fixed) $564,375 Net operating income $84,413 This income statement presents the sales, expenses and pre-tax operating income for a local eating facility. At Al Dente, the average...
6100 Case study Case #1 Sales $2,158,400 Cost of sales (all variable) $1,246,050 Gross Margin $912,350 Operating expenses: Variable $222,380 Fixed $170,940 Total operating expenses: $393,320 Administative expenses (all fixed) $451,500 Net operating income $67,530 The above income statement presents the sales, expenses and pre-tax operating income for a local eating facility. At this facility, the average meal cost for lunches and dinners are $20 and $40 respectively. This restaurant serves both lunch and dinner 300 days per year, and...
• Average dinner sale price - $40 Income statement - La Brasserie restaurant Revenues $2,098,400 • Average lunch sale price - $20 Cost of sales, all variable 1.246,500 • Assume that the variable cost of preparing and Gross profit 851,900 serving dinner is also twice that of a lunch Operating expenses • The restaurant serves twice as many lunches Variable 222,380 as dinners Fixed 170,940 Administrative expenses, all fixed 451,500 • Assume - restaurant open for 305 days Net income...
ICE-3 (Work as a group of 3-4. Submit to Canvas by 02/17/2020, 11:59 PM) Income statement -La Brasserie restaurant $2,098,400 1.246,500 851,900 • Average dinner sale price - $40 • Average lunch sale price - $20 • Assume that the variable cost of preparing and serving dinner is also twice that of a lunch • The restaurant serves twice as many lunches as dinners • Assume - restaurant open for 305 days Revenues Cost of sales, all variable Gross profit...
ICE-3 (Work as a group of 3-4. Submit to Canvas by 02/17/2020, 11:59 PM) Income statement -La Brasserie restaurant $2,098,400 1.246,500 851,900 • Average dinner sale price - $40 • Average lunch sale price - $20 • Assume that the variable cost of preparing and serving dinner is also twice that of a lunch • The restaurant serves twice as many lunches as dinners • Assume - restaurant open for 305 days Revenues Cost of sales, all variable Gross profit...
Cost-Volume-Profit Analysis P6-A Melon Company produces a knockoff watch that sells for $40 each. Variable costs are $12 each and fixed costs are $210,000 each year. Required: 1) What is this product's contribution margin ratio (CM %)? 2) What is this company's break-even point in sales dollars? 3) If sales increase $400,000, how much will net income increase (assuming they are operating within the relevant range and fixed costs do not change) ? 4) Assume 20,000 units were sold last...
Huels & Sons Inc. manufactures fishing products. As the senior financial analyst of the company, you are responsible for prepare the company's financial statements for internal use. The cost accountant provided you the following estimated financial data for the year 2020: Huels & Sons Inc. Projected Income Statement For the Year Ending December 31, 2020 $240,000 $60,000 36,000 Sales (12,000 units) Less variable costs: Variable manufacturing costs Variable selling costs Total variable costs Contribution margin Less fixed costs: Fixed manufacturing...
Exercise 6-10 Multiproduct Break-Even Analysis (L06-9) Lucido Products markets two computer games: Claimjumper and Makeover. A contribution format Income statement for a recent month for the two games appears below. Sales Variable expenses Contribution margin Fixed expenses Net operating income Claimjurper $ 112,890 34,600 $ 77,400 Makeover $ 56,000 7.489 $ 48,600 Total $ 168,000 42, eee 126,600 83,780 $ 42,380 Required: 1. What is the overall contribution margin (CM) ratio for the company? 2 What is the company's overall...