$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{4\}\{|$c$|\}\{\backslash$begin$\{$tabular$\}\{$l$\}$

Land O'Lakes $\backslash \backslash$

Balance Sheet as of December $31,2024$

$\backslash$end$\{$tabular$\}\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Assets$\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Liabilities and Equities$\}\backslash \backslash$

$\backslash$hline Cash & $\backslash$$ $322,000,000$ & Accounts Payable & $\backslash$$ $24,000,000\backslash \backslash$

$\backslash$hline Accounts Receivable & $\backslash$$ $79,000,000$ & Notes Payable & $\backslash$$ $135,000,000\backslash \backslash$

$\backslash$hline Raw Materials Inventory & $\backslash$$ $6,514,760$ & Interest Payable & $\backslash$$ $6,075,000\backslash \backslash$

$\backslash$hline Finished Goods Inventory & $\backslash$$ $14,396,400$ & Common Stock & $\backslash$$ $800,000,000\backslash \backslash$

$\backslash$hline Property, Plant and Equipment, net & $\backslash$$ $1,300,000,000$ & Retained Earnings & $\backslash$$ $756,836,160\backslash \backslash$

$\backslash$hline Total Assets & $\backslash$$$1,721,911,160$ & Total Liabilities and Equities & $\backslash$$$1,721,911,160\backslash \backslash$

$\backslash$hline & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$c$|\}\{$INPUTS$\}\backslash \backslash$

$\backslash$hline & $\backslash$multicolumn$\{4\}\{|$c$|\}\{2025($Projected$)\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{2026($Projected$)\}\backslash \backslash$

$\backslash$hline & Quarter $1$ & Quarter $2$ & Quarter $3$ & Quarter $4$ & Quarter $1$ & Quarter $2\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Sales$\}\backslash \backslash$

$\backslash$hline Pounds of Butter & $62,000,000$ & $53,000,000|$ & $49,000,000|$ & $78,000,000$ & $61,000,000$ & $51,000,000\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{\backslash$multirow$[$t$]\{2\}\{*\}\{$Selling Pice per Pound $(4$ Sticks$)\}\}\backslash \backslash$

$\backslash$hline & & & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Collections$\}\backslash \backslash$

$\backslash$hline Quarter of Sale & $80\backslash \%$ & & & & & $\backslash \backslash$

$\backslash$hline Quarter after Sale & $20\backslash \%$ & & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Finished Goods Inventory$\}\backslash \backslash$

$\backslash$hline Ending FG Inventory Requirement & $6\backslash \%$ & of next quarte & r$\text{'}$s sales & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{\backslash$multirow$[$t$]\{2\}\{*\}\{$Ending F G Inventory Units $($December $31,2024)3,\}\}\backslash \backslash$

$\backslash$hline & & & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Raw Materials Inventory$\}\backslash \backslash$

$\backslash$hline Raw Materials $($cream$)$ Required per Pound of Butter & $1$ & quart & & & & $\backslash \backslash$

$\backslash$hline Raw Materials Cost per Quart & $\backslash$$ $2\mathrm{.}65$ & per quart & & & & $\backslash \backslash$

$\backslash$hline Ending RM Inventory Requirement & $4\backslash \%$ & of next quarter & ris production & needs & & $\backslash \backslash$

$\backslash$hline Ending RM Inventory Units $($December $31,2024)$ & $2,458,400$ & quarts & & & & $\backslash \backslash$

$\backslash$hline Paid in Quarter of Purchase & $90\backslash \%$ & & & & & $\backslash \backslash$

$\backslash$hline Paid in Following Quarter & $10\backslash \%$ & & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Direct Labor$\}\backslash \backslash$

$\backslash$hline Labor Required per Pound of Butter & $0\mathrm{.}05$ & hours & & & & $\backslash \backslash$

$\backslash$hline Labor Cost per Hour & $\backslash$$ $18\mathrm{.}00$ & per hour & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Manufacturing Overhead$\}\backslash \backslash$

$\backslash$hline Variable & $\backslash$$ $0\mathrm{.}32$ & per pound of & butter & & & $\backslash \backslash$

$\backslash$hline Fixed & $\backslash$$ $18,000,000$ & per quarter & & & & $\backslash \backslash$

$\backslash$hline Noncash Fixed $($included in above$)$ & $\backslash$$ $12,000,000$ & per quarter & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Selling $\backslash$& Administrative Expenses$\}\backslash \backslash$

$\backslash$hline Variable & $\backslash$$ $0\mathrm{.}21$ & per pound of & butter & & & $\backslash \backslash$

$\backslash$hline Fixed & $\backslash$$ $58,000,000$ & per quarter & & & & $\backslash \backslash$

$\backslash$hline Noncash Fixed $($included in above$)$ & $\backslash$$ $17,000,000$ & per quarter & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Cash$\}\backslash \backslash$

$\backslash$hline Minimum Cash Balance & $\backslash$$ $75,000,000$ & & & & & $\backslash \backslash$

$\backslash$hline Note Payable as of December $31,2024$ & $\backslash$$ $135,000,000$ & to be paid Ja & nuary $1,2025$ & & & $\backslash \backslash$

$\backslash$hline Interest Payable as of December $31,2024$ & $\backslash$$ $6,075,000$ & to be paid Ja & nuary $1,2025$ & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Other$\}\backslash \backslash$

$\backslash$hline Factory Equipment Purchase $($capitalized$)$ & $\backslash$$ $80,000,000$ & $1$st Quarter & & & & $\backslash \backslash$

$\backslash$hline Corporate Headquarters Renovation $($capitalized$)$ & $\backslash$$ $210,000,000$ & $4$th Quarter & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$ ii need to fill in the raw materials budget I've done it several times but I keep getting the wrong awsner

Land O'Lakes Balance Sheet as of December $31,2024$

Assets Liabilities and Equities Cash $ $322,000,000$ Accounts Payable $ $24,000,000$ Accounts Receivable $ $79,000,000$ Notes Payable $ $135,000,000$ Raw Materials Inventory $ $6,514,760$ Interest Payable $ $6,075,000$ Finished Goods Inventory $ $14,396,400$ Common Stock $ $800,000,000$ Property, Plant and Equipment, net $ $1,300,000,000$ Retained Earnings $ $756,836,160$ Total Assets $$1,721,911,160$ Total Liabilities and Equities $$1,721,911,160$ ii need to fill in the raw materials budget I've done it several times but I keep getting the wrong answer