Homework Answers
Let,
xij = number of cars transported from plant i to distributor j where i = {A=1,B=2,C=3} and j ={I=1,II=2,III=3}
Objective is to minimize transportation cost = Min 230x11+410x12+210x13+150x21+320x22+230x23+190x31+130x32+200x33
subject to,
Capacity constraints
x11+x12+x13 <= 200 (Plant A)
x21+x22+x23 <= 150 (Plant B)
x31+x32+x33 <= 250 (Plant C)
x11+x21+x31 = 120 (Distributor 1)
x12+x22+x32 = 270 (Distributor 2)
x13+x23+x33 = 200 (Distributor 3)
xij >= 0
Solving in solver we get following optimal transportation schedule
| Plant A | Plant B | Plant C | |
| Distributor 1 | 0 | 0 | 120 |
| Distributor 2 | 200 | 70 | 0 |
| Distributor 3 | 0 | 80 | 120 |
Minimized cost = 169600
Solver screenshot
Solver formula
Solver window
Add Answer to:
Problem 2 (25 points): (Transportation problem) A car manufacturer has three assembly lines, Plant A, B,...
2. Consider a car manufacturer that assembles different trim levels of a car: i) Basic has...
2. Consider a car manufacturer that assembles different trim levels of a car: i) Basic has all the basic features of a car ii Luxury - has everything the Basic version has plus luxury features, e.g. leather seats, high-fidelity sound system, etc. i) Ultimate has everything the Luxury version has plus state-of-the-art features, e.g. lane-following, turn-by-turn navigation, etc. Design a system that can easily assemble a car of any trim level that a user requires. Draw the Class diagram. There...
Problem 2. (10 points) Froberg Aerospace LLC. has three plants producing small-sat propulsion units that are...
Problem 2. (10 points) Froberg Aerospace LLC. has three plants producing small-sat propulsion units that are to be shipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipments per month, respectively Each distribution center needs to receive 10 shipments per month. The distance from each plant to the respective distribution centers is given below Distance to Distribution Center Miles Distribution Center1 800 1,100 600 Distribution Center2 1,300 1,400 1.200 Distribution Center 3 400 600...
Q4: 3 marks A manufacturer has three machines I, Il and Il installed in his factory....
Q4: 3 marks A manufacturer has three machines I, Il and Il installed in his factory. Machines I and Il are capable of being operated for at most 12 hours whereas machine III must be operated for at least 5 hours a day. She produces only two items M and N each requiring the use of all the three machines. The number of hours required for producing 1 unit of each of M and N on the three machines are...
Location Section Project A small logistic company named LogTransit currently has 3 manufacturing facilities (suppliers) called...
Location Section Project A small logistic company named LogTransit currently has 3 manufacturing facilities (suppliers) called Supplier #1, #2 and #3 to supply for goods of its 3 retail stores (customers) called Customer A, B, and C. Due to customer demands at stores are increasing, the company is considering to construct a new manufacturing facility. The new factory will have a supply capacity of 200 units per week. After screening many potential sites, Toledo and Cincinnati have been determined to...
Solve the following LP problems using the Solver in MS Excel. Q1. A candy manufacturer has...
Solve the following LP problems using the Solver in MS Excel. Q1. A candy manufacturer has 130 pounds of chocolate-covered cherries and 170 pounds of chocolate-covered mints in stock. He decides to sell them in the form of two different mixtures. One mixture will contain half cherries and half mints by weight and will sell for $2.00 per pound. The other mixture will contain one-third cherries and two-thirds mints by weight and will sell for $1.25 per pound. How many...
Answer the problem 2 only please. Also if you could upload the excel sheet as well...
Answer the problem 2 only please. Also if you could upload the
excel sheet as well will be very appreciated. thanks
OPR 3450 - Fall 2019 Assignment 1 due 09/09/19 page 1 of 1 Assignment 1 This is due in class on multiple dates. Check each Part. Each person must submit his/her own answer. If anyone submits a copy of an assignment, everyone with that submission will get a zero on the assignment. I will not accept e-mail assignments. Each...
CASE 2 AFG is a leading manufacturer of Branded Consumer Food. It has a total of...
CASE 2 AFG is a leading manufacturer of Branded Consumer Food. It has a total of 200 brand and maintains around 600 SKU (stock-keeping-unit). The company has a total of 10 plants thus it maintains also the same number of Inbound Warehouses. It also operates 15 Distribution Centers/Outbound Warehouse nationwide. The head of the plant organization is the Production and Operation Manager and under his control includes the Production Personnel, Maintenance and Engineering Department, Quality Control, Production Planning, Supply Chain...
1) Come up with a single (one) question or problem 2) Think of an example with 30 data points a. ...
1) Come up with a single (one) question or problem
2) Think of an example with 30 data points
a. This data needs to be of a quantitative variable
(numbers).
3) Then proceed to follow the below steps.
example of 30 quantitative data points
Purpose
State how, when, and where data was collected
List of raw data pairs
Frequency distribution (table)
Histogram
Relative percentage polygon
Sample mean
Sample median
Sample mode(s)
Sample range
Sample variance
Sample standard deviation
Coefficient of...
Exercise 2 Linear Programming 1. The Scrod Manufacturing Co. produces two key items – special-purpose Widgets...
Exercise 2 Linear Programming 1. The Scrod Manufacturing Co. produces two key items – special-purpose Widgets (W) and more generally useful Frami (F). Management wishes to determine that mix of W & F which will maximize total Profits (P). Data W F Unit profit contributions $ 30 $ 20 Demand estimates (unit/week) 250 500 Average processing rates – each product requires processing on both machines (units/hour) Machine #1 2 4 Machine #2 ...
CORRECTED: ABC ORIGINAL PROBLEM DATA (18I Excel File: CHECK FIGURES: AX40 Traditional Unit Cost: $62.75 EX90...
CORRECTED: ABC ORIGINAL PROBLEM DATA (18I Excel File: CHECK FIGURES: AX40 Traditional Unit Cost: $62.75 EX90 ABC Unit Cost: $116.80 For several years, Adria Manufacturing has produced a single product called AX40. Then two years ago, the company automated a portion of its plant and at the same time introduced a second product called EX90 which has become increasingly popular. The EX90 is a more complex product, requiring one hour of direct labor time per unit to manufacture and extensive...
2. Consider a car manufacturer that assembles different trim levels of a car: i) Basic has all the basic features of a car ii Luxury - has everything the Basic version has plus luxury features, e.g. leather seats, high-fidelity sound system, etc. i) Ultimate has everything the Luxury version has plus state-of-the-art features, e.g. lane-following, turn-by-turn navigation, etc. Design a system that can easily assemble a car of any trim level that a user requires. Draw the Class diagram. There...
Problem 2. (10 points) Froberg Aerospace LLC. has three plants producing small-sat propulsion units that are to be shipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipments per month, respectively Each distribution center needs to receive 10 shipments per month. The distance from each plant to the respective distribution centers is given below Distance to Distribution Center Miles Distribution Center1 800 1,100 600 Distribution Center2 1,300 1,400 1.200 Distribution Center 3 400 600...
Q4: 3 marks A manufacturer has three machines I, Il and Il installed in his factory. Machines I and Il are capable of being operated for at most 12 hours whereas machine III must be operated for at least 5 hours a day. She produces only two items M and N each requiring the use of all the three machines. The number of hours required for producing 1 unit of each of M and N on the three machines are...
Location Section Project A small logistic company named LogTransit currently has 3 manufacturing facilities (suppliers) called Supplier #1, #2 and #3 to supply for goods of its 3 retail stores (customers) called Customer A, B, and C. Due to customer demands at stores are increasing, the company is considering to construct a new manufacturing facility. The new factory will have a supply capacity of 200 units per week. After screening many potential sites, Toledo and Cincinnati have been determined to...
Answer the problem 2 only please. Also if you could upload the
excel sheet as well will be very appreciated. thanks
OPR 3450 - Fall 2019 Assignment 1 due 09/09/19 page 1 of 1 Assignment 1 This is due in class on multiple dates. Check each Part. Each person must submit his/her own answer. If anyone submits a copy of an assignment, everyone with that submission will get a zero on the assignment. I will not accept e-mail assignments. Each...
1) Come up with a single (one) question or problem
2) Think of an example with 30 data points
a. This data needs to be of a quantitative variable
(numbers).
3) Then proceed to follow the below steps.
example of 30 quantitative data points
Purpose
State how, when, and where data was collected
List of raw data pairs
Frequency distribution (table)
Histogram
Relative percentage polygon
Sample mean
Sample median
Sample mode(s)
Sample range
Sample variance
Sample standard deviation
Coefficient of...
CORRECTED: ABC ORIGINAL PROBLEM DATA (18I Excel File: CHECK FIGURES: AX40 Traditional Unit Cost: $62.75 EX90 ABC Unit Cost: $116.80 For several years, Adria Manufacturing has produced a single product called AX40. Then two years ago, the company automated a portion of its plant and at the same time introduced a second product called EX90 which has become increasingly popular. The EX90 is a more complex product, requiring one hour of direct labor time per unit to manufacture and extensive...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago