ot split any b 1. Sales budget Create a sales budget for the 1st quarter that shows expected sales revenue for January, February, and March and total sales revenue for the quarter. Sales in units are expected to be: November: 10,000 March: 11,000 - (5 - 18 75 December: 11,000 April: 10,00 crs = 10625 January: 12,500 - May: 9,500 February: 9,000 Selling price/unit is expected to be $6/unit. 2. Cash collections budget Cash sales are generally 15% and credit sales are generally 85%. Credit sales are typically collected: 30% in the month of sale, 50% in the following month after the month of sale, 15% 2 months after the month of sale and 5% are never collected. What is the cash collections budget for January, February, and March and for the quarter? 3. Production budget The company plans to have ending inventory each month of 10% of the following month's expected sales. What is the production budget for January, February, and March and for the 1st quarter? 4. DM budget 1.5 pounds of DM is needed per unit at a cost of $2 per pound. Ending inventory of DM should be 15% of next month's production needs. What is the total cost of DM for January, February, and March and for the 1st quarter? 5. DL budget DL hours per unit is .05. The DL rate per hour is $13. What is the DL budget for January, February, and March and for the 1st quarter? 6. MOH budget The company's variable MOH rate is $10.50 per DL hour and the company's fixed MOH is $4,000 per month. How much MOH will be budgeted for January, February, and March and for the 1st quarter? 7. Capital Expenditures Budget The company expects to make the below purchases of PPE in the 1st quarter. Complete a capital expenditures budget for January, February, and March and for the 1st quarter. March New delivery truck $18,000 B. Combined cash budget Prepare a combined cash budget for January, February, and March and for the 1st quarter that includes cash collections and payments for the cost of DM, DL, MOH and capital expenditures found in prior budgets. Beginning cash balance on Jan. 1: $25,000 sting