Cost per Thousand Gallons (Y) Thousands of Plant Gallons Sold (X) 1 $1,015 416.9 2 973 472.5 3 1,046 250.0 4 1,006 372.1 1,058 238.1 6. 1,068 258.6 7 967 597.0 8 997 414.0 9 1,044 263.2 10 1,008 372.0 Total $10,182 3,654.4

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
100%

Ohio Swiss Milk Products manufactures and distributes ice
cream in Ohio, Kentucky, and West Virginia. The company
wants to expand operations by locating another plant in
northern Ohio. The size of the new plant will be a function of
the expected demand for ice cream within the area served by
the plant. A market survey is currently under way to deter-
mine that demand.
Ohio Swiss wants to estimate the relationship between the
manufacturing cost per gallon and the number of gallons
sold in a year to determine the demand for ice cream and,
thus, the size of the new plant. The following data have been
collected:
a. Develop a regression equation to forecast the cost per gal-
lon as a function of the number of gallons produced.

b. What are the correlation coefficient and the coefficient of
determination? Comment on your regression equation in
light of these measures.
c. Suppose that the market survey indicates a demand of
325,000 gallons in the Bucyrus, Ohio area. Estimate the
manufacturing cost per gallon for a plant producing
325,000 gallons per year.

Cost per Thousand
Gallons (Y)
Thousands of
Plant
Gallons Sold (X)
1
$1,015
416.9
2
973
472.5
3
1,046
250.0
4
1,006
372.1
1,058
238.1
6.
1,068
258.6
7
967
597.0
8
997
414.0
9
1,044
263.2
10
1,008
372.0
Total
$10,182
3,654.4
Transcribed Image Text:Cost per Thousand Gallons (Y) Thousands of Plant Gallons Sold (X) 1 $1,015 416.9 2 973 472.5 3 1,046 250.0 4 1,006 372.1 1,058 238.1 6. 1,068 258.6 7 967 597.0 8 997 414.0 9 1,044 263.2 10 1,008 372.0 Total $10,182 3,654.4
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Forecasting methods
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.