A manufacturing firm has three 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 (25) Customer 2 (50) Customer 3 (125) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 Note: This question requires Solver.Formulate the problem in Solver and find the optimal solution. What is the minimum total cost to meet all customer requirements?

A manufacturing firm has three 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 (25) Customer 2 (50) Customer 3 (125) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 Note: This question requires Solver.Formulate the problem in Solver and find the optimal solution. What is the minimum total cost to meet all customer requirements?

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.
• 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
ADVANCED ANALYSIS Linear equations for the consumption and saving schedules take the general form: C = a + bY and S = -a + (1-b)Y where C, S, and Y are consumption, saving, and national income, respectively. The constant a represents the vertical intercept, and b represents the slope of the consumption schedule. a. Use the following data to substitute specific numerical values into the consumption and saving equations. Instructions: If you are entering any negative numbers be sure to include a negative sign (-) in front of those numbers. C = $ Y. S = $ Y. b. What is the economic meaning of b? . What is the economic meaning of (1 – b)? .
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 refiner in city Q serves three customers near city Wand maintains consignment inventory (owned by the refiner) at each location. Currently, the refiner uses TL (truckload) transportation to deliver separately to each customer. Each truck costs $650 plus $300 per stop. The refiner is considering aggregating deliveries to city Won a singletruck. The demand ofthe first customer is 96 tons a year, the demand of the second customer is 24 tons per year, and the demand of the third customer is 9.6 tons per year. Product cost is $7,700 per ton, and it uses a holding cost of 15%. Truck capacity is 15tons. a.What is the annual transportation and holding cost if the refiner ships a full truckload each time a customer is running out of stock? How many days of inventory is carried at each customer under this policy? b.What is the optimal delivery policy to each customer if the refiner ships separately to each of them? What is the annual transportation and holding cost? How many days of inventory…
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
A company manufactures tables and chairs. Each table and chair must be made entirely out of oak or entirely out of pine. A total of 150 board ft of oak are available. A table requires 17 board ft of oak, and a chair requires 5 board ft of oak. Each table can be sold for $40, and each chair for $15. A LP model has been formulated to help the company determine the production plan that maximizes revenue. Please draw a flow chart for the program
The chairperson of the department of management at Tech wants to forecast the number of students who will enroll in operations management next semester in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for the past 15 semesters: Using Exponential Smoothing with (α = 0.6) compute the forecasted number of student for semester 16 Semester Students Enrolled in OM 1 270 2 310 3 250 4 290 5 370 6 410 7 410 8 450 9 440 10 470 11 525 12 515 13 538 14 544 15 504

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 (25)	Customer 2 (50)	Customer 3 (125)	Customer 4 (75)
A (100)	$	15		$	10	$	20	$	17
B (75)	$	20		$	12	$	19	$	20
C (100)	$	22		$	20	$	25	$	14