INPUTS $2025($Projected$)2026($Projected$)$ Quarter $1$ Quarter $2$ Quarter $3$ Quarter $4$ Quarter $1$ Quarter $2$ Sales Pounds of Butter $62,000,00053,000,000|49,000,000|78,000,00061,000,00051,000,000$ Selling Pice per Pound $(4$ Sticks$)$ Collections Quarter of Sale $80\%$ Quarter after Sale $20\%$ Finished Goods Inventory Ending FG Inventory Requirement $6\%$ of next quarte r$\text{'}$s sales Ending F G Inventory Units $($December $31,2024)3,$ Raw Materials Inventory Raw Material

INPUTS $2025($Projected$)2026($Projected$)$ Quarter $1$ Quarter $2$ Quarter $3$ Quarter $4$ Quarter $1$ Quarter $2$ Sales Pounds of Butter $62,000,00053,000,000|49,000,000|78,000,00061,000,00051,000,000$ Selling Pice per Pound $(4$ Sticks$)$ Collections Quarter of Sale $80\%$ Quarter after Sale $20\%$ Finished Goods Inventory Ending FG Inventory Requirement $6\%$ of next quarte r$\text{'}$s sales Ending F G Inventory Units $($December $31,2024)3,$ Raw Materials Inventory Raw Materials $($cream$)$ Required per Pound of Butter $1$ quart Raw Materials Cost per Quart $ $2\mathrm{.}65$ per quart Ending RM Inventory Requirement $4\%$ of next quarter ris production needs Ending RM Inventory Units $($December $31,2024)2,458,400$ quarts Paid in Quarter of Purchase $90\%$ Paid in Following Quarter $10\%$ Direct Labor Labor Required per Pound of Butter $0\mathrm{.}05$ hours Labor Cost per Hour $ $18\mathrm{.}00$ per hour Manufacturing Overhead Variable $ $0\mathrm{.}32$ per pound of butter Fixed $ $18,000,000$ per quarter Noncash Fixed $($included in above$)$ $ $12,000,000$ per quarter Selling & Administrative Expenses Variable $ $0\mathrm{.}21$ per pound of butter Fixed $ $58,000,000$ per quarter Noncash Fixed $($included in above$)$ $ $17,000,000$ per quarter Cash Minimum Cash Balance $ $75,000,000$ Note Payable as of December $31,2024$ $ $135,000,000$ to be paid Ja nuary $1,2025$ Interest Payable as of December $31,2024$ $ $6,075,000$ to be paid Ja nuary $1,2025$ Other Factory Equipment Purchase $($capitalized$)$ $ $80,000,0001$st Quarter Corporate Headquarters Renovation $($capitalized$)$ $ $210,000,0004$th Quarter

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$ I need help filling this out if you could add formulas do that would be amazing

INPUTS $2025($Projected$)2026($Projected$)$ Quarter $1$ Quarter $2$ Quarter $3$ Quarter $4$ Quarter $1$ Quarter $2$ Sales Pounds of Butter $62,000,00053,000,000|49,000,000|78,000,00061,000,00051,000,000$ Selling Pice per Pound $(4$ Sticks$)$ Collections Quarter of Sale $80\%$ Quarter after Sale $20\%$ Finished Goods Inventory Ending FG Inventory Requirement $6\%$ of next quarte r$\text{'}$s sales Ending F G Inventory Units $($December $31,2024)3,$ Raw Materials Inventory Raw Materials $($cream$)$ Required per Pound of Butter $1$ quart Raw Materials Cost per Quart $ $2\mathrm{.}65$ per quart Ending RM Inventory Requirement $4\%$ of next quarter ris production needs Ending RM Inventory Units $($December $31,2024)2,458,400$ quarts Paid in Quarter of Purchase $90\%$ Paid in Following Quarter $10\%$ Direct Labor Labor Required per Pound of Butter $0\mathrm{.}05$ hours Labor Cost per Hour $ $18\mathrm{.}00$ per hour Manufacturing Overhead Variable $ $0\mathrm{.}32$ per pound of butter Fixed $ $18,000,000$ per quarter Noncash Fixed $($included in above$)$ $ $12,000,000$ per quarter Selling & Administrative Expenses Variable $ $0\mathrm{.}21$ per pound of butter Fixed $ $58,000,000$ per quarter Noncash Fixed $($included in above$)$ $ $17,000,000$ per quarter Cash Minimum Cash Balance $ $75,000,000$ Note Payable as of December $31,2024$ $ $135,000,000$ to be paid Ja nuary $1,2025$ Interest Payable as of December $31,2024$ $ $6,075,000$ to be paid Ja nuary $1,2025$ Other Factory Equipment Purchase $($capitalized$)$ $ $80,000,0001$st Quarter Corporate Headquarters Renovation $($capitalized$)$ $ $210,000,0004$th Quarter

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$ I need help filling this out if you could add formulas do that would be amazing