Question: Please use excel solver step by step so I can understand how to do this. 2. A company is planning to open a maximum of

Please use excel solver step by step so I can understand how to do this.
2. A company is planning to open a maximum of 11 new stores in Chicago. The stores will be built in one of three sizes: a convenience store (open 24 hrs.), a standard store, and an expanded service store. The convivence store requires $4.1215 million to build and 30 employees to operate. The standard store requires $8.25 million to build and 15 employees to operate. The expanded-services store requires $12.375 million to build and 45 employees to operate. The company can dedicate up to $82.5 million for construction, and 300 employees to staff the stores. On average, the convenience store nets $1.2 million annually, the standard store nets $2 million and the expanded service store nets $2.6 million annually. How many of each store should the company build to maximize revenue? Use excel solver
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
