OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
7th Edition
ISBN: 9781259326738
Author: SCHROEDER
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 18, Problem 5P
Summary Introduction
To decide: On the location of the proposed warehouse by ABC company.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The ABC Company plans to locate a warehouse using the center-of-gravity model to serve four different customers. Find the coordinates for the warehouse given the following information:
The ABC Company plans to locate a warehouse using the center-of-gravity model to serve four different customers. Find the coordinates for the warehouse given the following information:
Travel
Passengers
1
405
2
410
3
420
4
415
5
412
6
420
7
424
8
433
9
438
10
440
11
446
12
451
13
455
14
464
15
466
16
474
17
476
18
482
a) Using a weighted moving average with three periods, determine the sales for day 15. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively
b) Find the MAD, MSE and MAPE
b) Use exponential smoothing with a smoothing constant of 0.50 to forecast the sales (Assume that last period’s forecast for period 1 is equal to actual to begin the procedure (Ft1=Yt1). Which method do you think is best? Is this an improvement over the weighted average- use MAD only
Chapter 18 Solutions
OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
Knowledge Booster
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.Similar questions
- Which of the measure(s) of central location can be used for both numerical and categorical variables? Choose from: mean, median, mode, and trimmed mean.arrow_forwardWhat is the Y coordinate if we use the center of gravity method? Please keep 3 decimals in your final answerarrow_forwardIf excel required then attached screenshotarrow_forward
- Using exponential smoothing method, forecast the demand for the fourth period. The historical demand for the previous three periods is 41, 42, and 43 respectively, assume Alpha =0.9 (Round to 2 decimals)arrow_forward10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A 25 26 27 28 29 30 B с 1 2 Based on the city distance dataset as follows: 3 4 5 6 7 8 9 1 Boston 2 Chicago 3 Dallas 4 Denver 5 LA 6 Miami 7 Phoenix 8 Seattle D Phoenix Chicago Denver Dallas 0 983 1815 1991 3036 1539 2664 2612 Boston Chicago Dallas Total trip miles by the traveler: Index Cities Seattle LA E Total trip miles 983 0 1205 1050 2112 1390 1729 2052 F Distance 1815 1205 0 801 1425 1332 1027 2404 G Denver LA 1991 1050 801 0 1174 2100 836 1373 H 3036 2112 1425 1174 0 2757 398 1909 I Miami 1539 1390 1332 2100 2757 0 2359 3389 J K Phoenix Seattle 2664 1729 1027 836 398 2359 0 1482 A resident of Seattle is embarking on a road trip that takes her to Los Angeles, Phoenix, Chicago, Denver, Dallas, and finally go back to Seattle. How many miles will she travel on this trip? Hint: Use INDEX and MATCH to answer the above question. 2612 2052 2404 1373 1909 3389 1482 0 L M Narrow_forwardhelp please I need it in excelarrow_forward
- Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year 1 2 3 4 5 Sales 460 502 520 575 575 a) Forecasted sales for year 6 using the trend projection (linear regression) method are sales (round your response to one decimal place).arrow_forwardTasty Bread Company has monthly demand for one of its products as follows: March= 520; April=490; May=550; June=580; July=600; August=420. Compute the three-month moving average for July.arrow_forwardAlvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend of international tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate over the past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) Table 2 Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Arrival 35.5 28.0 30.3 36.0 49.5 56.0 72.4 71.0 79.3 96.0 C000) Delayed 4.2 3.8 3.8 3.5 4.6 4.5 4.6 4.6 4.7 4.5 rate (1) Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particular model? (5 marks) (ii) Develop the forecasting model that you suggest in (i). Briefly explain your model. (20 marks)arrow_forward
- ABC Company manufacture passenger cars for Malaysian customers. The sales volume is shown in Table 1. Table 1: The sales volume Period (Month) Sales Volume of Passenger Cars 1 8000 2 9500 3 7000 4 6500 5 8100 6 8600 7 9000 8 7800 9 7600 a) Based on Table 1, calculate forecast volume using and 5 periods-moving average. b) Based on Table 1, calculate forecast volume using exponential smoothing with α = 0.6. c) Evaluate which forecasting method is better between 5 periods- moving average and exponential smoothing with α = 0.6.arrow_forwardplease solve it using excel and show the equations and pugging the numbersarrow_forward3. Answer the followings. a. Myanmar CP Live Stock Company Limited Shipped Sausage boxes around Myanmar. A manager wants to forecast shipments for the first four months of the next two years by using Linear equation method. The monthly forecast equation being used is: y= 402 + 3x and determine trend amounts for the first four months of the next two year: January, x=24, February, x=25; etc. b. A farm implements dealer is seeking a fourth warehouse location to complement three existing warehouses. There are three potential locations, N.C; Atlanta, Ga.; and Columbia, S.C. Charlotte would involve a fixed cost of $4,000 per month and a variable cost of $4 per unit. Atlanta would involve a fixed cost of $3,500 per month and a variable cost of $5 per unit; and Columbia would involve a fixed cost of $5,000 per month and a variable cost of $6 per unit. Use of the Charlotte location would increase system transportation costs by $19,000 per month. Atlanta by $22,000 per month, and Columbia by…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
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
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.