2.Solve the problem using the graphical method (specifically the corner point method) and show all of your work. Shade in the feasible solution region on your graph. 5 points for graph -Elements to look for in the graph -All constraint graphed correctly -FSR shaded -Solved intersections using 2-equations-2-unknowns
ADM2302 X Business Analytics Assignment 1Spring / Summer 2019 4To get full marks, students must show how they solved 2-equations-2-unknowns for the last two corner points. The optimal solution is to put $666.67 towards the social media influencer and $333.33 towards search engine optimization. The total number of people visiting the website will be 6000. 50050010001000X2X1
ADM2302 X Business Analytics Assignment 1Spring / Summer 2019 53.Solve the problem using Excel Solver and show all of your work (i.e., include the Excel formulation and answer report in your submission). 1 point for Excel layout 1 point for answer report 4.Provide a managerial statement that summarizes your solution for management. 2 points for managerial statement Problem 3: Solve the following linear programming models graphically and explain the solution results based on the different solution types we discussed in class. 5 points for each formulation -3/5 for the graph -2/5 for the explanation X1X2Number of visitors per dollar58Total visitorsAmount to allocate666.666667333.3333336000LHSRHSTotal111000 <=100025% minimum0.75-0.25416.666667 >=025% minimum-0.250.7583.3333333 >=0SMI twice SEO1-20 >=0Objective Cell (Max)CellNameOriginal ValueFinal Value$E$3Amount to allocate Total visitors60006000Variable CellsCellNameOriginal ValueFinal ValueInteger$B$3Amount to allocate X1666.6666667666.6666667 Contin$C$3Amount to allocate X2333.3333333333.3333333 ContinConstraintsCellNameCell ValueFormulaStatusSlack$D$6Total LHS1000 $D$6<=$F$6Binding0$D$725% minimum LHS416.6666667$D$7>=$F$7Not Binding416.6666667$D$825% minimum LHS83.33333333$D$8>=$F$8Not Binding83.33333333$D$9SMI twice SEO LHS0 $D$9>=$F$9Binding0
ADM2302 X Business Analytics Assignment 16
You've reached the end of your free preview.
Want to read all 9 pages?