Question: You are asked to solve the following Linear Programming (LP) problem. Objective: Maximize 1.50A +3.00B, Subject to the following constraints: -(3mathrm{~A}+2mathrm{~B}leq 600)-(2mathrm{~A}+4mathrm{~B}leq 600)-(mathrm{A}+3mathrm{~B}leq 420)-(mathrm{A}geq 0)-(mathrm{B}geq
You are asked to solve the following Linear Programming (LP) problem. Objective: Maximize 1.50A +3.00B, Subject to the following constraints: -\(3\mathrm{~A}+2\mathrm{~B}\leq 600\)-\(2\mathrm{~A}+4\mathrm{~B}\leq 600\)-\(\mathrm{A}+3\mathrm{~B}\leq 420\)-\(\mathrm{A}\geq 0\)-\(\mathrm{B}\geq 0\) a.(15 points) Graphical Solution - Plot the constraints on the grid provided below. - Clearly identify the feasible region and label its corner points. - Show all calculations and explain how you identified the feasible region and corner points. - Once you complete the graph, copy and paste it as a screenshot (using PrintScreen) into your report. b.(20 points) Analytical Solution - Calculate and report the optimal product mix (i.e., values of A and B ) that maximizes the objective function. - Clearly explain how you arrived at this solution. e.(15 points) Excel Solver Solution - Reproduce this problem in Excel and solve it using Excel's Solver. - Include two printouts as exhibits at the end of your report: 1. The Excel Solver Sheet showing your model setup and solution. 2. The Solver Answer Report generated by Excel. (You may insert screenshots using PrintScreen). Important Submission Instructions: - Save your entire report as one single PDF file. - Reports missing Excel Solver printouts will automatically receive 0 points for section e.- Please note that the Excel Solver task (Section e) requires you to personally build the model in Excel, run Solver, and generate your own screenshots of the Solver Setup and Answer Report.- Submitting copied or reused screenshots from classmates, the internet, or any external source will not meet the task requirements and will be considered a breach of academic integrity.- The goal of this task is for you to demonstrate your own ability to set up and solve optimization problems using Excel Solver. Your submission must reflect your own work.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
