Total Sales Revenue ($5 per serving) Less: Variable costs: Customer Meals: Single Serving $ Dual Serving...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Total Sales Revenue ($5 per serving) Less: Variable costs: Customer Meals: Single Serving $ Dual Serving Family Size 15,000 $ 50,000 $240,000 Total $305,000 Input Values: Number of Customer Meals Sales mix (% of customer meals) Number of Servings per Meal Number of Servings Dual Family Single Serving Serving 3,000 15% 1 Size Total 5,000 12,000 20,000 25% 60% 100% 2 4 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 Direct Materials ($1 per customer serving) $ 3,000 $ 10,000 $ 48,000 $ 61,000 Direct Labor ($0.75 per customer meal) 2,250 3,750 9,000 15,000 Number of Customer Orders Number of Donated Meals Variable Manufacturing Overhead (60% of Direct labor) Variable Manufacturing Cost ($1.25 per donated meal) 1,350 2,250 5,400 9,000 Number of Donated Deliveries 3,750 6,250 15,000 25,000 Customer Delivery Expenses ($2 per customer order) 1,500 2,500 6,000 10,000 Price Per Serving $ 5.00 per customer serving Donation Delivery Expense ($125 per delivery) 750 1,250 3,000 5,000 Variable Costs: Total Variable Costs $ 12,600 $ 26,000 $ 86,400 $125,000 Direct Materials ($1 per serving) $ 1.00 per customer serving Direct Labor ($0.75 per customer meal) $ 0.75 per customer meal Total Contribution Margin $ 2,400 $ 24,000 $ 153,600 $ 180,000 Less: Fixed Costs Allocated Based on Sales Revenue Variable Manufacturing Overhead 60% of DL Variable cost of donated meals 60% of direct labor cost $ 1.25 per donated meal Fixed Manufacturing Expenses $ 3,689 $ Fixed Selling Expenses 1,426 12,295 $ 4,754 59,016 $ 75,000 22,820 Variable delivery expenses (customer meals) $ 2.00 per customer order 29,000 Variable delivery expenses (donated meals) $ 125.00 per delivery Fixed Administrative Expenses 1,967 6,557 31,475 40,000 Total Fixed Expenses Net Operating Profit 7,082 23,607 113,311 $ (4,682) $ 393 $ 40,289 $ 144,000 36,000 Fixed costs: Fixed manufacturing costs $ 75,000 Single Serving Dual Serving Average Contribution Margin Per Meal Sold $ 0.80 $ 4.80 Family Size Overall $ 12.80 $ Fixed selling expenses $ 29,000 Average Contribution Margin Ratio (% of Revenue) 9.00 59.02% Fixed administrative expenses $ 40,000 Total Fixed costs $ 144,000 Break-even point (customer meals sold) Break-even point (total sales revenue) Margin of Safety (Customer Meals) Margin of Safety (Sales $) Degree of Operating Leverage Single Serving Dual Serving Family Size Total 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 d. How many meals will Bene Petit donate to the homeless at the break-even point? Number of meals Total Sales Revenue ($5 per serving) Less: Variable costs: Customer Meals: Single Serving $ Dual Serving Family Size 15,000 $ 50,000 $240,000 Total $305,000 Input Values: Number of Customer Meals Sales mix (% of customer meals) Number of Servings per Meal Number of Servings Dual Family Single Serving Serving 3,000 15% 1 Size Total 5,000 12,000 20,000 25% 60% 100% 2 4 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 Direct Materials ($1 per customer serving) $ 3,000 $ 10,000 $ 48,000 $ 61,000 Direct Labor ($0.75 per customer meal) 2,250 3,750 9,000 15,000 Number of Customer Orders Number of Donated Meals Variable Manufacturing Overhead (60% of Direct labor) Variable Manufacturing Cost ($1.25 per donated meal) 1,350 2,250 5,400 9,000 Number of Donated Deliveries 3,750 6,250 15,000 25,000 Customer Delivery Expenses ($2 per customer order) 1,500 2,500 6,000 10,000 Price Per Serving $ 5.00 per customer serving Donation Delivery Expense ($125 per delivery) 750 1,250 3,000 5,000 Variable Costs: Total Variable Costs $ 12,600 $ 26,000 $ 86,400 $125,000 Direct Materials ($1 per serving) $ 1.00 per customer serving Direct Labor ($0.75 per customer meal) $ 0.75 per customer meal Total Contribution Margin $ 2,400 $ 24,000 $ 153,600 $ 180,000 Less: Fixed Costs Allocated Based on Sales Revenue Variable Manufacturing Overhead 60% of DL Variable cost of donated meals 60% of direct labor cost $ 1.25 per donated meal Fixed Manufacturing Expenses $ 3,689 $ Fixed Selling Expenses 1,426 12,295 $ 4,754 59,016 $ 75,000 22,820 Variable delivery expenses (customer meals) $ 2.00 per customer order 29,000 Variable delivery expenses (donated meals) $ 125.00 per delivery Fixed Administrative Expenses 1,967 6,557 31,475 40,000 Total Fixed Expenses Net Operating Profit 7,082 23,607 113,311 $ (4,682) $ 393 $ 40,289 $ 144,000 36,000 Fixed costs: Fixed manufacturing costs $ 75,000 Single Serving Dual Serving Average Contribution Margin Per Meal Sold $ 0.80 $ 4.80 Family Size Overall $ 12.80 $ Fixed selling expenses $ 29,000 Average Contribution Margin Ratio (% of Revenue) 9.00 59.02% Fixed administrative expenses $ 40,000 Total Fixed costs $ 144,000 Break-even point (customer meals sold) Break-even point (total sales revenue) Margin of Safety (Customer Meals) Margin of Safety (Sales $) Degree of Operating Leverage Single Serving Dual Serving Family Size Total 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 d. How many meals will Bene Petit donate to the homeless at the break-even point? Number of meals
Expert Answer:
Answer rating: 100% (QA)
a To find the number of single dual and familysized meals that must be sold to break even we need to calculate the total fixed costs which are 144000 ... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0618777181
8th Edition
Authors: Susan V. Crosson, Belverd E. Needles
Posted Date:
Students also viewed these accounting questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
In Problems 1158, perform the indicated operation, and write each expression in the standard form a + bi. 6i 3 - 4i 5
-
What basic business fundamentals must business managers grasp to effectively incorporate e-commerce into their business?
-
The biggest part of this class for me was the financial concepts and models. I already knew that finances play an integral part of a company's success, but I didn't fully understand how finances were...
-
List three ways to get input from the console and convert that input to the desired data type.
-
Gitano Products operates a job-order costing system and applies overhead cost to jobs on the basis of direct materials used in production (not on the basis of raw materials purchased). All materials...
-
b. A fence company is measuring a rectangular area in order to install a fence around its perimeter. If the length of the rectangular area is 130 yards and the width is 75 feet, what is the total...
-
Consider the following scenario in the hypothetical country of Zootopia: The government budget deficit is $80 billion, total domestic savings are $1.2 trillion, and total domestic investment in...
-
ABC Company uses the equation P300,000+ P1.75 per direct labor hour to budget manufacturing overhead. ABC has budgeted 125,000 direct labor hours for the year. Actual results were 110,000 direct...
-
Find a portfolio with payoff at time T equal to if 0 S(T) 10, if 10 S(T) 30, if 30 S(T). VT = 2ST + 30, -3ST+80, ST-40, Here, ST denotes the price of the underlying asset at time T. You can hold...
-
= 24.0 cm and b = 50.0 cm. 5. Three point-like charges are placed at the corners of a rectangle as shown in the figure, a = Find the minimum amount of work required by an external force to move the...
-
You cause a particle to move from point A, where the electric potential is 18.9 V, to point B, where the electric potential is -29.1 V. Calculate the change that occurs in the particle's...
-
Are GAAP principles still adequate for ethical behavior in accounting? How should they be revised or amended to encourage greater levels of ethical conduct in the profession?
-
2. A 220 gm of carbon dioxide gas at 200c and 0.06 m. Find its pressure according to Van der Waals' eqn (M =44 gm) (327945 Pa) Find Boyle's point for hydrogen gas v Co Calculate the compressibility...
-
5. Consider a 1.2-m-high and 2-m-wide double-pane window consisting of two 3-mm-thick layers of glass (k = 0.78 W/m K) separated by a 12-mm-wide stagnant air space (k = 0.026 W/m K). Determine the...
-
Suppose Green Network Energy needs to raise money to finance its new manufacturing facility, but their CFO does not think the company is financially capable of making the periodic interest payments...
-
Amber Lutz started a retail clothing business two years ago. Lutzs first year was very successful, but sales dropped 50 percent in the second year. A friend who is a business consultant analyzed...
-
The numbered items below are concepts that underlie activity-based systems, such as ABM and JIT. Match each concept to the related lettered element(s) of a JIT operating environment. 1. Business...
-
Hauschlager Corp. produces and supplies automotive manufacturers with the mechanisms used to adjust the positions of front seating units. Several competitors have recently entered the market, and...
-
You are studying survival times for mice given a drug at one of three doses (Low, Medium, or High). You define two dummy variables: (a) With these definitions, write the expressions for the mean...
-
The data in Table 8.25 were collected in order to study factors affecting the supply and demand for commercial air travel. Data on various aspects of commercial air travel for an arbitrarily chosen...
-
It is beneficial to be able to estimate the yield of useful product of a tree based on measurements of the tree taken before it is harvested. Measurements on four such variables were taken on a...
Study smarter with the SolutionInn App