Case Study

Budgeting

XY Ltd plans to sell the following:

Months	Product A (units)
June	1200
July	1800
August	2800
September	3200
October	3200

Stock of finished goods at 1 June was 240 units and the companys stockholding policy for the finished goods stock at the end of each month to represent 20% of the following months sales requirement. Each unit of product A uses two units of a component X1. On 1 June there were expected to be 264 units of X1 in stock. The desired closing stock of X1 is 10% of the next months production.

Each unit of component X1 costs $5.

Each unit of product A requires $6 of labor.

Fixed administration overheads in each month are budgeted to be $5000 (and include a charge of $1000 depreciation). Product A can be sold for $26 each.

Labor and fixed overheads are paid in the same month. Trade receivables (trade debtors) take two months to pay and the company pays its trade payables (trade creditors) after one month. The opening cash balance is $10000.

Required:

" with step by step calculation please "

1. The production budget in units for June July and August
2. The production cost budget for June July and August
3. The raw material purchase budget (in units and $) for June, July and august.