Question: Please answer question #2. Formulate a mathematical model and solve the model using Excel Solver. Thank you. 2. A corporation plans on building a maximum

Please answer question #2. Formulate a mathematical model and solve the model using Excel Solver. Thank you.
2. A corporation plans on building a maximum of 11 new stores in a large city. They will build these stores in one of three sizes for each location - a convenience store (open 24 hours), standard store, and an expandedservices store. The convenience store requires $4.125 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 corporation can dedicate $82.5 million in construction capital, and 300 employees to staff the stores. On the average, the convenience store nets $1.2 million annually, the standard store nets $2 million annually, and the expandedservices store nets $2.6 million annually. How many of each should they build to maximize revenue? Submission Formulate a Mathematical model and solve the model using Excel Solver. Submit both word document and excel file that show mathematical model and solver resultsStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
