Answered step by step
Verified Expert Solution
Link Copied!

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!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
\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

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Management Systems Auditing A Practitioners Guide To Quality And Management Systems Audit

Authors: Dr Warren Doudle

1st Edition

B0C6W3G4W4, 979-8397130271

More Books

Students also viewed these Accounting questions

Question

5. Describe how contexts affect listening

Answered: 1 week ago