Schedule of Cash Collections of Accounts Receivable Bark & Purr Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $160,000 June 230,000 July 350,000 All sales are on account. 53 percent of sales are expected to be collected in the month of the sale, 37% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May, June, and July.
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.
Schedule of Cash Collections of
Bark & Purr Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows:
May | $160,000 |
June | 230,000 |
July | 350,000 |
All sales are on account. 53 percent of sales are expected to be collected in the month of the sale, 37% in the month following the sale, and the remainder in the second month following the sale.
Prepare a schedule indicating cash collections from sales for May, June, and July.
May | June | July | |
May sales on account: | |||
Collected in May | $fill in the blank 1 | ||
Collected in June | $fill in the blank 2 | ||
Collected in July | $fill in the blank 3 | ||
June sales on account: | |||
Collected in June | fill in the blank 4 | ||
Collected in July | fill in the blank 5 | ||
July sales on account: | |||
Collected in July | fill in the blank 6 | ||
Total cash collected | $fill in the blank 7 | $fill in the blank 8 | $fill in the blank 9 |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps