March
April
May
June
Budgeted Monthly Unit Sales
2,000.00
3,000.00
4,000.00
5,000.00
4,500.00
Using the table below, prepare a sales budget for the month of April, May, and June.
Budgeted Sales Forecast
April
June
Total
Budgeted Monthly Unit Sales
Unit Selling Price
Sales Budget
The beginning balance of Accounts Receivable amounted to P 10,000, which was fully paid in April. 80% of the monthly sales computed in the budgeted sales forecast are collected in the month of sale, while 20% of sales are collected the following month.
Using the table below, prepare a cash collection budget for the month of April, May, and June.
Cash Collection Budget
April
June
Total
Accounts Receivable, beg
Collection from March
Collection from April
Collection from May
Collection from June
Total Monthly Cash Collection