September = 300
October = 400
Novemeber = 450
December = 500
Blake has a policy that 20% of the following month's sales should be maintained in ending inventory. Each unit sells for $500. All sales are on account. The budgeted cash collections anticipate that one half of sales will be collected in the month of sale and the other half in the following month.
A. Prepare a production budget for the months of September, October, and November.
B. Prepare a schedule of budgeted cash collections from sales for the months of September, October, and November.
The response takes the form of a brief but clear budget and schedule attached in the accompanying Excel spreadsheet.