Using a separate columnar worksheet or Excel worksheet, prepare a Cash Budget by month for the quarter ending September 30, 2021, from the following data obtained from the CONSCIOUNESS Company. Support your solution with schedules of estimated receipts and payments. September P 18,000 120,000 110,000 16,000 July P 12,000 August P 16,000 150,000 120,000 18,000 2,000 Cash Sales Credit Sales 110,000 90,000 15,000 Purchases Operating expenses Interest expense Credit sales are collected 50% in the month of sales, 40% on the month following, 8% in the second month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and P90,000, respectively. Purchases of merchandise, all on account, are paid 60% in the month of purchase and 40% in the month following. Purchases for June are estimated at P80,000. Expenses include depreciation of P2,000, monthly, and are paid in the month incurred. Cash balance on June 30, 2021.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![Using a separate columnar worksheet or Excel worksheet, prepare a Cash Budget by month for the quarter
ending September 30, 2021, from the following data obtained from the CONSCIOÜNESS Company.
Support your solution with schedules of estimated receipts and payments.
August
P 16,000
150,000
July
September
Cash Sales
P 12,000
P 18,000
Credit Sales
Purchases
110,000
120,000
90,000
120,000
110,000
Operating expenses
Interest expense
15,000
18,000
16,000
2,000
Credit sales are collected 50% in the month of sales, 40% on the month following, 8% in the second
month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and
P90,000, respectively. Purchases of merchandise, all on account, are paid 60% in the month of purchase
and 40% in the month following. Purchases for June are estimated at P80,000.
Expenses include depreciation of P2,000 monthly, and are paid in the month incurred. Cash balance on
June 30, 2021.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F08db5eb1-07a4-4034-a5ae-481db76c965c%2F6d169d89-b73c-418e-8c01-1f7ff6a681d6%2Fyhmbes_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![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 Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![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 Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)