A workshop has 6 machines

Assignment Help Operation Management

Reference no: EM13153875

Integer Programming

A workshop has 6 machines that can perform any job assigned to them. The workshop has 10 jobs that it needs to complete over two days. Jobs 1 to 5 must be finished on the first day and jobs 6 to 10 must be finished on the second day. Any of the machines will take a complete day to finish any of the jobs. The workshop manager requires that none of the machines stay idle for the two days. Write an integer programming model that would minimize the total costs of running the 10 jobs. The cost per job per machine is given in Table 2.

Table 2
Job 1 Job 2 Job 3 Job 4 Job 5 Job 6 Job 7 Job 8 Job 9 Job 10
Machine 1 $85 $75 $80 $65 $80 $90 $85 $55 $60 $100
Machine 2 $82 $76 $78 $63 $80 $85 $82 $54 $58 $90
Machine 3 $87 $77 $82 $60 $82 $90 $87 $54 $62 $102
Machine 4 $79 $72 $76 $59 $78 $85 $77 $53 $56 $90
Machine 5 $90 $78 $84 $70 $85 $93 $90 $57 $64 $97
& have to solve it using Solver in Excel.

Reference no: EM13153875

Questions Cloud

Determining company net operating income : The Governmental Products Division's divisional segment margin is $255,000 and the Export Products Division's divisional segment margin is $59,800. The total amount of common fixed expenses not traceable to the individual divisions is $163,700. Wh..

Cost in a separate land account : Northwood paid $150,000 in cash. Record the purchase in the journal, identifying each lot's cost in a separate Land account. Round decimals to three places, and use your computed percentages throughtout.

Provide a managerial interpretation of estimated slope : Consisting of tire sales (in thousands of tires) and advertising expenditures (in thousands of dollars). The equation of the least squares line is, y = 3 + 1x. Provide a managerial interpretation of the estimated slope.

What is her new optimal consumption of z : Now suppose Alex's income increases to $1,500 per year. What is her new optimal consumption of x? What is her new optimal consumption of z?

A workshop has 6 machines : A workshop has 6 machines that can perform any job assigned to them. The workshop has 10 jobs that it needs to complete over two days. Jobs 1 to 5 must be finished on the first day and jobs 6 to 10 must be finished on the second day

Find the net amount to be paid the employee : hours worked, 46; federal income tax withheld, $354; cumulative earnings for year prior to current week, $95,735; social security tax rate, 6.0% on maximum of $111,091; and Medicare tax rate, 1.5% on all earnings. What is the net amount to be paid..

Calculate ksp for mg(oh)2 : Magnesium Hydroxide is a slightly soluble substance. If the pH of a saturated solution of Mg(OH)2 is 10.49 at 25 degrees celcius, calculate Ksp for Mg(OH)2.

What will happen in the market for personal computers : what will happen in the market for personal computers? How will the equilibrium price and equilibrium quantity of personal computers change?

Find probability to answer all ten questions incorrectly : Since he has not attended class recently, he doesn't know any of the answers. Assuming that he guesses on all 10 questions, find the following: What is the probability that he will answer all ten questions incorrectly?

User Account

All Pages