SandyCo has two (2) facilities that mine, clean, and sort sand for use in cement, children's...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
SandyCo has two (2) facilities that mine, clean, and sort sand for use in cement, children's playboxes, and small beaches. They distribute the sand from their two (2) plants, through two (2) packaging centers (DCs), to three (3) different customer regions where it is packaged and sold. Each plant has a specific maximum weekly supply of available sand and each region has an expected minimum weekly required demand. The cost to distribute a ton of sand differs between each plant and region pairing due to distance and other factors. The maximum weekly supply from Plant 1 is 100 tons, from Plant 2 it is 125 tons. The expected minimum weekly required demand (in tons) is: • Region 1: 25 Region 2: 95 • Region 3: 80 The transportation costs in dollars per ton of sand are given in the table below. DC A DC B Plant 1 Plant 2 Region1 Region 2 Region 3 190 185 175 180 165 210 205 235 130 145 Part 1 0.0/1.0 point (graded) We know that the optimal solution to the problem shows a total cost of $69,200 per week. The solution has the following weekly flows: • Plant 1 to DC B: 75 • Plant 2 to DC A: 25 • Plant 2 to DC B: 100 • DC A to Region 1: 25 • DC B to Region 2: 95 • DC B to Region 3: 80 Input the flows above as decision-variables in your spreadsheet model. Don't run the solver. The spreadsheet will tell you that the total weekly cost is indeed $69,200 per week. You hear from a colleague using another solver that there is another good solution to the problem. He tells you to consider following weekly flows: • Plant 1 to DC B: 75 . Plant 2 to DC A: 105 . Plant 2 to DC B: 20 • DC A to Region 1: 25 • DC A to Region 3: 80 • DC B to Region 2: 95 Input the suggested flows instead of the flows from the lesson. What is the minimum weekly cost using the suggested flow volumes? Round your answer to the nearest integer. Part 2 0.0/1.0 point (graded) After discussions with a number of carriers, SandyCo realizes that transportation costs to DC A need to be updated. The new costs are $180 per ton from Plant 1 to DC A and $190 per ton from Plant 2 to DC A. How many tons of sand should be delivered from Plant 2 to DC B with the new costs? Round your answer to the nearest integer. Submit You have used 0 of 2 attempts Part 3 0.0/1.0 point (graded) Save After hearing that a rival sand distributor is facing economic difficulties, SandyCo wants to reconsider its demand estimates. Were the rival to default, SandyCo believes that their demand would increase by roughly 10% across the board, leading to the following minimum expected demands: Region 1 - 28, Region 2 - 105, and Region 3 - 87 tons respectively. How many tons of sand should be delivered from DC A to Region 3 if the expected minimum demand was to increase by the amount specified? Note that the costs from Part 2 still apply. Round your answer to the nearest integer. Save Part 4 0.0/1.0 point (graded) The rival firm did not default - so your demand is back to the original values (Region 1: 25, Region 2: 95, and Region 3: 80). The management of Plant 2 has suggested they may use some of the available space in the plant for an on-site packaging machine. With such a machine in place, Plant 2 would be able to bypass the DCs and ship directly to Region 1. Direct transport from Plant 2 to Region 1 costs $275 per ton. All other costs remain the same as in Part 2. If Plant 2 invests in a on-site sand packaging machine, how many tons of sand should be delivered directly from Plant 2 to Region 1? Round your answer to the nearest integer. Submit You have used 0 of 2 attempts Part 5 0.0/1.0 point (graded) Save After investing in the new machine, a breakdown in DC B reduces the weekly capacity of DC B to 80 tons. All other costs and demand remain the same as in Part 2. (Note that the bypass option from Part 4 remains.) How many tons of sand should Plant 1 produce if the capacity of DC B drops to 80 tons? There is no capacity constraint for DC A. Round your answer to the nearest integer. SandyCo has two (2) facilities that mine, clean, and sort sand for use in cement, children's playboxes, and small beaches. They distribute the sand from their two (2) plants, through two (2) packaging centers (DCs), to three (3) different customer regions where it is packaged and sold. Each plant has a specific maximum weekly supply of available sand and each region has an expected minimum weekly required demand. The cost to distribute a ton of sand differs between each plant and region pairing due to distance and other factors. The maximum weekly supply from Plant 1 is 100 tons, from Plant 2 it is 125 tons. The expected minimum weekly required demand (in tons) is: • Region 1: 25 Region 2: 95 • Region 3: 80 The transportation costs in dollars per ton of sand are given in the table below. DC A DC B Plant 1 Plant 2 Region1 Region 2 Region 3 190 185 175 180 165 210 205 235 130 145 Part 1 0.0/1.0 point (graded) We know that the optimal solution to the problem shows a total cost of $69,200 per week. The solution has the following weekly flows: • Plant 1 to DC B: 75 • Plant 2 to DC A: 25 • Plant 2 to DC B: 100 • DC A to Region 1: 25 • DC B to Region 2: 95 • DC B to Region 3: 80 Input the flows above as decision-variables in your spreadsheet model. Don't run the solver. The spreadsheet will tell you that the total weekly cost is indeed $69,200 per week. You hear from a colleague using another solver that there is another good solution to the problem. He tells you to consider following weekly flows: • Plant 1 to DC B: 75 . Plant 2 to DC A: 105 . Plant 2 to DC B: 20 • DC A to Region 1: 25 • DC A to Region 3: 80 • DC B to Region 2: 95 Input the suggested flows instead of the flows from the lesson. What is the minimum weekly cost using the suggested flow volumes? Round your answer to the nearest integer. Part 2 0.0/1.0 point (graded) After discussions with a number of carriers, SandyCo realizes that transportation costs to DC A need to be updated. The new costs are $180 per ton from Plant 1 to DC A and $190 per ton from Plant 2 to DC A. How many tons of sand should be delivered from Plant 2 to DC B with the new costs? Round your answer to the nearest integer. Submit You have used 0 of 2 attempts Part 3 0.0/1.0 point (graded) Save After hearing that a rival sand distributor is facing economic difficulties, SandyCo wants to reconsider its demand estimates. Were the rival to default, SandyCo believes that their demand would increase by roughly 10% across the board, leading to the following minimum expected demands: Region 1 - 28, Region 2 - 105, and Region 3 - 87 tons respectively. How many tons of sand should be delivered from DC A to Region 3 if the expected minimum demand was to increase by the amount specified? Note that the costs from Part 2 still apply. Round your answer to the nearest integer. Save Part 4 0.0/1.0 point (graded) The rival firm did not default - so your demand is back to the original values (Region 1: 25, Region 2: 95, and Region 3: 80). The management of Plant 2 has suggested they may use some of the available space in the plant for an on-site packaging machine. With such a machine in place, Plant 2 would be able to bypass the DCs and ship directly to Region 1. Direct transport from Plant 2 to Region 1 costs $275 per ton. All other costs remain the same as in Part 2. If Plant 2 invests in a on-site sand packaging machine, how many tons of sand should be delivered directly from Plant 2 to Region 1? Round your answer to the nearest integer. Submit You have used 0 of 2 attempts Part 5 0.0/1.0 point (graded) Save After investing in the new machine, a breakdown in DC B reduces the weekly capacity of DC B to 80 tons. All other costs and demand remain the same as in Part 2. (Note that the bypass option from Part 4 remains.) How many tons of sand should Plant 1 produce if the capacity of DC B drops to 80 tons? There is no capacity constraint for DC A. Round your answer to the nearest integer.
Expert Answer:
Answer rating: 100% (QA)
To answer your question well calculate the costs for the flows mentioned for SandyCos sand distribut... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
1. How strong are the competitive forces confronting J. Crew in the market for specialty retail? Do a [Michael Porter] five-forces analysis to support your answer. (see chapter 3 in the textfor...
-
Multi-Star, Inc., had sales of $890,000, cost of sales and operating expenses of $450,000 and $200,000, respectively, and 10,000 shares of common stock outstanding. Calculate the amount of earnings...
-
What is the book value of an asset? Discuss.
-
Merrick Inc. follows IFRS and is adjusting and correcting its books at the end of 2023. In reviewing its records, the following information has been compiled: 1. In 2023, the depreciation method on...
-
A European recession and the U.S. economy a. In 2014, European Union spending on U.S. goods accounted for \(18 \%\) of U.S. exports (see Table 17-2), and U.S. exports amounted to \(15 \%\) of U.S....
-
During 2012, Jensen Company disposed of three different assets. On January 1, 2012, prior to their disposal, the accounts reflected the following: The machines were disposed of in the following ways:...
-
1. A car has tires that have an outer diameter of 31 inches. If the wheels are turning with an angular velocity of 12 rad/s, how far in miles will the car travel in 2 hours? Enter your result rounded...
-
There is an array A made of N integers. Your task is to choose as many integers from A as possible so that, when they are put in ascending order, all of the differences between all pairs of...
-
Rew Company plans to issue bonds with a face value of $910,000 and a coupon rate of 6 percent. The bonds will mature in 10 years and pay interest semiannually every June 30 and December 31. All of...
-
What is parallel processing?
-
What is a heuristic in judgment and decision making? Why can heuristics be useful? Why should heuristics be identified and sometimes avoided to improve ones decision making?
-
What is the algorithmic strategy of divide and conquer?
-
What protocol is used to discover the hardware address of a node with a certain IP address? A. CIDR, or Classless Inter-Domain Routing B. SQL database C. ARP table D. Subnet mask
-
What is Privacy Compliance Risk Mitigation Strategy in which Amazon company present a high-level strategy for implementing the risk mitigations (security controls). This section should include a...
-
What is a plus-minus table good for? Mark all that apply a) Identifying irrelevant values b) Identifying dominated alternatives c) Adding up prons and cons to evaluate options d) Weighing pros and...
-
Imagine that your best friend knows you are taking a psychology course and wonders what psychology is all about. How would you define psychology for your friend? Write an essay on the discipline of...
-
Assume that a start-up manufacturing company raises capital through a series of equity issues. a. Using the financial statement template below, summarize the financial statement effects of the...
-
Walmart makes significant investments in operating capacity, primarily via investments in property, plant, and equipment, but also via investments in wholly and partially owned subsidiaries. Walmart...
-
Priority Contractors provides maintenance and cleaning services to various corporate clients in New York City. The firm has provided the following forecasts of net income for Year +1 to Year +5: Year...
-
Data from the last nine decades for the broad U.S. equity market yield the following statistics: average excess return, 8.3%; standard deviation, 20.1%. a. To the extent that these averages...
-
Suppose that the risk premium on the market portfolio is estimated at 8% with a standard deviation of 22%. What is the risk premium on a portfolio invested 25% in Toyota and 75% in Ford if they have...
-
Stock XYZ has an expected return of 12% and risk of = 1. Stock ABC has expected return of 13% and = 1.5. The markets expected return is 11%, and rf = 5%. a. According to the CAPM, which stock is a...
Study smarter with the SolutionInn App