FratFiles

• Save Paper

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.

Consider this problem:

Example: 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 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......

View the rest of this paper...

Approximate Word Count: 437
Approximate Pages: 2 (250 words per double-spaced page)

Similar Essays

1. Linear Programming.,Corporation
   

   Linear Programming.,Corporation Using Excel to solve linear programming problems Technology can be used to solve a system of equations once the constraints and objective function

2. Comcast Research Paper
   

   in E! Entertainment Television after a stock exchange agreement with Liberty Media Corporation. Communications Technology magazine names Comcast "Operator of the Year." Comcast

3. Strategic Information Systems Planning (Literature Review)
   

   Figure 1: Inverted U curve 3.2 Optimization of Planning Process  Through the use of Linear Goal Programming (LGP) mathematical approach to analyze IS investment projects a

4. Computer History Timeline
   

   VTR 1957 1st image-processed photo at National Bureau of Standards Digital Equipment Corporation founded 1958 Numerical controlled digital drafting machines, APT II (Automated

5. Data Mining In A Nut Shell
   

   Many of the models and algorithms used in data mining are simplifications of the linear regression model. Data Mining is largely, if not entirely used for business purposes.