Question

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

Answer 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