Golden plates are produced for electronic circuit

Assignment Help Operation Management

Reference no: EM132239772

Consider a single machine production system in which thin golden plates are produced for an electronic circuit. The target plate thickness is 2 + (or -) 0.2 millimeters (plates with 1.8-2.2 mm thickness are acceptable). The historical data shows that the thickness of the golden plates that have been produced by the current machine (Model A) has a normal distribution with a mean of 2 mm and a standard deviation of 0.2 mm. Assume that each plate production has an independent success probability to meet the quality requirements and you have a contract to deliver 20 good items each day to a client. You would like to determine how many items to produce.

a) Calculate the probability of meeting the golden plate demand if 15, 16, 17 ,…, 40 plates are produced (Hint: Use BINOM.DIST.RANGE function). Generate an Excel chart to illustrate your calculations.

b) Find the production quantities that will satisfy the golden plate demand with 90 and 95% probabilities.

c) Construct a scroll bar to control plate thickness standard deviation for our production to see how the results of part 3.a and 3.b would change with the increase or decrease in the standard deviation

d) Now assume that:

Each plate requires 90 minutes machine time.

Machines can be operated for 8 hours a day and they require 30 minutes recalibration to start production at the beginning of each day.

Due to the failures the availability factor is estimated to be 0.9 for the machines.

Considering the daily production amount you determined in part b for %95 percent demand satisfaction probability.

e) Assume that Model A machine cost 10.000$ to purchase (we don’t consider the operating costs). Build a decision support tool (a fancy name for a useful Excel sheet!) for the facility managers that can calculate the worth of a new machine configuration for a given:

Machine time required to produce one plate,

Standard thickness deviation (assume mean is always the target thickness of 2 mm),

Machine set up time at the beginning of the day,

Availability factor.

Reference no: EM132239772

Questions Cloud

Use of standard templates and macros : What are two methods of self-directed training that can be used when implementing training on the use of standard templates and macros?

Designing a logical and physical topographical layout : Design a logical and physical topographical layout of the current and planned network through the use of graphical tools in Microsoft Word or Visio.

What makes up a good team : What makes up a good team? Meaning - what are some factors that would make a team cohesive and work together well?

Individual report of decision making : A manager has to make and implement decisions as part of his role. Being a future manager in the contemporary business environment

Golden plates are produced for electronic circuit : Consider a single machine production system in which thin golden plates are produced for an electronic circuit.

Discuss the question from that perspective : Think back to organizations where you have worked or are now working. Based upon your experience in this organization

Portrayed as having negative impact on environment : We have seen in the news how certain companies are portrayed as having a negative impact on the environment either through carelessness or negligence.

Evaluate the reasons to outsource goods or production : CIS 110 Evaluate the reasons to outsource goods, services, or production. Considering today's business climate, give your opinion on the most logical reason.

What is the 8-step sales call : What is the 8-step sales call and Do you have to follow all 8 steps? If so do you always follow them in order?

User Account

All Pages