Question

Vice President for Sales and Marketing Sam Totter is trying to plan for the coming year...

Vice President for Sales and Marketing Sam Totter is trying to plan for the coming year in terms of production needs to meet the sales demand. He is also trying to determine ways in which the company’s profits might be increased in the coming year.

Instructions :

Northern Illinois Manufacturing markets a simple water control and timer that it mass-produces. During last year, the company sold 701,000 units at an average selling price of 4.20 per unit. The variable expenses were $1,857,650 and the fixed expenses were $646,450.

  1. What is the product’s contribution margin ratio? (Round to nearest whole percentage.)
  2. What is the company’s break-even point in units and in dollars for this product?
  3. What is the margin of safety, both in dollars and as a ratio? What is the company’s degree of operating leverage? (Round to nearest whole percentage.)
  4. If management wanted to increase its net operating income from this product by 10%, how many additional units would have to be sold to reach this income level?
  5. If sales increase by 51,000 units and the cost behaviors do not change, how much will net operating income increase on this product?
  6. Northern Illinois’ management believes that increased advertising would increase unit sales by 10%. If management wants to increase its operating income by $50,000, how much could the company spend on additional advertising to reach its goal?
  7. Using last year’s data as the starting point, assume the company can increase sales by 5% by just continuing its current marketing program. What would the company’s net operating income by next year using the DOL?

Please complete in Microsoft excel.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The Vice President for Sales and Marketing at Waterways Corporation is planning for production needs to...
The Vice President for Sales and Marketing at Waterways Corporation is planning for production needs to meet sales demand in the coming year. He is also trying to determine how the company’s profits might be increased in the coming year. This problem asks you to use cost-volume-profit concepts to help Waterways understand contribution margins of some of its products and decide whether to mass-produce any of them. Waterways markets a simple water control and timer that it mass-produces. Last year,...
The Vice President for Sales and Marketing at Waterways Corporation is planning for production needs to...
The Vice President for Sales and Marketing at Waterways Corporation is planning for production needs to meet sales demand in the coming year. He is also trying to determine how the company’s profits might be increased in the coming year. This problem asks you to use cost-volume-profit concepts to help Waterways understand contribution margins of some of its products and decide whether to mass-produce any of them. Waterways markets a simple water control and timer that it mass-produces. Last year,...
Please answer a2 The Vice President for Sales and Marketing at Waterways Corporation is planning for...
Please answer a2 The Vice President for Sales and Marketing at Waterways Corporation is planning for production needs to meet sales demand in the coming year. He is also trying to determine how the company’s profits might be increased in the coming year. This problem asks you to use cost-volume-profit concepts to help Waterways understand contribution margins of some of its products and decide whether to mass-produce any of them. Waterways markets a simple water control and timer that it...
Please answer a3 The Vice President for Sales and Marketing at Waterways Corporation is planning for...
Please answer a3 The Vice President for Sales and Marketing at Waterways Corporation is planning for production needs to meet sales demand in the coming year. He is also trying to determine how the company’s profits might be increased in the coming year. This problem asks you to use cost-volume-profit concepts to help Waterways understand contribution margins of some of its products and decide whether to mass-produce any of them. Waterways markets a simple water control and timer that it...
The Vice President for Sales and Marketing at Waterways Corporation is planning for production needs to...
The Vice President for Sales and Marketing at Waterways Corporation is planning for production needs to meet sales demand in the coming year. He is also trying to determine how the company’s profits might be increased in the coming year. This problem asks you to use cost-volume-profit concepts to help Waterways understand contribution margins of some of its products and decide whether to mass-produce any of them. Waterways markets a simple water control and timer that it mass-produces. Last year,...
Minden Company introduced a new product last year for which it is trying to find an...
Minden Company introduced a new product last year for which it is trying to find an optimal selling price. The company’s present selling price is $60 per unit, and variable expenses are $45 per unit. Fixed expenses are $380,000 per year. The present annual sales volume (at the $60 selling price) is 30,000 units. Marketing is suggesting increasing the annual advertising expense by $100,000 and decreasing the selling price per unit by $5. Their study suggests these changes will increase...
Last year Bidwell company had the following data for its only product, Product SD: Fixed               Variable...
Last year Bidwell company had the following data for its only product, Product SD: Fixed               Variable Sales (100,000)                                                                                   $1,000,000             Expenses:             Direct Materials                                               $300,000             Direct Labor                                                    200,000             Manufacturing Overhead        $100,000         150,000             Selling and Administrative      110,000           50,000 Total Expenses                                    210,000           700,000           910,000 Net Operating Income                                                                         $90,000 The company produced and sold 100,000 units during the year and had no beginning or ending inventories. Suppose management believes that a $15,000 increase in annual advertising expense will result...
Crane Corporation has collected the following information after its first year of sales. Sales were $1,600,000...
Crane Corporation has collected the following information after its first year of sales. Sales were $1,600,000 on 100,000 units, selling expenses $240,000 (40% variable and 60% fixed), direct materials $514,000, direct labor $270,800, administrative expenses $280,000 (20% variable and 80% fixed), and manufacturing overhead $376,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...
Minden Company introduced a new product last year for which it is trying to find an...
Minden Company introduced a new product last year for which it is trying to find an optimal selling price. Marketing studies suggest that the company can increase sales by 5,000 units for each $2 reduction in the selling price. The company’s present selling price is $92 per unit, and variable expenses are $62 per unit. Fixed expenses are $832,500 per year. The present annual sales volume (at the $92 selling price) is 25,200 units. Required: 1. What is the present...
Minden Company introduced a new product last year for which it is trying to find an...
Minden Company introduced a new product last year for which it is trying to find an optimal selling price. Marketing studies suggest that the company can increase sales by 5,000 units for each $2 reduction in the selling price. The company’s present selling price is $94 per unit, and variable expenses are $64 per unit. Fixed expenses are $837,900 per year. The present annual sales volume (at the $94 selling price) is 25,200 units. Required: 1. What is the present...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT