Question: please show all work in excel 2) There are four jobs to be done and four machines with which to do them. Each resource will

please show all work in excel

2) There are four jobs to be done and four machines with which to do them. Each resource will take a specific time, translated to operating costs, to do each job, as shown in the following table: Job B 1 $26 22 19 22 Machine 2 22 17 21 18 3 21 23 22 20 23 21 24 21 D a. What is the result of the row reduction? (10 pts) b. What is the result of the column reduction? (10 pts) c. What is the result of modifying the row and column reductions table? (10 pts) d. What is the optimum assignment of jobs to machines? (5 pts) e. What is the total cost for the optimum assignment of jobs to machines? (5 pts)

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!

HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations. 1) Information on a project's activities is shown in the following table: Activity...

Show on excel and show formulas. please. There are four jobs to be done and four machines with which to do them. Each resource will take a specific time, translated to operating costs, to do each...

PLEASE DO ALL IN EXCEL There are four jobs to be done and four machines with which to do them. Each resource will take a specific time, translated to operating costs, to do each job, as shown in the...

There are four jobs to be done and four machines with which to do them. Each resource will take a specific time, translated to operating costs, to do each job, as shown in the following table:...

2) There are four jobs to be done and four employees to do them. Each resource will take a specific time, translated to salaries, to do each job, as shown in the following table: Employee Job A B C D...

Please show all work in Excel Spreadsheet! The CEO of St. Sebastian Health System, a moderate-sized hospital system in a mid-sized, Midwest city has hired you to help turn things around. The CFO is...

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. There are four jobs to...

Socio-demographic Profile of the Family Charles Henry is currently 32 years old and married to wife, Gwen who 30. They have twin two-year old daughters and do not plan to have more children. They...

this isHVAC Financial Analysis and a case. You have to look at the case to be able to solve the problems and to be able to write a 2 page paper questions ask about the case. Please take a look at...

HVAC Ratio Analysis See Balance Sheet & Income Stmt. in HVAC Case on Canvas. IND LIQUIDITY RATIOS AVG 1994 1992 1993 1 Current 1.4 1.5 1.5 Name _____________________________________________ 1993...

The program execution of Figure 1.4 is described in the text using six steps. Expand this description to show the use of the MAR and MBR.

A producer has the possibility of discriminating between the domestic and foreign markets for a product where the demands, respectively, are (4.5) Total cost = 2000 + 100 where Q=Q +Q. What price...

Berikut yang bukan merupakan jurnal khusus yang terdapat pada perusahaan dagang

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...