Complete a cash budget for this information please

Waterways Corporation is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Waterways gathered the following information from the managers. Sales: Actual unit sates for November Actual unit sales for December Expected unit sales for January 113,500 103,100 114,000 Expected unit sales for February 113,500 Expected unit sales for March Expected unit sales for April Expected unit sales for May Unit selling price 116,000 126,000 138,500 $12 waterways wants to keep 10% of the next month's unit sales in ending inventory. All sales are on account, 85% of the Accounts Receivable are collected in the month of sale and is% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31 totaled 183,780. Direct Materials The product uses metal, plastic, and rubber. In total, each unit requires 2 pounds of material at an average cost of 0.75 per pound. waterways likes to keep 5% of the materials needed for the next month in its ending inventory. Payment for materials is made within 15 days, 50% is paid in the month of purchase and 50% is paid in the month after purchase. Accounts Payable on December totaled $120,595. Raw materials on December 31 totaled 11,295 pounds. Direct Labor: Labor requires 12 minutes per unit for completion and is paid at a rate of $18 per hour. Manufacturing Overhead Indirect materials 30 cents per labor hour 50 cents per labor hour Indirect labor Utilities 45 cents per labor hour Maintenance 25 cents per labor hour $52,000 per month Depreciation$16,800 per month $2,675 per month $2,200 per month $1,800 per month Salaries Property taxes Insurance Janitorial