Question: MUST SOLVE IN EXCEL WITH SOLVER: Do not use critical ratios A job shop must schedule 6 jobs. Information is provided in the table below.

MUST SOLVE IN EXCEL WITH SOLVER:

Do not use critical ratios

A job shop must schedule 6 jobs. Information is provided in the table below. In what order should the jobs be scheduled to minimize the total days the jobs are late. Treat like traveling sales man question.

Job	Time	Due date
1	9	32
2	7	29
3	8	22
4	18	21
5	9	37
6	6	28

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The solution must be optimized uing excel solver if solver isnt available you cant answer the question. Solver is an add-in in excel. You can activate it. MUST SOLVE IN EXCEL WITH SOLVER: Do not use...

Objective: This assignment will involve the use of corporate annual reports, analysis of the relevant information provided within the reports, compare and contrast the information with the...

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

Hi. I need Chapter 11 part 1-4 Let me know. Thanks! (it wont letme add more than $8, but I will give $12+ tip) Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK...

Activity Based Costing (ABC) Background Information: Nick's Woodworking Inc. began operations in 2023 as a manufacturer of picnic tables with attached benches. During its first decade of operations,...

GPS-to-Go: Case Study GPS-to-GO Case You are Joseph Thomas, Vice-President of Operations for GPS-to-GO and responsible for preparing the factory to build, test and ship GO I, II, and II GPS products....

1004 Project Questions Questions and Calculations 1. What is the 30 year fixed "purchase money" market Interest rate at your bank? 2. What is the "APR" for #1? (you do not have to calculate this, it...

The Production manager of the Good Time Wine Rack Company is retiring and the Managing Director is looking to replace her. You are preparing a work schedule as you are hoping to be offered the...

I'm an undergrad accounting student in an introduction to forensic accounting course.I need help getting started on a final project for this class over a fictitious company called the Grand Teton...

Pin Company owns 40,000 of 50,000 outstanding shares of Sum Company, and during 2011, it recognizes income from Sum as follows: Share of Sum net income ($500,000 * 80%) .... $ 400,000 Patent...

For Job 101, company has the following transactions 1. purchased raw material of 100,000 on credit 2. Direct material assigned to WIP is 20,000 and indirect material assigned is 5,000 3. The time...

A taxpayer with earned income within limits can open a Roth IRA at any age, but will need to be aged 1 8 for a traditional IRA

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...