Gastro Corporation supplies acetylene and other compressed gases to industry. You as a Finance Manager of the company, need to prepare the cash budget for the month of November and December. Data regarding the store's operations follow: • Sales are budgeted at RM310,000 for November, RM330,000 for December and RM320,000 for January. • Collections are expected to be 80% in the month of sale and 20% in the month of following sale. All account receivable on October 2020 will be collected in month of November. Purchase of inventory are expected to be RM238,700 for November and RM254,100 for the month of December. 85% of the purchase are paid in the month of purchase, the remainder are paid in the following month. • Other monthly expenses to be paid in cash are RM20,500 every month. • During November, the company will borrow RM7,595 from its bank by giving a new note payable to the bank. The new note will be due in one year. Statement of Financial Position 31 Oct 2020 Assets: RM Cash Account Receivable Merchandise inventory Property, plant and Equipment 21,300 82,300 202,895 999,000 TOTAL ASSETS 1,305,495 Liabilities and Equity: Account Payable 195,300 540,000 Common Stock Retained Earning 570,195 TOTAL LIABILITIES AND EQUITY 1,305,495
Gastro Corporation supplies acetylene and other compressed gases to industry. You as a Finance Manager of the company, need to prepare the cash budget for the month of November and December. Data regarding the store's operations follow: • Sales are budgeted at RM310,000 for November, RM330,000 for December and RM320,000 for January. • Collections are expected to be 80% in the month of sale and 20% in the month of following sale. All account receivable on October 2020 will be collected in month of November. Purchase of inventory are expected to be RM238,700 for November and RM254,100 for the month of December. 85% of the purchase are paid in the month of purchase, the remainder are paid in the following month. • Other monthly expenses to be paid in cash are RM20,500 every month. • During November, the company will borrow RM7,595 from its bank by giving a new note payable to the bank. The new note will be due in one year. Statement of Financial Position 31 Oct 2020 Assets: RM Cash Account Receivable Merchandise inventory Property, plant and Equipment 21,300 82,300 202,895 999,000 TOTAL ASSETS 1,305,495 Liabilities and Equity: Account Payable 195,300 540,000 Common Stock Retained Earning 570,195 TOTAL LIABILITIES AND EQUITY 1,305,495
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
please answer it asap thnx
Transcribed Image Text:Gastro Corporation supplies acetylene and other compressed gases to industry. You as a
Finance Manager of the company, need to prepare the cash budget for the month of
November and December. Data regarding the store's operations follow:
• Sales are budgeted at RM310,000 for November, RM330,000 for December and
RM320,000 for January.
Collections are expected to be 80% in the month of sale and 20% in the month of
following sale. All account receivable on Otober 2020 will be collected in month of
November.
• Purchase of inventory are expected to be RM238,700 for November and RM254,100
for the month of December. 85% of the purchase are paid in the month of purchase,
the remainder are paid in the following month.
• Other monthly expenses to be paid in cash are RM20,500 every month.
• During November, the company will borrow RM7,595 from its bank by giving a new
note payable to the bank. The new note will be due in one year.
Statement of Financial Position 31 Oct 2020
Assets:
RM
Cash
21,300
Account Receivable
Merchandise inventory
Property, plant and Equipment
82,300
202,895
999,000
TOTAL ASSETS
1,305,495
Liabilities and Equity:
Account Payable
195,300
Common Stock
540,000
570,195
Retained Earning
TOTAL LIABILITIES AND EQUITY
1,305,495
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 3 steps with 2 images
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