ollowing information prepare a Cash Budget for the three months commencing 1st June, when the bank balance was Rs. 1,10.000. Month Sales Purchases Wages Research Overheads expenses Selling Factory Admn. Rs. Rs. Rs. Rs. Rs. Rs. Rs. April May 88,500 37,000 8,000 2,400 3,250 5,680 2,500 84,000 40,000 39,000 8.400 2,400 4,100 5,920 2,760 June 93,000 8,800 2,400 3,710 5,440 2,480 July 72,000 39,900 6,000 2,400 3,210 5,880 2,600 6,000 2,520 82,500 35,000 9,600 2,600 August A sales commission of 5% on sales, due 2 months after sales, is payable in addition to the above selling overheads. Capital Expenditure : Plant purchased in June Rs. 38,000 payable on delivery; Building purchased in June Rs. 80,000 payable in two half-yearly instalments, the first in July. 3,600 A dividend of Rs. 20,000 will be paid in October. Period of credit allowed by suppliers and to customers-8 weeks Lag in payment as to the tollowings are to be taken into account: Wages-1/8th month: Factory overheads-4 weeks; Administration overheads-4 weeks; Research Expenditure-4 weeks; Selling overheads-4 weeks. [CA, (F
ollowing information prepare a Cash Budget for the three months commencing 1st June, when the bank balance was Rs. 1,10.000. Month Sales Purchases Wages Research Overheads expenses Selling Factory Admn. Rs. Rs. Rs. Rs. Rs. Rs. Rs. April May 88,500 37,000 8,000 2,400 3,250 5,680 2,500 84,000 40,000 39,000 8.400 2,400 4,100 5,920 2,760 June 93,000 8,800 2,400 3,710 5,440 2,480 July 72,000 39,900 6,000 2,400 3,210 5,880 2,600 6,000 2,520 82,500 35,000 9,600 2,600 August A sales commission of 5% on sales, due 2 months after sales, is payable in addition to the above selling overheads. Capital Expenditure : Plant purchased in June Rs. 38,000 payable on delivery; Building purchased in June Rs. 80,000 payable in two half-yearly instalments, the first in July. 3,600 A dividend of Rs. 20,000 will be paid in October. Period of credit allowed by suppliers and to customers-8 weeks Lag in payment as to the tollowings are to be taken into account: Wages-1/8th month: Factory overheads-4 weeks; Administration overheads-4 weeks; Research Expenditure-4 weeks; Selling overheads-4 weeks. [CA, (F
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![sales.
[C.U. B. Com. (Hons.) 1989]
12. From the following information prepare a Cash Budget for the three months
commencing 1st June, when the bank balance was Rs. 1,10.000.
Month
Sales Purchases Wages Research
Overheads
expenses Selling Factory Admn.
Rs.
Rs.
Rs.
Rs.
Rs.
Rs.
Rs.
April
May
88,500
37,000
8,000
2,400
3,250
5,680
2,500
84,000 40,000
8,400
2,400
4,100
5,920 2,760
June
93,000
39,000
8,800 2,400
3,710
5,440 2,480
July
72,000
39,900
6,000 2,400
3,210
5,880
2,600
82,500 35,000 9,600 2,600
3,600 6,000 2,520
August
A sales commission of 5% on sales, due 2 months after sales, is payable in
addition to the above selling overheads. Capital Expenditure : Plant purchased in
June Rs. 38,0O00 payable on delivery; Building purchased in June Rs. 80,000 payable
in two half-yearly instalments, the first in July.
A dividend of Rs. 20,000 will be paid in October.
Period of credit allowed by suppliers and to customers-8 weeks
Lag in payment as to the tollowings are to be taken into account:
Wages-1/8th month: Factory overheads-4 weeks; Administration
overheads-4 weeks; Research Expenditure-4 weeks; Selling
overheads-4 weeks.
[C.A. (F)-Adapted](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F81ae2af8-f9e9-4877-9a05-5452218bebf3%2F23dc97f0-fb86-4aad-a0e9-5a6096d29809%2Frxehlwb_processed.jpeg&w=3840&q=75)
Transcribed Image Text:sales.
[C.U. B. Com. (Hons.) 1989]
12. From the following information prepare a Cash Budget for the three months
commencing 1st June, when the bank balance was Rs. 1,10.000.
Month
Sales Purchases Wages Research
Overheads
expenses Selling Factory Admn.
Rs.
Rs.
Rs.
Rs.
Rs.
Rs.
Rs.
April
May
88,500
37,000
8,000
2,400
3,250
5,680
2,500
84,000 40,000
8,400
2,400
4,100
5,920 2,760
June
93,000
39,000
8,800 2,400
3,710
5,440 2,480
July
72,000
39,900
6,000 2,400
3,210
5,880
2,600
82,500 35,000 9,600 2,600
3,600 6,000 2,520
August
A sales commission of 5% on sales, due 2 months after sales, is payable in
addition to the above selling overheads. Capital Expenditure : Plant purchased in
June Rs. 38,0O00 payable on delivery; Building purchased in June Rs. 80,000 payable
in two half-yearly instalments, the first in July.
A dividend of Rs. 20,000 will be paid in October.
Period of credit allowed by suppliers and to customers-8 weeks
Lag in payment as to the tollowings are to be taken into account:
Wages-1/8th month: Factory overheads-4 weeks; Administration
overheads-4 weeks; Research Expenditure-4 weeks; Selling
overheads-4 weeks.
[C.A. (F)-Adapted
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education