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 northernOhio. 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 determine thatdemand.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, thesize of the new plant. The following data have been collected:ITTCost per Thousand Gallons (Y)$1,024Thousands of Gallons Sold (X)434.7Plant962466.4251.3372.1,0651,0061.045245.0258.61,0689889971,0631,000$10.218614.9414.0267.5380,43 704 9910Totala. Develop a regression equation to forecast the cost per thousand gallons as a function of the number of thousands of gallons produced.The forecasting model is given by the equation Y =- X. (Enter your responses rounded to two decimal places.)

Answered: Image /qna-images/answer/b6168639-befa-403a-bbfb-1c3082edf681.jpg

Answered: Ohio Swiss Milk Products manufactures…

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...

See similar textbooks

Similar questions

GreenLawns provides a lawn fertilizer and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $2,500 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media. S = −2R2 − 10M2 − 8RM + 18R + 34M where S = total sales in thousands of dollars R = thousands of dollars spent on radio advertising M = thousands of dollars spent on direct-mail advertising. GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. (a) What is the value of sales (in dollars) if $1,500 is spent on radio advertising and $1,000 is…
Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past 24 months. This is shown. Month 1 2 3 4 5 6 7 8 Sales Month 238 249 254 267 277 282 402 296 9 10 11 12 13 14 15 16 Sales 300 327 346 349 353 364 373 363 Month + 17 18 19 20 21 22 23 24 Sales 361 381 375 383 384 401 409 403 a. Develop a linear trend line for the data. (Round your answers to 2 decimal places, e.g.,25.28.) Sales = (month) b. Compute a correlation coefficient for the data and evaluate the strength of the linear relationship. (Round your answer to 2 decimal places, the tolerance is +/-0.01.) Correlation coefficient is . It indicates linear relationship. (Use not rounded amounts to answer this question.) c. Using the linear trend line equation, develop a forecast for the next period,month 25. (Round your answer to 2 decimal places, the tolerance is +/-0.01. Do not round intermediate results used to achieve this answer.) Forecast for month 25 =
Demand is forecasted using the following regression equation: D = 100 + 15(t) where “t” is a specified future time period. The current time period is 0 (t=0). The machines used to make this product have a capacity of 50 units/time period. The company currently has 4 machines yielding a total capacity of 200 units/time period. Due to technology changes, the current equipment will become obsolete at the end of period 15. If a new machine costs $2000, and the net revenue earned per unit is $10, how many machines should be added between today (t=0) and the end of period 15?
10 Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how many patients Dr. Fokh each year for the past 10 years. It also indicates what the robbery rate was in New Orleans during the same year: ! 1 F1 A 1 option Year Number of Patients Robbery Rate per 1,000 Population The simple linear regression equation that shows the best relationship between the number of patients and the robbery rate is (round your responses to three decimal places): ŷ=0+0x N @ 2 W S X command A where y Number of Patients and x = Robbery Rate. In year 11, if the robbery rate increases to 133.40, using trend analysis, the number of patients Dr. Fok will see = patients (round your response to two decimal places). In year 11, if the robbery rate decreases to 90.6, using trend analysis, the number of patients Dr. Fok will see = patients (round your response to two decimal places). #3 80 F3 E D $ 4 C 888…
Picture
Cool Beans is a locally owned coffeeshop that competes with two large coffee chains, PlanetEuro and Frothies. Alicia, the owner, is considering two different marketing promotions and thinks that CLV analysis will help her decide the best course of action. An average specialty coffee drink sells for $4.26 and has a margin of 83%. One promotion is providing loyalty cards to her regular customers that would give them one free specialty coffee drink after 10 regular purchases. Alicia estimates that this will increase the frequency of their purchases by 14%. Currently, her customers average buying 2 specialty drinks per week. The second promotion is targeted at new customers. She would offer a free specialty drink to incoming college freshmen by providing a coupon with their orientation packages. Because of her location near the college, she expects that 310 students will come to Cool Beans for a free trial. Of those, she anticipates that 16% will become regular customers who will…
Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how many patients Dr. Fok has seen each year for the past 10 years. It also indicates what the robbery rate was in New Orleans during the same year: Year Number of Patients Robbery Rate per 1,000 Population The simple linear regression equation that shows the best relationship between the number of patients and year is (round your responses to three decimal places): where y Dependent Variable and x = Independent Variable. culator Ask my instructor 3 A 8.0 F3 $ 4 898 F4 % 5 FS 6 2 1 36 33 57.8 61.4 F6 MacBook Air of A 3 40 73.4 7 F7 4 40 75.7 * 8 5 6 7 8 9 10 54 59 42 55 60 60 81.5 88.6 99.6 95.4 104.1 115.6 DII FB ( 9 DD F9 O F10 Clear all F11 - Check answer + 30 (49) F12 = delete
Read the following passage and answer the question that follows Quincy Snodgrass Enterprises—Forecasting Quincy Snodgrass is an entrepreneur and a lover of the outdoors. He has worked for various companies since he graduated college with his business administration degree in management. Over the years, he has saved every extra penny and now has the starting capital he needs; consequently, he plans to open his own business. Quincy plans to open a landscaping business. The primary services he’ll offer are grass cutting, edging, and bush trimming. Obviously, this will only provide income in the spring, summer, and early fall. Therefore, he plans to offer snow removal in the winter. His goal is to continue to provide those baseline services and expand into actual landscaping work. Quincy’s initial challenge is to develop a forecast of how many customers he’ll have each month. This is essential to determine if he needs to hire any additional labor throughout the season. Unfortunately, none…
Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: Price $2.70 $3.50 $2.10 $4.10 $3.10 $4.05 Number Sold 765 515 990 245 320 480 Using simple linear regression and given that the price per cup is $1.85, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place).
Dave F letcher, the general manager of NorthCarolina Engineering Corporation (NCEC), thinks that his firm'sengineering services contracted to highway construction firms aredirectly rela ted to the volume of highway construction businesscontracted with companies in his geographic area. He wondersif thjs is really so, and if it is, can this information help him planhjs operations better by forecasting the quantity of his engineeringservices required by construction firms in each quarter of theyear? The following table presents the sales of his services andtotal amounts of contracts for hjghway construction over the pasteight quarters:…
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 65 68 77 59 66 75 23456 2 5 6 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.500 on the present period, 0.250 one period ago, 0.125 two periods ago, and 0.125 three periods ago. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 40, 20, 10, and 10, respectively, how would the forecast change? OA. The value of the forecast will decrease. B. The value of the forecast will remain the same. C. The value of the forecast will increase. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7?…
Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: IT Price Number Sold $2.60 $3.60 $2.00 $4.20 $3.10 $4.00 770 505 975 250 315 490 Using simple linear regression and given that the price per cup is $1.85, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place).

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS