1 point for variable definition 1 point for objective function 4 points for

# 1 point for variable definition 1 point for objective

This preview shows page 3 - 7 out of 9 pages.

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