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
Using the grid technique to determine the least-cost location (warehouse) for this problem:
Tons
Rate
X - Coordinates
Y – Coordinates
S1
200
0.5
2
14
S2
300
0.6
6
10
M1
100
1
2
2
M2
100
2
10
14
M3
100
1
14
18
M4
100
2
14
6
The Grid center coordination is ____ and _____
(round the results to 1 decimal place)
Group of answer choices
(9.9; 7.8)
(5.5; 6.9)
(8.7; 10.5)
(10.5; 6.4)
(9.9; 8.9)
In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of
1,000
radials each year. In the past 2 years,
220
and
250,
respectively were sold in fall,
360
and
320
in winter,
145
and
175
in spring, and
300
and
230
in summer. With a major expansion planned, Kelle projects sales next year to increase to
1,200
radials.
Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers):
Season
Demand
Fall
nothing
In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of
1,000 radials each year. In the past 2 years, 200 and 260, respectively were
sold in fall, 340 and 300 in winter, 150 and 175 in spring, and 300 and 275
in summer. With a major expansion planned, kelle projects sales next year
to increase to 1,200 radials.
Based on next year's projected sales, the demand for each season is going
to be (enter your responses as whole numbers):
Season
Fall
Demand
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
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?arrow_forwardTrips Logistics, a third-party logistics firm that provides warehousing and other logistics services, is facing a decision regarding the amount of space to lease for the upcoming three-year period. The general manager has forecast that Trips Logistics will need to handle a demand of 100,000 units for each of the next three years. Historically, Trips Logistics has required 1,000 square feet of warehouse space for every 1,000 units of demand. For the purposes of this discussion, the only cost Trips Logistics faces is the cost for the warehouse. Trips Logistics receives revenue of $1.22 for each unit of demand. The general manager must decide whether to sign a three-year lease or obtain warehousing space on the spot market each year. The three-year lease will cost $1 per square foot per year, and the spot market rate is expected to be $1.20 per square foot per year for each of the three years. Trips Logistics has a discount rate of k = 0.1.arrow_forwardB & Carrow_forward
- 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.)arrow_forwardfertilizer manufacturer has to fulfill supply contracts to its two main customers (650 tons to Customer A and 800 tons to Customer B). It can meet this demand by shipping existing inventory from any of its three warehouses. Warehouse 1 (W1) has 400 tons of inventory onhand, Warehouse 2 (W2) has 500 tons, and Warehouse 3 (W3) has 600 tons. The company would like to arrange the shipping for the lowest cost possible, where the per-ton transit costs are as follows: W 1 W 2 W 3 Customer A $7.50 $6.25 $6.50 Customer B $6.75 $7.00 $8.00 Write the objective function and the constraint in equations. Let Vij= tons shipped to customer i from warehouse j, and so on. For example, VA1=tons shipped to customer A from warehouse W1. This exercise contains only parts b, c, d, e, and f. Part 2 b) The objective function for the LP model =arrow_forwardA company manufactures a product at its plants in A, B, and C, then ships the product to six customers in G, H, J, K, and L. The monthly capacity of plants A, B, and Care 7300, 7400, and 7500 units, respectively. The monthly demand from customers G, H, J, K, and Lare. 1200, 8900, 7600, 2600, and 1500 units, respectively. Use Excel Solver to find the optimal distribution plant that will give the lowest total monthly shipping cost if the shipping cost per unit (in dollars per unit) are as follows: from A to G, H, J, K, and L are 4, 9, 20, 6, and 13 dollars per unit, respectively; from B to G, H, J, K, and Lare 7, 6, 12, 2, and 9 dollars per unit, respectively; from C to G, H, J, K, and Lare 12, 7, 3, 17, and 6 dollars per unit, respectively. The optimal total shipping costs is dollars per montharrow_forward
- A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be $.50 per load meter moved. An analyst has prepared the following flow and distance matrices: Distances (meters) Flows (Loads per week) From/To I II III From/To X Y Z I - 10 20 X - 0 80 II - - 10 Y 30 - 150 III - Z 100 130 -If the company were to locate departments X, Y, and Z in areas 1, 2, and 3, respectively, what would be the total distance (in meters) loads would be moved each week?A. 3,100B. 3,600C. 6,200D. 7,200E. 8,200 Work must…arrow_forwardBriefly discuss the Nine dot problem. How did they come up with a solution?arrow_forwardJ 2 An electronics store wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annual number of truckloads are given in the accompanying table. Develop a model to find the best location, assuming that straight-line distances can be used between the locations. Experiment with the model by testing each of the possible best solutions, included, to find the best location. Click here to view the data for the store locations and annual numbers of truckloads. Click here to view some possible best solutions. The best location is at____. (Type an ordered pair. Round each coordinate to the nearest integer as needed.)arrow_forward
- HMO has 40 doctors to be apportioned among four clinics. The HMO decides to apportion the doctors based on the average weekly patient load for each clinic, given in the following table. Clinic A B C D Average Weekly 275 392 611 724 Patient Load Find the apportion of A and C using using Adam's Method. Use modified divisor 52. Doctors for clinic A Doctors for clinic B = %3D Doctors for clinic C= Doctors for clinic D =arrow_forwardPlease help me with part barrow_forwardOhio Swiss Milk Products manufactures and distributes ice cream in Ohio, Kentucky, and West Virginia. The company wants to expand operations by locating another plant in northern Ohio. The size of the new plant will be a function of the expected demand for ice cream within the area served by the plant. A market survey is currently under way to determine that demand. Ohio Swiss wants to estimate the relationship between the manufacturing cost per gallon and the number of gallons sold in a year to determine the demand for ice cream and, thus, the size of the new plant. The following data have been collected: Plant ITT Thousands of Gallons Sold (X) 434.7 Cost per Thousand Gallons (Y) 1 $1,024 2 962 466.4 3 1,065 1,006 1,045 1,068 251.3 372.1 5 245.0 6. 258.6 7 988 614.9 414.0 8 997 9 1,063 1,000 $10,218 267.5 380,4 3,704.9 10 Total a. Develop a regression equation to forecast the cost per thousand gallons as a function of the number of thousands of gallons produced. The forecasting model…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,