12. Multicuisine restaurant, with more than 5 outlets in the Sultanate of Oman. The restaurant isplanning for a new branch. Three locations are being considered. The following table givesthe factors and its weights for each alternative locations.FactorBuilding RentMaintenance CostDensity of PopulationSubsidiary IncomesLocal taxWeightSoharNizwaIbri40809510565.356080.3050705520406050.151109070Compute and suggest the best location the Multicuisine restaurant can open their newbranch in Oman.

Given information Factors Weights Sohar Nizwa lbri Building Rent 40 80 95 105…

12. Multicuisine restaurant, with more than 5 outlets in the Sultanate of Oman. The restaurant is planning for a new branch. Three locations are being considered. The following table gives the factors and its weights for each alternative locations. Weight Sohar Nizwa Factor Building Rent Maintenance Cost Density of Population Subsidiary Incomes Local tax Ibri 40 .35 .30 80 60 50 95 80 70 105 65 55 20 .15 40 110 60 90 50 70 Compute and suggest the best location the Multicuisine restaurant can open their new branch in Oman.

12. Multicuisine restaurant, with more than 5 outlets in the Sultanate of Oman. The restaurant is planning for a new branch. Three locations are being considered. The following table gives the factors and its weights for each alternative locations. Weight Sohar Nizwa Factor Building Rent Maintenance Cost Density of Population Subsidiary Incomes Local tax Ibri 40 .35 .30 80 60 50 95 80 70 105 65 55 20 .15 40 110 60 90 50 70 Compute and suggest the best location the Multicuisine restaurant can open their new branch in Oman.

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

4. Transrail is bidding on a project that it figures will cost $400,000 to perform. Using a 25% markup, it will charge $500,000, netting a profit of $100,000. However, it has been learned that another company, Rail Freight, is also considering bidding on the project. If Rail Freight does submit a bid, it figures to be a bid about $470,000. Transrail really wants this project and is considering a bid with only a 15% markup to $460,000 to ensure winning regardless of whether or not Rail Freight submits a bid. a. Prepare a profit payoff table from Transrail’s point of view. (6 points) b. For this payoff table find Transrail’s optimal decision using (1) the pessimistic approach, (2) the optimistic approach, and (3) minimax regret approach. (10 points) c. If Rail Freight is known to submit bids on only 25% of the projects it considers, what decision should Transrail make? (5 points) d. Given the information in (c), what is EVPI? (5 points)
A franchise operation that sells frozen custardintends to open one or more new stores in amedium-sized metropolitan area. Three sitesare under consideration. Each site hassomewhat different projected profitcontribution and different supervisionrequirements. The first site has an estimateddaily profit of $200 and a weekly supervisionrequirement of 48 hours; the second site has aprojected profit of $100 per day and a weeklysupervision requirement of 30 hours; and thethird site has an estimated daily profit of $150and a weekly supervision requirement of 20hours. The firm will have 65 hours available forper week for supervision.Use Excel to determine which site or sitesshould be selected in order to obtain thehighest projected daily profit?
1. George wishes to determine which of four investment strategies to use, given the payoff table here showing his annual returns (in thousands of shillings). The final outcome depends on what the government does in its upcoming tax bill. StrategyTaxes Go UpGo DownNo Change 1-255030 2-224030 3403550 4374050 a. Which investment strategy should James use if he is pessimistic regarding the future? b. Which investment strategy should James use of he is optimistic regarding the future? c. Which investment strategy should James use if he uses the Minimax Regret criterion? 2. Two different models are available for the same machine. The production statistics (number of units produced per hour) of these two models are given below. The data was collected on different days.Model A180176184181190137 Model B195194190192187185187 Will you conclude that Model A and Model B have the same productivity? 3. How large a sample should be selected to provide a 95% confidence interval with a margin of error…
1. Kirsten is trying to decide where to go for her well-earned vacation. She would like to camp, but if the weather is bad, she will have to go to a motel. Given the costs and probabilities of bad weather given below, which destination should she choose? Camping cost Motel cost Probability of bad weather Nevada $21.2 $80.9 0.2 Oregon $15.9 $84.6 0.4 California $30 $95 0.1 a. California, because its EMV = $33.14 b. Nevada, because its EMV = $33.14 c. California, because its EMV = $36.5 d. Any of the 3 choices. e. Oregon, because its EMV = $43.38 f. Nevada, because its EMV = $43.38 g. None of the 3 choices. h. Oregon, because its EMV is $36.50.
Nicole Nelson has come into an inheritance from hergrandparents. She is attempting to decide among several investment alternatives. The return after one year is depen-dent primarily on the interest rate during the next year. The rate is currently 7%, and she anticipates it will stay thesame or go up or down by at most 2 points. The variousinvestment alternatives plus their returns ($10,000s) giventhe interest rate changes are shown in the following table.Determine the best investment using the following decisioncriteria.a. Maximaxb. Maximinc. Equal likelihoodd. Assume that Nicole, with the help of a financialnewsletter and some library research, has been able toassign probabilities to each of the possible interest ratesduring the next year as follows: Interest Rate 5% 6% 7% 8% 9%Probability 0.1 0.2 0.4 0.2 0.1
Lorraine has received a lump sum of R500 000.00 from her retirement fund. She intends to usethese funds to start a student accommodation business. In order to start this business, Lorrainewould need approximately R1 million, funds are needed for building the students accommodationapartments and to register with various regulatory bodies. She has to source additional funding inorder to realise this dream. In the business plan, Lorraine has outlined the following:• Accommodation will be offered ONLY to students in Cape Town, Johannesburg,Mpumalanga and Polokwane.• ONLY females will be approved to reside in these houses, between the age of 18 - 35.• Marketing of the business will be done on community Radio stations only at the fourmentioned cities.• It is going to be a family business, Friends and relatives are in support of the idea but arenot able to support the business financially There are three types of Market coverage. Explain the type of market coverageapplicable to Lorraine’s…
1) A television network earns an average of $1.6 million each season from a hit program and loses an averageof $400,000 each season on a program that turns out to be a flop, and of all programs picked up by thisnetwork in recent years, 25% turn out to be hits and 75% turn out to be flops. a) Construct a decision tree to help the television network identify the strategy that maximizes itsexpected profit in responding to a newly proposed television program. Make sure to label all decision and chance nodes and include appropriate costs, payoffs and probabilities. b) What should the network do? What is their expected profit? c) The network can conduct market research to determine whether a program will be a hit or a flop. Ifthe market research report is perfectly reliable, what is the most the network should be willing to payfor it? 2) A buyer for a large sporting goods store chain must place orders for professional footballs with the footballmanufacturer six months prior to the time…
Carlisle Tire and Rubber, Inc., is considering expanding production to meet potential increases in the demand for one of its tire products. Carlisle’s alternatives are to construct a new plant, expand the existing plant, or do nothing in the short run. The market for this particular tire product may expand, remain stable, or contract. Carlisle’s marketing department estimates the probabilities of these market outcomes to be 0.25, 0.35, and 0.40, respectively. The file P06_31.xlsx (picture of given excel file is attached) contains Carlisle’s payoffs and costs for the various combinations of decisions and outcomes. Identify the strategy that maximizes this tire manufacturer’s expected profit. Perform a sensitivity analysis on the optimal decision, letting each of the monetary inputs vary one at a time plus or minus 10% from its base value, and summarize your findings. Which of the inputs appears to have the largest effect on the best solution?
Problem 17 page 552The chancellor of a small regional college is concernedabout the declining freshman enrollment at his college. A number of factors have contributed to the decline, butthe chancellor believes it is directly related to annualtuition increases. He has collected the following data forthe past 8 years.year FreshmanEnrollmentAnnualTuition (In USdollars)1 6,550 32,0002 6,230 37,0003 5,980 45,2004 5,540 45,7005 4,960 46,2006 4,630 46,7007 4,520 52,2008 4,220 57,700a Develop a linear regression equation for forecastingfreshman enrollment as a function of the annual tuition.b Forecast freshman enrollment if the annual tuitionincreases by US$9,000 in Year 9.c Evaluate the "goodness of fit" of the regressionequation by computing the values of R2, r, and Syx and interpret the results.
Method of Least Squares, Goodness of Fit Deepa Dalal opened a free-standing radiology clinic. She had anticipated that the costs for the radiological tests would be primarily fixed, but she found that costs increased with the number of tests performed. Costs for this service over the past nine months are as follows: Month Radiology Tests Total Cost January 2,800 $133,500 February 2,600 135,060 March 3,100 175,000 April 3,500 170,600 May 3,400 176,900 June 3,700 186,600 July 3,840 174,450 August 4,100 195,510 September 3,450 185,300 Required: 1. Compute the cost formula for radiology services using the method of least squares. If required, round your answers to two decimal places. Y = + X 2. Using the formula computed in Requirement 1, what is the predicted cost of radiology services for October for 3,500 appointments? (Round the answer to the nearest dollar.)
Given is a decision payoff table. Future Demand Alternatives Low Moderate High Small Facility 52 42 43 Medium Facility 50 49 49 Large Facility -15 38 51 a) The best decision under uncertainty using MAXIMIN is to select ( ) facility b) The best decision under uncertainty using LAPLACE/EQUALITY LIKELY is to select ( )facility c) If the probabilities for Future Demand when it is Low = 0.35, Moderate = 0.30, and High = 0.35, the expected monetary value (EMV) for the large facility = .d) If the probabilities for Future Demand when it is Low = 0.35, Moderate = 0.30, and High = 0.35, the best decision under risk is to select ( ) facility.
Janice Gould of Krebs Consulting is in the process of makinga recommendation to a client regarding the corporate-widepurchase of an analytical software platform. She has madethe following estimates on management’s most importantperformance criteria and has rated three Software packagesacross these criteria a. Which software platform would you recommend?b. Assume that the client changes their mind and nowargues that the maintenance and support criterion isalready accounted for by the total cost criterion. Further,the client asks Ms. Gould to drop maintenance and support and add its factor weight to total cost. Will this clientrequest alter the recommendation?