MachinCo runs a custom machine shop. Four jobs have to be done today. These are five machines,

Question:

MachinCo runs a custom machine shop. Four jobs have to be done today. These are five machines, each of which can do at most one job per day. The costs of doing each job on each machine are as follows:

Jobl Job 2 Job 3 Job 4 Machine 1 14 Machine 2 2 12 Machine 3 9. Machine 4 2 10 Machine 5

Job 1 Job 2 Job 3 Job 4 Machine 1 14 Machine 2 2 12 Machine 3 8. Machine 4 2 6. 10 Machine 5 8.

MachinCo runs a custom machine shop Four jobs have to be done today There are five machines
Based on the question and the spreadsheet above, write the necessary value/formula etc. to the following cells. Make sure your answers will yield correct results when copied to other cells.
€¢ What value should be in cell 1)6?
€¢ What formula should be in cell 14 to write the total cost?
€¢ What formula should be in cell F12?
€¢ What sign should be in cell C14?
€¢ What value should be in cell 1116?
etc. to the following cells. Make sure your answers will yield correct results when copied to other cells.
€¢ What value should be in cell D6?
€¢ What formula should be in cell 14 to write the total cost?
€¢ What formula should be in cell F12?
€¢ What sign should be in cell C14?
€¢ What value should be in cell 1116?
€¢ What formula should be in cell B17?
€¢ What sign should be in cell C18?
€¢ What value should be in cell E19?
€¢ What will be in the "Target Cell" part in Solver? Should it be maximized or minimized?
€¢ What will be in the "Changing Cells" part in Solver?
€¢ What will be in the "Constraints" part in Solver?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 50% (8 reviews)

Step1 Decide decision variables X 1 to X 20 Step2 Formulate objective function Maximize 14X 1 5X 2 8...View the full answer

Answered By

Salmon ouma

I am a graduate of Maseno University, I graduated with a second class honors upper division in Business administration. I have assisted many students with their academic work during my years of tutoring. That has helped me build my experience as an academic writer. I am happy to tell you that many students have benefited from my work as a writer since my work is perfect, precise, and always submitted in due time. I am able to work under very minimal or no supervision at all and be able to beat deadlines. I have high knowledge of essay writing skills. I am also well conversant with formatting styles such as Harvard, APA, MLA, and Chicago. All that combined with my knowledge in methods of data analysis such as regression analysis, hypothesis analysis, inductive approach, and deductive approach have enabled me to assist several college and university students across the world with their academic work such as essays, thesis writing, term paper, research project, and dissertation. I have managed to help students get their work done in good time due to my dedication to writing.

5.00+ 4+ Reviews 16+ Question Solved

Related Book For book-img-for-question

Data Analysis and Decision Making

ISBN: 978-0538476126

4th edition

Authors: Christian Albright, Wayne Winston, Christopher Zappe

See More Books

Question Posted: Mar 05, 2018 11:08 AM

See More Questions

MachinCo runs a custom machine shop. Four jobs have to be done today. These are five machines,

Question:

Jobl Job 2 Job 3 Job 4 Machine 1 14 Machine 2 2 12 Machine 3 9. Machine 4 2 10 Machine 5 Job 1 Job 2 Job 3 Job 4 Machine 1 14 Machine 2 2 12 Machine 3 8. Machine 4 2 6. 10 Machine 5 8.

Step by Step Answer:

Step1 Decide decision variables X 1 to X 20 Step2 Formulate objective function Maximize 14X 1 5X 2 8...View the full answer

Data Analysis and Decision Making

Students also viewed these Corporate Finance questions