Sunchem, a manufacturer of printing inks, has five manufacturing plants worldwide. Their locations, cost of producing...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sunchem, a manufacturer of printing inks, has five manufacturing plants worldwide. Their locations, cost of producing 1 ton of ink at each facility and capacities are shown in the table below: North South Capacity America Europe Japan America Asia $1300 $2000 $1200 $1400 ton/year Production cost/ton $10,000 15,000 euro 1,800,000 yen $600 $1300 $1700 $1400 $1300 $900 $2100 United States 185 $600 Germany Japan 475 $2000 $1200 $1400 $300 $1400 $2100 $1300 $1000 $2100 $800 50 Brazil 200 13,000 real India Demand $2200 $2300 $800 400,000 rupees 80 270 200 120 190 100 Table 1: Capacity, Demand, Production and Transportation Cost for Sunchem US$ Euro Yen Real Rupee 43.55 US$ 1 1.9333 107.7 1.78 Euro 0.502 54.07 0.89 21.83 Yen 0.0093 0.0185 0.016 0.405 Real 0.562 1.124 60.65 24.52 Rupee 0.023 0.046 2.47 0.041 Table 2: Anticipated Exchange Rates for the Next Year The production cost are in the local currency of the country where the plant is located. The major markets for the inks are North America, South America, Europe, Japan, and the rest of Asia. Demand at each market is also given in table 1. Transportation cost from each plant to each market (with dollar sign in table 1) are given in U.S. dollars. Management must come up with a production plan for the next year. Exchange rates are expected as in table 2. a) Which plants must open, and which markets will they supply? State the number of units that will be shipped from each plant to the markets. (Objective function = $7,816,450.00) Sunchem, a manufacturer of printing inks, has five manufacturing plants worldwide. Their locations, cost of producing 1 ton of ink at each facility and capacities are shown in the table below: North South Capacity America Europe Japan America Asia $1300 $2000 $1200 $1400 ton/year Production cost/ton $10,000 15,000 euro 1,800,000 yen $600 $1300 $1700 $1400 $1300 $900 $2100 United States 185 $600 Germany Japan 475 $2000 $1200 $1400 $300 $1400 $2100 $1300 $1000 $2100 $800 50 Brazil 200 13,000 real India Demand $2200 $2300 $800 400,000 rupees 80 270 200 120 190 100 Table 1: Capacity, Demand, Production and Transportation Cost for Sunchem US$ Euro Yen Real Rupee 43.55 US$ 1 1.9333 107.7 1.78 Euro 0.502 54.07 0.89 21.83 Yen 0.0093 0.0185 0.016 0.405 Real 0.562 1.124 60.65 24.52 Rupee 0.023 0.046 2.47 0.041 Table 2: Anticipated Exchange Rates for the Next Year The production cost are in the local currency of the country where the plant is located. The major markets for the inks are North America, South America, Europe, Japan, and the rest of Asia. Demand at each market is also given in table 1. Transportation cost from each plant to each market (with dollar sign in table 1) are given in U.S. dollars. Management must come up with a production plan for the next year. Exchange rates are expected as in table 2. a) Which plants must open, and which markets will they supply? State the number of units that will be shipped from each plant to the markets. (Objective function = $7,816,450.00)
Expert Answer:
Answer rating: 100% (QA)
We will solve this problem linear programming using Excel ... View the full answer
Related Book For
Mathematical Applications for the Management Life and Social Sciences
ISBN: 978-1305108042
11th edition
Authors: Ronald J. Harshbarger, James J. Reynolds
Posted Date:
Students also viewed these general management questions
-
Loki Company has 10 000 shares of ordinary shares outstanding at a market price of R55 a share. The firm also has a bond issue outstanding with a total face value of R250 000 which is selling for 105...
-
The values in the table below are measured maximum breadths (in millimeters) of male Egyptian skulls from different epochs (based on data from Ancient Races of the Thebaid, by Thomson and...
-
A company has the data shown in the table from the sale of its product. If x represents hundreds of units and revenue R is in hundreds of dollars, approximate the total revenue from the sale of 1000...
-
The Sellinger Business School's Information Technology Service (ITS) is considering a new process to refurbish older computers in order to save on costs of buying new computers. The five steps to the...
-
For the sample data below, construct four different interval estimates of the population mean-one each for the 90%, 95%, 99%, and 99.9% levels. What happens to the interval width as the confidence...
-
3- Calculate the following integrals by using the transform of z = ei -2 dx a- 0 cos(x)+4 b-So -2 dx 6sin(x)+10 -2 dx C- 0 So cos (x)+0.5
-
In 2015, Ottawa Oil Corporation paid \($40\) million for a partial interest in a Canadian oil field with proven reserves. The companys share of the future production was capped at eight million...
-
Iona wrote her will. The following year, she wrote another will that expressly revoked the earlier will. Later, while cleaning house, she came across the second will. She mistakenly thought that it...
-
1. Open the NP_EX_11-5.xlsx workbook located in the Excel11 > Case1 folder included with your Data Files. Save the workbook as NP_EX_11_Alcmaeon in the location specified by your instructor. 2. In...
-
On December 31, 2023, RCA Companys Allowance for Doubtful Accounts had an unadjusted debit balance of $7,800. The accountant for RCA has prepared a schedule of the December 31, 2023, accounts...
-
When Craig began operations on June 1, 2026 he contributed his own truck to the business. It was recorded in QB Online at its FMV (fair-market value) of $13,495. This truck was expected to last for 4...
-
An item costs $200 and has a markup percentage of 20% based on cost. Find the selling price.
-
The concepts and principles of analytics have remained consistent while the scope of available data and the technology to process data into information has rapidly evolved over time. Pick a...
-
Internet addiction is a significant issue for today's youth, how many times have you told your child to put away the device, only to be ignored? In this brief but informative video, the consequences...
-
Discuss presentism vs absenteeism What can a business do to reduce absenteeism and are the measures ethical?
-
Salinity The Puffer fish at the zoo requires the 405 gallon tank to be 4% salt. After a period of time, some water evaporated, raising the salinity to 9%. How many gallons of water must be resupplied...
-
BINOM.DIST function can be used to compute _____. Question 7 options: a) bin width for histograms b) binomial probabilities c) cumulative binomial probabilities d) binomial probabilities and...
-
You continue to work in the corporate office for a nationwide convenience store franchise that operates nearly 10,000 stores. The per- store daily customer count (i.e., the mean number of customers...
-
Determine a value for x that makes each statement true. 1. (A9)x = A 2. (B20)x = B 3. (7(R)x = R 4. ((T3)x = T
-
Juanita Domingo's parents want to establish a college trust for her. They want to make 16 quarterly withdrawals of $2000, with the first withdrawal 3 months from now. If money is worth 7.2%,...
-
Suppose that a company needs 1,500,000 items during a year and that preparation for each production run costs $600. Suppose also that it costs $15 to produce each item and $2 per year to store an...
-
On the evening of January 27, 1986, the temperature outside the Kennedy Space Center in Florida dropped below freezing. The National Aeronautics and Space Administration (NASA) had a dilemma. In...
-
Companies are sometimes faced with crisis management decisions. A good example is that of Ford with its Pinto brand. Compare Fords reaction, from an ethical perspective, to the gas tank problem in...
-
On February 26, 2009, the SEC accused Robert Allen Stanford of executing a massive Ponzi scheme over the last decade, in which he and his cohorts misappropriated funds and made more than \($1.6\)...
Study smarter with the SolutionInn App