Required information [The following information applies to the questions displayed below.] These questions relate to the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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: Bene Petit First Year Operating Data: Single (1 serving) Dual (2 servings) Family (4 Total servings) 3,000 5,000 12,000 20,000 3,000 10,000 48,000 61,000 750 1,250 3,000 5,000 3,000 5,000 12,000 20,000 6 10 24 40 Customer Meals Sold Total Customer Servings Customer Orders (Average = 4 meals per order) Number of Donated Meals (1 per customer meal) 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. Fixed selling expenses are $29,000 per year. Fixed administrative expenses are $40,000 per year. The attached 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 Analysis (starting data).xlsx 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 meals must be sold to break even? Single serving meal Dual serving meal Family size meal b. How much is the total sales revenue at the break-even point? 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? Margin of safety c. What was Bene Petit's margin of safety (in total meals sold) for the first year of operations? Margin of safety d. How many meals will Bene Petit donate to the homeless at the break-even point? Number of meals 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 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? Profit 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: Bene Petit First Year Operating Data: Single (1 serving) Dual (2 servings) Family (4 Total servings) 3,000 5,000 12,000 20,000 3,000 10,000 48,000 61,000 750 1,250 3,000 5,000 3,000 5,000 12,000 20,000 6 10 24 40 Customer Meals Sold Total Customer Servings Customer Orders (Average = 4 meals per order) Number of Donated Meals (1 per customer meal) 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. Fixed selling expenses are $29,000 per year. Fixed administrative expenses are $40,000 per year. The attached 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 Analysis (starting data).xlsx 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 meals must be sold to break even? Single serving meal Dual serving meal Family size meal b. How much is the total sales revenue at the break-even point? 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? Margin of safety c. What was Bene Petit's margin of safety (in total meals sold) for the first year of operations? Margin of safety d. How many meals will Bene Petit donate to the homeless at the break-even point? Number of meals 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 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? Profit
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Tubby Toys estimates that its new line of rubber ducks will generate sales of $7 million, operating costs of $4 million, and a depreciation expense of $1 million. If the tax rate is 35%, what is the...
-
In 1967, a Chicago brewer, Meister Brau, Inc., began making and selling a reduced-calorie, reduced-carbohydrate beer under the name LITE. Late in 1968, that company filed applications to register...
-
The Mountain States Office of State Farm Insurance Company reports that approximately 85% of all automobile damage liability claims are made by people under 25 years of age. A random sample of five...
-
When does a deficit occur?
-
4. Sleekfon and Sturdyfon are two major cell phone manufacturers that have recently merged. Their current market sizes are as shown in Table 5-9. All demand is in millions of units. Sleekfon has...
-
Discuss it in terms of concept analysis and evaluation of Relationships to Information Technology and Healthcare : Delivery of value in healthcare, regulatory requirements, and potential changes....
-
(Related to Checkpoint 11.2) (Calculating EAC) Barry Boswell is a financial analyst for Dossman Metal Works, Inc. and he is analyzing two alternative configurations for the firm's new plasma cutter...
-
(c) Identify the four (4) advantages of mass customization and examine with appropriate examples, how supermarkets may employ Pine and Gilmore's four (4) mass customization to create value for their...
-
An asset used in a four-year project falls in the five-year MACRS class for tax purposes. The asset has an acquisition cost of $8,100,000 and will be sold for $1,980,000 at the end of the project. If...
-
The rent on an apartment you like is $1700 per month. The monthly mortgage payment for a house you like would be $1900, of which approximately $1600 would go toward interest. Decide whether your...
-
Which social science discipline focuses on the family as who is related to whom? Anthropology or Social Psychology or Psychology or Sociology
-
14. The Centipede Company uses standard costing. The following data are available for October: Actual quantity of direct materials used 23,500 pounds Standard price of direct materials P 2 per pound...
-
Shiloh Chemicals, Inc., which manufactures products on a continuous basis, had 800 units in process in Dept. 1, one-half completed, at the beginning of May. The costs in April for processing these...
-
Define cultural intelligence. Cite the books or journal articles you found in Capella's library. Explain why cultural intelligence is important for HR practitioners and other organizational managers.
-
If demand is relatively _________ elastic than supply in the relevant region, the largest portion of a tax is paid by the producer.
-
Imagine driving a car with daggers sticking out of the steering wheelpointing directly at your chest. Would you drive more safely? Why?
-
Describe and explain the circular flow model. Scarcity, Trade-Offs, and Production Possibilities CHAPTER 3
Study smarter with the SolutionInn App