09 Jun BADM 3963 LP Solutions Homework
Question
Write answers to #1 & #2 in a Word document
Set up and solve #3 and #4 in Excel using LP Solver.
Report the optimal solutions and objective function results for #3 & #4 in your Word document
Submit both Word and Excel files in BB Assignment, due July 13, 9pm
1. The graph shown below has been drawn to solve the following LP problem:
Maximize 100A +100B
Subject to
Constraint 1
2A + 4B <= 400
Constraint 2
100A + 50B <= 8000
Constraint 3
A <= 60
Use the graph to answer the questions below
1a. What are each of the following arrows pointing to?
D_________
E________
F________
G_________
H__________
1b. Which of the corner points (labeled S, T, W, X, Y and Z) is the optimal solution?
1c. Solve for the exact coordinates of the optimal solution.
Show your work
2. Write the LP formulation for the following problem.
Metro Food Services Company delivers fresh sandwiches each morning to vending machines throughout
the city. The company makes three kinds of sandwiches ham and cheese, bologna and chicken salad. A
ham and cheese sandwich requires a worker 0.45 minutes to assemble, a bologna sandwich requires 0.41
minutes, and a chicken salad sandwich requires 0.50 minutes to assemble. The company has 960
available minutes each night for sandwich assembly. Vending machine capacity is available for 2000
sandwiches each day. The profit for a ham and cheese sandwich is $0.35, for a bologna sandwich is
$0.42, and for a chicken salad sandwich is $0.37. The company knows from past sales records that its
customers buy as many or more of the ham and cheese sandwiches than the other two types combined,
but customers need a variety of sandwiches available, so Metro stocks at least 200 of each. Metro
management wants to know how many of each sandwich it should stock to maximize profit.
3. Set up and solve using Excel Solver: Candy problem (Choco-Slugs & Baby Maximx) from LP
homework #1. Make sure that you have the correct formulation.
4. Set up and solve the following LP problem using Excel Solver
A = the number of pounds of food A in daily diet
B = the number of pounds of food B in daily diet
Minimize total cost = 7A + 3B
St
Vitamin X required
Vitamin Y required
Calories limit
3.4A + 1.5B >= 12
2.2A + 0.7B >= 6
200A + 250 B < 2000
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.