Please help me with the below Study question...It is using Excel Solver, and I a
ID: 2643895 • Letter: P
Question
Please help me with the below Study question...It is using Excel Solver, and I am having a terrible time trying to understand it. Each of the questions (below the table) need to be answered, but the red cells can't be changed. I need someone who is willing to explain what they did in each of the steps so I can understand how you came to that answer...
Question from book is located here:
https://books.google.com/books?id=cUHAAgAAQBAJ&pg=PA752&lpg=PA752&dq=Spreadsheet+modeling+and+decision+analytics+case+3.4&source=bl&ots=wujrO8abeL&sig=DZcHmcyZmZei9L5URV70PLKiK5o&hl=en&sa=X&ei=0NYeVeLcJcHJsAWPlYGYCA&ved=0CB8Q6AEwAA#v=onepage&q=manatees&f=false
Question 3 - Machine 3 has recently begun acting up and the owner feels it must be used consistently--producing at least 40% of its own capacity--in order to get back to normal working condition. Incorporate this decision and give the resulting optimal solution (give total cost only after re-solving the problem).
Question 4 - Last week, Machine 5 suffered a catastrophic failure injuring an employee. The machine cannot be used for the next six weeks until parts are received and the machine is fixed. In light of this issue, management would like to ensure the load typically absorbed by Machine 5 is spread evenly over the other five machines--regardless of whether they are typically used or not (note in the original solution that Machine 5 contributes 600 shoes so that number must be absorbed and spread equally over the other 5 machines as a minimum number made per machine). What is the resulting optimal solution (give total cost only after re-solving the problem.
Explanation / Answer
Q4 Answer:
Machine 5 contributes 600 Shoes. So this work need to be done on other 5 machines so this machines need to produce extra 120 shoes to cover machines 5 contribution with its original production capacity.