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 fast-food 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 stand-alone facilities with drive-through and sit-down capabilities (the company cannot open a partial location). The company has identified five prospective sites for lunch counter operations, each of which costs $150,000 in start-up, generates an annual return of $85,000, and creates nine jobs. There are seven potential mall locations, each of which costs $275,000 in start-up, generates an annual return of $125,000, and creates seventeen jobs. Finally, there are three possible stand-alone locations, each of which costs $450,000 in start-up, generates an annual return of $175,000, and creates thirty-five jobs. The company has $2,000,000 available for start-up 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 2a. b) Solve the linear optimization model that maximizes the annual return. o Create a copy of your 2a worksheet, make the necessary adjustments, and label this new worksheet 2b. 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 2a or 2b worksheet, make the necessary adjustments, and label this new worksheet 2c. 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 2c worksheet, make the necessary adjustments, and label this new worksheet 2d.

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 Finance Questions!