please show the work so i can see how to do these!! thank you so much

Please fill out manufacturing overhead budget, selling and administrative budget, schedule of cash collections, and the cash budget. Please fill out the charts for each including the work to the right

all the information given is in the pictures

Auto Zoom Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed the following sales forecast for the months of January through March 20X 1 for its only two products: 50,000 units of J to be sold at $90 each and 30,000 units of K to be sold at $70 each. The desired unit inventories at March 31, 20X1, are 10% of the next quarter's unit sales forecast, which are 60,000 units of J and 30,000 units of K. The January 1, 20X1, unit inventories were 5,000 units of J and 2,000 units of K. Each unit of J requires 3 pounds of material A and 2 pounds of material B for its manufacture;K requires 2 pounds of A and 4 pounds of B. The purchase cost of A is $9 per pound and the purchase cost of B is $5 per pound. Materials A and B on hand at January 1, 20x1, were 19,000 pounds of A and 7,000 pounds of B. Desired inventories at March 31, 20X1, are 14,000 pounds of A and 8,000 pounds of B. Each unit of J requires 0.5 hours of direct labor in the factory: each unit of K requires 1.0 hour of direct labor. The average hourly rate for direct labor is $12 per hour. Estimated manufacturing overhead cost is $6 per direct labor hour plus $90,000 per month. Selling and administrative expenses are estimated to be 10% of sales revenue plus $180,000 per month. Cash sales for the first quarter are estimated to be $300,000 per month. It is forecast that 30% of the credit sales for the quarter ended March 31, 20X1, will occur in January, 30% in February and 40% in March. Of credit sales (December through March), 40% will be collected as cash in the month of sale and 55% will be collected in the following month. The remainder will be uncollectible. Cash collected in January 20X 1 from December 20X0 sales will be $1,050,000. The January 1, 20X1, cash balance was $70,000. The minimum acceptable cash balance at the end of each month is $60,000. Short-term borrowings (6-month term) are made in multiples of $10,000. Interest is charged at the rate of 1% per month on short-term borrowings. The first interest payment is made the month following the borrowing. Cash disbursements (excluding interest on short-term borrowings) are estimated as follows: January February March BE ? 40% in March. Of credit sales (December through March), 40% will be collected as cas ath of sale and 55% will be collected in the following month. The remainder will be uncoll -h collected in January 20X1 from December 20X0 sales will be $1,050,000. The January 1, 20X1, cash balance was $70,000. The minimum acceptable cash bal end of each month is $60,000. Short-term borrowings (6-month term) are made in mult 0,000. Interest is charged at the rate of 1% per month on short-term borrowings. The first i wment is made the month following the borrowing. Cash disbursements (excluding inte ort-term borrowings) are estimated as follows: March Manufacturing costs. Selling and administrative expenses Interest expense.. Income tax payment. January February $1,500,000 $1,300,000 390,000 410,000 90,000 90,000 0 0 $1,400,000 400,000 90,000 210,000 Capital expenditures. 124,000 110,000 50,000 Cash dividends. 300,000 0 0 Chip D G H Donovan Manufacturing, Inc. Manufacturing Overhead Budget For the Quarter Ended March 31, 20X1 Show support for calculated answers here Total direct labor hours Variable manufacturing overhead rate Variable manufacturing overhead cost Fixed manufacturing overhead cost Total manufacturing overhead cost Donovan Manufacturing, Inc. Selling and Administrative Budget For the Quarter Ended March 31, 20X1 Show support for calculated answers here Total sales revenue Variable selling and administrative rate Variable selling and administrative expenses Fixed selling and administrative expenses Total selling and administrative expenses cheet! to search (2 11:12 AM 9/26/2020 D G H Donovan Manufacturing, Inc. Schedule of Cash Collections For the Quarter Ended March 31, 201 Show support for any calculated answers here January February March Cash sales Credit sales: December January February March Total credit sales Total sales Donovan Manufacturint Inc. Cash Budget For the Quarter Ended March 31, 20X1 Show support for any calculated answers here EYK 9.1 Sheet Type here to search O (2 11:13 AM 9/26/2020 D G H Donovan Manufacturing, Inc. Cash Budget For the Quarter Ended March 31, 20X1 Show support for any calculated answers here January February March Beginning cash balance Cash receipts: Cash sales Collections from customers Short-term borrowing Cash available Cash disbursements: Manufacturing costs Selling and administrative expenses Interest expense Income tax payments Capital expenditures Cash dividends Total disbursements Ending cash balance EYK 9.1 Sheet Type here to search ORI 11:13 AM 9/26/202 112 WYSOK D86 F G H Donovan Manufacturing, Inc. Schedule of Cash Collections For the Quarter Ended March 31, 20X1 s January February March 79 80 81 82 83 84 85 86 Cash sales 87 Credit sales: 88 December January 90 February: 91 March: 92 Total credit sales 93 Total sales 89 94 95 96 97 98 Donovan Manufacturing, Inc. Cash Budget EYK 9.1 Sheet1 Ready Type here to search ORI UPDATES AVAILABLE Updates for Ulice are ready to be installed, but first we need to dose some apps Update now 086 G H D Donovan Manufacturing, Inc. Cash Budget For the Quarter Ended March 31, 20X1 Show support for an January February March 97 98 99 100 101 102 Beginning cash balance 103 Cash receipts: 104 Cash sales 105 Collections from customers 106 Short-term borrowing 107 Cash available 108 109 Cash disbursements: 110 Manufacturing costs 111 Selling and administrative expenses 112 Interest expense 113 Income tax payments 114 Capital expenditures 115 Cash dividends 116 Total disbursements EYK 9.1 Sheet1 Ready Type here to search ORI hp 086 H 104 Cash sales 105 Collections from customers 106 Short-term borrowing 107 Cash available 108 109 Cash disbursements: 110 Manufacturing costs 111 Selling and administrative expenses 112 Interest expense 113 Income tax payments 114 Capital expenditures 115 Cash dividends 116 Total disbursements 117 Ending cash balance 118 119 Remember the ending balance of one month becomes the beginning balance of the next month 120 121 122 123 EYK 9.1 Sheet1 Ready Type here to search OBI mp