Part 5: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Cash Budget tab), calculate the cash receipts for the first quarter of this year.

Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses.

This is a 5301-Mangerial Accounting Applications course

Cookie Business
The budgeted credit sales are as follows:
December last year	$ 250,000
January	$ 125,000
February	$ 300,000
March	$ 90,000
Collection:
Month of the sale	80%
Month following the sale	20%
Estimated cash receipts
	January	February	March
Last month's sales	$ 200,000	$ 100,000	$ 240,000
Current month's sales	$ 25,000	$ 60,000	$ 18,000
Total	$ 225,000	$ 160,000	$ 258,000