Question

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 100,000 units for $80 per unit. The variable production costs are $40, and fixed costs amount to $1,600,000. Production engineers have advised management that they expect unit labor costs to rise by 20 percent and unit materials costs to rise by 15 percent in the coming year. Of the $40 variable costs, 45 percent are from labor and 25 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. 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 c. If the volume of sales were to remain at 100,000 units, what price change would be required to attain the 7 percent increase in profits? Calculate the new price, Complete this question by entering your answers in the tabs below.

Answer 1

Calculation of Existing profit

Sales                      100000*80 = 8000000

Variable Cost 100000*40 = (4000000)

Fixed Cost                                  (1600000)

Existing Profit                              2400000                     

Breakup of Variable cost

                                  Existing               Impact of Increase

Material               40*25% = 10          11.15

Labour                  40*45% = 18          21.6

Overhead            40-10-18 = 12         15

Variable Cost                          40         48.1

(1) Calculation Of volume of sales and dollar sales to maintain existing price after price increase

Sales price increase by 10%

Contribution

Sales price      = 88

Variable Cost = 48.1

Contribution = 39.9

Fixed cost increase by 6% = 1696000

Desired Sales = Fixed cost + Target profit

                              Contribution per unit

                         = 1696000+2400000

                                        39.9

Sales in unit   = 102656.64

Sales in Dollar = 102656.64*88 = $ 9033784.32

(2) Calculation of volume of sales and Dollar sales to maintain 7% increase in profit

Target Profit = 2400000*.07+2400000 = $ 2568000

Desired Sales = Fixed cost + Target profit

                              Contribution per unit

                        = 1696000+2568000

$39.9

Sales in units = 106867.17

Sales in Dollars = 106867.17*88 = 9404310.96

(3) Calculation of price change if the volume of sales remain 100000units and profit increase by 7%

Variable cost per unit                                   =$ 48.1

Fixed cost per unit = 1696000/100000     = $16.96

Target profit per unit = 2568000/100000 =$ 25.68

New Sales price                                       = $90.74

Increase in sales price = 90.74-80 = $10.74 (i.e 13.425% increase in sales price)