Determine expected activity times

Assignment Help Operation Management
Reference no: EM13726053

Problem 1. WeightedScore Method and Center Of Gravity Method

ABC Electronics is going to construct a new $1.2 billion semiconductor plant and has selected four towns in the Midwest as potential sites. The important location factors and ratings for each town are as follows:


Scores (0 to 100)

Location Factor

Weight

Abbeton

Bayside

Cane Creek

Dunnville

Work ethics

0.18

80

90

70

75

Quality of life

0.16

75

85

95

90

Labor laws/unionization

0.12

90

60

60

70

Infrastructure

0.10

60

50

60

70

Education

0.08

80

90

85

95

Labor skill and education

0.07

75

65

70

80

Cost of living

0.06

70

80

85

75

Taxes

0.05

65

70

55

60

Incentive package

0.05

90

95

70

80

Government regulations

0.03

40

50

65

55

Environmental regulations

0.03

65

60

70

80

Transportation

0.03

90

80

95

80

Space for expansion

0.02

90

95

90

90

Urban proximity

0.02

60

90

70

80

Recommend a site based on these location factors and ratings.

Problem 2. Excel Solver

XYZ  Furniture is one of the few remaining domestic manufacturers of wood furniture. In the current competitive environment, cost containment is the key to its continued survival. Demand for furniture follows a seasonal demand pattern with increased sales in the summer and fall months, culminating with peak demand in November.

The cost of production is $16 per unit for regular production, $24 for overtime, and $33 for subcontracting. Hiring and firing costs are $500 per worker. Inventory holding costs are $20 per unit per month. There is no beginning inventory. Ten workers are currently employed. Each worker can produce 50 pieces of furniture per month. Overtime cannot exceed regular production. Given the following demand data, use Excel Solver to design an aggregate production plan for XYZ Furniture that will meet demand at the lowest possible cost.

Input:

Beg. Wkrs

10

Regular

$16

Hiring

$500

 

 

Units/wkr

50

Overtime

$24

Firing

$500

 

 

Beg. Inv.

0

Subk

$33

Inventory

$20

 

Month

Demand

Reg

OT

Subk

Inv

#Wkrs

#Hired

#Fired

Jan

500

500

0

0

0

10

0

0

Feb

500

500

0

0

0

10

0

0

Mar

1000

1,000

0

0

0

20

10

0

Apr

1200

1,000

200

0

0

20

0

0

May

2000

1,000

1,000

0

0

20

0

0

Jun

400

400

0

0

0

8

0

12

Jul

400

400

0

0

0

8

0

0

Aug

1000

1,000

0

0

0

20

12

0

Sep

1000

1,000

0

0

0

20

0

0

Oct

1500

1,500

0

0

0

30

10

0

Nov

7000

3,500

3,500

0

0

70

40

0

Dec

500

500

0

0

0

10

0

60

Total

17,000

12,300

4,700

0

0

246

72

72
















Problem 3.

Complete the following MRP matrix for Item X. Determine when orders should be released and the size of those orders.

Item: X

LLC: 0

Period

Lot Size: Min 50

LT: 2

1

2

3

4

5

6

7

8

Gross Requirements

 

25

30

56

25

100

40

30

20

Scheduled Receipts

 

 

50

 

 

 

 

 

 

Projected on Hand

30

 

 

 

 

 

 

 

 

Net Requirements

 

 

 

 

 

 

 

 

 

Planned Order Receipts

 

 

 

 

 

 

 

 

 

Planned Order Releases

 

 

 

 

 

 

 

 

 

Release orders in periods 1 through 5 for quantities of 50, 50, 56, 50, and 50 respectively.

Problem 4.

 

XYZ Incorporated makes products from rough tree fibers. Its product line consists of five items processed through one of five machines. The machines are not identical, and some products are better suited to some machines. Given the following production time in minutes per unit, determine an optimal assignment of product to machine:

 

Machine

Product

A

B

C

D

E

1

17

10

15

16

20

2

12

 9

16

 9

14

3

11

16

14

15

12

4

14

10

10

18

17

5

13

12

 9

15

11

Problem 5- Needs some additional information to complete. The exact problem statement is  "The following probabilistic activity time estimates are for a CPM/PERT network.

Problem 5.


Time Estimates (days)

 

Time Estimates (days)

Activity

a

m

b

Activity

a

m

b

1

1

2

 6

 7

1

1.5

2

2

1

3

 5

 8

1

3

5

3

3

5

10

 9

1

1

5

4

3

6

14

10

2

4

9

5

2

4

 9

11

1

2

3

6

2

3

 7

12

1

1

1

Determine the following:

a. Expected activity times

b. Earliest start and finish times

c. Latest start and finish times

d. Activity Slack

e. Critical Path

Expected Project duration and standard deviation.

2350_CPMPERT diagram.png

Reference no: EM13726053

Questions Cloud

Explain the great compromise and how representation : How the Constitution addressed the complaints in the Declaration of Independence. The Great Compromise and how representation of states in Congress is determined.
Research on infa : Your Research Paper needs to focus on one or more themes covered in this INFA 670 capstone course. Being a capstone course it gives you an opportunity to incorporate knowledge from other INFA courses which you have taken.
Identify an important relationship : Identify an important relationship (co-worker, boss, friend) in which you are having trouble gaining cooperation. Assess this relationship in terms of the influence currency model.
What point does the auther make about religion and terrorism : When talking about the causes of errorism, what point does the auther make about religion and terrorism .
Determine expected activity times : Needs some additional information to complete. The exact problem statement is  "The following probabilistic activity time estimates are for a CPM/PERT network.
Important role that logistics plays in marketing : 100 word discusion on When you reflect on the important role that logistics plays in marketing, what relationships from our other course concepts come to mind for you? Can you share any examples to illustrate your thoughts
Program of javascript : Black Dot Printing is attempting to organize carpools to save energy. Each input record contains an employee's name and town of //residence.
What traditional role of women in society throughout history : What has been the traditional role of women in society throughout history? How does the wealth of a civilization affect the lives of women?
Convey your company image through a logo : What this assignment has taught you about the Object-Oriented programming concept; be sure to use OO terminology to express your thoughts; connections to OO programming may be difficult to make, but you should be able to make some

Reviews

Write a Review

 

Operation Management Questions & Answers

  Determining productivity

One of the students from Op Management class starts a company that produces baseball bats. He/she is the owner and the only employer in the company.

  Compute total cost per year

A grocery store orders paper grocery bags from a distributor. The store uses 2,300 cases of bags per year, and its ordering cost is $65 per order.

  How is ace products organized

Based on the organization chart described in the scenario, how is Ace Products organized? 2. Is Ace likely to be tall or flat? Explain.

  What is the expected profit for the lot size obtained

Determine the lot size that will yield a probability of .90 of producing at least 4 good castings. What is the expected profit for the lot size obtained?

  Discuss ethical issues involved in off shoring & outsourcing

Both big and small U.S. and European companies rely upon foreign companies for everything from software development to financial analysis. Discuss the legal, moral and ethical issues involved in off-shoring and outsourcing.

  What have you learned about the process

If you have been or are involved in forecasting values for a process (could be at work or in your personal life) please relay your experience to the class. What have you learned about the process? Can you think of any ways to change/improve the fo..

  How has amazon become a leader in inventory process control

How has Amazon become a leader in inventory process control?

  Jobe smith has decided to build is manufacturing business

Jobe Smith has decided to build is manufacturing business (lawn mowers in the U.S.) around te production concept. If his approac is taken, what will be Mr. Smith's primary areas of concentration

  Construct a c-chart for test errors

Construct a c-chart for test errors, and set the control limits to contain 99.73% of the random variation in test scores. What does the chart tell you? Has the new math program been effective?

  Which would be more of an issue in asian societies

Of the four conflicts that characterize teenagers, which would be more of an issue in Asian societies where conformity is highly valued.

  Brief discussion of theory in research

This solution offers a brief discussion of how theory is employed in scientific research.

  Define a quality problem in this organisation hint use the

assemble any three 3 suitable lean six sigma techniques that can be used to identify root causes of a possible quality

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd