Question: Part 3 Analytics Assignment: Managerial Decision Making [The following information applies to the questions displayed below.] These questions relate to the Integrated Analytics Case: Bene

![to the questions displayed below.] These questions relate to the Integrated Analytics](https://s3.amazonaws.com/si.experts.images/answers/2024/09/66e035ff435fb_91866e035fea1598.jpg)
Part 3 Analytics Assignment: Managerial Decision Making [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 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 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 overhead costs are $75,000 per year. - Fixed selling expenses are $29,000 per year. - Fixed administrative expenses are $40,000 per year. Part 3 Analytics Assignment C: Cost-Volume Profit Analytics 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 operating income? b. How much total sales is required to earn $126,000 in net operating income
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
