Question
The Chick'n-Pick'n fast-food chain is considering how to expand it' operations. 3 types of retail outlets are possible: a lunch counter operation designed for office
The Chick'n-Pick'n fast-food chain is considering how to expand it' operations. 3 types of retail outlets are possible: a lunch counter operation designed for office buildings in downtown areas, an eat-in operation designed for shopping malls, and a stand a-lone building with drive-through and sit-down facilities. The following table summarizes the number of jobs, start-up costs, and annual returns associated with each type of operation:
Lunch Counter: 9 Jobs, $150,000 costs and $85,000 returns
Mall: 17 Jobs, $275,000 costs, and $125,000 returns
Stand-alone: 35 jobs, $450,000 costs and $175,000 returns
The Company has $2,000,000 available to pay start-up costs for new operations in the coming year. Additional, there are five possible sites for lunch counter operations, seven possible mall locations, and three possible stand-alone locations. The company wants to plan its expansion in a way that maximizes annual returns and the number of jobs created.
a. Formulate an MOLP for this problem
b. Determine the best possible value for each objective in the problem.
c. Implement model in a spreadsheet and solve it with Excel Solver to determine the solution that minimizes the maximum % deviation from the optimal objective function values. What solution do you obtain?
d.Suppose management considers maximizing returns 3 times as important as maximizing the number of jobs created. What solution does this suggest?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started