Please use description and solve all

ions 1. Formulate the model in some questions the constraints have been filled in other parts have been left blank. 2. Enter your model in Excel and solve it graphically. You should identity and shade in the feasible region as demonstrated on the Camtasia video Save the file with three tabs, one per question. 3. Identify the optimal solution (either using the Zoom-in feature) or using the LP solver Add on from Excel and fill in the blanks at the end of each question. 4. "List any alternative optimal solutions on your excel sheet by determining the coordinates of all the extreme optimal points which make up the feasible region and list these together with their value ($). 5. Each excel solution should be saved on a separate worksheet of the same workbook. You should submit your workbook in addition to the Blackboard "Test solutions for participation credit. QUESTION 1 A senior class of 420 students will rent buses and vans for a class trip. Each bus can transport 50 students and 3 chaperones and costs $1200 to rent. Each van can transport 10 students and 1 chaperone and costs $100 to rent. There are 36 chaperones available (so they can't all go in vans). How many vehicles of each type should be rented in order to minimize the cost? Linear Programming Model Objective Function (Max or Min): subject to : Non-negativity: Optimal Solution: B = V- Cost =$ QUESTION 2 The Sureset Concrete Company produces concrete. Two ingredients in concrete are sand (costs $6 per ton) and gravel (costs $8 per ton). Sand and gravel together must make up exactly 75% of the weight of the concrete. Also, no more than 40% of the concrete can be sand and at least 30% of the concrete be gravel. Each day 2000 tons of concrete are produced. To minimize costs, how many tons of gravel and sand should be purchased each day? Linear Programming Model Objective Function (Max or Min): subject to LHS SYMBOL (0.40-2000) LHS SYMBOL (0.30 2000) LHS SYMBOL 0.75 2000 X: Y>0 Optimal Solution: X= YE Cost-$ QUESTION 3 A ship has a single cargo hold which has a weight capacity of 70,000 pounds and a volume capacity of 30,000 cubic feet. The shipowner has contracted to carry loads of packaged beef. The total weight of the available beef is 65,000 pounds; the total weight of the available grain is 75,000 pounds. The volume per mass of the beef is 0.2 cubic foot per pound, and the volume per mass of the grain is 0.4 cubic foot per pound. The profit for shipping beef is $0.35 per pound, and the profit for shipping grain is $0.12 per pound. The shipowner is free to accept all or part of the available cargo; he wants to know how much meat and grain to accept in order to maximize profit Linear Programming Model Objective Function (Max or Min): subject to Volume: Weight Capacity Beef Weight Grain Weight Non-negativity Optimal Solution: Beef = Grain = Profit = $ ions 1. Formulate the model in some questions the constraints have been filled in other parts have been left blank. 2. Enter your model in Excel and solve it graphically. You should identity and shade in the feasible region as demonstrated on the Camtasia video Save the file with three tabs, one per question. 3. Identify the optimal solution (either using the Zoom-in feature) or using the LP solver Add on from Excel and fill in the blanks at the end of each question. 4. "List any alternative optimal solutions on your excel sheet by determining the coordinates of all the extreme optimal points which make up the feasible region and list these together with their value ($). 5. Each excel solution should be saved on a separate worksheet of the same workbook. You should submit your workbook in addition to the Blackboard "Test solutions for participation credit. QUESTION 1 A senior class of 420 students will rent buses and vans for a class trip. Each bus can transport 50 students and 3 chaperones and costs $1200 to rent. Each van can transport 10 students and 1 chaperone and costs $100 to rent. There are 36 chaperones available (so they can't all go in vans). How many vehicles of each type should be rented in order to minimize the cost? Linear Programming Model Objective Function (Max or Min): subject to : Non-negativity: Optimal Solution: B = V- Cost =$ QUESTION 2 The Sureset Concrete Company produces concrete. Two ingredients in concrete are sand (costs $6 per ton) and gravel (costs $8 per ton). Sand and gravel together must make up exactly 75% of the weight of the concrete. Also, no more than 40% of the concrete can be sand and at least 30% of the concrete be gravel. Each day 2000 tons of concrete are produced. To minimize costs, how many tons of gravel and sand should be purchased each day? Linear Programming Model Objective Function (Max or Min): subject to LHS SYMBOL (0.40-2000) LHS SYMBOL (0.30 2000) LHS SYMBOL 0.75 2000 X: Y>0 Optimal Solution: X= YE Cost-$ QUESTION 3 A ship has a single cargo hold which has a weight capacity of 70,000 pounds and a volume capacity of 30,000 cubic feet. The shipowner has contracted to carry loads of packaged beef. The total weight of the available beef is 65,000 pounds; the total weight of the available grain is 75,000 pounds. The volume per mass of the beef is 0.2 cubic foot per pound, and the volume per mass of the grain is 0.4 cubic foot per pound. The profit for shipping beef is $0.35 per pound, and the profit for shipping grain is $0.12 per pound. The shipowner is free to accept all or part of the available cargo; he wants to know how much meat and grain to accept in order to maximize profit Linear Programming Model Objective Function (Max or Min): subject to Volume: Weight Capacity Beef Weight Grain Weight Non-negativity Optimal Solution: Beef = Grain = Profit = $