thank you!

\begin{tabular}{|c|c|c|c|} \hline & & 2023 & 2024 \\ \hline Sales & & 25,200,000 & 25,200,000 \\ \hline \multicolumn{4}{|l|}{ COGS } \\ \hline & Labor & 5,200,000 & 5,356,000 \\ \hline & Material & 8,240,000 & 9,064,000 \\ \hline \multicolumn{2}{|c|}{ Total COGS } & 13,440,000 & 14,420,000 \\ \hline \multicolumn{2}{|c|}{ Gross Profit } & 11,760,000 & 10,780,000 \\ \hline \multicolumn{4}{|c|}{ Expenses } \\ \hline & Advertising \& Mkt & 2,300,000 & 3,000,000 \\ \hline & Overhead Salaries & 3,000,000 & 3,500,000 \\ \hline & Rent & 500,000 & 750,000 \\ \hline & Other (Ins, Interest) & 1,250,000 & 1,500,000 \\ \hline \multicolumn{2}{|c|}{ Total Expenses } & 7,050,000 & 8,750,000 \\ \hline \multicolumn{2}{|c|}{ Net Operating Income } & 4,710,000 & 2,030,000 \\ \hline \end{tabular} Questions: If we wanted to maintain the same profit as 2023, and sell our 1) product at the same price per unit, how many units would we need to sell in 2024 ? If we want to maintain the same profit and fabricate the same 2) number of units, what does our sell price need to be to give us the same profit? 3) What is your recommended price and number of unit that we should plan for in 2024 and why? Using the information in the attached excel spreadsheet answer the following questions. Questions: 1) If we wanted to maintain the same profit as 2023 , and sell our product at the same price per unit ( $60 per unit), how many units would we need to sell in 2024 ? 2) If we want to maintain the same profit and fabricate the same number of units (420,000), what does our sell price need to be to give us the same profit? 3) What is your recommended price and number of unit that we should plan for in 2024 and why? We are planning for 2024 , we know that our COGS labor will all receive a 3% salary increase and we expect our raw materials to go up by 10% from this year. We also have projected increases in Marketing, Overhead, Rent and Other expenses. The price is currently $60 per unit, and at that price we sold 420,000 units. If we sell the same number of units in 2024 at the same price our Net Operating Income will drop to 2,030,000. \begin{tabular}{|c|c|c|c|} \hline & & 2023 & 2024 \\ \hline Sales & & 25,200,000 & 25,200,000 \\ \hline \multicolumn{4}{|l|}{ COGS } \\ \hline & Labor & 5,200,000 & 5,356,000 \\ \hline & Material & 8,240,000 & 9,064,000 \\ \hline \multicolumn{2}{|c|}{ Total COGS } & 13,440,000 & 14,420,000 \\ \hline \multicolumn{2}{|c|}{ Gross Profit } & 11,760,000 & 10,780,000 \\ \hline \multicolumn{4}{|c|}{ Expenses } \\ \hline & Advertising \& Mkt & 2,300,000 & 3,000,000 \\ \hline & Overhead Salaries & 3,000,000 & 3,500,000 \\ \hline & Rent & 500,000 & 750,000 \\ \hline & Other (Ins, Interest) & 1,250,000 & 1,500,000 \\ \hline \multicolumn{2}{|c|}{ Total Expenses } & 7,050,000 & 8,750,000 \\ \hline \multicolumn{2}{|c|}{ Net Operating Income } & 4,710,000 & 2,030,000 \\ \hline \end{tabular} Questions: If we wanted to maintain the same profit as 2023, and sell our 1) product at the same price per unit, how many units would we need to sell in 2024 ? If we want to maintain the same profit and fabricate the same 2) number of units, what does our sell price need to be to give us the same profit? 3) What is your recommended price and number of unit that we should plan for in 2024 and why? Using the information in the attached excel spreadsheet answer the following questions. Questions: 1) If we wanted to maintain the same profit as 2023 , and sell our product at the same price per unit ( $60 per unit), how many units would we need to sell in 2024 ? 2) If we want to maintain the same profit and fabricate the same number of units (420,000), what does our sell price need to be to give us the same profit? 3) What is your recommended price and number of unit that we should plan for in 2024 and why? We are planning for 2024 , we know that our COGS labor will all receive a 3% salary increase and we expect our raw materials to go up by 10% from this year. We also have projected increases in Marketing, Overhead, Rent and Other expenses. The price is currently $60 per unit, and at that price we sold 420,000 units. If we sell the same number of units in 2024 at the same price our Net Operating Income will drop to 2,030,000