Question 2 SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 5 states listed below. There are four potential sites for home offices: Los Angeles, Tulsa, Denver, and Seattle. The annual fixed cost of locating an office in Los Angeles is $165,000, Tulsa is $131,000, Denver is $140,000, and Seattle is $145,000. The expected number of trips to each state and the travel costs from each potential site are shown below. Each consultant is expected to take at most 40 trips each year. If at most 3 consultants are to be assigned to a home office, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of this network? Travel cost (S)

Question 2 SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 5 states listed below. There are four potential sites for home offices: Los Angeles, Tulsa, Denver, and Seattle. The annual fixed cost of locating an office in Los Angeles is $165,000, Tulsa is $131,000, Denver is $140,000, and Seattle is $145,000. The expected number of trips to each state and the travel costs from each potential site are shown below. Each consultant is expected to take at most 40 trips each year. If at most 3 consultants are to be assigned to a home office, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of this network? Travel cost (S)

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

Q2k Audi is considering three locations A, B and C for the production of its new model SUV XL500. The objective is to choose the location with the lowest costs. The costs are measured as annual fixed costs plus the variable costs of the product. The following data has been collected for the three locations.< Region Fixed costs per year A B C 10 000 000 20 000 000 25 000 000 Variable cost per unit 1. at what level of production will C be the best choice? 2. at what production rate will A be the best choice? 3. at what level of production will B be the best choice? 2500 2000< 1000< The company's projected annual production in the new plant is 0-60 000 units.< Ask
In deciding on where to locate their next grocery store, Publix narrowed it down to 3 locations (St. Augustine, the Airport area, or the Westside). They are using 2 criteria to make their decisions costs (with a weight of 70%) and customer base (with a weight of 30%). Each item was scored on a 10-point scale with 10 being the highest. St. Augustine rated a score of 4 for cost and 10 for customer base; the Airport area rated a score of 6 for cost and 5 for the customer base, and the Westside rated a score of 8 for cost and 2 for the customer base. __________ 2a. What is the computed mean score for each of the 3 locations? __________ 2b. Which location should be chosen based on the highest score?
How center of gravity method is used to determine the right location for the facility placement? Benefits of using this method?
An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. Fixed Cost Variable Cost Location A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 i. ii. 300 200 100 2 4 6 8 10 14 16 18 20 Q (000s of units) Plot the total cost curves in the chart provided above and identify the range over which each location would be best. [7 marks] Use break-even analysis to calculate exactly the break-even quantity that defines each range. [3 marks]
Fruit Centre Ice Cream Parlor is deciding where to locate a new facility. The annual fixed costs, initial fixed costs and variable costs for each site have been estimated as follows; Location Annual Fixed Costs (shs) Initial Fixed costs selling price (shs) Variable costs(shs) Namugongo 35,000 400,000 200/unit 200/unit Kireka 19,000 250,000 400/unit 45/unit Banda 15,000 200,000 600/unit 2500/unit Ntinda 95,000 170,000 100/unit 360/unit If demand is expected to be 2000 units, which location is best? and Forecasting is a key component in operations management. Identify and describe any three methods of forecasting that you would recommend to a service industry.
Please assist
Q) A discount store chain wants to build a new superstore in an area in Melbourne near four small towns with populations between 10,000 and 40,000. The coordinates (in miles) of these four towns and the market population in each are as follows: Coordinates Carlton St Kilda Ballarat Frankston 12 18 30 32 20 12 8 25 Population 18,000 17,000 10,300 10,000 a) Determine the best site using the center-of-gravity technique. b) Suppose the store is limited to two possible sites for locating a new superstore. The coordinates (in miles) of these two potential sites are site 1 (10, 30) and site 2 (20, 10). Using the load-distance technique, determine the best site for the new super store. c) Plot the four small towns and the proposed new distribution centers according to center of gravity method and load-distance method on a grid map. Give your own opinion about it.
6.- Comfort Zone Furniture has plants in Boston, Dallas and Seattle, which ship their production to four demand centers, with the transportation costs indicated in the following table. Using the northwest corner method and stepping stone find the optimal solution. Boston Dallas Seattle Demand 1 $3 $6 $1 20 2 $5 $8 $9 60 3 $7 $5 $7 30 4 $4 $2 $3 40 Capacity 50 50 50 150
Problem 4
Q4: Bluestar TV Cable company is in the process of providing cable services to five new housing development areas. Figure depicts possible TV linkages among the five areas. The cable miles are shown in each arc. Determine the most economical cable network by also providing a linear programming formulation. 3 miles 9 10 6 5
The following table shows the fixed cost and variable cost for 3 locations. Construct cost curves for these 3 locations for production from 0 to 200 units at 20 units intervals. What would be the range of production units that would give Location A a competitive advantage? What would be the range for Location B and Location C, respectively?
You may notice different warehouses close to customers, to maximize customer service levels Mostly FMCG companies have established their warehouses/distribution centers in this area. Name the location strategy theses warehouses are using? Why most of the FMCG companies have chosen this area for their distribution centers and what benefits can these warehouses in this area /location can bring to FMCG companies?