A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 Note: This question requires Solver. Formulate the problem in Solver and find the optimal solution. What is the optimal quantity to ship from Factory B to Customer 3? Multiple Choice 25 units 50 units 75 units 100 units 125 units

A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 Note: This question requires Solver. Formulate the problem in Solver and find the optimal solution. What is the optimal quantity to ship from Factory B to Customer 3? Multiple Choice 25 units 50 units 75 units 100 units 125 units

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
• Use this information for the question below. Low-Grade Copper Ore $571 per Ton High-Grade Copper Ore $843 per Ton Coloma Cooper Incorporated is able to produce $640 worth of copper from one ton of low-grade copper ore. Because of its higher copper content, Coloma can produce $940 worth of copper from one ton of high-grade copper ore. A mining company is offering to trade 7,250 tons of low-grade copper ore for 5,000 tons of high-grade copper ore. Assuming Coloma currently has 5,000 tons of high-grade ore, what should it do?
Refer to the Factory-to-Six-Customers problem and start with the original information. Each customer increases demand by 1000 units. This increased demand has to be met. Re-calculate the optimal solution. At the new solution, which of the following statements is true? A. The total shipping costs are $252,900 B. Quantity shipped from Factory 1 to Customer 1 declines by 6000 units C. Both A and B D. Neither A nor
A tire company has the following capacity and demand data for the year: Capacity = 3,000 tires per month Demand for the first six (6) months (January – June) = 2, 500 tires per month Demand for the next six (6) months (July – December) = 4, 000 tires per month If the company decides to produce tires at capacity (3, 000 tires per month) during the first six months, how many tires will it be able to build up in its inventory after six months? How many months will the built-up inventory computed in A last to meet the increasing demand. Assuming that the company continues to product at capacity per month. (
A production line is a set of sequential operations established in a factory plant where components are assembled to make a finished product or where materials are put through a refining process to produce an end-product that is suitable for onward consumption. Ford have seven production lines in their manufacturing plant for their automotive parts where each production line produces 120, 100, 80, 116, 77, 94, 112 output per day. (a) As the Production Manager at Ford, you are required to submit the daily report of the production plant. Calculate the mean, median, and mode from the data based on the output that has been provided. (b) Also calculate the three critical parameters for measuring spread in the following ways: Range Variance Standard Deviation
the excel file president’s inn guest database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed- and-breakfast inn during one month. room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. guests staying for seven days or more receive a 10% discount. modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem.
A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem. Part B: Solve the problem (provide exact values for all variables and the optimal objective function).
Please show solution and formula used. Assuming the total number of students studying in the top four universities in the Philippines is approximately 158,000. And the distribution is as follows: University of the Philippines (UP) - 40% of the total number Ateneo de Manila University (ADMU) - 23,700 De La Salle University (DLSU) - 25% of the total number University of Santo Tomas - 20% of the total number And only the following number of students owns a tablet computer: 20% of UP students 85% of ADMU students 90% of DLSU students 85% of UST students What is the total market penetration of tablet computers among the students of the top four universities? What is the total market size of tablet computers in the top four universities?
The operations manager for an auto supply company is evaluating the potential purchase of a new machine for the production of a transmission component. Current manufacturing costs are fixed costs of $11,000 and a variable cost of $0.50 per unit. The new machine would have fixed cost of $4,000 and a variable cost of $0.75 per unit. Each component is sold for $1.50 per unit. Develop two separate models in your spreadsheet to calculate Total Profit for each option. The models must be flexible and able to calculate Total profit for any Quantity produced. ( use an excel sheet to show formulas) . Find the break-even quantity for each option

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

	Customer (requirement)
Factory (capacity)	Customer 1 (125)	Customer 2 (150)	Customer 3 (175)	Customer 4 (75)
A (100)	$	15		$	10	$	20	$	17
B (75)	$	20		$	12	$	19	$	20
C (100)	$	22		$	20	$	25	$	14
D (250)	$	21		$	15	$	28	$	12