(A little sensitivity analysis.) You are given the final chart, with the optimal solution, for a transportation problem; note that the cell in the (4, 2) position is blank, i.e., the variable x42, with an objective coefficient (unit cost) of C42 = 18, is nonbasic. What range of values of c42 will keep the solution in the chart optimal? Hints: In this method, how do we tell that our latest solution is optimal? Temporarily replace the cost of 18 with C42. 10 13 15 14 12 4 [14 la 18 (5) 26 3 12 (5 20

(A little sensitivity analysis.) You are given the final chart, with the optimal solution, for a transportation problem; note that the cell in the (4, 2) position is blank, i.e., the variable x42, with an objective coefficient (unit cost) of C42 = 18, is nonbasic. What range of values of c42 will keep the solution in the chart optimal? Hints: In this method, how do we tell that our latest solution is optimal? Temporarily replace the cost of 18 with C42. 10 13 15 14 12 4 [14 la 18 (5) 26 3 12 (5 20

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

The sales manager like to have seasonal prices discounted from the regular sales price. He would like to change all his product prices at the same time whenever the season changes. What is the most efficient way to do this? Create a price list called 'regular sales price list' to list the regular sales prices. Whenever Manager wants to have a seasonal price list, he will use the 'regular sales price list' as the base price list and enter a discount factor. Create a price list for the regular sales price. Create a hierarchy called 'seasonal prices' which will be based on the regular sales price list and will give time-based discounts for the season based on a factor Manager enters. Create a price list which will contain the regular sales prices. Define period and volume discounts for the seasonal prices which will contain both the validity periods for the discounts and a factor to calculate the discounts for all items. Create a price list called 'regular sales price list' to list the…
Develop a spreadsheet for the question. The vice president of finance has looked at your ooriginal scoring model and feels that tax considerations should be included in teh model with a weight of 15. In addition, the VP has scored the methods on tax considerations as follows: method A recieved a score of 3, method B recieved a score of 2, and Method C recieved a score of 1. How would this additional information affect your recommendation?
Daniel Grady is the financial advisor for a number of professional athletes. An analysis of the long-term goals for many of these athletes has resulted in a recommendation to purchase stocks with some of their income that is set aside for investments. Five stocks have been identified as having very favorable expectations for future performance. Although the expected return is important in these investments, the risk, as measured by the beta of the stock, is also important. (A high value of beta indicates that the stock has a relatively high risk.) The expected return and the betas for five stocks are as follows: Stock 1 2 3 4 5 Expected Return (%) 11.0 9.0 6.5 15.0 13.0 Beta 1.20 0.85 0.55 1.40 1.25 Daniel would like to minimize the beta of the stock portfolio (calculated using a weighted average of the amounts put into the different stocks) while maintaining an expected return of at least 11%. Since future conditions may change, Daniel…
1. (EOQ)The Wallace Stationary Company purchases paper from the Seaboard Paper Company. Wallace produces stationary that require 1,415,000 sq. yards of stationary per year. The cost per order for the company is $2,200; the cost of holding 1 yard of paper in inventory is $0.08 per year. Determine the following: a. Economic order quantity (please show your work) B. Minimum total annual cost c. Optimal number of orders per year d. Optimal time between orders
allons of deionized water from each wholesaler to each distribution center is shown in the following table: Question Viewer a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? B. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center is needed. C. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. b. What is the total cost of the solution? The optimal cost is $ ((Enter your response rounded to the nearest dollar.)
No probabilities are known for the occurrence of the nature states. Compare the solutions obtained by each of the following criteria: Hurwitz (assume that alpha = 0.8)
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40 a) Generate the Sensitivity Report in EXCEL for the model that you built. Interpret, in context, the Shadow Price for the Leather and the Satin constraints. Include units in your interpretations.
The lease cost for a specialized highway design software package is estimated to be $13,000 for each of years 1, 2, and 3 (future dollars). (a) Calculate the CV amount today (year 0) of each future cost estimate at the inflation rate of 6% per year. (b) Develop a spreadsheet and graph for inflation rates of 3%, 6%, and 8% per year that show the CV today.
Read the following passage and answer the question that follows Quincy Snodgrass Enterprises—Forecasting Quincy Snodgrass is an entrepreneur and a lover of the outdoors. He has worked for various companies since he graduated college with his business administration degree in management. Over the years, he has saved every extra penny and now has the starting capital he needs; consequently, he plans to open his own business. Quincy plans to open a landscaping business. The primary services he’ll offer are grass cutting, edging, and bush trimming. Obviously, this will only provide income in the spring, summer, and early fall. Therefore, he plans to offer snow removal in the winter. His goal is to continue to provide those baseline services and expand into actual landscaping work. Quincy’s initial challenge is to develop a forecast of how many customers he’ll have each month. This is essential to determine if he needs to hire any additional labor throughout the season. Unfortunately, none…
A company has 4 plants: Plant 1, Plant 2, Plant 3, and Plant 4. All the plants make the same product The company sells the product in 4 different cities: City 1, City 2, City 3, City 4. Maximum production (in thousands of units) that is possible at the 4 plants are given respectively by (Plant 1 to Plant 4): 5, 25, 10, and 15. Your forecast shows that the demand for the product (in thousands of units) in each of the cities is given by (City 1 to City 4): 15, 7, 9, 10. Your firm does not want to have any backorders or lost demand. The production & transportation cost for getting a product from any given plant to any given city if given blow: Plant 1 Plant 2 Plant 3 Plant 4 Production and Transportation Cost per 1000 units (Thousand $) City 1 City 2 1070 1260 1825 780 800 City 3 1400 1685 1540 1070 2425 1355 843 City 4 1530 1100 500 1045 You need to decide which plant will serve which city and how much. Find the optimal way to serve the demands in all the cities. What is the optimal…
University Drug Pharmaceuticals orders its antibiotics every two weeks (14 days) when a salesperson visits from one of the pharmaceutical companies. Tetracycline is one of its most prescribed antibiotics, with average daily demand of 2,000 capsules. The standard deviation of daily demand was derived from examining prescriptions filled over the past three months and was found to be 800 capsules. It takes five days for the order to arrive. University Drug would like to satisfy 99 percent of the prescriptions. The salesperson just arrived, and there are currently 25,000 capsules in stock. How many capsules should be ordered?