EX3.Resource Allocation A furniture manufacturer has plants in Austin, TX and Huston, TX. For a popular...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
EX3.Resource Allocation A furniture manufacturer has plants in Austin, TX and Huston, TX. For a popular dining table and chair set that they sell for $1,200, they face the following logistics problem: Austin, TX Capacity = 2,400 New York: Demand = 1,500 Atlanta: Demand = 1,000 Chicago: Demand = 1,250 Huston, TX Capacity = 3,500 Cincinnati: Demand = 750 Detroit: Demand = 1,000 To determine how much to ship from each plant to each market, we need to know the per-uni transportation costs. For example, the per-unit transportation cost from Austin to Chicago is $225. CHI CINC DET $175 $175 NY ATL $150 $100 $225 $150 $200 $100 $100 $100 Austin Huston Note that, given the variable production costs of $500 (Austin) and $550 (Lansing), the total per-unit cost of supplying the markets is: e CHI CINC DET $650 $600 $725 $675 $675 $700 $750 $650 $650 s650 NY ATL Austin Huston For example, the total per-unit transportation cost from Austin to Chicago is $725 (=$500+S225). Your tasks: (a) Write the decision variables, objective function, and constraints. (b) Solve the problem using an Excel solver: what is your optimal solution? e ottttt EX3.Resource Allocation A furniture manufacturer has plants in Austin, TX and Huston, TX. For a popular dining table and chair set that they sell for $1,200, they face the following logistics problem: Austin, TX Capacity = 2,400 New York: Demand = 1,500 Atlanta: Demand = 1,000 Chicago: Demand = 1,250 Huston, TX Capacity = 3,500 Cincinnati: Demand = 750 Detroit: Demand = 1,000 To determine how much to ship from each plant to each market, we need to know the per-uni transportation costs. For example, the per-unit transportation cost from Austin to Chicago is $225. CHI CINC DET $175 $175 NY ATL $150 $100 $225 $150 $200 $100 $100 $100 Austin Huston Note that, given the variable production costs of $500 (Austin) and $550 (Lansing), the total per-unit cost of supplying the markets is: e CHI CINC DET $650 $600 $725 $675 $675 $700 $750 $650 $650 s650 NY ATL Austin Huston For example, the total per-unit transportation cost from Austin to Chicago is $725 (=$500+S225). Your tasks: (a) Write the decision variables, objective function, and constraints. (b) Solve the problem using an Excel solver: what is your optimal solution? e ottttt
Expert Answer:
Answer rating: 100% (QA)
Answer a Pls see the explanation section below for ... View the full answer
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these management leadership questions
-
The Kartick Company is trying to determine how much of each of two products to produce over the coming planning period. There are three departments, A, B and C, with limited labor hours available in...
-
A university is trying to determine how much it should charge for tickets to basketball games to help offset the expenses of the new arena. The cost to build the arena including labor, materials,...
-
In this assignment you are asked to determine how much ClearEye's pre-tax profit would change if the increased patient yield (increase of patients having their operations at ClearEyes from 5,283 to...
-
Write a program that takes the name of an image file as a command-line argument, and creates and shows three Picture objects, one that contains only the red components, one for green, and one for...
-
In the citation Schusters Express, Inc., 66 T.C. 588 (1976), affd 562 F.2d 39 (CA2, 1977), nonacq., to what do the 66, 39, and nonacq. refer?
-
Mike purchases a heavy-duty truck (5-year class recovery property) for his delivery service on April 30, 2013. The truck is not considered a passenger automobile for purposes of the listed property...
-
Analyze the tube-flow reactor data in Table B. 6 using all possible regressions. Evaluate the subset models using the \(R_{p}^{2}, C_{p}\), and \(M S_{\text {Res }}\) criteria. Justify your choice of...
-
Once a company allocates corporate costs to divisions these costs should not be reallocated to the indirect-cost-pools of the division. Do you agree? Explain.
-
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's reporting year - end is December 3 1 . The unadjusted trial balance as of December 3 1 , 2 0 2 4...
-
For the liquid storage system shown in Fig. E, it is desired to control liquid levels h1 and h2 by adjusting volumetric flow rates q1 and q2. Flow rate q6 is the major disturbance variable. The...
-
Reading Passage: In the wake of the global health crisis, the number of professionals suffering from workplace burnout has risen and is still rising significantly. Workplace burnout is an ongoing...
-
You want to invest a total sum of $10,000 in the market portfolio and the risk free asset. The market portfolio has an expected rate of return of 12%, and the risk free asset has a rate of return of...
-
For those who are nostalgic for the classic drivein diner experience, the Sonic fast-food chain helps fill that need. Sonic offers customers a dose of nostalgia with its 1950s-style curbside speakers...
-
1. Mark has a choice of investments; Mark can invest in City of Nowhere Bonds which pay 6% interest or in Big Bad Corporation bonds that pay 9% interest. Mark has a marginal tax rate of 40%. If both...
-
In the context of lysosomal storage disorders, what specific molecular defects lead to the aberrant accumulation of macromolecules within lysosomes, and how do these conditions manifest clinically?
-
On January 1, 2024, Alamar Corporation acquired a 35 percent interest in Burks, Incorporated, for $235,000. On that date, Burks's balance sheet disclosed net assets with both a fair and book value of...
-
What coefficient of friction is necessary to keep a car traveling 5 0 mi / hr in a turn with a radius of 9 5 m ? What coefficient of friction is needed to keep a car traveling 5 0 mi / hr in the turn...
-
For the given transfer function: Vo(s) / Vi(s) = (s^2C^2R^2 + 1) / (s^2C^2R^2 + 4sCR + 1) Assumiing that 1/(CR) = 120 PI so write the matlab code to find the magnitude plot
-
Use Solver to create a Sensitivity Report for question 29 at the end of Chapter 3 and answer the following questions: a. Is the optimal solution unique? How can you tell? b. Which location is...
-
Refer to question 5. The MBA director could make two types of admission mistakes using DA. One mistake is to classify a student into the weak category (and, therefore, not admit the student) when, in...
-
The owner of a local car dealership has just received a call from a regional distributor stating that a $5,000 bonus will be awarded if the owner's dealership sells at least 10 new cars next...
-
Some people argue that the government should not intervene in the case of a market failure because the government itself is inefficient and will simply create new problems to replace the ones it is...
-
Consider each of the following issues and discuss whether you support Theory X, Theory Y, neither theory, or some combination of them. Issue Theory X Theory Y Whether a person is healthy or sick...
-
Looking at Medicaids traditional eligibility rules, you will notice numerous value/policy judgmentspregnant women and children are favored over childless adults, the medically needy are favored over...
Study smarter with the SolutionInn App