Donaldson Company's contribution format income statement for the most recent month is shown below: Per Unit...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Donaldson Company's contribution format income statement for the most recent month is shown below: Per Unit $12.50 7.50 $5.00 Sales Variable expenses Contribution margin Fixed expenses Net operating income Total $500,000 300,000 200,000 180,000 $ 20,000 The company sold 40,000 units in its most recent month and its relevant range of production is 30,000 to 50,000 units. Click here to download the Excel template, which you will use to answer the questions that follow. Click here for a brief tutorial on Goal Seek in Excel. Click here for a brief tutorial on SOLVER in Excel. Click here for a a brief tutorial on Charts in Excel, 4. Using Charts: a. Prepare a profit graph for Donaldson Company. To prepare your graph, use sales volumes of zero units and 50,000 units as shown in cells 823 and 824. As a first step, create a formula in cell C23 that computes the profit when unit sales are zero. Your formula should reference data from the contribution format income statement provided in rows 4 through 18 of the worksheet. As a second step, copy your formula from cell C23 to cell C24. The profit (or loss) shown in cells C23 and C24 provide the two data points that you need to create a profit graph. b. Prepare a CVP graph for Donaldson Company. To prepare your graph, use sales volumes of zero units and 50,000 units as shown in cells 829 and 830. As a first step, create formulas in cells C29, D29, and E29 that compute the total sales dollars, total fixed expenses, and total expenses when unit sales are zero. Your formulas should reference data from the contribution format income statement provided in rows 4 through 18 of the worksheet. As a second step, copy your formulas from cells C29, D29, and E29, to cells C30, D30, and E30. The information shown in rows 29 and 30 provide the data points that you need to create a CVP graph. 5. Next, assume the company can decrease its variable expense per unit from $7.50 to $7.00 and decrease its fixed expenses from $180,000 to $150,000. Based on these assumptions: a. Prepare a profit graph for Donaldson Company. b. Prepare a CVP profit graph for Donaldson Company. 1 3 4 5 Data Inputs Unit sales 6 Selling price per unit 27 Variable expense per unit 8 Total fixed expenses 9 10 11 12 Sales 13 Variable expenses 14 Contribution margin 15 Fixed expenses 29 30 31 16 Net operating income 17 18 Net profit margin percentage 19 20 21 Profit Graph Information 22 23 27 CVP Graph Information Contribution Format Income Statement Total Per Unit Data Points $ $ $ Data Points $ 40,000 12.50 7.50 180,000 $ 500,000 $ 300,000 200,000 $ 180,000 20,000 4.00% 50,000 50,000 Profit 12.50 7.50 5.00 Sales Dollars Donaldson Company % 100% 60% 40% Fixed Expenses Total Expenses Margin of Safety Actual sales (a) Break-even sales (b) Margin of safety in dollars (a)-(b) Margin of safety percentage $ $ $ G 500,000 450,000 50,000 10.00% H Donaldson Company's contribution format income statement for the most recent month is shown below: Per Unit $12.50 7.50 $5.00 Sales Variable expenses Contribution margin Fixed expenses Net operating income Total $500,000 300,000 200,000 180,000 $ 20,000 The company sold 40,000 units in its most recent month and its relevant range of production is 30,000 to 50,000 units. Click here to download the Excel template, which you will use to answer the questions that follow. Click here for a brief tutorial on Goal Seek in Excel. Click here for a brief tutorial on SOLVER in Excel. Click here for a a brief tutorial on Charts in Excel, 4. Using Charts: a. Prepare a profit graph for Donaldson Company. To prepare your graph, use sales volumes of zero units and 50,000 units as shown in cells 823 and 824. As a first step, create a formula in cell C23 that computes the profit when unit sales are zero. Your formula should reference data from the contribution format income statement provided in rows 4 through 18 of the worksheet. As a second step, copy your formula from cell C23 to cell C24. The profit (or loss) shown in cells C23 and C24 provide the two data points that you need to create a profit graph. b. Prepare a CVP graph for Donaldson Company. To prepare your graph, use sales volumes of zero units and 50,000 units as shown in cells 829 and 830. As a first step, create formulas in cells C29, D29, and E29 that compute the total sales dollars, total fixed expenses, and total expenses when unit sales are zero. Your formulas should reference data from the contribution format income statement provided in rows 4 through 18 of the worksheet. As a second step, copy your formulas from cells C29, D29, and E29, to cells C30, D30, and E30. The information shown in rows 29 and 30 provide the data points that you need to create a CVP graph. 5. Next, assume the company can decrease its variable expense per unit from $7.50 to $7.00 and decrease its fixed expenses from $180,000 to $150,000. Based on these assumptions: a. Prepare a profit graph for Donaldson Company. b. Prepare a CVP profit graph for Donaldson Company. 1 3 4 5 Data Inputs Unit sales 6 Selling price per unit 27 Variable expense per unit 8 Total fixed expenses 9 10 11 12 Sales 13 Variable expenses 14 Contribution margin 15 Fixed expenses 29 30 31 16 Net operating income 17 18 Net profit margin percentage 19 20 21 Profit Graph Information 22 23 27 CVP Graph Information Contribution Format Income Statement Total Per Unit Data Points $ $ $ Data Points $ 40,000 12.50 7.50 180,000 $ 500,000 $ 300,000 200,000 $ 180,000 20,000 4.00% 50,000 50,000 Profit 12.50 7.50 5.00 Sales Dollars Donaldson Company % 100% 60% 40% Fixed Expenses Total Expenses Margin of Safety Actual sales (a) Break-even sales (b) Margin of safety in dollars (a)-(b) Margin of safety percentage $ $ $ G 500,000 450,000 50,000 10.00% H
Expert Answer:
Related Book For
Introduction to Managerial Accounting
ISBN: 978-0078025792
7th edition
Authors: Peter Brewer, Ray Garrison, Eric Noreen
Posted Date:
Students also viewed these accounting questions
-
Donaldson Company's contribution format income statement for the most recent month is shown below: Per Unit $12.50 7.50 Total Sales $500,000 300,000 Variable expenses Contribution margin $ 5.00...
-
Miller Company's contribution format income statement for the most recent month is shown below Sales (42,000 units) Variable expenses Contribution margin Fixed expenses Net operating income Total $...
-
Please help with question 5b !!! Please help with question 3 !!! Due to erratic sales of its sole product-a high-capacity battery for laptop computers-PEM, Inc., has been experiencing financial...
-
Data was collected for a sample of organic snacks. The amount of sugar (in mg) in each snack is summarized in the histogram below. Frequency 12 -10 8 6 4 2 n = 180 200 220 240 260 280 300 320 amount...
-
Get all pairs of supplier numbers, Sx and Su say, such that Sx and Sy supply exactly the same set of parts each. Note for simplicity, you might want to use the original suppliers-and-parts data-base...
-
How is communications feedback related to measurement of persuasion and sales effects?
-
Which of the following statements is true? a. One of the benefits of incorporating your business is that you become entitled to receive unlimited liability. b. Sole proprietorships are subject to...
-
Journalize the adjusting entry needed on December 31, the company's year end, for each of the following independent cases affecting East Coast Contractors: a. Details of Prepaid Rent are shown in the...
-
The following unadjusted trial balance is for Ace Construction Company at its June 30 current fiscal year-end. The credit balance of the Retained Earnings account was $78,660 on June 30 of the prior...
-
The Elbow Bend Hotel is located in Calgarys East Village and has 100 Rooms total. The breakdown of room types is as follows: 40 Deluxe Rooms, 50 Executive Rooms and 10 Suites. The Suites are always...
-
ABC Company issues $100,000 in bonds at their face amount. The bond issuance results in a(n): decrease in Bonds Payable increase in Cash decrease in Cash increase in Interest Expense decrease in...
-
What do the ending balances of permanent accounts for one fiscal period represent at the beginning of the next fiscal period?
-
When posting amounts from a journal to general ledger accounts, a $10.00 debit to Supplies is mistakenly posted as a credit to Utilities Expense. Will this error be discovered when the work sheet is...
-
By law, boards of directors are primarily accountable to: a. Management. b. Society. c. Stockholders. d. Courts. e. None of the above.
-
Peter Dowther owns a small business. At the end ofa fiscal period, he does not make an adjustment for supplies. Are Mr. Dowthers accounting procedures correct? What effect will Mr. Dowther's...
-
Why are temporary accounts omitted from a post-closing trial balance?
-
please help me resolve: 2- . Debit Credit $ $ Totals to. From the following ledger balances. prepare a trial balance for the Bramble Company at June 30, 2022.A|l account balances are normal....
-
Representative data read from a plot that appeared in the paper Effect of Cattle Treading on Erosion from Hill Pasture: Modeling Concepts and Analysis of Rainfall Simulator Data (Australian Journal...
-
Markus Company's common stock sold for $2.75 per share at the end of this year. The company paid a common stock dividend of $0.55 per share this year. It also provided the following data excerpts...
-
Gino's Restaurant is a popular restaurant in Boston, Massachusetts. The owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct...
-
Comparative financial statements for Weaver Company follow: During 2015, Weaver sold some equipment for $20 that had cost $40 and on which there was accumulated depreciation of $16. In addition, the...
-
Will a company that is making losses record positive economic profits or EVA?
-
What is the main drawback of accounting profitability indicators?
-
Can a company with a positive net profit show a negative economic profit?
Study smarter with the SolutionInn App