Sales Budget
The marketing department has estimated sales as follows for the remainder of
the year: (Actual sales in June were 5,000 units)
July	8,000		October		8,000
August	15,000		November		6,000
September	12,000		December		10,000
The selling price of a SUPER DUPER widget is $35 and all sales are on account.
Based on past experience, sales are collected in the following pattern:
	40% in the month of sale
	55% in month following the sale
	5% are never collected (uncollectible)
Company
Sales Budget					Total
3rd Quarter	June	July	August	September	3rd Quarter
Sales in Units	5,000	8,000	15,000	12,000	35,000
Selling Price per Unit	35	35	35	35	35
Total Sales in $	175,000	280,000	525,000	420,000	1,225,000
Cash Collections
June's Cash Collections		96,250			96,250
July's Cash Collections		112,000	154,000		266,000
August's Cash Collections			210,000	288,750	498,750
September's Cash Collections				168,000	168,000
Total Cash Collections		$ 208,250	$ 364,000	$ 456,750	$ 1,029,000
Production Budget
The company maintains a finished goods inventory equal to 5% of the following
month's sales. The inventory of finished goods on July 1 is as it should be.
Vaughan Company
Production Budget					Total
3rd Quarter	July	August	September		3rd Quarter
Budgeted Sales in Units
Add: Desired Ending Inventory
Total Needs
Less: Beginning Inventory
Required Production
Raw Materials Purchasing Budget
Each unit of SUPER DUPER widget requires 0.8 pounds of WHAM compound. To
prevent shortages, the company would like the inventory of WHAM compound on hand
at the end of each month to equal 30% of the following month's production needs.
The inventory on July 1 is 2,004 pounds.
WHAM compound costs $5.00 per pound and company pays for 70% of its purchases
in the month of purchase; the remainder is paid in the following month. $50,400
of WHAM compound was purchased in June and 70% was paid for in June.
Company
RM Purchasing Budget					Total
3rd Quarter	July	August	September		3rd Quarter
Required Production
RM per Unit
Production Needs
Add: Desired Ending Inventory
Total Needs
Less: Beginning Inventory
RM to be Purchased
Cost of RM per pound
Cost of RM to be Purchased
Cash Disbursements for RM					2
June's RM Purchases
July's RM Purchases
August's RM Purchases
September's RM Purchases
Total Disbursements

Please help with the Production budget and the Raw Materials Purchasing budget and please explain, I will have to transfer to an excel format. Thank you!