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 CaseOverview, Case Background, and Part 3: Managerial Decision Making.The following table summarizes the operating results for Bene Petit's first year of operations:Bene PetitFirst Year Operating Data:Single (1 Dual (1)serving)serving)3,0005,0003,00075010,0001,2505,0003,000610Family (1) Totalserving)12,00020,00048,000 61,0003,000 5,00012,000 20,0002440Customer Meals SoldTotal Customer ServingsCustomer Orders (Average = 4 meals per order)Number of Donated Meals (Average = 4 meals per order)Number of Donated Deliveries (500 meals per delivery)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.o Fixed selling expenses are $29,000 per year.• Fixed administrative expenses are $40,000 per year. Part 3 Analytics Assignment C: Cost-Volume Profit Analytics3. 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 onlythe 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?Total mealsb. How much total sales is required to earn $126,000 in net operating income?Total sales

Cost-Volume Profit (CVP) Analysis is a management accounting technique that examines the…

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: Bene Petit First Year Operating Data: Single (1 serving) 3,000 3,000 750 3,000 6 Dual (1) serving) 5,000 10,000 1,250 5,000 10 Family (1 serving) Total 12,000 20,000 48,000 61,000 5,000 20,000 40 Customer Meals Sold Total Customer Servings Customer Orders (Average = 4 meals per order) Number of Donated Meals (Average = 4 meals per order) Number of Donated Deliveries (500 meals per delivery) 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. 3,000 12,000 24 • 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.

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q