Interested to Buy Any Domain ? << Click Here >> for more details...
From the following information you are to prepare a
Cash Budget for the period from July to December 2008.
(i) The estimated sales and expenses are
as follows:
June
July
Aug.
Sep.
Oct.
Nov.
Dec.
Sales
35,000
40,000
40,000
50,000
50,000
60,000
65,000
Purchases
14,000
16,000
17,000
20,000
20,000
25,000
28,000
Wages & Salaries
12,000
14,000
14,000
18,000
18,000
20,000
22,000
Expenses
5,000
6,000
6,000
6,000
7,000
7,000
7,000
Interest Received
2,000
-
-
2,000
-
-
2,000
Sale of Fixed Assets
-
-
20,000
-
-
-
-
(ii) Sales are 20% in cash and balance on
credit. 50% of the debtors are collected in the month of
sales and the remaining in the next month.
(iii) The time lag in payment of purchases
and expenses is 1 month. However, wages and salaries are
paid fortnightly with a time lag of 15 days.
(iv) The company maintains a minimum cash
balance of Rs. 5,000. The cash balance in excess of Rs.
7,000 is invested in government securities in multiples of
Rs. 1,000. Short falls in cash balance are made good by
borrowing from banks. The interest received as well as paid
is to be ignored.
- 1 Answers
- 3096 Views
- Ignou, I also Faced
- E-Mail Answers
Answer Posted / Rameez Iqbal Khan
Here's a Cash Budget for the period from July to December 2008 based on the provided information:
July:
Beginning Cash Balance: (Assume a cash balance of Rs. 5,000 from June)
- Purchases: 16,000
- Wages & Salaries: 14,000
- Expenses: 6,000
Ending Cash Balance: 5,000 - 36,000 = -31,000 (Cash deficit)
August:
Beginning Cash Balance: (-31,000 from July) + Sales: 40,000
- Purchases: 17,000
- Wages & Salaries: 14,000
- Expenses: 6,000
Ending Cash Balance: 40,000 - 38,000 = 2,000 (Cash surplus)
September:
Beginning Cash Balance: 2,000 from August
+ Sale of Fixed Assets: 20,000 (assuming this sale occurs in September)
- Purchases: 20,000
- Wages & Salaries: 18,000
- Expenses: 6,000
Ending Cash Balance: 40,000 (Cash surplus)
October, November, and December can be calculated similarly. Note that the Interest Received is not included in the cash budget as it is ignored per the given rules.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Sir i am working in 3 star hotel as a senior accountant i need some general letter drafts pleas do the need ful
hai everybody... wish u all the best for those who got selected in sbi associate bank is anyone from coimbatore region attending on 27th may 2009.
someone plz plz plzz.. send me the sample papers for SBI clerical xams... i need it very badly..
can anybody send me interview question&answer to me in accounts and finance and income tax....my mail.id...jagathis1986@gmail.com
please send me some previous sbi clerical interview questions to my email id....
You are given the following information in respect of a company: Fixed cost –Rs.13,000 Variable cost –Rs.14,000 Net profit –Rs.3,000 Net sales-Rs.30,000 Find out: a>BEP b>The profit for sales volume of Rs.50,000 c>The volume of sales to make a profit of Rs.10,000
Q5 Prepare a Balance sheet from the following particulars: Gross profit =Rs.80,000 Gross profit to cost of goods sold =1/3 Stock velocity =6 times Opening stock =Rs.36,000 Accounts receivable velocity =72 days (year=360 days) Current assets=Rs.1,50,000 Account payable velocity=90 days Bills receivable =Rs.20,000 Bills payable=Rs.5,000 Fixed assets turnover ratio (on cost of goods sod)=8 times
respected sir,i am doing II b.com(CA) in a reputed college..i want to know about the ideas and ways to shine in future.i am doing ICWAI also sir.i want to know what shall i study more in this field to shine...
hi.this krishan .i m slect in axis bank for executive. when i sposse to join
What is meant by advance ruling? What is the scheme of advance rulings?
what is new updates in account
Hi, Please post in here the Aptitude Test Questions given in companies like Thomson, Reuters, GMS, JP Morgan, Northern Trust Bank etc.
HOW MUCH LATEST ACCOUNTING STANDARDS , TDS RATE , INCOME TAX RATE, EXCISE , VAT , SERVICE TAX & FBT RATES? (PLS. ARRANGE TO SEND THE RATES FOR ABOVE IN CATAGORY & LIMIT WISE)
what salary you expect???
For the production of 10,000 units the following are the budgeting expenses: Per Unit Rs. Direct materials 60 Direct labour 30 Variable overhead 25 Fixed overhead (Rs.1,50,000) 15 Selling expenses (10% fixed) 15 Variable expenses (direct) 5 Administrative expenses (Rs.50,000 fixed) 5 Distribution expenses (20% fixed) 5 Total cost of sales per unit 160 Prepare the flexible budget for the production of 6,000 , 7,000 ,and 8,000 units of production
