Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 13.6, Problem 19P
The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period.
- a. Using a span of 3,
forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? - b. Repeat part a with a span of 10.
- c. Which of these two spans appears to be more appropriate? Justify your choice.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Question 3
i.
Using the Center of Gravity method, determine the optimal location (X, Y) for the new
distribution center.
[7 marks]
[TOTAL 25 MARKS]
Time (sec.)
Power steering assembly firm wants to set up an assembly line which must have an output of 60 units per
hour. The work elements, task times and their precedence relationships are shown in Table 2: Table 1
Work Element
Immediate Predecessor(s)
A
30
NONE
B
26
A
C
50
A
D
44
B
E
10
с
F
20
с
G
15
D.E
H
30
E,G,F
Required:
a. Draw the precedence diagram showing the task precedence and their times
b. Determine the cycle time associated with the rate of output required.
[3 marks]
c. What is the theoretical number of work stations required to satisfy this output rate?
[3 marks]
[4 marks]
d. Allocate the tasks to work stations taking into consideration the precedence requirements and using
the
LOT rule to break ties between feasible tasks.
e. Calculate the total idle time
[8 marks]
[3 marks]
f. What is the efficiency of the line and the…
Question 2
MGMT2026 Production and Operations Management Semester II 2024-2025
a. Aman ltd. desires to locate a new facility. Based on preliminary analysis, the choice has been
reduced to four locations: A, B, C, and D. These four locations were rated on a scale from 1
(worst) to 10 (best) on each of four criteria. Each criterion was also weighted to indicate its
importance (i.e., the higher the weight, the more important). The list of ratings and weights
follows in the Table 2 below:
Table 2
Factor Score Evaluation by Location
Criterion
Weights
A
B
с
D
Wages
25
4
5
3
4
Government Policies
30
8
7
6
5
Unionisation
Weather
15
6
4
3
2
30
3
4
6
5
i.
Based on weighted scores, where should Acme locate its new facility?
[6 marks]
b. An operations manager has narrowed down the search for a new factory to three locations. The
fixed and variable costs associated with each location is given in the table below.
i.
Table 3
Location
Fixed Cost
Variable Cost
A
$100,000
$10
B
$150,000
$7
с
$200,000
$5…
The University of the West
Indies
GLOBAL CAMPUS
MGMT 2026 Production and Operations Management - Problem Sheet
Assignment Semester II
2024/2025
Note:
Although this assignment is being currently assessed out of 100 marks it
would be prorated to
Contribute a maximum of 40% towards your final course marks.
M&H company ltd. sells television sets and has collected monthly sales
data (in units) for the past 12 months as shown in table 1below:
TABLE 1
Month
Sales (Units)
1
120
2
135
3
150
165
5
180
200
7
195
8
210
225
10
240
11
255
12
270
This Assignment is comprised of four (4) Questions - All questions
must be attempted
Using the data provided, answer the following questions:
a. Using a 3-month weighted moving average with weights 0.5, 0.3,
and 0.2 (most recent month having the highest weight), calculate
the forecast for month 13.
[2 marks]
Screens 5-7 of 7
Chapter 13 Solutions
Practical Management Science
Ch. 13.3 - The file P13_01.xlsx contains the monthly number...Ch. 13.3 - The file P13_02.xlsx contains five years of...Ch. 13.3 - The file P13_03.xlsx contains monthly data on...Ch. 13.3 - The file P13_04.xlsx lists the monthly sales for a...Ch. 13.3 - Management of a home appliance store wants to...Ch. 13.3 - Do the sales prices of houses in a given community...Ch. 13.3 - Prob. 7PCh. 13.3 - The management of a technology company is trying...Ch. 13.3 - Prob. 9PCh. 13.3 - Sometimes curvature in a scatterplot can be fit...
Ch. 13.4 - Prob. 12PCh. 13.4 - A trucking company wants to predict the yearly...Ch. 13.4 - An antique collector believes that the price...Ch. 13.4 - Stock market analysts are continually looking for...Ch. 13.4 - Suppose that a regional express delivery service...Ch. 13.4 - The owner of a restaurant in Bloomington, Indiana,...Ch. 13.6 - The file P13_19.xlsx contains the weekly sales of...Ch. 13.6 - The file P13_20.xlsx contains the monthly sales of...Ch. 13.6 - The file P13_21.xlsx contains the weekly sales of...Ch. 13.6 - The file P13_22.xlsx contains total monthly U.S....Ch. 13.7 - You have been assigned to forecast the number of...Ch. 13.7 - Simple exponential smoothing with = 0.3 is being...Ch. 13.7 - The file P13_25.xlsx contains the quarterly...Ch. 13.7 - The file P13_26.xlsx contains the monthly number...Ch. 13.7 - The file P13_27.xlsx contains yearly data on the...Ch. 13.7 - The file P13_28.xlsx contains monthly retail sales...Ch. 13.7 - The file P13_29.xlsx contains monthly time series...Ch. 13.7 - A version of simple exponential smoothing can be...Ch. 13 - Prob. 31PCh. 13 - Prob. 32PCh. 13 - Management of a home appliance store would like to...Ch. 13 - A small computer chip manufacturer wants to...Ch. 13 - The file P13_35.xlsx contains the amount of money...Ch. 13 - Prob. 36PCh. 13 - Prob. 37PCh. 13 - Prob. 39PCh. 13 - The Baker Company wants to develop a budget to...Ch. 13 - Prob. 41PCh. 13 - The file P13_42.xlsx contains monthly data on...Ch. 13 - Prob. 43PCh. 13 - Prob. 44PCh. 13 - Prob. 45PCh. 13 - Prob. 46PCh. 13 - Prob. 49P
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
- Gas sales across type: 80% of gas sales tend to be regular. 15% midgrade, 5% tend to be premium. $0.10 increase in price per gallon tends to decrease gallons sold by 1 to 3%. Jan-0.87, Feb-0.95, Mar-1.00, Apr-1.05, May-1.08, Jun1.15, Jul-1.13, Aug-1.07, Sep-1.02, Oct-0.94, Nov-0.89, Dec-0.85. You want the MAPE to be below 20%, if ypu can get it to or below 10% they'll throw in extra $10k. Wont get bonus if it is above 11% or 20%. It cannot be over 20%.arrow_forwardhelp me choose the correct path please. There are other optionsarrow_forwardNegotiators can gain several benefits from using the strategy of multiple equivalent simultaneous offers. By offering multiple options it reduces the chance of rejection. It also improves the chances of reaching reaching an agreement. By presenting multiple offers, it shows you are flexible. agree with the postarrow_forward
- Negotiators can gain several benefits from using the strategy of multiple equivalent simultaneous offers. By offering multiple options it reduces the chance of rejection. It also improves the chances of reaching reaching an agreement. By presenting multiple offers, it shows you are flexible. disagree with this post or add on to the postarrow_forwardThe strategy of Multiple Equivalent Simultaneous Offers involves presenting several equally valuable options to the other party during negotiations. This approach benefits negotiators by creating flexibility and increasing the chances of finding a mutually agreeable solution. By offering multiple options, negotiators show that they are open to compromise, which can build trust and make the negotiation process smoother. It also helps avoid getting stuck on one issue, as the other party can choose from several alternatives that meet their needs. In my experience, using MESOs in a work negotiation helped both parties reach an agreement more quickly because each option was carefully thought out to address different needs, and this made it easier for us to settle on one that worked for both sides. This strategy can also reveal what is most important to the other party, helping negotiators understand their priorities better. agree or disagree with the postarrow_forwardExamine the conflicts between improving customer service levels and controlling costs in sales. Strategies to Balance Both customer service levels and controlling costs in sales 1.Outsourcing and workforce optimization 2. AI-driven customer supportarrow_forward
- how can you gain trust in a negotiation setting?arrow_forward✓ Custom $€ .0 .on File Home Insert Share Page Layout Formulas Data Review View Help Draw Arial 10 B B14 ✓ X✓ fx 1400 > 甘く 曲 > 冠 > Comments Editing ✓ . . . P Q R S T 3 A Production cost ($/unit) B с D E F G H J K L M N $74.00 4 Inventory holding cost ($/unit) $1.50 5 Lost sales cost ($/unit) $82.00 6 Overtime cost ($/unit) $6.80 7 Undertime cost ($/unit) $3.20 8 Rate change cost ($/unit) $5.00 9 Normal production rate (units) 2,000 10 Ending inventory (previous Dec.) 800 11 Cumulative 12 13 Month Demand Cumulative Demand Product Production Availability Ending Inventory Lost Cumulative Cumulative Product Sales 14 January 1,400 1,475 15 FUERANZ222222223323333BRUINE 14 February 1,000 2,275 Month January February Demand Demand Production Availability Ending Inventory Lost Sales 1,400 #N/A 1,475 #N/A #N/A #N/A 1,000 #N/A 2,275 #N/A #N/A #N/A 16 March 1,800 2,275 March 1,800 #N/A 2,275 #N/A #N/A #N/A 17 April 2,700 2,275 April 2,700 #N/A 2,275 #N/A #N/A #N/A 18 May 3,000 2,275 May 3,000 #N/A…arrow_forwardFollow guidelines and summarize in a paragrapharrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License