please can you give me the Direct Materials Budget, cash collection budget, schedule of expected cash payments for purchases, cash budget?

Thermium, Inc. is preparing its budget for the coming year, 2023. The first step is to plan for the first quarter of the month after sale. Accounts receivable on December 31, 2022, totaled $200,000 Thermium likes to keep 8% of the materials needed for the next month in its ending inventory. Raw Materials on December 31,2022 , totaled 34,050 pounds. Payment for materials is paid 75% in the month of purchase, and 25% is paid in the month after purchase. Accounts Payable on December 31,2022 , totaled $150,000. 37% of next months material on hand at end of month 8% 38 Direct Labor 39 Labor requires 15 minutes per unit for completion and is paid at a rate of $7 per hour. 40 Labor Hours per unit =15/60= 0.25 hours per unit 42 Manufacturing Overhead 43 Indirect materials 545556575859Variablesellingandadministrativecostperunitis:AdvertisingInsuranceSalariesDepreciationOtherfixedcosts$1.80perunit$15,000amonth$1,300amonth$75,000amonth$3,000amonth$4,000amonth 60 Other Information 6) Other Information Instructions - Data The Cash balance on December 31,2022 , totaled $200,000, but management has decided it would like to maintain and end of month cash balance of at least $500,000 beginning on January 31,2023. Dividends are paid each month at the rate of $3.00 per share for 5,000 shares outstanding. The company has an open line of credit with Calypso Bank. The terms of the agreement requires borrowing to be in $1,000 increments at 12% interest. Thermium borrows on the first day of the borrowing month and repays on the last dav of the redavment month. Thermium, Inc. Direct labor budget First Quarter 2023 \begin{tabular}{lrrrrr} & \multicolumn{2}{c}{ January } & February & March & \multicolumn{2}{c}{ Quarter } \\ \cline { 2 - 6 } Units to be produced & 113,500 & 102,000 & 121,000 & 336,500 \\ Direct Labor time per unit & 0.25 & 0.25 & 0.25 & 0.25 \\ \cline { 2 - 6 } Total Required dirct labor hours & 28375 & 25500 & 30250 & 84125 \\ Direct Labor cost per hour & $7.00 & $7.00 & $7.00 & $7.00 \\ \hline Totel direct labor cost & $198,625 & $178,500 & $211,750 & $588,875 \\ \hline & & & & \\ \hline \end{tabular} Thermium, Inc. Manufacturing ovrhead expense Budget First Quarter 2020 Fixed cost Salaries Depreciation Property taxes Insurance Maintenance Total fixed costs Total Manufacturing overhed \begin{tabular}{rrrr} $45,000 & $45,000 & $45,000 & $135,000 \\ \hline 18,000 & $18,000 & $18,000 & $54,000 \\ $3,000 & $3,000 & $3,000 & $9,000 \\ $1,500 & $1,500 & $1,500 & $4,500 \\ $1,400 & $1,400 & $1,400 & $4,200 \\ \hline$68,900 & $68,900 & $68,900 & $206,700 \\ \hline \end{tabular} Direct labor hours $119,976$114,800$123,350$358,126 Predetermined overhead rate for quarter Thermium, Inc. Selling and administrative expense budget First Quarter 2023 Fixed expenses Advertising Insurance Salaries Deprciation Other Total Fixed expenses \begin{tabular}{rrrr} 15,000 & 15,000 & 15,000 & 45,000 \\ 1,300 & 1,300 & 1,300 & 3,900 \\ 75,000 & 75,000 & 75,000 & 225,000 \\ 3,000 & 3,000 & 3,000 & 9,000 \\ 4,000 & 4,000 & 4,000 & 12,000 \\ \hline 98,300 & 98,300 & 98,300 & 294,900 \\ \hline \end{tabular} Total selling and administrative expenses \begin{tabular}{llll} $305,300 & $278,300$314,300$897,900 \\ \hline \end{tabular}