Jones Consulting is deciding where to place a new office. The candidate cities are Chicago and Houston. A partially completed Factor Rating worksheet follows: City RatingsFactorWeight Chicago Wt.Score Houston Wt.ScoreAvailabilityof Labor454Availabilityof535TechnicalSkillsProximityto24CustomersТаxation331StructureGiven the data above, what is the weighted score of Chicago?Your answer will be a whole number.3.

Weighted Score = Σ (Weight * Rating) Calculation of Weighted score of Chicago: = (4 * 5) + (5 * 3)…

Answered: Given the data above, what is the…

Business

Operations Management

Given the data above, what is the weighted score of Chicago?

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

Read the scenarios below to answer the following question : After operating from the founder’s garage for three years, the team at Yebo Sauce, a condiment manufacturing business, that is dealing primarily in table sauces, has decided that it is time to expand their operation to the rest of Gauteng province. The implication of this expansion is that they need to introduce wide-ranging supply chain management processes within the business. As the newly appointed head for the logistics part of the operation, your primary focus is to align all employees and managers to the key concepts, processes and implications of adopting the necessary supply chain processes. Sauces & Spices Revenue in the Sauces & Condiments segment amounts to US$486.40m in 2022. The market is expected to grow annually by 3.49% (CAGR 2022-2027). In global comparison, most revenue is generated in China (US$38.24bn in 2022). In relation to total population figures, per person revenues of US$8.01 are generated in…
Explain corner-point feasible (CPF) solution?
Northwest Pipe (NP) makes water pipe. NP is planningproduction for the next seven months, March through September.Th e forecast demands (in thousands of feet) are, respectively, 40,60, 70, 80, 90, 100, and 80. NP can make 75,000 feet of pipe permonth using regular-time production, at a cost of $1.25 per foot.Th ey can make up to an additional 15,000 feet using overtimeproduction at a cost of $1.50 per foot. Any pipe made in onemonth and sold in a later month incurs an inventory holding costof $0.15 per foot, per month. NP expects to end February with5000 feet of pipe and would like to plan to end September with10,000 feet in inventory. NP would like to plan their productionschedule to minimize total cost during the next seven months. (a) Formulate an LP to minimize total costs.(b) Set up and solve the problem on a spreadsheet.(c) What is the optimal solution? Explain the rationale for thesolution
A manager has received an analysis of several cities being considered for a new officecomplex. The data (10 pts maximum) are as follows:Location AlternativesFactors A B CBusiness Service 7 6 6Community Services 5 6 7Real Estate Cost 5 8 7Construction Cost 6 7 6Cost of Living 2 7 8Taxes 6 5 4Transportation 7 7 8a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores?b. If business services and construction costs are given weights that are double the weights of the other factors, how would the locations stack up
Wiebe Trucking, Inc., is planning a new warehouse to servethe western United States. Denver, Santa Fe, and Salt LakeCity are under consideration. For each location, annual fixedcosts (rent, equipment, and insurance) and average variablecosts per shipment (labor, transportation, and utilities) arelisted in the following table. Sales projections range from500,000 to 600,000 shipments per year. a. Plot the total cost curves for all the locations on a singlegraph.b. Which city provides the lowest overall costs?
Case: The Yellowstone Story Home Country as Largest Production Country Monstansa is Yellowstone's most important location. It is where the company was founded in 1949, it is the location of the headquarters and it is also Yellowstone's biggest manufacturing site. More than one third of all Yellowstone products are produced in Monstansa (577,000 products in 2013). It has all the major components of manufacturing production process: a farm, an agro processing facility, an assembly line and even a label print shop. The factory builds some of the company's most important products (A3, A4, A5 and Q5). For many of the products, Monstansa serves almost as a world market factory, supplying most countries with their respective products, and having a high level of value added for these lines. The Monstansa factory even has an in-house tool-making department, which develops and builds meta-forming tools and assembly-line systems for the factory but also for other factories in the Yellowstone and…
Metro has initiated discussions on attracting rail service. A depot would need to be constructed, which would require $2.5million in land and $7.5 million in construction costs. Annual operating and maintenance costs (O&M) for the facility would be $150,000, and personnel costs would be an additional $110,000. Other assorted costs would be born by the railroad and federal authorities. Annual benefits (B) of the rail service are estimated as listed: $120,000 for Railroad annual payments, $25,000 for Rail tax charged to passengers, $20,000 for Convenience benefits to local residents, and $12,000 for Additional tourism dollars for Metro. Apply the B-C ratio method, with a MARR of 8% per year and 20 year study period, to determine if the rail service should be established. a. BC ratio=2.12, good project b. BC ratio=-1.76, good project c. BC ratio=1.69, good project d. BC ratio=0.14, not good project
What are the considerations in planning for location, facilities and capacity?
Crystal Clear Health Drinks: A health drink production company, Crystal Clear Health Drinks, decides to introduce a new line of health drink that will include several flavours. The marketing team forecasts an increase in demand for the new line of product; this is due to the growing popularity of the idea of living healthier lifestyles. They prepare the following aggregate forecasts (tank loads of several flavours) for the next six-month planning horizon: May: 50 June: 60 July: 70 August: 90 September: 80 October: 70 The operations team prepared the following information: 1. The production line has the capacity to produce 60 tank loads per month in regular time at the cost of R10,000 per tank load. 2. Overtime production and subcontracting to the available suppliers cost R16,000 and R18,000 per tank load, respectively. 3. The cost to hold one tank load for one month is R2,000. 4. Demand can also be back-ordered at the cost of R5,000 per month. 5. The company has no starting inventory…
SOLVE USING EXCEL Metal Fabricators, Inc. manufactures gas grill tanks, Model # 1420, for four original equipment manufacturers (OEMs). Demand is forecast to be as follows: Quarter 1 = 2,800 tanks, Quarter 2 = 3,400, Quarter 3 = 3,600, and Quarter 4 = 2,900. Due to a hedging program for sheet steel and increases in international tariffs, production cost per quarter vary as follows: Quarter 1 = $23.50 per tank, Quarter 2 = $28.00, Quarter 3 = $25.90, and Quarter 4 = $29.00. Due to production contracts with the OEMs, no shortages are allowed. Beginning inventory for Quarter 1 is 300 tanks. At the end of each quarter, inventory holding costs are $4.25 per tank. a. Formulate the problem as a linear programming model (see Supplement D). b. Solve the model in (a) using Excel Solver.
How did they get 3% and 1 % (%price difference)
(use excel to show formulas used) Amazing is evaluating three locations for a second headquarters. Costs for construction at location A are $18,900,000, Location B are $21,700,000 and Location C are $23,300,000. Variable costs for Location A are $16, Location B are $14 and Location C are $12. The company plans to sell products for $27. What is the break-even point for each location?