can you answer with the formula please it makes it easier for me to understand

OPERATING EXPENSES Wages and Salaries Payaient Payment Policy 2 times monthly on the 15 th and 30 th Fully paid each month Variable Selling \& Administrative Exp. 2.50 s of selling price Fixed Seltine \& Naministrative Exp Depreciation \$ $5,000 perquarter Other Selling \& Administrative Exp \$ 180,000 per quarter CAPTAL EXPENDITURES \begin{tabular}{|r|r|r|r|} \hline 1st Quarter & 2nd Quarter & 3rd Quarter & 4th Quarter \\ \hline 2024 & 2024 & 2024 & 2024 \\ \hline$1,00000 & $1,50000 & $2,00000 & $2,50000 \\ \hline \end{tabular} Equipment Purchases TREASURY ACTIVIIIES \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & 1st Quarte & r & 2ndQuarter & Brd Cuarter & 4th Quarter & & & \\ \hline & & 2024 & 2024 & 2024 & 2024 & & & \\ \hline Dividends to be Declared. & - & $50000 & $1,00000 & $1.500.00 & $2,00000 & 3= & & \\ \hline & & x & - & & & & & a. \\ \hline Minimum Cash Ealance. & s & 250,000 & Aequired ot end of & feverv quarter & & & r2 & \\ \hline & & & 8 & 28 & & 2 & & \\ \hline Interest Rate for iovesting (short-term) & & 4.255 & Annually & & & & & \\ \hline Interest Policy & AII & & of the ending cash & balanice for the a & auarter earns int & erest for the entif & equarter & \\ \hline & AII & & of the ending cash & h balance for the a & quarter remains & in Cash at the bes & inning of th & enest quart \\ \hline \end{tabular} FLBCIELE BUDGEI Actual Units Produced USE VALUE FROM PRODUCTION BUDGET Flexible Budget - Analyze at Additional Production Levels \begin{tabular}{|c|c|} \hline Production level 1 & 500 units \\ \hline Production level 2 & 750 unit \\ \hline \end{tabular} PHOR YEAR RESULTS Wheels \& Widgets inc. \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & Fixed Manufacturing Overhead Rate & & & & & & HINTS \\ \hline & & & & & 4 & & +4 \\ \hline & Total Finished Goods Units Produced & . & & & 1 & & \\ \hline & Total Fixed Overhead & & & & 8 & & \\ \hline & Fixed Manufacturine Overhead prate & & & & & & \\ \hline & & & 1 & & & & \\ \hline & CHECK YOUA FIXED MUNUEACTUAING OVEALEAD & DRIE & & & & & \\ \hline & Have you found the Total fixed Overhead and u & used the correct fo & formula? & MORE WORK TO DO & & & \\ \hline 9 & & & & & & & \\ \hline 10 & & & & & & 11 & \\ \hline 11 & & & & & & & \\ \hline 12 & Endine Finished Coods inventorr Absorption & & & & & & \\ \hline 13 & & Uve Per Unit Costs & & & & & \\ \hline 14 & 4 Direct Material & 25500 & & & & & Aemember to multiply direct material units times cost per unit \\ \hline 15 & 5 Direct labor & 7200 & & & & & Remember to multiply rate per hour times number of hours \\ \hline 16 & 6 Variable Overhead & 5175 & & & & 3 & Remember to multiply rate per hour times number of hours \\ \hline 17 & 7 Fixed Overhead & 26.51 & & & & & \\ \hline 18 & 8 Total product cost per unit manufactured & 405.26 & & & & & \\ \hline 19 & & & & & & & \\ \hline 20 & 0 Units in Ending Finished Goods inventory & 16,000 & & & & & \\ \hline 21 & 1 Finished Goods Ending inventory Value & 5.484,123 & & & & & \\ \hline \end{tabular} Cost of Goods Mamulactured - Aborption For Year frided 12/31/2024 \begin{tabular}{|c|c|} \hline \multicolumn{2}{|r|}{ Direct Materials: } \\ \hline \multicolumn{2}{|r|}{ Eecinnine irventary of raw materials } \\ \hline \multicolumn{2}{|r|}{ Raw Material Purchases: } \\ \hline \multicolumn{2}{|r|}{ Raw Materials Avaitable } \\ \hline \multicolumn{2}{|r|}{ Endine imentory of Raw Materials } \\ \hline \multicolumn{2}{|r|}{ Direct Materials Used } \\ \hline \multicolumn{2}{|r|}{ Direct Labor: } \\ \hline \multicolumn{2}{|r|}{ Oveiheod. } \\ \hline \multicolumn{2}{|r|}{ Total Manufacturing Costs Added } \\ \hline \multicolumn{2}{|r|}{ Plus' Beginning Work in Process imventory } \\ \hline & Total Manulacturinz Costs \\ \hline & 5. Less Ending Work in Procese inventory \\ \hline 6 & Cost of Coods Manufactured \\ \hline \end{tabular} Beginnting inventory of raw materials is associated with Ending inventory of the prev Haw material purchases are on the Direct Material Budget Endiag inventory of Raw Materials is on the Cirect Matenal eudget. Direct tabor is on the Oirect Labor Budget: Overhead is on the Overhead budget Beginning WIP is on the Project information worksheet Ending wP is on the Project information workheet. Cost of Goods Manulactured - Variable for Year Lnded 12/31/2024 \begin{tabular}{|c|c|c|} \hline Darect Materials Used & & \\ \hline Direct Labor & & \\ \hline Varisble Overthead & & \\ \hline Totol Variehle Man & & AIIIIII \\ \hline \end{tabular} Graned cells not used Production Budget Projected for Year Ending 12/31/2024 \begin{tabular}{|l|r|r|r|r|r|} \hline & \multicolumn{1}{|c|}{\begin{tabular}{c} First \\ Quarter \end{tabular}} & \multicolumn{1}{|c|}{\begin{tabular}{c} Second \\ Quarter \end{tabular}} & \multicolumn{1}{c|}{\begin{tabular}{c} Third \\ Quarter \end{tabular}} & Quarth \\ \hline Budgeted Sales in units & 48,600 & 34,500 & 31,000 & 43,000 \\ \hline Ending Inventory of Finished Goods & 15,000 & 19,000 & 20,000 & 16,000 & 157,100 \\ \hline Total Need for Finished Goods & 63,600 & 53,500 & 51,000 & 59,000 & 173,100 \\ \hline Beginning Inventory of Finished Goods & & 15,000 & 19,000 & 20,000 \\ \hline Budgeted Finished Goods Produced in units & 63,600 & 38,500 & 32,000 & 39,000 & 173,100 \\ \hline \end{tabular} 173,100 CHECK YOUR PRODUCTION BUDGET Does the sum of the four quarters of units produced equal the total calculated from the Annual Total column (F)? YES \begin{tabular}{|c|c|c|c|c|c|c|} \hline & & & & & & G \\ \hline Direct Materials Purchases Budget & & & & & & \\ \hline & & & & & & \\ \hline & First & Second & Third & Fourth & Annual & +1 \\ \hline & Quarter & Quarter & Quarter & Quarter & Total & E \\ \hline Budgeted Finished Goods Produced (units) & 63,600 & 38,500 & 32,000 & 39,000 & 173,100 & \\ \hline Raw Materials needed per unit & 3 & 3 & 3 & & 3 & \\ \hline Raw Moterials needed for production & 190,800 & 115,500 & 96,000 & 117,000 & 519,300 & \\ \hline Raw Material Ending Inventory (units) & 28,875 & 24,000 & 29,250 & 26,000 & 26,000 & \\ \hline Total Raw Materials needed & 219,675 & 139,500 & 125,250 & 143,000 & 545,300 & \\ \hline Raw Materials Beginning Inventory (units) & 41,368 & 28,875 & 24,000 & 29,250 & 41,368 & \\ \hline Raw Materials Purchases (units) & 178,307 & 110,625 & 101,250 & 113,750 & 503,932 & \\ \hline Cost per Unit & 85.00 & $85.00 & $85.00 & 85.00 & 85.00 & \\ \hline Raw Material Purchases Cost (dollars) & $15,156,095 & \$ 9,403,125 & $8,606,250 & s 9,668,750 & $42,834,220 & . \\ \hline & +2 & & +2 & & & $42,834,220 \\ \hline & & & & k. & & \\ \hline CHECK YOUA DIRECT MATEAIALS PURCHASES & BUDGET & - & & + & & \\ \hline \begin{tabular}{l} oes the sum of the Direct Material Purcha \\ e Annual Total column (F)? \end{tabular} & ach guarte & ual the tota & & YES & & \\ \hline \end{tabular} Overhead Budget Total Direct Labor Hours Budgeted Variable Overhead Rate per hour Variable Overhead Cost Fixed Overhead cost without Depreciation Depreciation Cost Total Overhead Cost \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & First & & Second & & Third & & Fourth & Annual \\ \hline & Quarter & & Quarter & & Quarter & & Quarter & Total \\ \hline & 286,200 & & 173,250 & & 144,000 & & 175,500 & 778,950 \\ \hline & 11.50 & $ & 11.50 & $ & 1150 & $ & 11.50 & 11.50 \\ \hline$ & 3,291,300 & s & 1,992,375 & s & 1,656,000 & s & 2,018,250 & 8,957,925 \\ \hline & 950,000 & $ & 950,000 & $ & 950,000 & s & 950,000 & 3,800,000 \\ \hline s & 197,120 & s & 197,120 & s & 197,120 & $ & 197,120 & 788,480 \\ \hline$ & 4,438,420 & $ & 3,139,495 & $ & 2,803,120 & s & 3,160 & \$ 13,546,405 \\ \hline \end{tabular} $13,546,405 CHECK YOUR OVERHEAD BUDGET Does the sum of the overhead costs each quarter equal the fotal calculated from the Annual Total column (F)? YES Selling \& Administrative Expense Budget \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline 38 & & First & & Second & & Third & & Fourth & Annual \\ \hline & & Quarter & & Quarter & & Quarter & & Quarter & Total \\ \hline Budgeted Sales in Dollars & $ & 25,758,000 & $ & 18,285,000 & $ & 16,430,000 & & 22,790,000 & $83,263,000 \\ \hline Variable S\&A rate & & 2.50% & & 2.50% & & 2.50% & & 2.50% & 2.50% \\ \hline Variable S\&A Cost & $ & 643,950 & $ & 457,125 & s & 410,750 & 73 & 569,750 & $2,081,575 \\ \hline Fixed S\&A Cost without Depreciation & $ & 180,000 & $ & 180,000 & $ & 180,000 & 3 & 180,000 & 720,000 \\ \hline Depreciation Cost & $ & 55,000 & $ & 55,000 & $ & 55,000 & $ & 55,000 & 220,000 \\ \hline Total S\&A Cost & $ & 878,950 & $ & 692,125 & $ & 645,750 & ? & 804,750 & $3,021,575 \\ \hline \end{tabular} $3,021,57 CHECK YOUR SEUUNG \& ADMINISTRATIVE EXPENSE BUDGET Does the sum of the selling \& administrative costs each quarter equal the total calculated from the Annual Total column (F) information? YES \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline SCHEDULE OF CASHCOLLCCTIONS & & & & & & & & Hins \\ \hline & + & + & & & & & & \\ \hline & Fast & & Second & Thind & Fourth & Annus & & \\ \hline & Quaster & & Ouster & Quation & Quver & & & \\ \hline Budgeted Soles indolary & 25,758,000 & s & 18,285,000 & 16,430,000 & 22,790,000 & 83.283,000 & & \\ \hline & & & & & & & & \\ \hline Collections in quinter d rale & 20.735 .790 & 3 & 14.719 .425 & 13.225 .150 & $8,345950 & 67,026,715 & & \\ \hline Colectonthquivietiolowingste & 5,050,000 & s & 4,378,160 & 3,100,450 & 2,793,100 & 15.330 .410 & 7 & O1 Collections in quarter foll \\ \hline ToulColections: & 525,785,190 & s & 19,098,285 & 16,334,600 & 21,139,050 & 82,357,125 & & \\ \hline & -2 & & & & & & 182357.125 & \\ \hline Nect Accounts Peceivable Balance & S 4,378,860 & 5 & 3,108,450 & 2,793,100 & 3,374,300 & 3,874,300 & & \\ \hline & & & & & & & 13874300 & \\ \hline CHEOKYOUASOHEDUEC CF CASHCCLLEL & & & & & & & & \\ \hline & colestedinhelart & & ionstesina & & res & & & \\ \hline & & & & e2 & & & & \\ \hline & & & & & E. & & & \\ \hline & & = & Tr & & & 2 & & \\ \hline SCHEDULE OF CASH PAYMENTS & & 7 & & t & & & & \\ \hline & & & & & & & & \\ \hline & Finst & & Second & Thind & Fourth & Annual & & \\ \hline & Quarter: & & Quarter & Quarter & Ouarter & & & \\ \hline & & & & & & & & \\ \hline Five Macerial Puchases & 15,155,095 & 5 & 2,403,125 & 8,606,250 & 9,665,750 & 42,834,220 & & \\ \hline & & & & & & & & \\ \hline Pamendin quatter cl puchase & 512,862,600.75 & 4 & 799265.625 & 5731,531,250.00 & $321,843,750.00 & 53,640,908,700 & & Q1 Paymenta in quarter fol: \\ \hline Paymentin quarter folloving pirchase & 8,00000 & 5 & 2,273,41425 & \begin{tabular}{|cc|} 3 & 1,410,463.75 \\ \end{tabular} & 51,290,937.50 & 13,074,321 & & \\ \hline Totalpormenes & 20,982,6911 & 1 & 10.265,071 & 0,225,201 & 9509.375 & 49,483,900 & & \\ \hline & & & & & & & 1494030 & \\ \hline & 32273.41425 & s. & 1,410,468.75 & 51,290,92750 & is 1,450,31250 & 1,450,711 & & \\ \hline & & & & & & & t4503J & \\ \hline \end{tabular} CASHBUDGET Net Operating CashFlow: Beginning Cash NetCah Avaluble Mnimum carhbalance Cash Avalable for Discretionary Uses \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|l|}{ Ditchetionacy Urez ot Cash. } \\ \hline Equipment Puechates & \begin{tabular}{ll} 5 & 1,000 \\ \end{tabular} & 5 & 1,500 & 5 & 2,000 & 2,500 & 7,000 \\ \hline Dividends & \begin{tabular}{ll} 5 & 500 \\ \end{tabular} & s. & 1,000 & 5 & 1,500 & 2,000 & 5,000 \\ \hline & & & & & & & \\ \hline Leave Finanoing seotion empty: & & & & 1 & & & \\ \hline Financing (thould not be tequired) & & & & & & & \\ \hline Borrowing & & & 8= & & - & & \\ \hline Reparment & & ar & & & 40 & & \\ \hline Interert & +2 & & & & & 2= & \\ \hline Total Finarioing Cashlonciease (Deciease) & +2 & & & & & & \\ \hline & +2 & +8 & E & & & & \\ \hline Net Cath Awalsble Alter Dioretionary Cash Use & \begin{tabular}{ll} & 1,306,559 \\ \end{tabular} & 5 & 3,798,656 & 5 & 5,943,505 & 11,105,911 & 10,983,518 \\ \hline Interesteaned on Cath & 513,382 & si & 40,761 & 5 & 6,151 & 118,000 & 235,394 \\ \hline Ending Carh Balance & 51,320,441 & s & 3.839 .017 & 5 & 6,006,736 & 11,223,911 & 11,223,912 \\ \hline \end{tabular} Ending CarhBalanse \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline(4,841,941) & s & 2,480,715 & s & 2,1 & 5 & 5,103,675 & 5 & 4,850,518 \\ \hline 6,150,000 & 5 & 1 & 2 & & 20 & 6,006,736 & 5 & 6,150,000 \\ \hline 1,308,059 & 5 & 3,80 & 8 & & 3 & 11,110 & 3 & 513 \\ \hline 5250,000 & 5 & 250,000 & 5 & 00 & s & 250,000 & 3 & 5 \\ \hline & & & E & - & & & & \\ \hline- & & & & & & & & \\ \hline & & & & & & & & \\ \hline 51,000 & 5 & 1,500 & 5 & & 5 & 2,500 & s & 7,000 \\ \hline \begin{tabular}{ll} 5 & 500 \\ \end{tabular} & 5 & 1,000 & & 1,500 & 5 & 2,000 & 5 & 5,0 \\ \hline & & & & & & & & \\ \hline & & & 1 & & & & & \\ \hline & & +8 & & & & & & \\ \hline & & & & & & & & \\ \hline & a & & & & Z & & & \\ \hline & ar & & H & & & - & & \\ \hline & a & & & & & & & \\ \hline & & & = & & & & & \\ \hline \begin{tabular}{|ll|} 5 & 1,306,559 \\ \end{tabular} & 5 & 3,798,656 & s & 5,943,505 & s & 11,105,911 & 3 & 10,938,518 \\ \hline \begin{tabular}{ll} & 13,302 \\ \end{tabular} & 5 & 40,361 & 5 & 63,151 & 5 & 118,000 & 5 & 235,394 \\ \hline 1,320,441 & 3 & 3,839,017 & 3 & 6,006,736 & 5 & 11,223,911 & 3 & 11,223,912 \\ \hline \end{tabular} (1) 11223912 Graped celli are not used Ligh yellow cels are your eash outlow chicices fiom the INPUT wolkheet CHEOKREUACASHEUDGET Does the ending balance of cash derived trom your Rou 73 information march the ending walue cl oash from the Annual Tocalochumn (Fi)