Reference no: EM132515354
Month Pints of Applesauce Produced Energy Cost
January . . . . . . . . . . . . . . . . . . . 35, 000 . . . . . . . . . . . . . . . . . . . $23,400
February . . . . . . . . . . . . . . . . . . . 21,000 . . . . . . . . . . . . . . . . . . . 22,100
March . . . . . . . . . . . . . . . . . . . 22,000 . . . . . . . . . . . . . . . . . . . 22,000
April . . . . . . . . . . . . . . . . . . . 24,000 . . . . . . . . . . . . . . . . . . . 22,450
May . . . . . . . . . . . . . . . . . . . 30,000 . . . . . . . . . . . . . . . . . . . 22,900
June . . . . . . . . . . . . . . . . . . . 32,000 . . . . . . . . . . . . . . . . . . . 23,350
July . . . . . . . . . . . . . . . . . . . 40,000 . . . . . . . . . . . . . . . . . . . 28,000
August . . . . . . . . . . . . . . . . . . . 30,000 . . . . . . . . . . . . . . . . . . . 22,800
September . . . . . . . . . . . . . . . 30,000 . . . . . . . . . . . . . . . . . . . 23,000
October . . . . . . . . . . . . . . . . . . . 28,000 . . . . . . . . . . . . . . . . . . . 22,700
November . . . . . . . . . . . . . . . . . . . 41,000 . . . . . . . . . . . . . . . . . . . 24,100
December . . . . . . . . . . . . . . . . . . . 39,000 . . . . . . . . . . . . . . . . . . . 24,950
Question 1: Draw a scatter diagram and graph the company's energy cost behavior using the visual-fit method.
Question 2: Predict the energy cost for a month in which 26,000 pints of applesauce are produced.
Question 3: What peculiarity is apparent from the scatter diagram? What should the cost analyst do?