Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Excel to solve linear programming problems Technology can be used to solve a system of equations once the constraints and objective function have

 

Using Excel to solve linear programming problems Technology can be used to solve a system of equations once the constraints and objective function have been defined. Excel has an add-in called the Solver which can be used to solve systems of equations or inequalities 1. 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 i an expanded services 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 expanded services store nets $2.6 million annually. How many of each should they build to maximize revenue? (a) Identify decision variables. (b) Write the mathematical model of the corporation.. (e) Use Excel Solver to obtain the optimum solution. 2. Use excel solver to find the optimal solution minimize subject to 42r1 +52 +1723. 321-22+72325 -371-y+373 28 6z1+z2+z3 216 21. 22, and 220

Step by Step Solution

3.48 Rating (165 Votes )

There are 3 Steps involved in it

Step: 1

Solution Identify decision variables The decision variables are x1 number of conv... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Discovering Advanced Algebra An Investigative Approach

Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke

1st edition

1559539844, 978-1604400069, 1604400064, 978-1559539845

More Books

Students also viewed these Computer Network questions