subject
Business, 02.04.2021 02:20 Animallover100

Donaldson Company’s contribution format income statement for the most recent month is shown below: Total Per Unit Sales $ 500,000 $ 12.50 Variable expenses 300,000 7.50 Contribution margin 200,000 $ 5.00 Fixed expenses 180,000 Net operating income $ 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. rev: 05_07_2020_QC_CS-210952 2. Refer back to the Excel file. Using Goal Seek: a. Calculate the unit sales required to break even. b. Calculate the unit sales required to attain a target profit of $25,000. What would be the company’s margin of safety at this level of sales? c. Calculate the unit sales required to attain a margin of safety of $75,000. 3. Using Solver: a. Calculate the unit sales required to attain a margin of safety percentage of 15%. b. Restore the original values in your Excel file. Calculate the unit sales required to attain an 8% profit margin.

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 02:30
The monthly sales for yazici​ batteries, inc., were as​ follows: month jan feb mar apr may jun jul aug sept oct nov dec sales 19 20 17 12 11 18 16 17 19 22 21 24 this exercise contains only parts b and c. ​b) the forecast for the next month​ (jan) using the naive method​ = nothing sales ​(round your response to a whole​ number). the forecast for the next period​ (jan) using a​ 3-month moving average approach​ = nothing sales ​(round your response to two decimal​ places). the forecast for the next period​ (jan) using a​ 6-month weighted average with weights of 0.10​, 0.10​, 0.10​, 0.20​, 0.20​, and 0.30​, where the heaviest weights are applied to the most recent month​ = nothing sales ​(round your response to one decimal​ place). using exponential smoothing with alpha ​= 0.40 and a september forecast of 21.00​, the forecast for the next period​ (jan) = nothing sales ​(round your response to two decimal​ places). using a method of trend​ projection, the forecast for the next month​ (jan) = nothing sales ​(round your response to two decimal​ places). ​c) the method that can be used for making a forecast for the month of march is ▾ a 3-month moving average a 6-month weighted moving average exponential smoothing the naive method a trend projection .
Answers: 2
question
Business, 22.06.2019 13:30
What do you recommend adam do to increase production in a business setting that does not seem to value high productivity?
Answers: 3
question
Business, 22.06.2019 14:50
Ann chovies, owner of the perfect pasta pizza parlor, uses 20 pounds of pepperoni each day in preparing pizzas. order costs for pepperoni are $10.00 per order, and carrying costs are 4 cents per pound per day. lead time for each order is three days, and the pepperoni itself costs $3.00 per pound. if she were to order 80 pounds of pepperoni at a time, what would be the average inventory level?
Answers: 3
question
Business, 22.06.2019 19:30
About 20 years ago, sturdy light, inc., produced a sturdy, lightweight backpack in a market that was rapidly growing. sturdy light became a leader in this market. eventually, the backpack market reached the maturity stage and slowed down. however, by this time, sturdy light had developed a strong brand name and continued to steadily lead the market. which of the following describes this scenario? a. sturdy light was a star that developed into a cash cow. b. sturdy light was a question mark that developed into a star. c. sturdy light was a dog that developed into a question mark. d. sturdy light was a cash cow that developed into a star.
Answers: 2
You know the right answer?
Donaldson Company’s contribution format income statement for the most recent month is shown below: T...
Questions
Questions on the website: 13722366