Scenario

You are the Certified Managerial Accountant (CMA) for Northwood Company. You have worked for the company for several years and your responsibilities include working with managers to analyze business decisions by allocating production costs to goods, and creating budgets and production forecasts . You also provide information to the external accountant for preparation of the financial statements. Your opinion is well respected and you have successfully worked with management on several big projects in the past.

Northwood Company manufactures a single line of basketballs in a small plant. Management has been meeting on several ideas they are considering about expansion of the plant as well as your advice on which would be the best alternative for production. After you have prepared the journal entries and income statement for the current year, management has asked you to review the data related to the proposed scenarios and prepare a presentation for top management.

Management has been meeting about different scenarios they have considered to increase sales and improve profitability. They would like to see the results of these scenarios and have sat down with you, the CMA, to have you provide information to help with their decision.

Requirements

1. Compute the CM ratio (round variable expenses to the nearest dollar) and break-even point in balls and the degree of operating leverage at the given sales levels.

2. Due to an increase in labor rates, the company estimates that variable expenses will increase by $2 per ball next year. If this change takes place and the selling price per ball remains constant at $25, what is the new CM ratio and break-even point in balls?

3. If the expected change in variable expenses takes place, how many balls will have to be sold next year to earn the same net operating income as last year?

4. The president feels that the company must raise the selling price of the basketballs if the variable expenses increase by $2. If Northwood Company wants to maintain the same CM ratio as the current

year, what selling price per ball must it charge to cover the increased costs? (round to the nearest dollar)

5. The company is discussion the construction of a new, automated manufacturing plan. The new plant would slash variable expenses by 40% per ball, but it would cause fixed expenses per year to double. If the new plant is built, what is the company's new CM ratio and break-even point in balls?

6. Prepare a contribution format income statement and compute the degree of operating leverage with the assumption that the new plant is built in the next year and the company manufactures 50,000 balls.

The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers, thus variable expenses are $14 per ball, of which 56% is direct labor cost.

Last year, the company sold 50,636 balls with the following results (rounded):

Selling & Admin expenses totaling $310,000 are broken down (based on actual performance, 50,000 balls sold):

Sales Commission: $63, 000

Administrative salaries: $90,000.

Rent Expense: $5,000

Advertising Expense: $140,000

Depreciation expense: $12,000

Week 6 -- Prepare a Budget

Your instructor will provide any necessary feedback to support your project moving forward.

Scenario

Management has reviewed your report and would like to see budget comparisons between continuing operations with the existing plant or opening a new plant. After a review of operations and expenses Management has provided the following information:

a)   Opening new plant:

• Sales price remains at $25, estimate 55,000 basketballs sold based on additional advertising.
• Use variable expenses calculated in Week 5, #5
• Do not estimate any Overhead variance
• Sales commissions are 5% of gross sales.
• Administrative salaries remain unchanged.
• Rent expense is eliminated because the new plant offers space for administration.
• Management has decided to increase the advertising budget by 20%.
• Depreciation on the new plant is $250,000, this is in addition to current depreciation on selling and administrative equipment.

b)   Keeping existing plant:

• Sales price is increased to $29, sales decline to 48,000 because of increase in price.
• Use variable expenses calculated in Part 3, #4
• Do not estimate any Overhead variance
• Sales commissions are 5% of gross sales.
• Administrative salaries, rent and advertising increase by 5% because of increase in costs.
• Depreciation expense is $10,000 on selling and administrative equipment.

Requirements

1. Prepare a budget comparing operating in the new plant versus continuing operations in the existing plant.