Answered step by step
Verified Expert Solution
Question
1 Approved Answer
From the following forecast of income and expenditure prepare a cash budget for the three months ending on June 2020. Month Sales (Rs.) Purchases(Rs) Wages(Rs)
From the following forecast of income and expenditure prepare a cash budget for the three months ending on June 2020.
Month | Sales (Rs.) | Purchases(Rs) | Wages(Rs) | Misc.(Rs) |
Feb | 1,20,000 | 84,000 | 10,000 | 7,000 |
March | 1,30,000 | 1,00,000 | 12,000 | 8,000 |
April | 80,000 | 1,04,000 | 8,000 | 6,000 |
May | 1,16,000 | 1,06,000 | 10,000 | 12,000 |
June | 88,000 | 80,000 | 8,000 | 6,000 |
Additional information:
- Sales: 25% realized in the month of sales, discount allowed 2% in cash on the sales realized in the month of sale; balance realized equally in two subsequent months.
- Purchases: These are paid in the month following the month of supply.
- Wages: 30% paid in the arrears following month. D
- Misc.Expenses: Paid a month in arrears.
- Rent: Rs1,000 per month paid quarterly in advance, due in April.
- Income tax: First installment of advance tax Rs. 25,000 due on or before 15th June to be paid within the month.
- Income from investment; Rs. 5,000 received quarterly in April, July, etc.
- Cashin hand Rs. 25,000 on April l.
- Depreciation: Rs 5000 for the month of April.
- Sale of old machinery at Rs. 50,000 in June.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started