Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 &
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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started