Question: At a machine tool plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used

At a machine tool plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job. If a machine is used at all, a setup time is required. The relevant times (in minutes) are given in the file P06_59.xlsx.

a. Determine how to minimize the sum of the setup and machine operation times needed to complete all jobs.

b. Use SolverTable to see how a change in the setup time for machine 4 changes the optimal solution.

c. Use SolverTable to see how a change in the required time for machine 1 to complete job 3 changes the optimal solution.

Step by Step Solution

★★★★★

3.35 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Assigning jobs to machines Times to do jobs large times mean machine cant do job and setup times Job ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (3 attachments)

1497_60b741248db0e_696575.pdf

180 KBs PDF File

1497_607c14f689128_696575.xlsx

300 KBs Excel File

1497_60b741248db0e_696575.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!

Modify the machine-to-job assignment model under the assumption that only three of the four jobs must be completed. In other words, one of the four jobs does not have to be assigned to any machine....

A machine tool, which has been used in a plant for 10 years, is being considered for replacement. It cost $9500 and was depreciated by MACRS depreciation using a 5-year recovery period. An equipment...

Albert Machine Tool Company produces tools on a job order basis. During May, two jobs were completed, and the following costs were incurred: Other factory costs for the month totaled $16,800. Factory...

At a machine tool plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job, but not every machine can handle every job. If a machine is...

3 . 2 At a machine tool plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job, but not every machine can handle every job. If a...

At a machine tool plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job. If a machine is used at all, there is a setup time required....

Problem 2: At a machine tool plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job. If a machine is used at all, there is a setup...

23 At a machine tool plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job. If a machine is used at all, there is a setup time...

At a die setting plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job. If a machine is used at all, there is a setup time required....

At a die-setting plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job. If a machine is used at all, there is a setup time required....

The Case Study is in the Attached file Please answer the following: 1. Discuss the American pricing paradox. Use the concepts of scarcity and value to explain why Americans would want to pay higher...

Suppose a firm has several divisions, each with a unique area of business. What role does the firm-wide weighted average cost of capital play when determining a project's cost of capital in a given...

Elmwood Manufacturing reported sales of $ 2 , 0 0 0 , 0 0 0 last year ( 1 0 0 , 0 0 0 units at $ 2 0 each ) , when the break - even point was 8 0 , 0 0 0 units. Elmwood's margin of safety ratio is 1...

6.14 This exercise is associated with the proof of Theorem 6.14. Parts (i)(iii) are regarding the necessity part, where Xni = (Xi )/ n; whereas part (iv) is regarding the sufficiency part, where...

Limited liability companies (LLCs) are very popular today as a form of organization. Assume a client asks you to explain what this type of organization is all about. Prepare a brief description of...

For flow-through entities, such as partnerships, how does the tax law use partner basis adjustments to prevent double taxation of partnership income?

Partnerships and S corporations are flow-through entities. In connection with filing annual tax returns, these entities must include Form K-1 in the returns. What is Form K-1, what is its purpose,...

The Triquel Theater Inc. was recently formed. It began operations in March 2017. The Triquel is unique in that it will show only triple features of sequential theme movies. On March 1, the ledger of...

On January 1, 2015, Extensive Manufacturing purchased a machine for $1.050.000 that is expected to have a sette of five years. The company estimated that the residual value of the machine was...

Given the following models and corresponding OLS output, where Commodity Housing Price (P) One Year Lagged Housing Price (P t-1 ) Commodity Housing Price in the Secondary Housing Market (Ps)...