Question

Scholes Systems supplies a particular type of office chair to large retailers such as Target, Costco,...

Scholes Systems supplies a particular type of office chair to large retailers such as Target, Costco, and Office Max. Scholes is concerned about the possible effects of inflation on its operations. Presently, the company sells 96,000 units for $60 per unit. The variable production costs are $30, and fixed costs amount to $1,560,000. Production engineers have advised management that they expect unit labor costs to rise by 20 percent and unit materials costs to rise by 5 percent in the coming year. Of the $30 variable costs, 60 percent are from labor and 20 percent are from materials. Variable overhead costs are expected to increase by 25 percent. Sales prices cannot increase more than 10 percent. It is also expected that fixed costs will rise by 6 percent as a result of increased taxes and other miscellaneous fixed charges.

The company wishes to maintain the same level of profit in real dollar terms. It is expected that to accomplish this objective, profits must increase by 7 percent during the year.

Required:

a. Compute the volume in units and the dollar sales level necessary to maintain the present profit level, assuming that the maximum price increase is implemented. (Do not round intermediate calculations. Round up your answer for "Volume in units" to the nearest whole number and round your answer for "Sales" to the nearest whole dollar amount.)

Volume in units ?

Sales ?

b. Compute the volume of sales and the dollar sales level necessary to provide the 7 percent increase in profits, assuming that the maximum price increase is implemented. (Do not round intermediate calculations. Round up your answer for "Volume in units" to the nearest whole number and round your answer for "Sales" to the nearest whole dollar amount.)

Volume in units ?

Sales ?

c. If the volume of sales were to remain at 96,000 units, what price change would be required to attain the 7 percent increase in profits? Calculate the new price. (Round intermediate calculations of unit cost and final answer to 2 decimal places.)

New price ?

Homework Answers

Answer #1

Current Year Income Statement

1.Sales ( 96000 * 60 ) 5760000
Variable Costs
Material [ 96000 * (30*20%) ] 576000
Labour [ 96000 * (30*60%) ] 1728000
Overhead Variable Costs [ 96000 * (30*20%) ] 576000
2.Total Variable Costs 2880000
3. Fixed Cost 1560000
Present Profit (1 - 2 - 3) 1320000

a.Next Year Income Statement

Let us assume the required volume in units is denoted by s.

1.Sales [ s * (60*1.10 ) ] (increase by 10%) 66s
Variable Costs
Material [ s * (6 * 1.05) ] (increase by 5%) 6.3s
Labour [ s * (18 * 1.2) ] (increase by 20%) 21.6s
Overhead Variable Costs [ s * (6*1.25) ] (increase by 25%) 7.5s
2.Total Variable Costs 35.4s
3. Fixed Cost (1560000 * 1.06) (increase by 6%) 1653600
Present Profit (1 - 2 - 3) 1320000

Contribution = 1320000 + 1653600 = 2973600

2973600 = 66s - 35.4s = 30.6s

s = 97176.47 or 97176 units

Dollar sales Level = 97176 * 66 = 6413616

b. Next year Income Statement

1.Sales [ s * (60*1.10 ) ] (increase by 10%) 66s
Variable Costs
Material [ s * (6 * 1.05) ] (increase by 5%) 6.3s
Labour [ s * (18 * 1.2) ] (increase by 20%) 21.6s
Overhead Variable Costs [ s * (6*1.25) ] (increase by 25%) 7.5s
2.Total Variable Costs 35.4s
3. Fixed Cost (1560000 * 1.06) (increase by 6%) 1653600
Present Profit (1320000 * 1.07) (increase by 7%) 1412400

Contribution = 1412400 + 1653600 = 3066000

3066000 = 66s - 35.4s = 30.6s

s = 100196.078 or 100196 units

Dollar sales Level = 100196 * 66 = 6612936

c. Next year Income Statement

Let us assume the new price be p.

1.Sales ( 96000 * p ) 96000p
Variable Costs
Material [ 96000 * (6 * 1.05) ] (increase by 5%) 604800
Labour [ 96000 * (18 * 1.2) ] (increase by 20%) 2073600
Overhead Variable Costs [ 96000 * (6*1.25) ] (increase by 25%) 720000
2.Total Variable Costs 3398400
3. Fixed Cost (1560000 * 1.06) (increase by 6%) 1653600
Present Profit (1320000 * 1.07) (increase by 7%) 1412400

Contribution = 1412400 + 1653600 = 3066000

3066000 = 96000p - 3398400

6464400 = 96000p

p = 6464400/96000 = 67.3375 or 67.34

Price change = (67.34-60) / 60 = 12.23%

Sales price = 96000 * 67.34 = 6464640

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
Scholes Systems supplies a particular type of office chair to large retailers such as Target, Costco,...
Scholes Systems supplies a particular type of office chair to large retailers such as Target, Costco, and Office Max. Scholes is concerned about the possible effects of inflation on its operations. Presently, the company sells 90,000 units for $70 per unit. The variable production costs are $35, and fixed costs amount to $1,500,000. Production engineers have advised management that they expect unit labor costs to rise by 20 percent and unit materials costs to rise by 5 percent in the...
Question: 6. Scholes Systems supplies a particular type of office chair to large retailers such as...
Question: 6. Scholes Systems supplies a particular type of office chair to large retailers such as Target, ... 6. Scholes Systems supplies a particular type of office chair to large retailers such as Target, Costco, and Office Max. Scholes is concerned about the possible effects of inflation on its operations. Presently, the company sells 82,000 units for $70 per unit. The variable production costs are $40, and fixed costs amount to $1,420,000. Production engineers have advised management that they expect...
Argentina Partners is concerned about the possible effects of inflation on its operations. Presently, the company...
Argentina Partners is concerned about the possible effects of inflation on its operations. Presently, the company sells 76,000 units for $50 per unit. The variable production costs are $35, and fixed costs amount to $860,000. Production engineers have advised management that they expect unit labor costs to rise by 20 percent and unit materials costs to rise by 5 percent in the coming year. Of the $35 variable costs, 60 percent are from labor and 20 percent are from materials....
The following information is available for year 1 for Pepper Products:    Sales revenue (260,000 units)...
The following information is available for year 1 for Pepper Products:    Sales revenue (260,000 units) $ 7,020,000 Manufacturing costs Materials $ 413,000 Variable cash costs 351,000 Fixed cash costs 808,000 Depreciation (fixed) 2,464,000 Marketing and administrative costs Marketing (variable, cash) 1,041,000 Marketing depreciation 369,000 Administrative (fixed, cash) 1,255,000 Administrative depreciation 185,000 Total costs $ 6,886,000 Operating profits $ 134,000     All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
The manufacturer of a product that has a variable cost of $2.80 per unit and total...
The manufacturer of a product that has a variable cost of $2.80 per unit and total fixed cost of $133,000 wants to determine the level of output necessary to avoid losses. What level of sales is necessary to break-even if the product is sold for $4.85? Round your answer to the nearest whole number.   units What will be the manufacturer’s profit or loss on the sales of 99,000 units? Round your answer to the nearest dollar. $   If fixed costs...
CollegePak Company produced and sold 79,000 backpacks during the year just ended at an average price...
CollegePak Company produced and sold 79,000 backpacks during the year just ended at an average price of $39 per unit. Variable manufacturing costs were $16.50 per unit, and variable marketing costs were $3.78 per unit sold. Fixed costs amounted to $549,000 for manufacturing and $223,200 for marketing. There was no year-end work-in-process inventory. (Ignore income taxes.) Required: Compute CollegePak’s break-even point in sales dollars for the year. (Do not round intermediate calculations. Round your final answer up to the nearest...
Corrigan Enterprises is studying the acquisition of two electrical component insertion systems for producing its sole...
Corrigan Enterprises is studying the acquisition of two electrical component insertion systems for producing its sole product, the universal gismo. Data relevant to the systems follow. Model no. 6754: Variable costs, $19.00 per unit Annual fixed costs, $986,200 Model no. 4399: Variable costs, $10.80 per unit Annual fixed costs, $1,114,100 Corrigan’s selling price is $66 per unit for the universal gismo, which is subject to a 15 percent sales commission. (In the following requirements, ignore income taxes.) 1. How many...
Corrigan Enterprises is studying the acquisition of two electrical component insertion systems for producing its sole...
Corrigan Enterprises is studying the acquisition of two electrical component insertion systems for producing its sole product, the universal gismo. Data relevant to the systems follow. Model no. 6754: Variable costs, $19.00 per unit Annual fixed costs, $986,200 Model no. 4399: Variable costs, $12.80 per unit Annual fixed costs, $1,114,600 Corrigan’s selling price is $70 per unit for the universal gismo, which is subject to a 5 percent sales commission. (In the following requirements, ignore income taxes.) 4. Ignoring the...
Detroit Disk, Inc. is a retailer for digital video disks. The projected net income for the...
Detroit Disk, Inc. is a retailer for digital video disks. The projected net income for the current year is $1,880,000 based on a sales volume of 240,000 video disks. Detroit Disk has been selling the disks for $23.00 each. The variable costs consist of the $11.00 unit purchase price of the disks and a handling cost of $2.00 per disk. Detroit Disk’s annual fixed costs are $520,000.      Management is planning for the coming year, when it expects that the unit...
Disk City, Inc. is a retailer for digital video disks. The projected net income for the...
Disk City, Inc. is a retailer for digital video disks. The projected net income for the current year is $2,600,000 based on a sales volume of 280,000 video disks. Disk City has been selling the disks for $22 each. The variable costs consist of the $9 unit purchase price of the disks and a handling cost of $2 per disk. Disk City’s annual fixed costs are $480,000. Management is planning for the coming year, when it expects that the unit...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT