A company manufactures and sells only Product X. The unit selling price of Product X is $100. The following budget details are also available:
Budgeted sales units are as follows:
January February March April May
2,000 1,000 3,500 4,000 7,000
- All sales are cash only.
- Opening inventory (units) at the start of January will be 500 units. Closing inventory (units) is budgeted at 5% of the sales volume of the next month.
- Production and sales occur in the same month.
- Raw materials are acquired and paid for in the month of production. A single unit of Product X requires 2 kg of raw materials. In January the price per kg is expected to be $ 15. This price is expected to increase to $ 25 per kg from March and remain at this level for the rest of the year.
- Labour costs are paid for in the month of production. It takes 5 hours to make a single unit of Product X. In January the labour rate is expected to be $ 2 per hour. However this rate is expected to increase by 50% from the month of April.
- Fixed overheads are paid for in the month in which they are incurred. These overheads are expected to be: $80,000 in January and February, thereafter overheads will increase by 10% on the previous figure.
- Machinery costing $ 500,000 is due to be installed in February and paid for in March.
- Taxation of $150,000 will be paid in April.
- A loan of $ 2,000,000 will be received in March. A loan interest payment of 1% will be made in the month of May.
- The opening cash balance in January is $100,000.
Prepare the following budgets for each of the four months January to April:
- Sales budget (showing volume and revenue);
- Production budget (in units) and
- Cash budget
