Prepare a recommended monthly sales schedule in units


Problem:

In preparation for your meeting with Judith Howarth, you are asked to calculate:

(a) the minimum number of beds to be sold if Brita Beds is to avoid making a loss;

(b) the minimum turnover required if Brita Beds it to avoid making a loss.

At the meeting, Judith Howarth provides you with further information:

1 The purchase price of the business is £300 000.

2 Judith has savings of £300 000 currently earning 5% interest per annum, which she can use to aquire Beta Beds.

3 Her current salary is £36 550.

To reduce costs, Judith suggests that she should take over the role of manager as the current one is about to retire. However, she does not want to take a reduction in income. Judith also tells you that she has been carrying out some market research. The results of this are as follows:

1 The number of households in Mytown is currently 44 880

2 Brita Beds Ltd is the only outlet selling beds in Mytown.

3 According to a recent survey, 10% of house-holds change their beds every 9 years, 60% every 10 years and 30% every 11 years.

4 The survey also suggested that there is an average of 2.1 beds per household.

Task 2

Write a letter to Judith Howarth. Your letter should: (a) identify the profit required to compensate for the loss of salary and interest;

(b) show the number of beds to be sold to achieve that profit;

(c) calculate the likely maximum number of beds that Brita Beds would sell in a year;

(d) use your answers in {a) to (c) to justify whether or not Judith Howarth should purchase the company and become its manager;

(e) give two possible reasons why your estimate of the maximum annual sales volume may prove inaccurate.

On receiving your letter, Judith Howarth decides she would prefer to remain as the purchasing director for Winter plc rather than acquire Brita Beds Ltd. Shortly afterwards, you receive a telephone call from her. Judith explains that Winter plc is redeveloping its premises and that she is concerned about the appropriate sales policy for Winter's bed department while the redevelopment takes place. Although she has a statement of unit profitability, this had been prepared before the start of the redevelopment and had assumed that there would be in excess of 800 square metres of storage space available to the bed department. Storage space is critical as customers demand immediate delivery and are not prepared to wait until the new stock arrives.

The next day, Judith Howarth sends you a letter containing a copy of the original statement of profitability. This is reproduced below:

Model




Monthly demand

A

B

C

(beds)

35

45

20


(£)

(£)

(£)

Unit selling price

240.00.


672.00

Unit cost per bed

130.00

310.00

550.00

Carriage inwards

20.00

20.00

20.00

Staff costs

21.60

40.32

60.48

Department fixed overheads

20.00

20.00

20.00

General fixed overheads

25.20

25.20

25.20

Unit profit

23.20

32.48

(3.68)

Storage required per bed (square metres)

3

4

5

In her letter she asks for your help in preparing a marketing plan which will maximize the profit-ability of Winter's bed department while the re-development takes place. To help you, she has provided you with the following additional information:

1 Currently storage space available totals 300 square metres.

2 Staff costs represent the salaries of the sales staff in the bed department. Their total cost of £3780 per month is apportioned to units on the basis of planned turnover.

3 Departmental fixed overhead of £2000 per month is directly attributable to the department and is apportioned on the number of beds planned to be sold.

4 General fixed overheads of £2520 are also apportioned on the number of beds planned to be sold. The directors of Winter plc believe this to be a fair apportionment of the store's central fixed overheads.

5 The cost of carriage inwards and the cost of beds vary directly with the number of beds purchased.

Task 3

(a) Prepare a recommended monthly sales schedule in units which will maximize the profitability of Winter plc's bed department.

(b) Calculate the profit that will be reported per month if your recommendation is implemented.

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Prepare a recommended monthly sales schedule in units
Reference No:- TGS02041460

Now Priced at $30 (50% Discount)

Recommended (98%)

Rated (4.3/5)