Question: i Data Table - X Total Per Unit % Sales. $ 40 ? 110,000 $ ? ? ? ? ? Variable expenses Contribution margin Fixed

i Data Table - X Total Per Unit % Sales. $ 40 ? 110,000 $ ? ? ? ? ? Variable expenses Contribution margin Fixed expenses 11,000 $ 44,000 Operating income Print Done Requirement 1. Fill in the missing numbers in the table. Use the following questions to help fill in the missing numbers in the table: a. What is the total contribution margin? The total contribution margin is $ b. What is the total variable expense? The total variable expense is $ c. How many units were sold? units were sold d. What is the per-unit variable expense? The per-unit variable expense is $ e. What is the per-unit contribution margin? The per-unit contribution margin is $ Now fill in the missing numbers in the table. (Enter the percentages as whole numbers, "XX") % Total Per Unit 110,000 $ 40 Sales $ % Variable expenses % % Contribution margin Fixed expenses Operating income 11,000 $ 44,000 Requirement 2. Answer the following questions about breakeven analysis: a. What is the breakeven point in units? Begin by identifying the formula to compute the breakeven point in units. = Breakeven sales in units The breakeven point in units is b. What is the breakeven point in sales dollars? Begin by identifying the formula to compute the breakeven point in sales dollars. = Breakeven sales in dollars The breakeven point in sales dollars is $ Requirement 3. Answer the following questions about target profit analysis and safety margin: b. What is the current margin of safety in units? Begin by identifying the formula to compute the current margin of safety in units. Margin of safety in units The current margin of safety in units is c. What is the margin of safety in sales dollars? Begin by identifying the formula to compute the margin of safety in dollars. Margin of safety in dollars The margin of safety in dollars is $ Requirement 2. Answer the following questions about breakeven analysis: a. What is the breakeven point in units? Begin by identifying the formula to compute the breakeven point in units. = Breakeven sales in units The breakeven point in units is b. What is the breakeven point in sales dollars? Begin by identifying the formula to compute the breakeven point in sales dollars. = Breakeven sales in dollars The breakeven point in sales dollars is $ Requirement 3. Answer the following questions about target profit analysis and safety margin: b. What is the current margin of safety in units? Begin by identifying the formula to compute the current margin of safety in units. Margin of safety in units The current margin of safety in units is c. What is the margin of safety in sales dollars? Begin by identifying the formula to compute the margin of safety in dollars. Margin of safety in dollars The margin of safety in dollars is $ d. What is the margin of safety in percentage? Begin by identifying the formula to compute the margin of safety in percentage. Margin of safety as a percentage of budgeted sales (Round the percentage to the nearest tenth percent, X.X%.) The margin of safety percentage is %

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

1 Data Table - X Total Per Unit % Sales $ $ 125,000 $ 25 2 Variable expenses ? ? ? Contribution margin ? ? ? Fixed expenses 12,500 ago Operating income $ 37,500 Print Done Requirement 1. Fill in the...

Menlo Company distributes a single product. The company's sales and expenses for last month follow Total Per Unit 628,000 40 439,60026 Sales Variable expenses Contribution margin Fixed expenses Net...

Menlo Company distributes a single product. The company's sales and expenses for last month follow: Total $ 632,000 442,400 189,600 146,400 $ 43,200 Per Unit $ 40 28 $ 12 Sales Variable expenses...

Menlo Company distributes a single product. The company's sales and expenses for last month follow: Total $ 636,000 445,200 190, 800 153,600 $ 37,200 Per Unit $ 40 28 $ 12 Sales Variable expenses...

Required information Excel Analytics 05-01 (Static) Cost-Volume-Profit Relationships (LO5-1, LO5-2, LO5-5, LO5-6, LO5-7) [The following information applies to the questions displayed below) Donaldson...

Menlo Company distributes a single product. The company's sales and expenses for last month follow: Total $ 612,000 428, 400 183,600 144,000 $ 39, 600 Per Unit $ 40 28 $ 12 Sales Variable expenses...

Menlo Company distributes a single product. The company's sales and expenses for last month follow: Total $ 628,000 439,600 188,400 144,000 $ 44,400 Per Unit $ 40 28 $12 Sales Variable expenses...

Menlo Company distributes a single product. The company's sales and expenses for last month follow: Total $ 628,000 439,600 188,400 152,400 $ 36,000 Per Unit $ 40 28 $ 12 Sales Variable expenses...

Menlo Company distributes a single product. The company's sales and expenses for last month follow: Total $ 600,000 420,000 180,000 146,400 $ 33,600 Per Unit $ 40 28 $ 12 Sales Variable expenses...

Menlo Company distributes a single product. The company s sales and expenses for last month follow: Total Per Unit Sales $ 6 2 0 , 0 0 0 $ 4 0 Variable expenses 4 3 4 , 0 0 0 2 8 Contribution margin...

What roles govern data collection?

Each cable of the side spans of the Golden Gate Bridge supports a load w =10.2 kips/ft along the horizontal. Knowing that for the side spans the maximum vertical distance h from each cable to the...

Windmills Production Inc. ( WPI ) manufactures paper products. The old manufacturing machine has now completely stopped working. It can be salvaged at a scrap value of $ 5 , 0 0 0 . The company is...

True or false discharge has often been described as the capital punishment of the world of work

1 If you were designing the overall training and development strategy for Hilton, in what areas would you seek to supplement elearning, and what approaches to training in these areas would you...

3 How can national schemes be supportive of training in organisations?

1 What is meant by systematic training?