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.

Answers: 1

Show answers

Other questions on the subject: Business

Business, 22.06.2019 02:30, maddielr17

Acompany using the perpetual inventory system purchased inventory worth $540,000 on account with credit terms of 2/15, n/45. defective inventory of $40,000 was returned 2 days later, and the accounts were appropriately adjusted. if the company paid the invoice 20 days later, the journal entry to record the payment would be

Answers: 1

continue

Business, 22.06.2019 04:10, maddylaugh

Lynch company manufactures and sells a single product. the following costs were incurred during the company’s first year of operations: variable costs per unit: manufacturing: direct materials $ 12 direct labor $ 6 variable manufacturing overhead $ 1 variable selling and administrative $ 1 fixed costs per year: fixed manufacturing overhead $ 308,000 fixed selling and administrative $ 218,000 during the year, the company produced 28,000 units and sold 15,000 units. the selling price of the company’s product is $56 per unit. required: 1. assume that the company uses absorption costing: a. compute the unit product cost. b. prepare an income statement for the year. 2. assume that the company uses variable costing: a. compute the unit product cost. b. prepare an income statement for the year.

Answers: 1

continue

Business, 22.06.2019 08:30, dezmondpowell

Which of the following is an example of search costs? a.) driving to a faraway place to find available goods b.) buying goods in some special way that is outside the normal channels c.) paying a premium cost for goods d.) selling extra goods for a discount price

Answers: 1

continue

Business, 22.06.2019 11:10, jordanbyrd33

Robert black, regional manager for ford in texas and oklahoma, faced a dilemma. the ford f-150 pickup truck was the best-selling pickup ever, yet ford's headquarters in detroit had decided to introduce a completely redesigned f-150. how could mr. black sell both trucks at the same time? he still had "old" f-150s in stock. in his advertising, mr. black referred to the new f-150s as follows: "not a better f-150. just the only truck good enough to be the next f-150." this statement represents ford's of the new f-150.

Answers: 2

continue

Do you know the correct answer?

Donaldson Company’s contribution format income statement for the most recent month is shown below: T...