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

Another question on Business

Business, 21.06.2019 15:30

Marvin wrote a check of $58.25 for the water bill and $450 for rent. he also made a deposit of $124.16. how much is his new balance after writing the checks and making the deposit?

Answers: 3

Answer

Business, 21.06.2019 16:50

Malcolm has several receipts from recent transactions that he entered in his records. the receipts include an atm receipt for an $80.00 deposit, a grocery store receipt for $25.50, and a paycheck deposit slip for $650.00 when he finishes entering his transactions, malcolm realizes that his balance is incorrect. assuming that malcolm had no beginning balance, what should his correct balance be?

Answers: 1

Answer

Business, 21.06.2019 23:00

The monthly payment m of a loan of amount p for y years with an interest rate r can be calculated by the formula: m = p(r/12) 1 â’ (1 + r/12)â’12y calculate the monthly payment and the cummulative total payment for a $100,000 loan with an interest rate of 4.85% if taken out for 10 years, for 11 years, etc., up to a 30 year term. display the results in a three-column table where the first column is the number of years, the second is the monthly payment, and the third is the cummulative total payment. note: use format bank; for this problem. also, remember to represent the interest rate as a decimal (e.g. 0.0485) 2. a torus-shaped water tube is designed to have a volume of 8, 000in3 . the volume of the tube, v , and its surface area, s, are given by: v = 1 4 ď€ 2 (a + b)(b â’ a) 2 s = ď€ 2 (b 2 â’ a 2 ) if a = kb, determine s, a, and b for k = 0.2, 0.3, 0.7. display the results in a table

Answers: 1

Answer

Business, 22.06.2019 04:10

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

Answer

You know the right answer?

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

Questions