Problem
Sales and Cash Collections Budgets
Mountain Mash produces ice cream for wholesale distribution to grocers, restaurants, and independent ice cream shops. March, April, May, June, and July are busy months for the company as its customers gear up for the spring and summer rush. Mountain Mash has projected the following level of sales (in gallons) for March through July:
The company has a set wholesale selling price of $3.50 per gallon. Mountain Mash's customers purchase ice cream on credit, with the agreement that they must pay invoices within 30 days. Nonetheless, not all customers pay within that time frame. Mountain Mash's credit manager has developed the following table to show the typical cash collection pattern:
Required:
A. Prepare a sales budget for March, April, May, June, and July. When required, round answers to the nearest cent.