Central, Inc., is a manufacturer of granite paints. Sales are seasonal due to the seasonality in the home-building industry.
The expected pattern of sales for the first quarters of 2011 is as follows: Sales in Units 1st quarter 2nd Quarter Quantity 1,200 gallons 800 gallons Additional Information Inventory of finished goods and raw materials at the end of 2010 were 120 gallons and 240 pounds of respectively. Third quarter sales are predicted to be 1,000 gallons. Each gallon of paint sells for $280. All sales are on account, and the company’s experience with cash collections is that 75 percent of each quarter’s sales are collected during the same quarter as the sale. The remaining 25 percent of sales is collected in the quarter after the sale. Sales in the last quarter of 2010 were $280,000 (1000 units). Central desires to have 10 percent of the following quarter’s sales needs in finished-goods inventory at the end of each quarter. Each tile requires two pounds of raw material. Central desires to have 10 percent of the next quarter’s raw material in inventory at the end of each quarter. The raw material price is $90 per pound. The company buys its raw material on account and pays 60 percent of the resulting accounts payable during the quarter of the purchase. The remaining 40 percent is paid during the following quarter. (The raw-material purchases in the fourth quarter of 2010 were $260,000.)
Required: Calculate
a. Sales budget (in dollars); production budget and cash receipts budget for both quarters.
b. Direct materials purchases budget and cash disbursements budget for raw material for the first quarter.