Question 1

You are a member of the sales team at Joel Brown Manufacturing Company Ltd. The team has decided on the following sales forecast for the months indicated.

The company produces two products Clam and Glam Sales Forecast 2016

Details	Clam	Glam
July	3,000 units	4,000 units
August	3,500 units	4,500 units
September	4,000 units	3,800 units
October	2800 units	3200 units
November	3400 units	3000 units
December	4200 units	4600 units

Notes:

i. To make one unit of Clam three (3) units of raw material Z508 is used. One unit of Z508 costs $80. Glam uses two (2) units of raw material K500 which costs $60 each.

ii. The company has decided that raw material stocks at the end of each month should be held equivalent to fifteen percent (15%) of the budgeted sales for the month in question.

iii. During the year, the company sold one unit of Clam for $220, while one unit of Glam was sold for $300.

iv. The decision was made that at the end of each month, there should be in store sufficient finished goods stock to meet thirty percent (30%) of the sales for the next month.

Required:

a. Prepare the companys sale budget for the period August to November 2016. (6 Marks)

b. Prepare the production budget for both products for the period August to November 2016. (10 Marks)

c. Prepare the direct raw materials usage budget for the period August to November 2016. (5 Marks)

d. Prepare the direct raw materials purchases budget for the period of August to November. (15 Marks)

e. Briefly explain, using two examples what is meant by a limiting budget factor. (4 Marks) (Total Marks: 50 Marks)