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 03:00
Insurance companies have internal controls in place to protect assets, monitor the accuracy of accounting records and encourage operational efficiencies and adherence to policies. these internal controls are generally of two types: administrative controls and accounting controls. administrative controls are the policies and procedures that guide the daily actions of employees. accounting controls are the policies and procedures that delineate authorizations of financial transactions that are done, safeguard assets, and provide reports on the company’s financial status in a reliable and timely manner. internal controls should include both preventative and detective controls. the purpose of preventative controls is to stop problems and errors before they occur. detective controls identify problems after they have occurred. preventative controls are usually more effective at reducing problems, but they also tend to be more expensive. internal controls must be flexible to adjust for changes in laws and regulations in addition to adding new products or modifying current ones. companies must also do regular analyses to ensure that the benefits of implementing the controls are worth their costs. when concerned about paying unwarranted insurance claims which type of control would be useful?
Answers: 2
question
Business, 22.06.2019 04:00
Assume that the following conditions exist: a. all banks are fully loaned up- there are no excess reserves, and desired excess reserves are always zero. b. the money multiplier is 5 .     c. the planned investment schedule is such that at a 4 percent rate of interest, investment =$1450 billion. at 5 percent, investment is $1420 billion. d. the investment multiplier is 3 . e.. the initial equilibrium level of real gdp is $12 trillion. f. the equilibrium rate of interest is 4 percent now the fed engages in contractionary monetary policy. it sells $1 billion worth of bonds, which reduces the money supply, which in turn raises the market rate of interest by 1 percentage point. calculate the decrease in money supply after fed's sale of bonds: $nothing billion.
Answers: 2
question
Business, 22.06.2019 22:00
What legislation increased the ability for federal authorities to tap telephones and wireless devices, tightened the enforcement of money laundering activities, as well as broadened powers toward acts of terrorism and acts such as drug trafficking?
Answers: 2
question
Business, 22.06.2019 22:30
Which of the following describes one of the ways that the demographics of an area affect the price of housing in that area? a. when more people have children, their incomes tend to be higher and the housing prices are also higher. b. older people are more likely to stay in their houses, creating a seller's market that keeps prices low. c. an area with a lower population density won't have enough construction workers to build new houses quickly. d. an area with younger people will have a higher demand for rentals and a lower demand for buying.
Answers: 1
You know the right answer?
Donaldson Company’s contribution format income statement for the most recent month is shown below: T...
Questions
question
Mathematics, 04.09.2020 21:01
question
Mathematics, 04.09.2020 21:01
question
Mathematics, 04.09.2020 21:01
Questions on the website: 13722363