Question: a) Graph the constraint lines and mark them clearly with the numbers (1), (2) and (3) to indicate which line corresponds to which constraint. Darken

a) Graph the constraint lines and mark them
a) Graph the constraint lines and mark them
a) Graph the constraint lines and mark them clearly with the numbers (1), (2) and (3) to indicate which line corresponds to which constraint. Darken the feasible region. (12 points) You can NOT use a software that automatically does the plotting: you are NOT allowed to use DESMOS or any similar tool. Plotting using Excel, a paint tool or hand plotting is OK. If you wish to use a graph paper" to assist you with plotting, one is provided below (check page 4). (b) Using the graphical method, how many of each size should the architect's design provide? What is the annual revenue? Report the solution in a managerial statement (ie, describe verbally the optimal solution and its profit). Provide all necessary calculations to justify your answers. (8 points) (C) The bank would like to add a mini size box, which will rent for $35 per year and will consume 0.3 square feet of wall space. The bank will now require at least 30 mini boxes, at least 100 small boxes, and at least 40 large boxes. Further, the bank wants the total area of the large boxes to be at least 50% of the available space. How many boxes of each type should the architect include and what is the total annual revenue? Formulate the linear programming problem on a spreadsheet and SOLVE using Excel Solver (Provide the corresponding "Excel Spreadsheet" and the "Answer Report on this document). Include managerial statements" that communicate the results of the analysis. as describe verbally the results) (16 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!