Decker Manufacturing is preparing its master budget for thefirst quarter of the upcoming year. The following data pertain toDecker Manufacturing's operations 1: Data Table Current Assets asof December 31 (prior year): Cash $ 4,600 Accounts receivable, net$ 46,000 Inventory $ 15,500 Property, plant, and equipment, net $123,000 Accounts payable $ 43,000 Capital stock $ 124,000 Retainedearnings $ 22,700 a. Actual sales in December were $71,000. Sellingprice per unit is projected to remain stable at $12 per unitthroughout the budget period. Sales for the first five months ofthe upcoming year are budgeted to be as follows: January $ 99,600February $ 118,800 March $ 115,200 April $ 108,000 May $ 103,200 b.Sales are 35% cash and 65% credit. All credit sales are collectedin the month following the sale. c. Decker Manufacturing has apolicy that states that each month's ending inventory of finishedgoods should be 10% of the following month's sales (in units). d.Of each month's direct material purchases, 20% are paid for in themonth of purchase, while the remainder is paid for in the monthfollowing purchase. Three pounds of direct material is needed perunit at $2.00 per pound. Ending inventory of direct materialsshould be 20% of next month's production needs. e. Most of thelabor at the manufacturing facility is indirect, but there is somedirect labor incurred. The direct labor hours per unit is 0.05. Thedirect labor rate per hour is $9 per hour. All direct labor is paidfor in the month in which the work is performed. The direct labortotal cost for each of the upcoming three months is as follows:January $ 3,807 February $ 4,442 March $ 4,293 f. Monthlymanufacturing overhead costs are $5,500 for factory rent, $2,900for other fixed manufacturing expenses, and $1.10 per unit forvariable manufacturing overhead. No depreciation is included inthese figures. All expenses are paid in the month in which they areincurred. g. Computer equipment for the administrative offices willbe purchased in the upcoming quarter. In January, DeckerManufacturing will purchase equipment for $5,000 (cash), whileFebruary's cash expenditure will be $12,200 and March's cashexpenditure will be $16,600. h. Operating expenses are budgeted tobe $1.25 per unit sold plus fixed operating expenses of $1,800 permonth. All operating expenses are paid in the month in which theyare incurred. No depreciation is included in these figures. i.Depreciation on the building and equipment for the general andadministrative offices is budgeted to be $5,000 for the entirequarter, which includes depreciation on new acquisitions. j. DeckerManufacturing has a policy that the ending cash balance in eachmonth must be at least $4,000. It has a line of credit with a localbank. The company can borrow in increments of $1,000 at thebeginning of each month, up to a total outstanding loan balance of$150,000. The interest rate on these loans is 1% per month simpleinterest (not compounded). The company would pay down on the lineof credit balance in increments of $1,000 if it has excess funds atthe end of the quarter. The company would also pay the accumulatedinterest at the end of the quarter on the funds borrowed during thequarter. k. The company's income tax rate is projected to be 30% ofoperating income less interest expense. The company pays $10,000cash at the end of February in estimated taxes. Requirement 1.Prepare a schedule of cash collections for January, February, andMarch, and for the quarter in total Requirement 2. Prepare aproduction budget. (Hint: Unit sales = Sales in dollars / Sellingprice per unit.) Requirement 3. Prepare a direct materials budget.(Round your answers to the nearest whole dollar.) Requirement 4.Prepare a cash payments budget for the direct material purchasesfrom Requirement 3. (Round your answers to the nearest wholedollar.) Requirement 5. Prepare a cash payments budget for directlabor. Requirement 6. Prepare a cash payments budget formanufacturing overhead costs. (Round your answers to the nearestwhole dollar.) Requirement 7. Prepare a cash payments budget foroperating expenses. (Round your answers to the nearest wholedollar.) Requirement 8. Prepare a combined cash budget. (If a boxis not used in the table leave the box empty; do not enter a zero.Use parentheses or a minus sign for negative cash balances andfinancing payments.) Requirement 9. Calculate the budgetedmanufacturing cost per unit (assume that fixed manufacturingoverhead is budgeted to be $0.80 per unit for the year). (Roundyour answer to the nearest cent Requirement 10. Prepare a budgetedincome statement for the quarter ending March 31. (Hint: Cost ofgoods sold = Budgeted cost of manufacturing one unit x Number ofunits sold.) (Round your answers to the nearest whole dollar.)