Hi guys I have to prepare a cash budget for a college assignment. Generally I am usually quite good at accounting and understand the concept of cash budgeting but my lecturer did not go into a lot of detail and has left the majority of the class in the dark. I will some details of the assignment below. If anyone can give us a hand it would be greatly appreciated.
Sales Information:
The selling price of the violin is € 200.
(b) Quantities sold (in units) on credit will be as follows:
Nov20 Dec20 Jan Feb March April May June
1,000 1,200 1,400 1,600 1,800 2,000 2,200 2,600
(c) Credit sales customers are given TWO months to pay their bills.
(d) Cash sales are expected to be 100 units per month.
Production Information:
(e) The production cost of the company’s product is € 100 made up as follows:
Materials € 30 per unit
Labour € 50 per unit
Variable Overhead € 20 per unit
Production quantities (in units) are as follows:
Nov Dec Jan Feb March April May June
1,200 1,400 1,600 2,000 2,400 2,600 2,400 2,200
(f) Materials are paid for TWO months after they have been purchased.
(g) Labour is paid in the same month as it is incurred.
(h) Variable overheads are paid in the same month as they are incurred.
Other business costs:
(i) A bank Loan of €25,000 is to be repaid in April 2021.
(j) A company van will be bought in Jan.2021 for € 8,000. It will be paid for in April 2021.
(k) Fixed costs are € 15,000 every month.
(l) The company is expected to be €24,000 overdrawn in the bank on 1st January 2021.
(m) Cleaning & maintenance will be €2,000 each month from January to June 2021.
(n) Repairs to premises will be €20,000 each month from January to June 2021.
Sales Information:
The selling price of the violin is € 200.
(b) Quantities sold (in units) on credit will be as follows:
Nov20 Dec20 Jan Feb March April May June
1,000 1,200 1,400 1,600 1,800 2,000 2,200 2,600
(c) Credit sales customers are given TWO months to pay their bills.
(d) Cash sales are expected to be 100 units per month.
Production Information:
(e) The production cost of the company’s product is € 100 made up as follows:
Materials € 30 per unit
Labour € 50 per unit
Variable Overhead € 20 per unit
Production quantities (in units) are as follows:
Nov Dec Jan Feb March April May June
1,200 1,400 1,600 2,000 2,400 2,600 2,400 2,200
(f) Materials are paid for TWO months after they have been purchased.
(g) Labour is paid in the same month as it is incurred.
(h) Variable overheads are paid in the same month as they are incurred.
Other business costs:
(i) A bank Loan of €25,000 is to be repaid in April 2021.
(j) A company van will be bought in Jan.2021 for € 8,000. It will be paid for in April 2021.
(k) Fixed costs are € 15,000 every month.
(l) The company is expected to be €24,000 overdrawn in the bank on 1st January 2021.
(m) Cleaning & maintenance will be €2,000 each month from January to June 2021.
(n) Repairs to premises will be €20,000 each month from January to June 2021.