Question

In: Accounting

Managers at marc Corp. are concerned that the company’s costs of production have gone wild. The...

Managers at marc Corp. are concerned that the company’s costs of production have gone wild. The chief financial officer brings you the following historic data:

Period

Units

Costs

Quarter 1, 2016

1,120

$111,502.00

Quarter 2, 2016

980

$111,009.00

Quarter 3, 2016

1,260

$114,012.00

Quarter 4, 2016

1,3401

$115,452.00

Quarter 1, 2017

1,280

$114,301.00

Quarter 2, 2017

1,300

$114,689.00

Quarter 3, 2017

1,420

$116,735.00

Quarter 4, 2017

1,500

$118,209.00

marc corp selling price is $80 per unit

Use Excel. Using the High-low method:

Estimate the company’s cost formula.

Estimate the total cost of producing 1,200 units.

Calculate the breakeven point in dollar sales.

Prepare the contribution format income statement when 1,200 units are sold.

Compute the degree of operating leverage when 1,200 units are sold. Compute Net operating income if sales increased 120 units above this level.

Solutions

Expert Solution

Cost at highest level of activity                118,209.00
Cost at Lowest level of activity                111,009.00
Highest level of activity                     1,500.00
Lowest Level of activity                        980.00
Variable cost per unit = (118209 - 111009)/(1500 - 980)
Variable cost per unit = 7200/520
Variable cost per unit = $13.85
Fixed Costs = 111009 - 980*13.85
Fixed Costs = $97436
company’s cost formula = 97436 + 13.85x
total cost of producing 1,200 units= 97436 + 1200*13.85                114,056.00
Selling price per unit                           80.00
Variable cost per unit                           13.85
Contribution per unit                           66.15
CM Ratio = 66.15/80 82.69%
Fixed costs                  97,436.00
breakeven point in dollar sales = 97436/82.69%                117,836.43
Sales                  96,000.00
Less Variable Expenses                  16,620.00
Contribution Margin                  79,380.00
Fixed cost                  97,436.00
Net operating income                (18,056.00)
DOL =                             (4.40)
Increase in net income = 4.40*10% 44%
New NOI= 18056 - 18056*44%                (10,111.36)

Related Solutions

Some defined benefit pension plans have been subject to abuse and some managers have gone to...
Some defined benefit pension plans have been subject to abuse and some managers have gone to prison for their illegal activities. Can you cite and any particular case where this happened and explain why it did?
this semester we have gone over in detail theories of human nature that managers might assume...
this semester we have gone over in detail theories of human nature that managers might assume in trying to understand the worker they manage. Describe ALL three theories. In your view, are they really theories of "human nautre" or are they really descriptions of three kinds of organizations or organizational structure that produce one kind of 'human nautre' or another ? you must justify your answer with examples with either personal experience or reference current events
Zachary Manufacturing pays its production managers a bonus based on the company’s profitability. During the two...
Zachary Manufacturing pays its production managers a bonus based on the company’s profitability. During the two most recent years, the company maintained the same cost structure to manufacture its products. Year Units Produced Units Sold Production and Sales Year 2 4,000 4,000 Year 3 6,000 4,000 Cost Data Direct materials $ 14.80 per unit Direct labor $ 22.50 per unit Manufacturing overhead—variable $ 10.90 per unit Manufacturing overhead—fixed $ 103,200 Variable selling and administrative expenses $ 7.40 per unit sold...
Gibson Manufacturing pays its production managers a bonus based on the company’s profitability. During the two...
Gibson Manufacturing pays its production managers a bonus based on the company’s profitability. During the two most recent years, the company maintained the same cost structure to manufacture its products. Year Units Produced Units Sold Production and Sales Year 2 4,000 4,000 Year 3 6,000 4,000 Cost Data Direct materials $ 13.50 per unit Direct labor $ 22.90 per unit Manufacturing overhead—variable $ 11.10 per unit Manufacturing overhead—fixed $ 102,600 Variable selling and administrative expenses $ 8.00 per unit sold...
Campbell Manufacturing pays its production managers a bonus based on the company’s profitability. During the two...
Campbell Manufacturing pays its production managers a bonus based on the company’s profitability. During the two most recent years, the company maintained the same cost structure to manufacture its products. Year Units Produced Units Sold Production and Sales 2018 4,000 4,000 2019 6,000 4,000 Cost Data Direct materials $ 14.6 per unit Direct labor $ 23.4 per unit Manufacturing overheadvariable $ 10.7 per unit Manufacturing overheadfixed $ 102,000 Variable selling and administrative expenses $ 8.6 per unit sold Fixed selling...
In a factory concerned with the production of soft drinks you have been asked to analyse...
In a factory concerned with the production of soft drinks you have been asked to analyse the production of two drinks, X and Y. Each litre of X that is produced can (if required) be further processed into Y. Producing one litre of X costs £0.12 and the further processing to produce Y costs an additional £0.03. Wholesalers have in the forthcoming month ordered 150,000 litres of X and 175,000 litres of Y. The production capacity allocated to X and...
A company has, technical specialists, sales, costs, production and engineering managers in a manufacturing company which...
A company has, technical specialists, sales, costs, production and engineering managers in a manufacturing company which has supply chain relationships with a few inter state, local and international companies. what are the information needs of each manager after the company has experienced major declines due to the coronavirus pandemic ?
Managers should answer the following questions when considering outsourcing: How do the company’s variable costs compare...
Managers should answer the following questions when considering outsourcing: How do the company’s variable costs compare to the outsourcing costs? Are any fixed costs avoidable if the company outsources? What could the company do with the freed manufacturing capacity?
Gotham Inc. has a total of $50,000 in production overhead costs. The company’s products and related...
Gotham Inc. has a total of $50,000 in production overhead costs. The company’s products and related statistics follow. Product X Product Y Direct Material in Pounds 2,400 1,600 Direct labor hours 320 480 Machine Hours 720 280 Number of setups 54 96 Number of Units Produced 312 140 Additional data: The direct material was purchased for $8,000. One direct labor hour costs $20. 2A)      Assume that Gotham uses direct labor hours to apply the overhead costs to the products. Determine...
QUESTION 2 A company’s directors have decided to provide senior managers with a performance bonus scheme....
QUESTION 2 A company’s directors have decided to provide senior managers with a performance bonus scheme. The bonus scheme entitles the managers to a cash payment of K250,000 should the company share price have increased by more than 20% at the end of the next 6 months. In addition, the managers will be entitled to 5,000 free shares each, should the share price have increased by more than 10% at the end of the next 6 months. You are given...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT