Homework Help Question & Answers

5 Lab Problem PB5-1, page 238 the following step Enter formulas or descriptions in these fields T...

5 Lab Problem PB5-1, page 238 the following step Enter formulas or descriptions in these fields To create a seattergraph only

5 Lab Problem PB5-1, page 238 the following step Enter formulas or descriptions in these fields To create a seattergraph only cha Insert chart here 1. Sclect the data, bottles sold and operating cost 2. Seloct insert, next to home Bottles Operating MonthSold Cost 4. Select charts, scattergraph January 1000 $8,000 February 1100 57,700 Mareh 300 $9,900 Apri 2000 S14,000 May 2400 517,250 3000 S20,000 3 High Low Analysis Units Dollars High Difference Variable cost per Unit Use the min max functions to determine th๑ high low units High Low Units Total Cost Total Fixed 4 Operating cost of 9600 bottles sold Using High-low 5 Least squares Operating cost of 9600 Bottles using least squares Intercept RSO Regression Chart buil 1. Select the data, bottles sold and operating coslnsert chart here 2. Select insert, next to homo 3. Select charts 4. Select charts, scattergraph .Select Quick Layout Regression Chart
0 0
ReportAnswer #1

Scatter plot

Bottle sold vs Operating cost 25000 20000 15000 5000 500 1000 1500 2000 2500 3000 3500

Units Dollars
High 3000 20000
Low 1000 7700
Difference 2000 12300

The regression equation is
Operating cost = 1399 + 6.339 Bottles sold

Slope = 6.339

Intercept = 1399

With 0 bottles sold, operating cost = 1399

Fixed Cost Variable cost Cost/Bottle
January 1399 6601 6.60
February 1399 6301 5.73
March 1399 8501 6.54
April 1399 12601 6.30
May 1399 15851 6.60
June 1399 18601 6.20
High Low
Units 3000 1000
Total Cost 20000 7700
Total Variable 18601 6301
Total fixed 1399 1399
Add Homework Help Answer
Add Answer of:
5 Lab Problem PB5-1, page 238 the following step Enter formulas or descriptions in these fields T...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
More Homework Help Questions Additional questions in this topic.
Need Online Homework Help?
Ask a Question
Get FREE EXPERT Answers
WITHIN MINUTES
Related Questions