Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please fill in all blue boxes with correct answers begin{tabular}{|c|c|c|c|} hline multicolumn{4}{|c|}{begin{tabular}{l} Land O'Lakes Balance Sheet as of December 31,2023 end{tabular}} hline

please fill in all blue boxes with correct answers image text in transcribed
image text in transcribed
image text in transcribed
\begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{\begin{tabular}{l} Land O'Lakes \\ Balance Sheet as of December 31,2023 \\ \end{tabular}} \\ \hline \multicolumn{2}{|l|}{ Assets } & \multicolumn{2}{|c|}{ Liabilities and Equities } \\ \hline Cash & $318,000,000 & Accounts Payable & $31,000,000 \\ \hline Accounts Receivable & $79,000,000 & Notes Payable & $120,000,000 \\ \hline Raw Materials Inventory & 6,144,600 & Interest Payable & $4,800,000 \\ \hline Finished Goods Inventory & $12,000,000 & Common Stock & $800,000,000 \\ \hline Property, Plant and Equipment, net & \#\#\#\#\#\#\#\#\#\# & Retained Earnings & $759,344,600 \\ \hline Total Assets & & Total Liabilities and Equities & \#\#\#\#\#\#\#\#\#\#\#\# \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|c|}{2024ProductionBudget} \\ \hline & \multicolumn{5}{|c|}{2024} & \multicolumn{2}{|c|}{2025} \\ \hline & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 & Total & Quarter 1 & Ouarter 2 \\ \hline \multicolumn{8}{|l|}{\begin{tabular}{l} Unit Sales \\ Plus: Desired FG Ending Inventory \end{tabular}} \\ \hline \multicolumn{8}{|l|}{\begin{tabular}{l} Plus: Desired FG Ending Inventory \\ Total Units Required \end{tabular}} \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{\begin{tabular}{l} Total Units Required \\ Less: FG Beginning Inventory \end{tabular}}} \\ \hline & & & & & & & \\ \hline \multicolumn{8}{|l|}{\begin{tabular}{l} Less: FG Beginning Inventory \\ Units Produced \end{tabular}} \\ \hline & & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{ Variable Product Cost per Unit }} \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{\begin{tabular}{l} Direct Materials Cost per Unit \\ Direct Labor Cost per Unit \end{tabular}}} & \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{ Variable Overhead Cost per Unit }} \\ \hline & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ INPUTS } \\ \hline & \multicolumn{2}{|c|}{2024(Projected)1NT010} & 2025 (Projected) \\ \hline Sales & Quarter 1 & \begin{tabular}{l} 2024 (Projected) \\ Quarter 2 Quarter 3 \end{tabular} & \begin{tabular}{|l|l|} \multicolumn{2}{|c|}{2025 (Projecteu) } \\ Quarter 1 & Quarter 2 \\ \end{tabular} \\ \hline \begin{tabular}{l} Sales \\ Pounds of Butter \end{tabular} & & \begin{tabular}{|l|l|l|} 50,0000000 & 50,000,000 & 106,000,000 \\ \end{tabular} & \begin{tabular}{|l|l|} 72,000,000 & 60,000,000 \end{tabular} \\ \hline \begin{tabular}{l} Pounds of Butter \\ Selling Price per Pound ( 4 sticks) \end{tabular} & \begin{tabular}{rr|} & 75,000,000 \\ $ & 6.10 \end{tabular} & \begin{tabular}{|c|c|c|} 62,000,000 & 50,000,000 & 106,000,000 \\ \end{tabular} & \\ \hline & & & \\ \hline \begin{tabular}{|l|} Collections \\ Quarter of Sale \\ \end{tabular} & \multicolumn{3}{|c|}{\begin{tabular}{l} Selling Price per Pound ( 4 sticks) \\ Collections \end{tabular}} \\ \hline \begin{tabular}{|l|} Quarter of Sale \\ Quarter after Sale \\ \end{tabular} & 85% & & \\ \hline \multirow{2}{*}{\multicolumn{4}{|c|}{\begin{tabular}{l} Quarter of Sale \\ Quarter after Sale \\ Fined Goods Inventory \end{tabular}}} \\ \hline \begin{tabular}{l} Finished Goods Inventory \\ Ending FG Inventory Requirement \\ \end{tabular} & & & \\ \hline \begin{tabular}{l} Ending FG Inventory Requirement \\ Ending FG Inventory Units (December 31, 2023) \end{tabular} & \begin{tabular}{r} 4% \\ 3,000,000 \end{tabular} & \begin{tabular}{l} of next quarter's sales \\ units (1 pound - pkg w/ 4 sticks) \end{tabular} & \\ \hline \multirow{2}{*}{\multicolumn{4}{|c|}{\begin{tabular}{l} Ending FG Inventory Units (December 31, 2023) \\ Raw Materials Inventory \end{tabular}}} \\ \hline Raw Materials Inventory & 1 & guart & \\ \hline \begin{tabular}{l} Raw Materials (cream) Requared pe \\ Raw Materials Cost per Quart \\ Ending RM Inventory Requirement \end{tabular} & 2.75 & \begin{tabular}{l} quart \\ per quart \end{tabular} & \\ \hline Ending RM Inventory Requirement & 3% & \begin{tabular}{l} per quart \\ of next quarter's production needs \end{tabular} & \\ \hline Ending RM Inventory Units (December 31,2023 ) & 2.234,400 & \begin{tabular}{l} of next quarter's production needs \\ quarts \end{tabular} & \\ \hline \begin{tabular}{l} Paid in Quarter of Purchase \\ Paid in Following Quarter \end{tabular} & 90%2,234,400 & & \\ \hline Paid in Following Quarter & 10% & & \\ \hline \multicolumn{4}{|l|}{ Direct Labor } \\ \hline Labor Required per Pound of Butter & 0.05 & Thours & \\ \hline \begin{tabular}{l} Labor Required per Pound of Butter \\ Labor Cost per Hour \end{tabular} & 18.000.05 & per hour & \\ \hline \multicolumn{4}{|l|}{ Manufacturing Overhead } \\ \hline \begin{tabular}{l} Manutacturing Uverneada \\ Variable \end{tabular} & 0.35 & per pound cibutter & \\ \hline \begin{tabular}{|l|l|l|} Variable \\ Fixed \end{tabular} & \begin{tabular}{|r|} \\ $20.000,000 \end{tabular} & & \\ \hline Fixed & \begin{tabular}{|l|l|} $ & 20,000,000 \\ $ & 14,000,000 \\ \end{tabular} & per quarter & \\ \hline \multicolumn{4}{|l|}{ Selling \& Administrative Expenses } \\ \hline & 0.25 & per pound of butter & \\ \hline \begin{tabular}{|l|l|l} Vaxinad \\ Fixed \\ \end{tabular} & \begin{tabular}{|l|} $68,000,000 \\ \end{tabular} & per quarter & \\ \hline \begin{tabular}{l} Fixed \\ Noncash Fixed (included in above) \end{tabular} & \begin{tabular}{l} $68,000,000 \\ $19,000,000 \end{tabular} & per quarter & \\ \hline \multicolumn{4}{|l|}{ Cash } \\ \hline \begin{tabular}{l} Misn \\ Minum Cash Balance \end{tabular} & $100,000,000 & & \\ \hline Note Payable as of December 31,2023 & $120,000,000 & to be paid January 1,2024 & \\ \hline Interest Payable as of December 31, 2023 & $4,800,000 & to be paild January 1,2024 & \\ \hline \multicolumn{4}{|l|}{ Other } \\ \hline Factory Equipment Purchase (capitalized) & $80,000,000 & 1st Quarter & \\ \hline Corporate Headquarters Renovation (capitalized) & $140,000,000 & 3rd \& 4th Quarter & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions