Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

the beginning number will be 50103 PLEASE SHOW EXCEL FORMULAS To begin, please enter 50,000 plus the square root of the last 5 digits of

the beginning number will be 50103
PLEASE SHOW EXCEL FORMULAS
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
To begin, please enter 50,000 plus the square root of the last 5 digits of your student number in the yellow cell indicated ( F9). (50,000+103) 3 POINTS can be earned by correctly determining net operating income in the three scenarios. NOTE: when preparing the 3 income statements, the starting point is the original information provided in the Base Scenario (i.e. cells F6 through F10) - do not use the adjusted income statement in Scenario 1 as a starting point for Scenario 2. 2 POINTS are for completing the spreadsheet using formulas, not numbers, in all gray cells. 5 POINTS can be earned by correctly graphing the CVP graph. Fill out the "Cost-Volume-Profit Graph Data Points" table by calculating the profit for the base scenario and each of the other three scenarios at the four different given levels of units sold. Use a "XY (Scatter) with Straight Lines" graph on this data. Format the chart to have Unit Sales on the X-axis and Profit on the Y-axis. Ensure that the X-axis begins at zero units. Insert 50,000 plus the square root of the last 5 digits of your student number in the yellow highlighted cell \begin{tabular}{|r|r|r|r|} \multicolumn{1}{|c|}{ Units Sold } & \multicolumn{2}{|c|}{ Cost-Volume-Profit Graph Data Points } \\ \cline { 2 - 4 } 1,000 & Base & & H1 \\ \hline 10,000 & & & \\ 15,000 & & & \end{tabular} Insert your graph under here. To begin, please enter 50,000 plus the square root of the last 5 digits of your student number in the yellow cell indicated ( F9). (50,000+103) 3 POINTS can be earned by correctly determining net operating income in the three scenarios. NOTE: when preparing the 3 income statements, the starting point is the original information provided in the Base Scenario (i.e. cells F6 through F10) - do not use the adjusted income statement in Scenario 1 as a starting point for Scenario 2. 2 POINTS are for completing the spreadsheet using formulas, not numbers, in all gray cells. 5 POINTS can be earned by correctly graphing the CVP graph. Fill out the "Cost-Volume-Profit Graph Data Points" table by calculating the profit for the base scenario and each of the other three scenarios at the four different given levels of units sold. Use a "XY (Scatter) with Straight Lines" graph on this data. Format the chart to have Unit Sales on the X-axis and Profit on the Y-axis. Ensure that the X-axis begins at zero units. Insert 50,000 plus the square root of the last 5 digits of your student number in the yellow highlighted cell \begin{tabular}{|r|r|r|r|} \multicolumn{1}{|c|}{ Units Sold } & \multicolumn{2}{|c|}{ Cost-Volume-Profit Graph Data Points } \\ \cline { 2 - 4 } 1,000 & Base & & H1 \\ \hline 10,000 & & & \\ 15,000 & & & \end{tabular} Insert your graph under here

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

Financial Audit American Battle Monuments Commissions Financial Statements For Fiscal Years 2011 And 2010

Authors: Government Accountability Office

1st Edition

1492310883, 978-1492310884

More Books

Students also viewed these Accounting questions

Question

Please help me evaluate this integral. 8 2 2 v - v

Answered: 1 week ago

Question

Identify three ways to manage an intergenerational workforce.

Answered: 1 week ago

Question

Prepare a Porters Five Forces analysis.

Answered: 1 week ago

Question

Analyze the impact of mergers and acquisitions on employees.

Answered: 1 week ago