Question: Show how to build the following problems into models in Excel to find the optimal solution, with different worksheets. Bao House is a rapidly growing
Show how to build the following problems into models in Excel to find the optimal solution, with different worksheets. Bao House is a rapidly growing fastfood chain. The company is looking at expanding three of their different location types: lunch counters that are placed in office buildings in downtown areas; a food court location for shopping malls; and standalone facilities with drivethrough and sitdown capabilities the company cannot open a partial location The company has identified five prospective sites for lunch counter operations, each of which costs $ in startup generates an annual return of $ and creates nine jobs. There are seven potential mall locations, each of which costs $ in startup generates an annual return of $ and creates seventeen jobs. Finally, there are three possible standalone locations, each of which costs $ in startup generates an annual return of $ and creates thirtyfive jobs. The company has $ available for startup costs in the next year and would like to expand in a way that maximizes annual returns and the number of jobs created. a Solve the linear optimization model that maximizes the number of jobs created. o Label this worksheet a b Solve the linear optimization model that maximizes the annual return. o Create a copy of your a worksheet, make the necessary adjustments, and label this new worksheet b c Revise the model to determine the solution that will minimize the maximum percentage deviation from the optimal objective function values with equal importance o Create a copy of your a or b worksheet, make the necessary adjustments, and label this new worksheet c d Find the optimal solution if the company considers maximizing annual returns to be three times as important as maximizing the number of jobs created. o Create a copy of your c worksheet, make the necessary adjustments, and label this new worksheet d
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
