Suppose in the original Grand Prix example that the routes from plant 2 to region 1 and
Question:
Transcribed Image Text:
Figure 14.12 Transportation Model A B D F G H K 1 Grand Prix transportation model Range names used: Capacity Demand Shipping Plan Total_cost =ModellSI$13:SIS15 =Model$C$18:$F$ 18 =Modell$C$13:$F$15 =Modell$B$21 =Modell$C$16:SF$16 =Modell$G$ 13:$G$15 3 Unit shipping costs 4 To Region 1 Region 2 Region 3 Region 4 $266 $263 5 6 From Plant 1 Plant 2 Plant 3 $131 $218 $120 Total_received Total shipped $278 $250 $178 $116 $132 8 $122 $180 10 Shipping plan, and constraints on supply and demand 11 To Region 1 Region 2 Region 3 Region 4 Total shipped 450 300 12 Сарacity| 13 From Plant 1 Plant 2 Plant 3 Total received 150 300 450 14 100 200 600 15 200 300 500 500 16 450 200 300 300 17 >= >= >= 18 Demand 450 200 300 300 19 20 Jobjective to minimize 21 Total cost $176,050
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 53% (13 reviews)
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt...View the full answer
Answered By
Rohith Bellamkonda
I am studying in IIT Indore,the most prestigious institute of India.I love solving maths and enjoy coding
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Question Posted:
Students also viewed these Statistics questions
-
How would you modify your design in Problem 12.101 if one of the pieces to be welded has a noncircular cross section?
-
How would you modify the statement of Theorem 7.62 if ker L {0}? Theorem 7.62 Suppose L: U V is a linear map between inner product spaces with ker L = {0} and adjoint map L*: V U. Let K = L* L: U...
-
Discuss the pros and cons of having the directors formally announce what a firms dividend policy will be in the future.
-
A contractor has the opportunity to choose between building a house or doing two extension works in the next 6 months. If you build the house and sell it, you can make $25,000. However, if the...
-
Think of your favourite retailers. How have the retailers integrated channel systems? How would you like to see channels integrated? Do you use multiple channels from the retailers? Why?
-
Ogden, Inc., issued a \(\$ 50,000,8 \%, 10\)-year bond payable at a price of 90 on January 1, 2006. Journalize the following transactions for Ogden. Include an explanation for each entry. a. Issuance...
-
\(\left(12^{5} ight)^{3}\) Simplify the expression.
-
Hudson Company operates two factories. The company applies factory overhead to jobs on the basis of machine hours in Factory 1 and on the basis of direct labor hours in Factory 2. Estimated factory...
-
Prepare journal entries for each of the foregoing entries that affected the Town of Bayshore. Begin with the tax levy entry, assuming 1 percent of the gross levy will be uncollectible. a. Record the...
-
Marty has been driving his Dads old beat up car to work and school. To embarrass him, Biff, the local bully, has challenged Marty to a race. If he wins, he gets $1,000 but if he loses, he pays...
-
Continuing the previous problem, make the problem even more general by allowing upper bounds (arc capacities) and lower bounds for the flows on the allowable arcs. Some of the upper bounds can be...
-
In the Red Brand two-product problem, we assumed that the unit shipping costs are the same for both products. Modify the spreadsheet model so that each product has its own unit shipping costs. You...
-
Evaluate the integral. s2 s ds
-
Which of the following statements is true of investments accounted for under the equity method? a. Investor reports its percentage share of the investees income in its operating income. b . Investor...
-
In accounting for available-for-sale-securities, the: a. Securities are reported at their fair value, along with their fair value adjustment from cost. b. Securities are reported at cost. c....
-
Community Medical Associates (CMA) is a large health care system with two hospitals, 25 satellite health centers, and 56 outpatient clinics. CMA had 1.5 million outpatient visits and 60,000 inpatient...
-
_____ consists of the interactions between management and unionized employees.
-
Which of the following conditions must exist for an item to be recorded as an asset? a. Item is not owned or controlled by the company. b. Future benefits from the item cannot be reliably measured....
-
What is the direct cause of sicklecell anemia (think primary structure)?
-
In the current year, the City of Omaha donates land worth $500,000 to Ace Corporation to induce it to locate in Omaha and create an estimated 2,000 jobs for its citizens. a. How much income, if any,...
-
Is the AE function the same thing as a demand curve? Why or why not?
-
What are the tax consequences to a partner who contributes liabilities that exceed the total basis of assets transferred to a new partnership in exchange for a partnership interest? How does your...
-
What inequities might result if partners were not required to make special allocations for precontribution gains and losses on noncash property contributed to a partnership?
-
Indicate whether a partners basis in the partnershipinterest increases, decreases, or is not affected by the partners share of the following operating items: a. Ordinary income b. Ordinary loss c....
-
Unit sales Contribution margin per unit Product X Product Y Product Z 2,000 $ 30 4,000 $ 20 4,000 $ 10 The average contribution margin for Company A is: Multiple Choice $18 per unit. $20 per unit....
-
When calculating earnings per share, a preferred dividend will affect the value of the numerator. True or false
-
In social responsibility reporting, the income statement bottom line is expanded to include financial, social and environmental performance, This standard is being only used in community government...
Study smarter with the SolutionInn App