fill in whats missing (manufacturing overhead expense 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 that coming year. The company has gathered information from its managers in preparation of the budgeting process. Thermium likes to keep 10% of the next month's unit sales in ending inventory. All sales are on account. 80% of the Accounts Receivable are collected in the month of sale, and 20% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31,2022 , totaled $180,000 Direct materials per unit produced Direct material - cost per pound pounds Direct Labor Rate 3$0.50$7.00 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 $25,000. Raw Materials - December 31, 2022 % of next months material on hand at end of month 34,050 lbs. Direct Labor 8% Labor requires 15 minutes per unit for completion and is paid at a rate of $7 per hour. a9f494815859abd6618e09e78600581 Instructions - Data The Cash balance on December 31, 2022, totaled $100,000, but the Bank requires Thermium to maintain an end of month cash balance of at least $700,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 Cash balance on December 31,2022 , totaled $100,000, but the Bank requires Thermium to maintain an end of month cash balance of at least $700,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 day of the repayment month. Thermium, Inc. Thermium, Inc. \begin{tabular}{|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{l} \\ Units to be \\ Produced \end{tabular}} & \multirow[b]{2}{*}{ January } & \multirow[b]{2}{*}{ Febuary } & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{l} Direct Materials Budget \\ March Fi Quariqurter \end{tabular}}} \\ \hline & & & & \\ \hline & 135000 & 102000 & 121000 & 336500 \\ \hline \begin{tabular}{l} Direct \\ Materials \\ (bs) per Unit \end{tabular} & 3 & 3 & 3 & 3 \\ \hline \begin{tabular}{l} Total \\ Pounds \\ Needed for \\ Prduction \\ (lbs) \end{tabular} & 405000 & 306000 & 363000 & 1074000 \\ \hline \begin{tabular}{l} Add: \\ Desired \\ Ending \\ Direct \\ Materials \\ (lbs) \end{tabular} & 61200 & 72600 & 86400 & 220200 \\ \hline \begin{tabular}{l} Total \\ Material \\ Required \\ (lbs) \end{tabular} & 466200 & 378600 & 449400 & 1294200 \\ \hline \begin{tabular}{l} Less: \\ Beginning \\ Direct \\ Material (bs) \end{tabular} & 34050 & 61200 & 72600 & 34050 \\ \hline \begin{tabular}{l} Dirrect \\ Material \\ Purchases \\ (lbs) \end{tabular} & 432150 & 317400 & 376800 & 1260150 \\ \hline \begin{tabular}{l} Cost Per \\ Pound (lbs) \end{tabular} & $0.50 & $0.50 & $0.50 & $0.50 \\ \hline \begin{tabular}{l} Total Cost \\ of Direct \\ Material \\ Purchases \end{tabular} & 216075 & 158700 & 128670 & 503445 \\ \hline \end{tabular} Thermium, Inc. Thermium, Inc. Manufacturing Overhead Expense Budget Thermium, Inc. Selling anf Administrative Expenese Budget Thermium, Inc. Cash Collection Budget \begin{tabular}{|c|c|c|c|c|} \hline & January & Febuary & Marchsi Qua & \\ \hline \begin{tabular}{l} Accounts \\ Receivable, \\ 12/31/23 \end{tabular} & $180,000 & & & $180,000 \\ \hline \begin{tabular}{l} January \\ Sales \end{tabular} & $1,196,000 & $299,000 & & $1,495,000 \\ \hline Febuary Sale & & $1,040,000 & $260,000 & $1,300,000 \\ \hline March Sales & & & $1,248,000 & $1,248,000 \\ \hline \begin{tabular}{l} Total Cash \\ Collections \end{tabular} & $1,376,000 & $1,339,000 & $1,508,000 & $422,300 \\ \hline \end{tabular} Thermium, Inc. Schedule of Expected Cash Payments for Purchases Thermium, Inc. Cash Budget Add footer