Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
snip
DryIce, Inc. is a manufacturer of air conditioners that has seen its demand grow significantly. The company anticipates nationwide demand for the year 2010 to be 180,000 units in the South; 120,000 units in the Midwest; 110,000 units in the East; and 100,000 units in the West. Managers at DryIce are designing the manufacturing network and have selected four potential sites – New York, Atlanta, Chicago, and San Diego. Plants could have a capacity of either 200,000 or 400,000 units. The annual fixed costs at the four locations are shown in the table below, along with the cost of producing and shipping an air conditioner to each of the four markets. Where should DryIce build its factories and how large should they be?
New York
Atlanta
Chicago
San Diego
Annual fixed cost of 200,00 plant
$6 miilion
5.5 million
5.6 million
6.1 million
Annual fixed cost of 400,000
$10 million
$9.2 million
9.3 million
10.2 million
EAST
$211
$232
$238
$299
SOUTH
$232
$212…
Given:
Shop‐n‐Go is seeking the optimal site for their new premium strip mall in Suburbanville, CA. There are four locations under consideration (Sites 1 through 4). The company’s operations manager and his facility location team have identified seven primary location factors that should be considered when choosing the optimal location. Each factor was assigned a weight from 1 – lowest to 10 – highest. Each site under consideration was rated from 1 – poor to 10 – great based on each factor. Use the factor‐ rating method and the criteria specified below to rank each site from best to worst based on the factors identified.
a) Rank the sites from best to worst based on all seven factors.
b) Rank the sites from best to worst if the operating costs are not factored into the evaluation.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- A chain of home health care firms in Louisiana needs to locate a central office from which to conduct internal audits and other periodic reviews of its facilities. These facilities are scattered throughout the state, as detailed in the following table. Each site, except for Houma, will be visited three times each year by a team of workers, who will drive from the central office to the site. Houma will be visited five times a year. Which coordinates represent a good central location for this office? What other factorsmight influence the office location decision? Where would youplace this office? Explain.arrow_forwardTech wants to develop an area network that will connect its server at its computer and satellite center with the main campus buildings to improve Internet service. The cable will be laid primarily through existing electrical tunnels, although some cable will have to be buried underground. The following network shows the possible cable connections between the computer center at node 1 and the various buildings, with the distances, in feet, along the branches:arrow_forwardDaniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a location for this factory has been narrowed to four sites: A, B, C, or D. The following table shows the results thus far obtained by Tracy by using the factor-rating method to analyze the problem. The scale used for each factor scoring is 1 through 5. Factor 1 2 3 4 5 6 Factor Description Quality of labor Construction cost Transportation costs Proximity to Markets Taxes 7 Weight 10 7 78565 A 5 3 4 5 2 2 4 B 3 2 5 3 2 5 4 (Enter your response as an integer.) Site Scores Weather Energy costs a) Based on the given information, the best site for Daniel Tracy is C with a total weighted score of 197. (Enter your response as an integer.) b) If site D's score for Energy costs increases from a 3 to a 5, its a total weighted score will be 144. (Enter your response as an integer.) Then, the best site for Daniel Tracy will be C with a total weighted score of 197. (Enter your response as an…arrow_forward
- Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City 50,000 Fort Worth 70,000 San Diego 60,000 Minneapolis 80,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder 100,000 Macon 100,000 Gary 150,000 Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) SHIPPED TO PRODUCED AT NEW YORK CITY FORT WORTH SAN DIEGO MINNEAPOLIS Boulder 7 11 8 13 Macon 20 17 12 10…arrow_forwardBindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City 50,000 Fort Worth 70,000 San Diego 60,000 Minneapolis 80,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder 100,000 Macon 100,000 Gary 150,000 Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) PRODUCED AT SHIPPED TO NEW YORK CITY FORT WORTH SAN DIEGO MINNEAPOLIS Boulder 7 11 8 13 Macon 20 17 12 10 Gary 8 18 13 16 Given…arrow_forwardBindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City 50,000 Fort Worth 70,000 San Diego 60,000 Minneapolis 80,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder 100,000 Macon 100,000 Gary 150,000 Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) SHIPPED TO PRODUCED AT NEW YORK CITY FORT WORTH SAN DIEGO MINNEAPOLIS Boulder 7 11 8 13 Macon 20 17 12 10…arrow_forward
- (a) Mohawk Valley Furniture Warehouse has purchased a retail outlet with six departments (A, B, C, D, E, and F), as shown below. The anticipated number of customers that move between the departments each week is given as follows: 70 and 50 customers move from department A to department B and F respectively; 100 customersmove from department B to department E; 70 customers move from department C to department B; 80 customers move from department D to department C; 40 and 30 customers move from department E to departments A and F respectively; and 60 and 100 customers move from department F to departments B and E respectively. The initial layout is given in the matrix below. (i) Construct the load summary chart for Mohawk's layout.) (ii) Evaluate the current layout in terms of non-adjacent loads.arrow_forwardGiven the following existing facilities data: Existing facility #1 has weight 2 and coordinate (9, 10). Existing facility #2 has weight 10 and coordinate (6, 8). Existing facility #3 has weight 8 and coordinate (-3, -3). Existing facility #4 has weight 9 and coordinate (5, 2). Existing facility #5 has weight 3 and coordinate (-7, -1). Existing facility #6 has weight 7 and coordinate (-2, -6). Existing facility #7 has weight 4 and coordinate (-5, 0). Existing facility #8 has weight 3 and coordinate (4, -7). What is the optimal minisum rectilinear x-coordinate? What is the optimal minisum rectilinear y-coordinate? What is the optimal minisum rectilinear objective function value? Need allarrow_forwardplease solve manuallyarrow_forward
- Case Stucay A commercial company has a main branch located in Beirut with around 35 employees. The company is looking to expand its activities by opening 3 new branches in Lebanon. To facilitate information and data sharing, the company decided to implement a network in each branch, then to connect all the branches into a single network. Also, the new network will be based on giving employees the facility to use their laptops and smartphones in most of their operations. On the other hand, the company has a major problem with organizing its data. The human resource, finance, sales, and customer service departments have all developed separately their own systems and data files, which created a lot of redundancy and poor security. Managers can't have access to timely, accurate, or relevant information for analysis because the data have been poorly organized and maintained in separated files. The main concern for the company, regarding this problem, is to discover new and hidden patterns…arrow_forwardDaniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a location for this factory has been narrowed to four sites: A, B, C, or D. The following table shows the results thus far obtained by Tracy by using the factor-rating method to analyze the problem. The scale used for each factor scoring is 1 through 5. Factor Factor Description Quality of labor 2 3 4 5 6 Construction cost Transportation costs Proximity to Markets Taxes 7 Weight 10 7 7 8 5 6 5 Weather Energy costs a) Based on the given information, the best site for Daniel Tracy is C b) If site D's score for Energy costs increases from a 3 to a 5, its a total weighted score will be A 5 3 4 5 2 2 4 B 3 2 5 3 2 5 4 Site Scores C 5 4 3 4 with a total weighted score of 197 (Enter your response as an integer.) (Enter your response as an integer.) D 3 1 2 3 4 3arrow_forwardUse the table below to answer the following question(s). The Riviera Transport Company (RTC) produces car accessories at two plants: Dallas and Atlanta. They ship them to major distribution centers in Houston, San Jose, Jacksonville, and Memphis. The accounting, production, and marketing departments have provided the information in the table below, which shows the unit cost of shipping between any plant and distribution center, plant capacities over the next planning period, and distribution center demands. RTC's supply chain manager faces the problem of determining how much to ship between each plant and distribution center to minimize the total transportation cost, not exceed available capacity, and meet customer demand. Assume Xij = amount shipped from plant i to distribution center j, where i = 1 represents Dallas, i = 2 represents Atlanta, j = 1 represents Houston, and so on. Transportatio In Model Data Distribution Center Plant Houston Memphis 18.48 Dallas 13.00 Atlanta 10.75…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,