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.
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.
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter2: Basic Managerial Accounting Concepts
Section: Chapter Questions
Problem 49E: Use the following information for Exercises 2-47 through 2-49. Jasper Company provided the following...
Related questions
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 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 Dual (1)
serving)
serving)
3,000
5,000
3,000
750
10,000
1,250
5,000
3,000
6
10
Family (1) Total
serving)
12,000
20,000
48,000 61,000
3,000 5,000
12,000 20,000
24
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.
• 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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F1db4d791-fb9c-4071-8729-8887c8c44b5f%2F16acec17-0f94-4b1f-aa4b-d5b68028d925%2Fspaw7a_processed.jpeg&w=3840&q=75)
Transcribed Image Text: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 Dual (1)
serving)
serving)
3,000
5,000
3,000
750
10,000
1,250
5,000
3,000
6
10
Family (1) Total
serving)
12,000
20,000
48,000 61,000
3,000 5,000
12,000 20,000
24
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.
• 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.
Transcribed Image Text: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?
Total meals
b. How much total sales is required to earn $126,000 in net operating income?
Total sales
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Accounting Information Systems
Finance
ISBN:
9781337552127
Author:
Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College