MoxhartPatelTech Inc, manufactures a special ceramic tile used as a component in residential solar energy systems. Sales are seasonal due to the seasonality in the home-building industry. The expected pattern of sales for the next year (2018) is as follows: Sales in Units 1st quarter: 2000 2nd Qurater: 6,000 3rd Qurter: 8000 4th Quarter: 4,000 Year 20,000 Each tile sells for $25. All sales are on account, and MoxhartPatelTech's experience with cash collections is that 60 percent of each quarter's sales are collected during the same quarter as the sale. The remaining 40 percent of sales is collected in the quarter after the sale. MoxhartPatelTech experiences negligible bad debts, and so this is ignored in the budgeting process. Sales in the fourth quarter of 20x7 are expected to be $100,000 (4,000 units). MoxhartPatelTech desires to have 10 percent of the following quarter's sales needs in finished-goods inventory at the end of each quarter. (On December 31, 2017, MoxhartPatelTech expects to have 200 units in inventory.) Each tile requires two pounds of raw material. MoxhartPatelTech desires to have 10 percent of the next quarter's raw material required for production in inventory at the end of each quarter. (On December 31, 2017, MoxhartPatelTech expects to have 480 pounds of raw material in inventory.) The raw material price is $5 per pound. The company buys its raw material on account and pays 70 percent of the resulting accounts payable during the quarter of the purchase. The remaining 30 percent is paid during the following quarter. (The raw-material purchases in the fourth quarter of 2017 are expected to be $36,600.) Each tile takes 1.5 hours to manufacture. Workers are paid $20 an hour Fixed overhead is $25,000 and Variable overhead is $12 per direct labor hour. Required: Prepare the following budget schedules, in good form, for 2018. Include a column for each quarter and for the year. 5. Cash disbursements budget for raw material purchases. 6. Direct Labor budget in hours and dollars 7. The Manufacturing Overhead Budget