Using Excel to solve linear programming problems Technology can be used to solve a system of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Solution Identify decision variables The decision variables are x1 number of conv... View the full answer
Related Book For
Discovering Advanced Algebra An Investigative Approach
ISBN: 978-1559539845
1st edition
Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke
Posted Date:
Students also viewed these computer network questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
1. Based on the information provided in the case below, what is the key strategic goal for Tim Hortons as of August 2014? It would be a year of dramatic change for Tim Hortons Inc. On August 26,...
-
Using the displacement formulation given in Section 9.3.2, use standard separation of variables to solve the torsion problem of a rectangular section shown in Fig. 9.12. Verify your solution with...
-
In a Harris poll of 514 human resource professionals, 45.9% said body piercings and tattoos were big grooming redflags. a. Among the 514 human resource professionals who were surveyed, how many of...
-
After reading Homosexuals in the Churches, Id like to point out that I dont know any serious, capable exegetes who stumble over Saint Pauls denunciation of homosexuality. Only a fool (and there seem...
-
The following are speeds (mi/h) of cars measured with a radar gun on the New Jersey Turnpike based on data from Statlib and authors Joseph Kadane and John Lamberth. 70 70 71 72 72 73 73 74 76 77 78...
-
the stockholders equity section of Acerin Moving and Storage Corporations balances sheet as of December 31, 2010, appears below. Contributed capital Common stock, $2 par value, 6,000,000 shares...
-
Answer the following questions. What are key issues that needed to be addressed in the John Deere intervention? How did the AI consultants address these issues? Create a table in which you explain...
-
Consider the Everglade cash flow problem discussed in this chapter. Suppose that extra cash is kept in an interest-bearing savings account. Assume that any cash left at the end of a year earns 3...
-
On April 15, Year 5, Bailey Inc. negotiated a large sale of their premium maple syrup to Sweet Co. for US$3,000,000. The contract required payment in three years from the date of delivery of the...
-
Total number of shares in Dhofar steel company are 10000 and each one is sold for RO 10. Mr. Ahmed invested RO 10000 in purchasing shares of the above company. Based on one share one vote, how much %...
-
Selling price for 100. Cash flows over 10 years 1 $12 2 $11 3 $13 4 $14.1 5 $12. 6 $13.3 7 $12 8 $13 9 $11 10 $10 The cash flow yield is closest to what percent?
-
Suppose a different company offers Ludo Corporation a "Loss Control" service which costs S (in dollars) and which cuts the probability of all losses in half (such that the probability of both the...
-
How much equity would Phil have in his home based on the following information: Purchased price of $425,000 Fair market value of $432,000 20% down payment Has made $15,000 in principal payments
-
Analyze and interpret the complex accounting implications of a merger between two multinational corporations, each with unique accounting practices, tax structures, and financial reporting standards....
-
Movements for month of August for company "Devolucion PLC" are as follows: Date Movements N Units Unit cost Selling Price Total $ 08/01/10 Initial Inventory 100 75 $7,500 08/03/10 Purchase 50 70...
-
Assume Eq. 6-14 gives the drag force on a pilot plus ejection seat just after they are ejected from a plane traveling horizontally at 1300 km/h. Assume also that the mass of the seat is equal to the...
-
Write parametric equations for each graph in Exercise 2. a. b. c. d. 2.3.0.75 33.25
-
A, you saw an arithmetic sequence that generates from a geometric pattern: the number of seats around a linear arrangement of square tables is 4, 6, 8, . . . . Notice that the sequence comes from the...
-
A panel of judges rate 20 science fair exhibits as shown. The judges decide that the top rating should be 100, so they add 6 points to each rating. a. What are the mean and the standard deviation of...
-
The following technical terms are used. Check that you understand the meaning of each. accountancy firm accountancy profession accounting audit manager business entity conceptual framework ...
-
The following technical terms are used. Check that you understand the meaning of each. articles of association capital Companies Act directors dividend entity HM Revenue and Customs investors...
-
The following technical terms are used. Check that you understand the meaning of each. annual report cash flow projections creditors default dividend equities analyst fixed assets ...
Study smarter with the SolutionInn App