Please prepare Cost-Volume-Profit (CVP) calculations for a small business, reflect on those calculations, and make a recommendation for the company based on your findings and research. Hint: for the "current situation" calculations, you should get a Composite CMu of $5.58. The Birch Bench is a caf located in Campbell, California operated by husband and wife team Leo and Jerry Bernard. The couple emigrated to the region from Europe in 1971 and brought with them their family recipes for delicious quiches and fruit pies. Their caf has been a community staple since it started in 1981 with the majority of its business coming from repeat, local, elderly customers. The caf operates in the morning only from 6:00am-12:00pm when it serves hot beverages, its popular breakfast quiches, and slices of its fresh fruit pies. The sales mix and financial data for its offerings are as follows: Beverages (hot coffee) Breakfast quiches (slice) Fruit pies (slice) Percent of Total Sales 25% 60% 15% 100% Sales price per unit $3.00 $11.50 $5.00 Variable cost per unit $0.60 $3.45 $4.00 The majority of customers are dine-in customers, but the caf does offer orders to-go when requested in person or over the phone. Of those customers dining in, they have an average dine-in time of 50 minutes. Order placing and service takes no more than 15 minutes, the rest of the time the patrons spend enjoying their meal and chatting with other regular customers or staff. The caf has fixed costs of $205,000. In 2020, the caf generated net income of $107,000. To increase profitability, the owners are considering the following options for 2021. Option 1: Limited Delivery Program As more and more of its customers age, they are less likely to come in for dining or picking up a to-go order. Because of this, the owners are considering hiring some part-time drivers to deliver food to its regular customers within a 10-mile radius. This limited delivery option would require customers to place their orders by phone the day before. Delivery would occur the day following the order, during the time window requested by the customer (still falling between the normal business hours of 6am to 12pm). This option would increase variable costs by 8%, have no impact on total fixed costs, and increase the sales volume by 10% but not impact the sales price per item or sales mix. Option 2: Expanded Delivery Program Under this option, the caf will hire a full-time manager to run the company's new delivery program. Delivery, under this option, will be expanded to all interested individuals (not just current, loyal customers) and would reach beyond a 10-mile radius. Customers can place their order by phone or the company's website for same day for delivery. This option would increase variable costs by 10%, increase fixed costs by $65,000 per year, increase the sales volume by 25% but not impact the sales price per item or sales mix. Requirements: Calculations (Current Situation) ---------Please round to two decimal places, and please show your work steps since I'm not quite good at accounting and I really want to figure these questions out, thank you. 1.) Calculate the company's current level of unit sales and sales dollars based on the net income of $107,000. How much of each product is the company selling at this net income? Prepare a Contribution Margin Income Statement for the company at this level. 2.) What is the company's total break-even point in units? Using this information, determine the break- even point in sales dollars? What is the company's break-even point in units and sales dollars for each product given the current situation? 3.) What is the company's margin of safety in units, sales dollars, and as a percentage for the current situation? 4.) What is the company's operating leverage for the current situation? Requirements: Calculations (Option 1) 5.) Calculate the company's level of unit sales and sales dollars based on the increase in sales volume of 10% and increase in variable costs of 8%. Prepare a Contribution Margin Income Statement for the company at this level. 6.) What is the company's total break-even point in units? Using this information, determine the break- even point in sales dollars. What is the company's break-even point in units and sales dollars for each product? 7.) What is the company's margin of safety in units, sales dollars, and as a percentage under this option? 8.) What is the company's operating leverage for this option? Requirements: Calculations (Option 2) 9.) Calculate the company's level of unit sales and sales dollars based on the increase in sales volume of 25%, increase in variable costs of 10%, and increase in fixed costs by $65,000. Prepare a Contribution Margin Income Statement for the company at this level. 10.) What is the company's total break-even point in units? Using this information, determine the break- even point in sales dollars? What is the company's break-even point in units and sales dollars for each product? 11.) What is the company's margin of safety in units, sales dollars, and as a percentage under this option? 12.) What is the company's operating leverage for this option? Again I would really appreciate if you can show your calculation steps!! Thank you Please prepare Cost-Volume-Profit (CVP) calculations for a small business, reflect on those calculations, and make a recommendation for the company based on your findings and research. Hint: for the "current situation" calculations, you should get a Composite CMu of $5.58. The Birch Bench is a caf located in Campbell, California operated by husband and wife team Leo and Jerry Bernard. The couple emigrated to the region from Europe in 1971 and brought with them their family recipes for delicious quiches and fruit pies. Their caf has been a community staple since it started in 1981 with the majority of its business coming from repeat, local, elderly customers. The caf operates in the morning only from 6:00am-12:00pm when it serves hot beverages, its popular breakfast quiches, and slices of its fresh fruit pies. The sales mix and financial data for its offerings are as follows: Beverages (hot coffee) Breakfast quiches (slice) Fruit pies (slice) Percent of Total Sales 25% 60% 15% 100% Sales price per unit $3.00 $11.50 $5.00 Variable cost per unit $0.60 $3.45 $4.00 The majority of customers are dine-in customers, but the caf does offer orders to-go when requested in person or over the phone. Of those customers dining in, they have an average dine-in time of 50 minutes. Order placing and service takes no more than 15 minutes, the rest of the time the patrons spend enjoying their meal and chatting with other regular customers or staff. The caf has fixed costs of $205,000. In 2020, the caf generated net income of $107,000. To increase profitability, the owners are considering the following options for 2021. Option 1: Limited Delivery Program As more and more of its customers age, they are less likely to come in for dining or picking up a to-go order. Because of this, the owners are considering hiring some part-time drivers to deliver food to its regular customers within a 10-mile radius. This limited delivery option would require customers to place their orders by phone the day before. Delivery would occur the day following the order, during the time window requested by the customer (still falling between the normal business hours of 6am to 12pm). This option would increase variable costs by 8%, have no impact on total fixed costs, and increase the sales volume by 10% but not impact the sales price per item or sales mix. Option 2: Expanded Delivery Program Under this option, the caf will hire a full-time manager to run the company's new delivery program. Delivery, under this option, will be expanded to all interested individuals (not just current, loyal customers) and would reach beyond a 10-mile radius. Customers can place their order by phone or the company's website for same day for delivery. This option would increase variable costs by 10%, increase fixed costs by $65,000 per year, increase the sales volume by 25% but not impact the sales price per item or sales mix. Requirements: Calculations (Current Situation) ---------Please round to two decimal places, and please show your work steps since I'm not quite good at accounting and I really want to figure these questions out, thank you. 1.) Calculate the company's current level of unit sales and sales dollars based on the net income of $107,000. How much of each product is the company selling at this net income? Prepare a Contribution Margin Income Statement for the company at this level. 2.) What is the company's total break-even point in units? Using this information, determine the break- even point in sales dollars? What is the company's break-even point in units and sales dollars for each product given the current situation? 3.) What is the company's margin of safety in units, sales dollars, and as a percentage for the current situation? 4.) What is the company's operating leverage for the current situation? Requirements: Calculations (Option 1) 5.) Calculate the company's level of unit sales and sales dollars based on the increase in sales volume of 10% and increase in variable costs of 8%. Prepare a Contribution Margin Income Statement for the company at this level. 6.) What is the company's total break-even point in units? Using this information, determine the break- even point in sales dollars. What is the company's break-even point in units and sales dollars for each product? 7.) What is the company's margin of safety in units, sales dollars, and as a percentage under this option? 8.) What is the company's operating leverage for this option? Requirements: Calculations (Option 2) 9.) Calculate the company's level of unit sales and sales dollars based on the increase in sales volume of 25%, increase in variable costs of 10%, and increase in fixed costs by $65,000. Prepare a Contribution Margin Income Statement for the company at this level. 10.) What is the company's total break-even point in units? Using this information, determine the break- even point in sales dollars? What is the company's break-even point in units and sales dollars for each product? 11.) What is the company's margin of safety in units, sales dollars, and as a percentage under this option? 12.) What is the company's operating leverage for this option? Again I would really appreciate if you can show your calculation steps!! Thank you