Question: Please focus on the excel and solver portion of this problem and its steps in detail, I cannot seem to get solver to find a
Please focus on the excel and solver portion of this problem and its steps in detail, I cannot seem to get solver to find a feasible solution for the LP model. Thank you!
The Adler Machine Company is planning to add a new product to its line and wishes to hire some experienced machinists. The local union has advised them that machinists are categorized in one of three skill levels: expert, associate, and apprentice. An expert machinist has at least years of experience and is expected to produce units per day. An associate machinist must have at least years of experience and can produce units per day. An apprentice machinist must have at least year of experience and must be able to produce units per day. The union contract calls for wages of $$and $per hour for the three skill levels. Currently, there are expertsassociate and apprentice machinists available for hire. Adler has budgeted $per day, hourweek for machinists' wages. They would like to hire a crew of new machinists that will yield the highest output rate. To keep both the union and present employees happy, they need to ensure that the total level of experience of the workers hired represents a seniority level of at least workeryears. Formulate the linear program that determines the number of machinists of each type that should be hired. Describe the objective function for this LPMust the decision variables be nonnegative? Create a spreadsheet with a table containing the appropriate values. Label each of the constraints and give the units of each resource represented. Run Solver on your spreadsheet to obtain the optimal values for the decision variables in your Linear Programming Model. Answer the following questions, based on this nonintegersolution: How many units per week are produced, based on this solution? How many are made by experts? How many by associates and how many by apprentices? What is the total number of workeryears of experience with the crew suggested by the model solution? Would it be worth trying to negotiate with the union to set a lower requirement? How much of the weekly salary budget is paid to the crew members in the solution suggested by your model? Suppose a ninth associate machinist becomes available, would it be worthwhile to hire this individual, keeping in mind that the total salary budget is fixed? Explain. Adjust the solution suggested by your model by making sure that the number of hires at each level is an integer iea whole numberDescribe the differences between this new solution and the optimal one. Extra Credit: Briefly explain why your adjusted solution cannot result in a higher level of unit production.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
