Required information [The following information applies to the questions displayed below] These questions relate to the Integrated Analytics Case. Bene Petit. Select the appropriate eBook link to open the Case Overview, Case Background, and Part 3: Managerial Decision Making The following table summarizes the operating results for Bene Petit's first year of operations: Additional information about selling prices, variable costs, and fxed costs is summanzed below - The averege sales price for customer meals is 55 per serving - The average direct materials (ingredients) cost of customer meais is $1 per serving - Direct labor costs average 5075 per customer meal. - Variable manufacturing overheod costs are applied at a rate equal to 60% of direct labor. - The delivery expense for customer meals is $2 per customer order. - The incremental cost of producing the donated meals is $1.25 per meal - The delivery expense for donated meals is $125 per delivery to community partners - The following fixed costs are allocated to customer meals based on total sales revenue: - Fixed manufacturing overheod costs are $75,000 per year - Fixed selling expenses are $29,000 per year. * Foxed administrative expenses are $40,000 per year. The attachied excel file shows a contribution margin income statement based on these starting assumptions: You should return to this starting spreadsheet for each part of the case below Part 3 CVP Anelysisstanting dato) wisx 2. Treat the following questions as independent scenarios. Use the starting spreadsheet to complete the following break-even analysis questions a. How many single-, dual- and family-sized meais must be sold to break even? b. How much is the total sales revenue at the break-even point? c. What was Bene Petit's margin of safety (in total meals sold) for the first year of operations? d. How many meals will Bene Petit donate to the homeless at the break-even point? 3. Use the "goal seek" function in Excel to determine how many customer meals (in total and by product line) must be sold to earn $126,000 in net operating income. Hint Use the "goal seek" function to change net operating income to $126,000 by changing only the cell that contains the total number of customer meals sold a. How many total meals must be sold to earn $126,000 in net operatindincome? b. How much total sales is required to eam $126.000 in net operating income? 6. Assume that Taylor is considering raising the price per serving by 20% but expects a corresponding drop in demand. How much would profit increase or decrease compared to the starting profit of $36,000 ? Bene Petit is currently paying employees to dellver the meal boxes to customers' doorsteps using a small fleet of dellvery trucks. As he business expands, Taylor is trying to decide whether she should outsource to a private delivery company such as FedEx or UPS. he following additional details are avallable: - Variable delivery expenses for fuel and driver wages are $2 per customer order. - Fixed delivery expenses for insurance and maintenance on delivery trucks are currently $12,000 per year. - To expand delivery capacity beyond 7,500 deliveries per year, Bene Petit would need to invest in additional delivery trucks, Which would increase fixed delivery expenses to $30,000 per year. This would provide the capacity to make up to 15,000 deliveries per year. - The contract rate for third party logistics providers such as UPS and FedEX is $5 per dellvery. Use the Tableau dashboard below to answer the questions. a. At the current volume of 5.000 orders per year, what are the incremental savings from insourcing or outsourcing? b. If Bene Pett expects demand to stabilize at about 8,000 orders per year, what will the incremental savings from insourcing or outsourcing be? c. If Bene Petit expects demand to increase beyond d,200 orders per year, at what point will they be indifferent toward insourcing versus outsourcing? d. If Bene Pext expects to seli 13,000 orders per yeot, what will the incremental savings from insourcing of outsoureing be? 4. Perform a "What if" analysis to see how operating results will change if sales increase by 12% during the second year of operations. a. What is the new net operating income? b. What is the new degree of operating leverage? c. If sales increased by 10N in the third yeat, what percentage growth in proft can the Fompory expect? d. What is the predicted operating prott in year 37 These questions relate to the integrated Analytics Case: Bene Petit Select the appropriate eBook link to open the Case Overview, Case Background, and Part 3 Managerial Decision Making. The following table summarizes the operating results for Bene Petit's first year of operations: Additional information about seling prices, variable costs, and fixed costs is summarized below - The average sales price for customer meals is $5 per serving - The average direct materials (ingredients) cost of customer meals is $1 per serving. - Direct labor costs average $0.75 per customer meal - Variable manufacturing overhead costs are oppled at a rate equal to 60% of clirect labor. - The delivery expense for customer meals is $2 per customer order. - The incremental cost of producing the donated meals is $1.25 per meal - The dellvery expense for donated meals is $125 per delivery to community portners - The following fixed costs are allocated to customer meals based on total sales revenue. - Fixed manulacturing overhead costs ate $75,000 per year - Faed selling expenses are $29,000 per year. - Fuced administrative expenses are $40,000 per year. The atrached excel file shows a contribution margin income statement based on these starting assumptions You should return to this starting spreadsheet for each part of the cdse below. 7. If Bene Petit wants to increase net operating income to $121,400 by changing only the selling price per serving. what should the new pnce be? Required information [The following information applies to the questions displayed below] These questions relate to the Integrated Analytics Case. Bene Petit. Select the appropriate eBook link to open the Case Overview, Case Background, and Part 3: Managerial Decision Making The following table summarizes the operating results for Bene Petit's first year of operations: Additional information about selling prices, variable costs, and fxed costs is summanzed below - The averege sales price for customer meals is 55 per serving - The average direct materials (ingredients) cost of customer meais is $1 per serving - Direct labor costs average 5075 per customer meal. - Variable manufacturing overheod costs are applied at a rate equal to 60% of direct labor. - The delivery expense for customer meals is $2 per customer order. - The incremental cost of producing the donated meals is $1.25 per meal - The delivery expense for donated meals is $125 per delivery to community partners - The following fixed costs are allocated to customer meals based on total sales revenue: - Fixed manufacturing overheod costs are $75,000 per year - Fixed selling expenses are $29,000 per year. * Foxed administrative expenses are $40,000 per year. The attachied excel file shows a contribution margin income statement based on these starting assumptions: You should return to this starting spreadsheet for each part of the case below Part 3 CVP Anelysisstanting dato) wisx 2. Treat the following questions as independent scenarios. Use the starting spreadsheet to complete the following break-even analysis questions a. How many single-, dual- and family-sized meais must be sold to break even? b. How much is the total sales revenue at the break-even point? c. What was Bene Petit's margin of safety (in total meals sold) for the first year of operations? d. How many meals will Bene Petit donate to the homeless at the break-even point? 3. Use the "goal seek" function in Excel to determine how many customer meals (in total and by product line) must be sold to earn $126,000 in net operating income. Hint Use the "goal seek" function to change net operating income to $126,000 by changing only the cell that contains the total number of customer meals sold a. How many total meals must be sold to earn $126,000 in net operatindincome? b. How much total sales is required to eam $126.000 in net operating income? 6. Assume that Taylor is considering raising the price per serving by 20% but expects a corresponding drop in demand. How much would profit increase or decrease compared to the starting profit of $36,000 ? Bene Petit is currently paying employees to dellver the meal boxes to customers' doorsteps using a small fleet of dellvery trucks. As he business expands, Taylor is trying to decide whether she should outsource to a private delivery company such as FedEx or UPS. he following additional details are avallable: - Variable delivery expenses for fuel and driver wages are $2 per customer order. - Fixed delivery expenses for insurance and maintenance on delivery trucks are currently $12,000 per year. - To expand delivery capacity beyond 7,500 deliveries per year, Bene Petit would need to invest in additional delivery trucks, Which would increase fixed delivery expenses to $30,000 per year. This would provide the capacity to make up to 15,000 deliveries per year. - The contract rate for third party logistics providers such as UPS and FedEX is $5 per dellvery. Use the Tableau dashboard below to answer the questions. a. At the current volume of 5.000 orders per year, what are the incremental savings from insourcing or outsourcing? b. If Bene Pett expects demand to stabilize at about 8,000 orders per year, what will the incremental savings from insourcing or outsourcing be? c. If Bene Petit expects demand to increase beyond d,200 orders per year, at what point will they be indifferent toward insourcing versus outsourcing? d. If Bene Pext expects to seli 13,000 orders per yeot, what will the incremental savings from insourcing of outsoureing be? 4. Perform a "What if" analysis to see how operating results will change if sales increase by 12% during the second year of operations. a. What is the new net operating income? b. What is the new degree of operating leverage? c. If sales increased by 10N in the third yeat, what percentage growth in proft can the Fompory expect? d. What is the predicted operating prott in year 37 These questions relate to the integrated Analytics Case: Bene Petit Select the appropriate eBook link to open the Case Overview, Case Background, and Part 3 Managerial Decision Making. The following table summarizes the operating results for Bene Petit's first year of operations: Additional information about seling prices, variable costs, and fixed costs is summarized below - The average sales price for customer meals is $5 per serving - The average direct materials (ingredients) cost of customer meals is $1 per serving. - Direct labor costs average $0.75 per customer meal - Variable manufacturing overhead costs are oppled at a rate equal to 60% of clirect labor. - The delivery expense for customer meals is $2 per customer order. - The incremental cost of producing the donated meals is $1.25 per meal - The dellvery expense for donated meals is $125 per delivery to community portners - The following fixed costs are allocated to customer meals based on total sales revenue. - Fixed manulacturing overhead costs ate $75,000 per year - Faed selling expenses are $29,000 per year. - Fuced administrative expenses are $40,000 per year. The atrached excel file shows a contribution margin income statement based on these starting assumptions You should return to this starting spreadsheet for each part of the cdse below. 7. If Bene Petit wants to increase net operating income to $121,400 by changing only the selling price per serving. what should the new pnce be