NEED HELP WITH # 4- 7 ASAP !!!

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 20 times 7 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 Total points available =140 1. Sales budget (in units and dollars). 2. Cash receipts budget. 3. Production budget. 4. Direct material budget in units and dollars. 5. Cash disbursements budget for raw material purchases. 6. Direct Labor budget in hours and dollars 7. The Manufacturing Overhead Budget 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 20 times 7 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 Total points available =140 1. Sales budget (in units and dollars). 2. Cash receipts budget. 3. Production budget. 4. Direct material budget in units and dollars. 5. Cash disbursements budget for raw material purchases. 6. Direct Labor budget in hours and dollars 7. The Manufacturing Overhead Budget