MANAGEMENT 22
SOLUTION: MGMT3106 GU Management Science and Operations Management Worksheet
SOLUTION: MGMT3106 GU Management Science and Operations Management Worksheet.
MGMT 3106: Management Science and Operations Management
Assignment Instructions
Follow instructions carefully. Otherwise your grade will be affected
You can discuss the questions with colleagues. But you are not allowed to share your work.
Alike assignments will earn a grade of 0 first time.
Alike assignments will lead to an F in the course second time.
Previous semester assignments will earn a grade of 0 first time.
Previous semester assignments will lead to an F in the course second time.
Sources and Plagiarism
Cite your sources (i.e., websites, books, magazines, etc.)
Answers without sources will not earn grade.
Plagiarism: To use the same words as your source.
Plagiarism leads to a 0 in the assignment. No matter if it is only a sentence.
Be organized and professional.
Consistent formatting is expected (Line spacing, margins, fonts, numbering, etc.)
Poorly presented assignments will lose up to 20% because of presentation.
Answers without proper support will not earn any grade.
Include calculations when necessary.
Refer to appendixes when explaining your answer.
Question/answer examples
Example 1: How many Daejo leaders are located in the state of Texas?
Unacceptable answer: 9.
Acceptable answer: Currently there are 9 dealers in the state of Texas.
Note: Answers need to be presented in a professional and nice fashion.
Example 2: One of the best sellers at a paint store is an Iron-coat paint. The annual demand is
forecasted as 10,000 gallons. The carrying cost is $0.75 per gallon. The ordering cost is $150 per order.
How much paint should be ordered each time?
Unacceptable answer: 2000.
Acceptable answer: The paint store should order 2,000 gallons each time. Calculations below show how
the answer was obtained:
Q=
2Co D
2 *150 *10,000
=
= 2,000
Cc
0.75
Note: Answer is professionally presented. Calculation details are shown using Microsoft equation editor.
MGMT 3106: Management Science and Operations Management
Assignment 4
Answer all questions. Show all your work to earn credit.
1. [20 points] Assume that you were selected for a summer internship in Belize. You are
unprepared and you need to get everything prepared by May 15th (and do not have a passport
yet!).
a. List the activities you need to do to get prepared for the internship. How much time do
you need for each activity?
b. Select one activity. Create a list of tasks for this activity. (e.g. Activity: Getting a
passport; Tasks: all the steps that is required to get a passport).
c. Create a project network for the activities indicating the precedence relationships.
2. [20 points] A project for upgrading a point-of-sale system at a local business has
following precedence relationships and activity times. The tasks, durations (in days),
costs, and predecessor relationships are shown as follows:
Activity
Immediate Predecessor
Activity Time
A
-3
B
-11
C
A
7
D
B, C
13
E
B
10
F
D
6
G
E
5
H
F, G
8
a. Draw the network for this project.
b. Calculate the slack for each activity. What are the critical path activities?
c. What is the project completion time?
3. [20 points] A landscaping upgrade project consists of following activities. Times are
given in weeks.
Activity
Immediate Predecessor
Activity Time
A
5
B
A
8
C
A
7
D
6
E
B, D, C
8
F
D
3
G
D
3
a. Draw the network diagram and find the ES, EF, LS, LF, and slack for each activity.
b. Construct an early-start-date Gantt chart for the project.
c. As a project manager, where would you focus your attention, given your analysis?
MGMT 3106: Management Science and Operations Management
4. Environment Recycling, Inc. must clean up a large automobile tire dump under a state
environmental cleanup contract. Some of the activities can be crashed. The tasks, durations
(in days), costs, predecessor relationships, the crash times, and costs associated with
performing the activities at their original (normal) times and for the crash times are shown as
follows:
Activity
A
B
C
D
E
F
G
H
Immediate
Predecessor
–A, B
B
C, D
E
E
G
Normal Time
(days)
6
4
3
2
6
3
4
4
Normal Cost
($)
1,000
800
600
1,500
900
1,300
900
500
Crash Time
5
2
2
1
4
1
4
2
Crash Cost
($)
1,200
2,000
900
2,000
1,200
1,400
900
900
a. Find the total project completion time. (Show all work including finding the critical
path).
b. Find the lowest cost solution if the state wants to complete the project two weeks
early. State which activities need to be crashed and calculate the crashing cost for the
total project.
5. A competitor of Kozar International, Inc. has begun marketing a new instant developing
film project. Kozar has had a similar product under study in its R&D department but has not
yet been able to begin production. Because of the competitor’s action, top managers have
asked for a speedup of R&D activities so that Kozar can produce and market instant film at
the earliest possible date. The predecessor information and activity time estimates in months
are shown in the next column.
Activity
A
B
C
D
E
F
G
Immediate
Predecessor
A
A
B, C
B
C, D, E
F
Optimistic Time
(weeks)
4
2.5
6
5
6
1
8
Most Probable
Time
5
3
7
5.5
7
3
10
Pessimistic Time
6
3.5
8
9
8
5
12
MGMT 3106: Management Science and Operations Management
a. Draw the project network.
b. Develop an activity schedule for this project using early and late start and finish
times, compute activity slack time, and define the critical activities.
c. What is the probability of finishing the project in 30 weeks?
d. What is the probability of finishing the project in 35 weeks?
MGMT 3106: Management Science and Operations Management
Assignment Instructions
Follow instructions carefully. Otherwise your grade will be affected
You can discuss the questions with colleagues. But you are not allowed to share your work.
Alike assignments will earn a grade of 0 first time.
Alike assignments will lead to an F in the course second time.
Previous semester assignments will earn a grade of 0 first time.
Previous semester assignments will lead to an F in the course second time.
Sources and Plagiarism
Cite your sources (i.e., websites, books, magazines, etc.)
Answers without sources will not earn grade.
Plagiarism: To use the same words as your source.
Plagiarism leads to a 0 in the assignment. No matter if it is only a sentence.
Be organized and professional.
Consistent formatting is expected (Line spacing, margins, fonts, numbering, etc.)
Poorly presented assignments will lose up to 20% because of presentation.
Answers without proper support will not earn any grade.
Include calculations when necessary.
Refer to appendixes when explaining your answer.
Question/answer examples
Example 1: How many Daejo leaders are located in the state of Texas?
Unacceptable answer: 9.
Acceptable answer: Currently there are 9 dealers in the state of Texas.
Note: Answers need to be presented in a professional and nice fashion.
Example 2: One of the best sellers at a paint store is an Iron-coat paint. The annual demand is
forecasted as 10,000 gallons. The carrying cost is $0.75 per gallon. The ordering cost is $150 per order.
How much paint should be ordered each time?
Unacceptable answer: 2000.
Acceptable answer: The paint store should order 2,000 gallons each time. Calculations below show how
the answer was obtained:
Q=
2Co D
2 *150 *10,000
=
= 2,000
Cc
0.75
Note: Answer is professionally presented. Calculation details are shown using Microsoft equation editor.
MGMT 3106: Management Science and Operations Management
Assignment 5
Answer all questions. Show all your work to earn credit.
1. [20 points] Discuss some forecasting issues that you encounter in your daily life. How do you
make your forecasts? (minimum 200 words).
2. [20 points] A general manager in a restaurant wants your help to plan for the next year. The
manager asked whether they can use time series forecasting models of regression-based
forecasting modes. Write a memorandum explaining the difference between two methods.
Also discuss which method should be used in the restaurant and providing reasons. (min.
200 words)
3. [20 points] Following table shows the sales data of new satellite tv services by an agent of
last 6 months.
Month
Sales
1
19
2
21
3
22
4
24
5
23
6
26
a. Calculate the forecast sales for month 7 using four-month moving average [5 points]
b. If the weights for last three months are 0.5, 0.3, and 0.2 (0.5 being for the most recent),
forecast sales the weighted moving average for months 7? [5 points]
c. If the actual sales for month 7 is 28, calculate the error for each method (MA and WMA)
for months 7. [5 points]
d. Which method is better? Explain why. [5 points]
4. [20 points] Sales data of Travel Mugs in a store is as follows:
Month
Actual
Sales
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
1623
1533
1455
1386
1209
1348
1581
1332
The managers are trying to choose a good forecasting model for forecasting the demand.
They are considering Single Exponential Smoothening (SES) method as the forecasting model.
One manager suggested that α value should be 0.2 and another experienced manager
suggested that α value should be 0.5. They decided to test the α values by comparing the
mean square error for each α value.
Help the managers to decide α value is better for SES model. Show all calculations.
(A non-analytical discussion is not acceptable as the answer).
MGMT 3106: Management Science and Operations Management
5. [20 points] Crossroad Inn is a small bed-and-breakfast inn. It also has a restaurant, which serves the
guests of the inn. Due to poor forecasting, the restaurant is losing money on food inventory. The
general manager seeks a better way to forecast the demand for restaurant patrons and belies that
the demand of patrons is related to advertising expenditures. The following are number of patrons
and advertising data for the past 7 months.
Month
1
2
3
4
5
6
7
Patrons
564
418
463
402
501
534
484
Advertising (Thousands of $)
2.6
1.3
1.4
1
2
2.1
1.7
a) Develop a simple linear regression model that relates advertising cost to number of patrons.
b) The manager has decided to spend $2,750 next month (8th month) on advertising. Use linear
regression model and forecast the number of patrons for next month.
Purchase answer to see full
attachment
Assignment Instructions
Follow instructions carefully. Otherwise your grade will be affected
You can discuss the questions with colleagues. But you are not allowed to share your work.
Alike assignments will earn a grade of 0 first time.
Alike assignments will lead to an F in the course second time.
Previous semester assignments will earn a grade of 0 first time.
Previous semester assignments will lead to an F in the course second time.
Sources and Plagiarism
Cite your sources (i.e., websites, books, magazines, etc.)
Answers without sources will not earn grade.
Plagiarism: To use the same words as your source.
Plagiarism leads to a 0 in the assignment. No matter if it is only a sentence.
Be organized and professional.
Consistent formatting is expected (Line spacing, margins, fonts, numbering, etc.)
Poorly presented assignments will lose up to 20% because of presentation.
Answers without proper support will not earn any grade.
Include calculations when necessary.
Refer to appendixes when explaining your answer.
Question/answer examples
Example 1: How many Daejo leaders are located in the state of Texas?
Unacceptable answer: 9.
Acceptable answer: Currently there are 9 dealers in the state of Texas.
Note: Answers need to be presented in a professional and nice fashion.
Example 2: One of the best sellers at a paint store is an Iron-coat paint. The annual demand is
forecasted as 10,000 gallons. The carrying cost is $0.75 per gallon. The ordering cost is $150 per order.
How much paint should be ordered each time?
Unacceptable answer: 2000.
Acceptable answer: The paint store should order 2,000 gallons each time. Calculations below show how
the answer was obtained:
Q=
2Co D
2 *150 *10,000
=
= 2,000
Cc
0.75
Note: Answer is professionally presented. Calculation details are shown using Microsoft equation editor.
MGMT 3106: Management Science and Operations Management
Assignment 4
Answer all questions. Show all your work to earn credit.
1. [20 points] Assume that you were selected for a summer internship in Belize. You are
unprepared and you need to get everything prepared by May 15th (and do not have a passport
yet!).
a. List the activities you need to do to get prepared for the internship. How much time do
you need for each activity?
b. Select one activity. Create a list of tasks for this activity. (e.g. Activity: Getting a
passport; Tasks: all the steps that is required to get a passport).
c. Create a project network for the activities indicating the precedence relationships.
2. [20 points] A project for upgrading a point-of-sale system at a local business has
following precedence relationships and activity times. The tasks, durations (in days),
costs, and predecessor relationships are shown as follows:
Activity
Immediate Predecessor
Activity Time
A
-3
B
-11
C
A
7
D
B, C
13
E
B
10
F
D
6
G
E
5
H
F, G
8
a. Draw the network for this project.
b. Calculate the slack for each activity. What are the critical path activities?
c. What is the project completion time?
3. [20 points] A landscaping upgrade project consists of following activities. Times are
given in weeks.
Activity
Immediate Predecessor
Activity Time
A
5
B
A
8
C
A
7
D
6
E
B, D, C
8
F
D
3
G
D
3
a. Draw the network diagram and find the ES, EF, LS, LF, and slack for each activity.
b. Construct an early-start-date Gantt chart for the project.
c. As a project manager, where would you focus your attention, given your analysis?
MGMT 3106: Management Science and Operations Management
4. Environment Recycling, Inc. must clean up a large automobile tire dump under a state
environmental cleanup contract. Some of the activities can be crashed. The tasks, durations
(in days), costs, predecessor relationships, the crash times, and costs associated with
performing the activities at their original (normal) times and for the crash times are shown as
follows:
Activity
A
B
C
D
E
F
G
H
Immediate
Predecessor
–A, B
B
C, D
E
E
G
Normal Time
(days)
6
4
3
2
6
3
4
4
Normal Cost
($)
1,000
800
600
1,500
900
1,300
900
500
Crash Time
5
2
2
1
4
1
4
2
Crash Cost
($)
1,200
2,000
900
2,000
1,200
1,400
900
900
a. Find the total project completion time. (Show all work including finding the critical
path).
b. Find the lowest cost solution if the state wants to complete the project two weeks
early. State which activities need to be crashed and calculate the crashing cost for the
total project.
5. A competitor of Kozar International, Inc. has begun marketing a new instant developing
film project. Kozar has had a similar product under study in its R&D department but has not
yet been able to begin production. Because of the competitor’s action, top managers have
asked for a speedup of R&D activities so that Kozar can produce and market instant film at
the earliest possible date. The predecessor information and activity time estimates in months
are shown in the next column.
Activity
A
B
C
D
E
F
G
Immediate
Predecessor
A
A
B, C
B
C, D, E
F
Optimistic Time
(weeks)
4
2.5
6
5
6
1
8
Most Probable
Time
5
3
7
5.5
7
3
10
Pessimistic Time
6
3.5
8
9
8
5
12
MGMT 3106: Management Science and Operations Management
a. Draw the project network.
b. Develop an activity schedule for this project using early and late start and finish
times, compute activity slack time, and define the critical activities.
c. What is the probability of finishing the project in 30 weeks?
d. What is the probability of finishing the project in 35 weeks?
MGMT 3106: Management Science and Operations Management
Assignment Instructions
Follow instructions carefully. Otherwise your grade will be affected
You can discuss the questions with colleagues. But you are not allowed to share your work.
Alike assignments will earn a grade of 0 first time.
Alike assignments will lead to an F in the course second time.
Previous semester assignments will earn a grade of 0 first time.
Previous semester assignments will lead to an F in the course second time.
Sources and Plagiarism
Cite your sources (i.e., websites, books, magazines, etc.)
Answers without sources will not earn grade.
Plagiarism: To use the same words as your source.
Plagiarism leads to a 0 in the assignment. No matter if it is only a sentence.
Be organized and professional.
Consistent formatting is expected (Line spacing, margins, fonts, numbering, etc.)
Poorly presented assignments will lose up to 20% because of presentation.
Answers without proper support will not earn any grade.
Include calculations when necessary.
Refer to appendixes when explaining your answer.
Question/answer examples
Example 1: How many Daejo leaders are located in the state of Texas?
Unacceptable answer: 9.
Acceptable answer: Currently there are 9 dealers in the state of Texas.
Note: Answers need to be presented in a professional and nice fashion.
Example 2: One of the best sellers at a paint store is an Iron-coat paint. The annual demand is
forecasted as 10,000 gallons. The carrying cost is $0.75 per gallon. The ordering cost is $150 per order.
How much paint should be ordered each time?
Unacceptable answer: 2000.
Acceptable answer: The paint store should order 2,000 gallons each time. Calculations below show how
the answer was obtained:
Q=
2Co D
2 *150 *10,000
=
= 2,000
Cc
0.75
Note: Answer is professionally presented. Calculation details are shown using Microsoft equation editor.
MGMT 3106: Management Science and Operations Management
Assignment 5
Answer all questions. Show all your work to earn credit.
1. [20 points] Discuss some forecasting issues that you encounter in your daily life. How do you
make your forecasts? (minimum 200 words).
2. [20 points] A general manager in a restaurant wants your help to plan for the next year. The
manager asked whether they can use time series forecasting models of regression-based
forecasting modes. Write a memorandum explaining the difference between two methods.
Also discuss which method should be used in the restaurant and providing reasons. (min.
200 words)
3. [20 points] Following table shows the sales data of new satellite tv services by an agent of
last 6 months.
Month
Sales
1
19
2
21
3
22
4
24
5
23
6
26
a. Calculate the forecast sales for month 7 using four-month moving average [5 points]
b. If the weights for last three months are 0.5, 0.3, and 0.2 (0.5 being for the most recent),
forecast sales the weighted moving average for months 7? [5 points]
c. If the actual sales for month 7 is 28, calculate the error for each method (MA and WMA)
for months 7. [5 points]
d. Which method is better? Explain why. [5 points]
4. [20 points] Sales data of Travel Mugs in a store is as follows:
Month
Actual
Sales
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
1623
1533
1455
1386
1209
1348
1581
1332
The managers are trying to choose a good forecasting model for forecasting the demand.
They are considering Single Exponential Smoothening (SES) method as the forecasting model.
One manager suggested that α value should be 0.2 and another experienced manager
suggested that α value should be 0.5. They decided to test the α values by comparing the
mean square error for each α value.
Help the managers to decide α value is better for SES model. Show all calculations.
(A non-analytical discussion is not acceptable as the answer).
MGMT 3106: Management Science and Operations Management
5. [20 points] Crossroad Inn is a small bed-and-breakfast inn. It also has a restaurant, which serves the
guests of the inn. Due to poor forecasting, the restaurant is losing money on food inventory. The
general manager seeks a better way to forecast the demand for restaurant patrons and belies that
the demand of patrons is related to advertising expenditures. The following are number of patrons
and advertising data for the past 7 months.
Month
1
2
3
4
5
6
7
Patrons
564
418
463
402
501
534
484
Advertising (Thousands of $)
2.6
1.3
1.4
1
2
2.1
1.7
a) Develop a simple linear regression model that relates advertising cost to number of patrons.
b) The manager has decided to spend $2,750 next month (8th month) on advertising. Use linear
regression model and forecast the number of patrons for next month.
Purchase answer to see full
attachment
SOLUTION: MGMT3106 GU Management Science and Operations Management Worksheet