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, 21.06.2019 21:00
Which of the following statements is correct? a) due to limited liability, unlimited lives, and ease of ownership transfer, the vast majority of u.s. businesses (in terms of number of businesses) are organized as corporationsb) most businesses (by number and total dollar sales) are organized as proprietorships or corporation. however, if the business gets very large, it becomes advantageous to convert to a corporation, primarily because corporations have important tax advantages over proprietorships and partnerships.c) due to legal considerations related to ownership transfers and limited liability, which affect the ability to attract capital, most business (measured by dollar sales) is conducted by corporations in spite of large corporations' less favorable tax treatmentd) large corporations are taxed more favorably than proprietorshipse) corporate stockholders are exposed to unlimited liability
Answers: 2
question
Business, 22.06.2019 13:10
Laval produces lamps and home lighting fixtures. its most popular product is a brushed aluminum desk lamp. this lamp is made from components shaped in the fabricating department and assembled in the assembly department. information related to the 22,000 desk lamps produced annually follows.direct materials $280,000direct labor fabricating department (8,000 dlh × $24 per dlh) $192,000assembly department (16,600 dlh × $26 per dlh) $431,600machine hours fabricating department $15,200mhassembly department $20,850mhexpected overhead cost and related data for the two production departments follow.fabricating assemblydirect labor hours 150,000dlh 295,000dlhmachine hours 161,000mh 128,000mhoverhead cost $400,000 430,000required1. determine the plantwide overhead rate for laval using direct labor hours as a base.2. determine the total manufacturing cost per unit for the aluminum desk lamp using the plantwide overhead rate.3. compute departmental overhead rates based on machine hours in the fabricating department and direct labor hours in the assembly department.4. use departmental overhead rates from requirement 3 to determine the total manufacturing cost per unit for the aluminum desk lamps.
Answers: 3
question
Business, 22.06.2019 16:10
Regarding the results of a swot analysis, organizational weaknesses are (a) internal factors that the organization may exploit for a competitive advantage (b) internal factors that the organization needs to fix in order to be competitive (c) mbo skills that should be emphasized (d) skills and capabilities that give an industry advantages problems that a specific industry needs to correct
Answers: 1
question
Business, 22.06.2019 16:30
Which of the following has the largest impact on opportunity cost
Answers: 2
You know the right answer?
Donaldson Company’s contribution format income statement for the most recent month is shown below: T...
Questions
question
English, 16.01.2021 18:10
question
Mathematics, 16.01.2021 18:20
Questions on the website: 13722367