In 2021 the company “AROFAH” will prepare a cash budget. The cash receipts and disbursements plan for the first six months (January to June) are as follows: Admission Plan: Sales Receipts: Sales are made in cash as much as 50% and 50% credit of sales. Of credit sales, 60% is received one month after the month of sale and the remaining is received 2 months after the month of sale. The total receipts of receivables in January and February are IDR 200,000 and IDR 300,000, respectively. The acceptance plans are: A. The amount of sales are: B. Other receipts are: January IDR 1,400,000 January IDR 200,000 February IDR 1,500,000 February IDR 300,000 March IDR 1,500,000 March IDR 100,000 April IDR 1,600,000 April IDR 200,000 May IDR 1,700,000 May IDR 400,000 June IDR 1,650,000 June IDR 500,000 2. Expediture Plan : A. Purchase of raw materials: B. Purchase of auxiliary materials January IDR 100,000 January IDR 20,000 February IDR 200,000 February IDR 30.000 March IDR 200,000 March IDR 20,000 April IDR 220,000 April IDR 50.000 May IDR 150.000 May IDR 40,000 June IDR 210,000 June IDR 60,000 C. Payment of salaries and wages D. Transport costs and sales commissions: January IDR 500,000 January IDR 30,000 February IDR 500,000 February IDR 50.000 March IDR 600,000 March IDR 40,000 April IDR 800,000 April IDR 60,000 May IDR 1,000,000 May IDR 50.000 June IDR 800,000 June IDR 70,000 E. Administration fees and others: F. In March, a tax of IDR 50,000 will be paid January IDR 35,000 February IDR 55,000 March IDR 45,000 April IDR 55,000 May IDR 40,000 June IDR 60,000 3. Other plans: A. Cash balance at the end of December of the previous year IDR 50,000 B. If there is a deficit, the company will make a loan to the bank at the beginning of the month and pay it back at the end of the month without interest. C. Cash iron inventory of IDR 60,000 Requested From the data information above, prepare a cash budget for January to June 2021 in stages, namely a cash budget for operating transactions (business transactions), financial transactions and transactions as a whole.
In 2021 the company “AROFAH” will prepare a cash budget. The cash receipts and disbursements plan for the first six months (January to June) are as follows:
- Admission Plan:
Sales Receipts: Sales are made in cash as much as 50% and 50% credit of sales. Of credit sales, 60% is received one month after the month of sale and the remaining is received 2 months after the month of sale.
The total receipts of receivables in January and February are IDR 200,000 and IDR 300,000, respectively. The acceptance plans are:
A. The amount of sales are: B. Other receipts are:
January IDR 1,400,000 January IDR 200,000
February IDR 1,500,000 February IDR 300,000
March IDR 1,500,000 March IDR 100,000
April IDR 1,600,000 April IDR 200,000
May IDR 1,700,000 May IDR 400,000
June IDR 1,650,000 June IDR 500,000
2. Expediture Plan :
A. Purchase of raw materials: B. Purchase of auxiliary materials
January IDR 100,000 January IDR 20,000
February IDR 200,000 February IDR 30.000
March IDR 200,000 March IDR 20,000
April IDR 220,000 April IDR 50.000
May IDR 150.000 May IDR 40,000
June IDR 210,000 June IDR 60,000
C. Payment of salaries and wages D. Transport costs and sales commissions:
January IDR 500,000 January IDR 30,000
February IDR 500,000 February IDR 50.000
March IDR 600,000 March IDR 40,000
April IDR 800,000 April IDR 60,000
May IDR 1,000,000 May IDR 50.000
June IDR 800,000 June IDR 70,000
E. Administration fees and others: F. In March, a tax of IDR 50,000 will be paid
January IDR 35,000
February IDR 55,000
March IDR 45,000
April IDR 55,000
May IDR 40,000
June IDR 60,000
3. Other plans:
A. Cash balance at the end of December of the previous year IDR 50,000
B. If there is a deficit, the company will make a loan to the bank at the beginning
of the month and pay it back at the end of the month without interest.
C. Cash iron inventory of IDR 60,000
Requested
From the data information above, prepare a cash budget for January to June 2021 in stages, namely a cash budget for operating transactions (business transactions), financial transactions and transactions as a whole.
PLEASE ANSWER AND NO REJECT THANK YOU
Step by step
Solved in 2 steps with 1 images
