Problem 5 (Preparation of Cash Budget) The sales forecast for January to May 20X4 and actual sales for November and December 20X3 for Purple Company are as follows: Month November December Sales (P) 80,000 70,000 Actual (20X3) 80,000 100,000 80,000 100,000 90,000 Forecast (20x4) January February March April Мay The 20% of sales is in cash and the rest is on credit, payment on which is realized on the third month. The following other information are also available. a. Amount of purchase is budgeted at 60% of the sales turnover of a month and paid on the third month of purchase. b. Variable expenses is 5% of turnover – time lag of payment half month. Commission on credit sales at 5% is payable on the third month. d. Rent and other expenses amounting to P3,000 paid every month. e. Payment for purchase of fixed assets amounting to P50,000 on March 20X4. f. Payment for taxes on April 20X4 amounting to P20,000. There will be an opening cash balance of P25,000. C. g.
Problem 5 (Preparation of Cash Budget) The sales forecast for January to May 20X4 and actual sales for November and December 20X3 for Purple Company are as follows: Month November December Sales (P) 80,000 70,000 Actual (20X3) 80,000 100,000 80,000 100,000 90,000 Forecast (20x4) January February March April Мay The 20% of sales is in cash and the rest is on credit, payment on which is realized on the third month. The following other information are also available. a. Amount of purchase is budgeted at 60% of the sales turnover of a month and paid on the third month of purchase. b. Variable expenses is 5% of turnover – time lag of payment half month. Commission on credit sales at 5% is payable on the third month. d. Rent and other expenses amounting to P3,000 paid every month. e. Payment for purchase of fixed assets amounting to P50,000 on March 20X4. f. Payment for taxes on April 20X4 amounting to P20,000. There will be an opening cash balance of P25,000. C. g.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Concept explainers
Variance Analysis
In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.
Standard Costing
The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.
Topic Video
Question
![Problem 5 (Preparation of Cash Budget)
The sales forecast for January to May 20X4 and actual sales for November and December 20X3 for Purple
Company are as follows:
Month
November
Sales (P)
80,000
70,000
Actual (20X3)
December
Forecast (20X4)
January
February
March
80,000
100,000
80,000
100,000
90,000
April
May
The 20% of sales is in cash and the rest is on credit, payment on which is realized on the third month. The
following other information are also available.
a. Amount of purchase is budgeted at 60% of the sales turnover of a month and paid on the third
month of purchase.
b. Variable expenses iş 5% of turnover – time lag of payment half month.
c. Commission on credit sales at 5% is payable on the third month.
d.
Rent and other expenses amounting to P3,000 paid every month.
e. Payment for purchase of fixed assets amounting to P50,000 on March 20X4.
f. Payment for taxes on April 20X4 amounting to P20,000.
g. There will be an opening cash balance of P25,000.
Required:
a. Prepare a cash budget for five months from January to May 20XS.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F69310ae6-caad-474b-8d0a-264a43086c14%2F5966dcf4-e734-4766-83bc-649bc8d5009f%2Ff3hzsjr_processed.png&w=3840&q=75)
Transcribed Image Text:Problem 5 (Preparation of Cash Budget)
The sales forecast for January to May 20X4 and actual sales for November and December 20X3 for Purple
Company are as follows:
Month
November
Sales (P)
80,000
70,000
Actual (20X3)
December
Forecast (20X4)
January
February
March
80,000
100,000
80,000
100,000
90,000
April
May
The 20% of sales is in cash and the rest is on credit, payment on which is realized on the third month. The
following other information are also available.
a. Amount of purchase is budgeted at 60% of the sales turnover of a month and paid on the third
month of purchase.
b. Variable expenses iş 5% of turnover – time lag of payment half month.
c. Commission on credit sales at 5% is payable on the third month.
d.
Rent and other expenses amounting to P3,000 paid every month.
e. Payment for purchase of fixed assets amounting to P50,000 on March 20X4.
f. Payment for taxes on April 20X4 amounting to P20,000.
g. There will be an opening cash balance of P25,000.
Required:
a. Prepare a cash budget for five months from January to May 20XS.
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