sales forecasts have been made for parts of 2017 and 2018: In Rs May 2017 150,000 June 150,000 July 300.000 August 450,000 September 600,000 October 300,000 November 300,000 December 75,000 January 2018 150.000 Collection estimates obtained from the credit and collection department are as follows: collected within the month of sale, 5 percent; collected the month following the sale, 80 percent; collected the second month following the sale, 15 percent. Payments for labor and raw materials are typically made during the month following the month in which these costs are incurred. Total labor and raw materials costs are estimated for each month as follows: In Rs Мay 2017 June 75,000 75,000 July 105,000 August 735,000 September 255,000 October 195,000 November 135,000 December 75,000 General and administrative salaries will amount to approximately Rs 22,500 a month; lease payments under long-term lease contracts will be Rs 7,500 a month; depreciation charges will be Rs 30,000 a month; miscellaneous expenses will be Rs 2,250 a month; income tax payments of Rs 52,500 will be due in both September and December; and a progress payment of Rs 150,000 on a new research laboratory must be paid in October. Cash on hand on July 1 will amount to RS 110,000 and a minimum cash balance of Rs 75,000 will be maintained through-out the cash budget period. Prepare a cash budget for the last six months of 2017 with an estimate of required financing (or excess funds).
sales forecasts have been made for parts of 2017 and 2018: In Rs May 2017 150,000 June 150,000 July 300.000 August 450,000 September 600,000 October 300,000 November 300,000 December 75,000 January 2018 150.000 Collection estimates obtained from the credit and collection department are as follows: collected within the month of sale, 5 percent; collected the month following the sale, 80 percent; collected the second month following the sale, 15 percent. Payments for labor and raw materials are typically made during the month following the month in which these costs are incurred. Total labor and raw materials costs are estimated for each month as follows: In Rs Мay 2017 June 75,000 75,000 July 105,000 August 735,000 September 255,000 October 195,000 November 135,000 December 75,000 General and administrative salaries will amount to approximately Rs 22,500 a month; lease payments under long-term lease contracts will be Rs 7,500 a month; depreciation charges will be Rs 30,000 a month; miscellaneous expenses will be Rs 2,250 a month; income tax payments of Rs 52,500 will be due in both September and December; and a progress payment of Rs 150,000 on a new research laboratory must be paid in October. Cash on hand on July 1 will amount to RS 110,000 and a minimum cash balance of Rs 75,000 will be maintained through-out the cash budget period. Prepare a cash budget for the last six months of 2017 with an estimate of required financing (or excess funds).
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![III. The Simmons Company is planning to request a line of credit from its bank. The following
sales forecasts have been made for parts of 2017 and 2018:
In Rs
May 2017
150,000
June
150,000
July
300,000
August
450,000
September
600.000
October
300,000
November
300,000
December
75,000
January 2018
150,000
Collection estimates obtained from the credit and collection department are as follows: collected
within the month of sale, 5 percent; collected the month following the sale, 80 percent; collected
the
ond month following
sale, 15 percent.
Payments for labor and raw materials are typically made during the month following the month in
which these costs are incurred. Total labor and raw materials costs are estimated for each month
as follows:
In Rs
May 2017
75,000
June
75,000
July
105,000
August
735,000
September
255,000
October
195,000
November
135,000
December
75,000
General and administrative salaries will amount to approximately Rs 22,500 a month; lease
payments under long-term lease contracts will be Rs 7,500 a month; depreciation charges will be
Rs 30,000 a month; miscellaneous expenses will be Rs 2,250 a month; income tax payments of Rs
52,500 will be due in both September and December; and a progress payment of Rs 150,000 on a
new research laboratory must be paid in October. Cash on hand on July 1 will amount to RS
110,000 and a minimum cash balance of Rs 75,000 will be maintained through-out the cash budget
period.
Prepare a cash budget for the last six months of 2017 with an estimate of required financing
(or excess funds).](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F40718d26-d3ff-43bf-af34-c83480779484%2Fc776232e-52a5-401a-8077-4407b2fbd045%2Frjs2lpc_processed.jpeg&w=3840&q=75)
Transcribed Image Text:III. The Simmons Company is planning to request a line of credit from its bank. The following
sales forecasts have been made for parts of 2017 and 2018:
In Rs
May 2017
150,000
June
150,000
July
300,000
August
450,000
September
600.000
October
300,000
November
300,000
December
75,000
January 2018
150,000
Collection estimates obtained from the credit and collection department are as follows: collected
within the month of sale, 5 percent; collected the month following the sale, 80 percent; collected
the
ond month following
sale, 15 percent.
Payments for labor and raw materials are typically made during the month following the month in
which these costs are incurred. Total labor and raw materials costs are estimated for each month
as follows:
In Rs
May 2017
75,000
June
75,000
July
105,000
August
735,000
September
255,000
October
195,000
November
135,000
December
75,000
General and administrative salaries will amount to approximately Rs 22,500 a month; lease
payments under long-term lease contracts will be Rs 7,500 a month; depreciation charges will be
Rs 30,000 a month; miscellaneous expenses will be Rs 2,250 a month; income tax payments of Rs
52,500 will be due in both September and December; and a progress payment of Rs 150,000 on a
new research laboratory must be paid in October. Cash on hand on July 1 will amount to RS
110,000 and a minimum cash balance of Rs 75,000 will be maintained through-out the cash budget
period.
Prepare a cash budget for the last six months of 2017 with an estimate of required financing
(or excess funds).
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education