Question: Help me with my linear programming homework pleaae ! A moving company that operates within Los Angeles has decided to replace its entire fleet of
Help me with my linear programming homework pleaae !
A moving company that operates within Los Angeles has decided to replace its entire fleet of trucks with two types of trucks: small trucks and large trucks. The two truck types are different in that large trucks have a higher purchase cost, can carry shipments of higher weight, and are operated by more workers. The company only has 90 workers available and 80 parking spaces for overnight parking of all trucks. Also the company would like to maintain a minimum weight capacity of 60 tons across its fleet. The objective is to minimize the total purchasing cost. Here is the structure of the linear program corresponding to this problem: L= number of large trucks to S = number of small trucks to purchase purchase Min total purchase cost Subject to: weight capacity provided by both truck types 2 60 total parking space used by all trucks s 80 total number of workers required to operate trucks = 90 L20, S20 Below is the Excel sensitivity report for this problem. The values marked as "Not Given" are intentionally removed. Below is the Excel sensitivity report for this problem. The values marked as "Not Given" are intentionally removed. Variable Calls Call Name 5C54 Purchase large truck 5054 Purchase small truck Final Reduced Value Cost 0 4000 75 Not given Objective Allowable Coefficient Increase 40000 1E30 24000 2000.000067 Allowable Decrease 4000 24000 Constraints Call Name SES7 Weight capacity Total SEB Partong space to SEO Workers Total Final Shadow Constraint Value Price R.H. Side 60 30000 0 75 Not given 30 75 0 90 Allowable Increase 4 1E+30 16.30 Allowable Decrease 00 5 15 What is the optimal number of small trucks to purchase? (enter as a whole number) 75 What is the optimal total purchase cost? (enter as a whole number) 24000 If the seller of trucks decreases its prices of both trucks by 5%, what would be the new optimal number of small trucks to purchase? Enter as a whole number, or enter the value - 1000 if it cannot be determined only using the sensitivity report - 1000 What is the maximum additional wage the company is willing to pay per worker to hire more workers? Enter as a whole number, or enter the value - 1000 if it cannot be determined only using the sensitivity report. The price of large trucks should drop by how much until it is beneficial to buy any large trucks? Enter as a whole number, or enter the value - 1000 if it cannot be determined only using the sensitivity report. The price should drop by at least How much would the optimal total cost change if the weight capacity decreases by 2.5 tons and at the same time, the number of available workers increases by 3 workers? Enter a negative number for reduction in total cost. Enter as a whole number, or enter the value - 1000 if it cannot be determined only using the sensitivity report. What should be the shadow price for the parking space constraint (instead of the "Not Given" value)? Enter as a whole number, or enter the value - 1000 if it cannot be determined only using the sensitivity report information



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
