ABC Company seeks your assistance in developing cash and other budget information for August, September, and October, 2
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.
ABC Company seeks your assistance in developing cash and other budget information for August, September,
and October, 201A. On July 31, 201A, the company had cash of P22,000,
inventories of P618,800, and accounts payable of P266,110.
The budget is based on the following assumptions:
a. Sales
1. Sixty percent (60%) of the billings are collected within the month of sale, 25% are collected in the first
month after the month of sale, 10% are collected in the second month after the month of sale, and
5% are proved uncollectible.
b. Purchases
1. Sixty-five percent (65%) of all purchases of materials and selling and administrative expenses are paid
in the month purchased and the remainder in the following month.
2. Each month’s units of ending inventory are equal to 120% of the next month’s units of sales.
3. The cost of each unit of inventory is P20.00.
4. Selling and administrative expenses are equal to 20% of the current month’s sales.
Actual and projected sales are as follows:
Month In pesos In units
June P708,000 23,600
July 726,000 24,200
August 714,000 23,800
September 684,000 22,800
October 720,000 24,000
November 732,000 24,400
Required (15 items x 5 points):
Prepare cash budgets for August, September, and October, 201A, based on the above data and supported by
the following schedules:
a. Cash receipts from accounts receivable (3 items)
b. Purchases of inventory (3 items)
c. Cash disbursements on accounts payable (3 items)
d. Cash disbursements on selling and administrative expenses (3 items)
e.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
