QUESTION 1 The table below shows the sales figures for a brand of shoe over the last 12 months. Months Sales January 69 February 75 March 86 April 92 May 95 June 100 July 108 August 115 September 125 October 131 November 140 December 150 a. Using the following, forecast the sales for the months up to January the following year:- i. A simple three month moving average.  ii. A three period weighted moving average using weights of 1, 2 and 3. Assign the highest weight to the most recent data.  iii. Exponential Smoothing when α= .6 and the forecast for March is 350. iv. Determine which of the three forecasting technique is the most accurate using MAD.  b. The following table shows the number of televisions sold over the last ten years at a local electronic store. YEAR TV SALES 1 150 2 300 3 480 4 600 5 630 6 640 7 700 8 825 9 900 10 980 i. Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept.  ii. Use that formula to forecast television sales for years 11 and 12.  QUESTION 2 1. Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in the coming year. He has four locations in mind. The costs information for these locations is in the following table. Location A B C D Fixed Costs 60,000 80,000 100,000 130,000 Variable costs/unit 30 20 15 10  a. i. Write an equation to represent the total costs for each location.  ii. Draw the total costs lines for each location on the same axes. (Use output ranges of 200, 400, 600, 800 etc. and intervals of $50,000 on the Y axis. iii. Over what range of output is location A the most preferred location? iv. Over what range of output is location B the most preferred location? v. Over what range of output is location C the most preferred location? b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y-Coordinate Judy Inc 25 3 7 Zac Supermarket 13 5 2 Harry Inc 6 8 4 Sky Productions 4 1 5 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.  QUESTION 3 Mr. John produces a special type of shoes on an assembly line. The process involves eight different tasks. Mr. John would like to increase productivity on this line and asked you for some assistance. He would like to balance the assembly line in order to reduce idle time and increase efficiency. a. What information would you need in order to demonstrate to Mr. John how to balance the assembly line?  b. Setup an example that will be used to demonstrate to Mr. John how to balance the line. c. Using the example that you setup in “b” above, demonstrate to Mr. John how to balance the line using the LOT heuristics.  d. Based on the example above, calculate the efficiency of the line.  QUESTION 4 a. Explain any two process technologies for materials.  b. Discuss any three factors that will help to determine the type of production process used.  c. Distinguish between design capacity and effective capacity. Provide a brief example.  d. Why is the capacity decision important? e. A regional bank training center has the physical ability to handle 1,300 participants. However, management personnel believe that only 1,100 participants can be handled effectively for most training sessions. The last training session, although forecasted to have 1,000 participants, resulted in the attendance of only 990 participants. Calculate the utilization and efficiency of the training facility.

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
icon
Concept explainers
Topic Video
Question

QUESTION 1
The table below shows the sales figures for a brand of shoe over the last 12 months.
Months Sales
January 69
February 75
March 86
April 92
May 95
June 100
July 108
August 115
September 125
October 131
November 140
December 150
a. Using the following, forecast the sales for the months up to January the following year:-
i. A simple three month moving average. 
ii. A three period weighted moving average using weights of 1, 2 and 3. Assign the
highest weight to the most recent data. 
iii. Exponential Smoothing when α= .6 and the forecast for March is 350.

iv. Determine which of the three forecasting technique is the most accurate using
MAD. 


b. The following table shows the number of televisions sold over the last ten years at a
local electronic store.
YEAR TV SALES
1 150
2 300
3 480
4 600
5 630
6 640
7 700
8 825
9 900
10 980
i. Using trend projection, develop a formula to predict sales for years 11 and 12. You
have to show all working. You will need to develop a table to calculate the slope and
the intercept. 


ii. Use that formula to forecast television sales for years 11 and 12. 

QUESTION 2
1. Mr. Jack is in the process of expanding his manufacturing business. He decided to open
a plant in the coming year. He has four locations in mind. The costs information for
these locations is in the following table.

Location A B C D
Fixed Costs 60,000 80,000 100,000 130,000
Variable costs/unit 30 20 15 10

 a.
i. Write an equation to represent the total costs for each location. 
ii. Draw the total costs lines for each location on the same axes. (Use output ranges
of 200, 400, 600, 800 etc. and intervals of $50,000 on the Y axis.


iii. Over what range of output is location A the most preferred location?

iv. Over what range of output is location B the most preferred location?
v. Over what range of output is location C the most preferred location?


b. A food manufacturer wants to locate a warehouse to serve its major customers.
The customers, annual volume and the X and Y coordinates are shown in the
table below.

Customer Annual Volume X-Coordinate Y-Coordinate
Judy Inc 25 3 7
Zac Supermarket 13 5 2
Harry Inc 6 8 4
Sky Productions 4 1 5


i. Using the centre of gravity location technique, determine the location
coordinates that will minimize the transportation costs for their family of
products. 


QUESTION 3
Mr. John produces a special type of shoes on an assembly line. The process involves eight
different tasks. Mr. John would like to increase productivity on this line and asked you for some
assistance. He would like to balance the assembly line in order to reduce idle time and increase
efficiency.
a. What information would you need in order to demonstrate to Mr. John how to balance
the assembly line? 
b. Setup an example that will be used to demonstrate to Mr. John how to balance the line.

c. Using the example that you setup in “b” above, demonstrate to Mr. John how to
balance the line using the LOT heuristics. 
d. Based on the example above, calculate the efficiency of the line. 


QUESTION 4
a. Explain any two process technologies for materials. 
b. Discuss any three factors that will help to determine the type of production process
used. 
c. Distinguish between design capacity and effective capacity. Provide a brief
example. 
d. Why is the capacity decision important?


e. A regional bank training center has the physical ability to handle 1,300 participants.
However, management personnel believe that only 1,100 participants can be handled
effectively for most training sessions. The last training session, although forecasted to
have 1,000 participants, resulted in the attendance of only 990 participants. Calculate
the utilization and efficiency of the training facility. 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 7 images

Blurred answer
Knowledge Booster
Inventory management
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
  • SEE MORE QUESTIONS
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.