I need a good powerpoint presentation. I have uploaded the instructions and the data needed to complete the presentation. I need to show how much money I can spend and still be profitable. I need to show graphs and give explanations based on the answer. I have uploaded the data in excel and some of the graphs and conclusions in a word program. I chose to do topic #10 and I am pursuing a bachelor in management. That will help answer one of the questions.Instructions
Create a 5- to 7-minute presentation that must include:



Introduction (approximately 1 minute):
o
Introduce your topic and question.
o
Why did it interest you? How does it relate to your degree program?
o
What should the audience learn from your presentation?
Visuals/Evidence (approximately 4-5 minutes):
o
Show your tables, scatterplot, graphs, calculations, and any other evidence to support
your conclusion(s).
o
Discuss why you selected each visuals/evidence.
Conclusion (approximately 1 minute):
o
Restate your topic and question and give your answer to the question.
o
How confident are you that your conclusion is sound?
o
What work would need to be done to increase your confidence?
o
Discuss what you learned from this project.
Include detailed speaker notes for each slide.
Soda Co.
2015
2014
2013
2012
2011
Advertising Labor Costs Shipping Costs
3.783.000
5.044.000 25.220.000
2.667.200
4.000.800
5.334.400
3.985.200
5.313.600 26.568.000
3.929.400
5.239.200 26.196.000
3.990.000
5.320.000 26.600.000
Production
10.088.000
10.668.800
10627200
10478400
10640000
Sales
63.050.000
66.680.000
66.420.000
65.490.000
66.500.000
Advertising Labor Costs Shipping Costs
1.746.000
1.309.500 19.642.500
1.837.200
1.377.900 20.668.500
1.868.000
1.401.000 21.015.000
1.922.800
1.442.100 21.631.500
1.870.800
1.403.100 21.046.500
Production
6.111.000
6.430.200
6.538.000
6.729.800
6.547.800
Sales
43.650.000
45.930.000
46.700.000
48.070.000
46.770.000
Pop Co.
2015
2014
2013
2012
2011
Signature Assignment
Courtney Axel
MTH/216
Dawn McNAir
December 5, 2016
Money Spent vs Profit: The Cost of Doing Business
Focus question: How much money can I spend and still be profitable?
Provided data:
Soda Co.
2015
2014
2013
2012
2011
Advertising
5,044,000
5,334,400
5,313,600
5,239,200
5,320,000
Labor Costs
25,220,000
2,667,200
26,568,000
26,196,000
26,600,000
Shipping Costs
3,783,000
4,000,800
3,985,200
3,929,400
3,990,000
Production
10,088,000
10,668,800
10,627,200
10,478,400
10,640,000
Sales
63,050,000
66,680,000
66,420,000
65,490,000
66,500,000
Advertising
1,309,500
1,377,900
1,401,000
1,442,100
1,403,100
Labor Costs
19,642,500
20,668,500
21,015,000
21,631,500
21,046,500
Shipping Costs
1,746,000
1,837,200
1,868,000
1,922,800
1,870,800
Production
6,111,000
6,430,200
6,538,000
6,729,800
6,547,800
Sales
43,650,000
45,930,000
46,700,000
48,070,000
46,770,000
Pop Co.
2015
2014
2013
2012
2011
Analysis of each Corporation’s Profit
Soda Co. Profit over 5 years
Profit
Linear (Profit)
20,200,000
20,000,000
19,800,000
y = -171300x + 4E+08
R² = 0.356
19,600,000
19,400,000
19,200,000
19,000,000
18,800,000
2010
2011
2012
2013
2014
2015
2016
Throughout the 5 year data, Soda Co.’s profit was within a range of 19,600,000 through 20,000,000, until the last
year in the data set, 2015. In the year 2015, the corporation went below the 19,000,000 range. After comparing
2015’s revenue to previous years, we can see that 2015’s loss in profit was due to a fluctuation in money usage
across all costs, even though the amount of sales constantly increased for Soda Co.
The best fit line is fairy inaccurate, by looking at our R² value is fairly lower than 1, meaning it is a rough
approximation.
Calculation:
Prediction:
(-171300(2016)+(4*10^8))(0.356)
According to the trend line, 2016’s profit would be $19,458,675
(-345340800+(4*10^8) )(0.356)
Soda Co. will not likely decrease in profit like the trend line shows. The line is very
(54659200 ) (0.356)
inaccurate as shown by our R² value.
19458675
Pop Co. Profit over 5 years
Profit
Linear (Profit)
16,600,000
16,400,000
16,200,000
y = -284920x + 6E+08
R² = 0.6597
16,000,000
15,800,000
15,600,000
15,400,000
15,200,000
15,000,000
14,800,000
14,600,000
2010
2011
2012
2013
2014
2015
2016
Pop Co.’s best fit line looks similar to Soda. Co’s. If we look at their data table though, we will see that
the corporation’s spent money was actually lower in all categories comparing 2015 to 2014, yet we saw
a huge dip in between those years. The reason this dip occurred was because of a decrease in sales.
Prediction:
Calculation:
According to the trend line, 2016’s profit would be $16,889,164
(-284920(2016)+(6*10^8))(0.6597)
This trend line and prediction seems much more accurate than Soda Co’s
(-574398720+(6*10^8))(0.6597)
because the R squared value is much higher and the line looks much more
(25601280)(0.6597)
close the actual profit values.
16889164
Soda Co. Money Distribution from 2011 to 2015
Advertising
5\%
Labor Cost
24\%
Sales
59\%
Shipping
3\%
Production
9\%
This pie chart shows that 59\% of the money moving through Soda Co. was profit, while the other 41\%
was business costs, meaning that Soda Co. had a 9\% margin of profit.
Pop Co. Money Distribution from 2011 to
2015
Advertising
2\%
Labor Cost
27\%
Sales
60\%
Shipping
2\%
Production
9\%
This pie chart shows that 60\% of the money moving through Pop Co. was profit, while the other 40\%
was business costs, meaning that Pop Co. had a 10\% margin of profit. Comparing Soda and Pop Co.’s pie
charts, we see that the margins are about the same, with the biggest change in advertising.
Soda Co. Money Distribution from
2011 to 2015
100\%
90\%
80\%
70\%
Sales
60\%
Production
50\%
Shipping Costs
40\%
Labor Costs
30\%
Advertising
20\%
10\%
0\%
2011
2012
2013
2014
2015
Pop Co. Money Distribution from
2011 to 2015
100\%
90\%
80\%
70\%
Sales
60\%
Production
50\%
Shipping Costs
40\%
Labor Costs
30\%
Advertising
20\%
10\%
0\%
2011
2012
2013
2014
2015

Purchase answer to see full
attachment




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.