Question

In: Operations Management

You have three plants that produce a certain type of boats. The capacity for next month...

You have three plants that produce a certain type of boats. The capacity for next month is 38 in San Diego, 45 in Santa

Ana, and 58 in San Jose. Production cost per boat is $1,065 in San Diego, $1,005 in Santa Ana, and $975 in San Jose.

Demand for next month is 42 in Newport Beach, 33 in Long Beach, 14 in Ventura, 10 in San Luis Obispo, and 22 in San

Francisco. The shipping costs per boat are summarized in the following table:

Shipping Cost to:
From NB LB VEN SLO SF
SD $200 $220 $280 $350 $400
SA $125 $125 $280 $350 $400
SJ $390 $365 $300 $250 $100

Develop a production and shipping schedule that minimizes the total cost of production and shipping while satisfying all

the demand.

Solutions

Expert Solution

We tabulate the given data as shown below:

The above table considers transportation cost as well as production cost at each location.

We solve this problem in Excel using Excel Solver as shown below:

Here Total Demand = 42 + 33 + 14 + 10 + 22 = 121

Total Supply = 38 + 45 + 58 = 141

Total Demand < Total Supply. Hence, there will be "<=" sign in Excel Solver for Supply Constraint

We get solution as:

The above solution in the form of formulas along with Excel Solver extract is shown below for better understanding and reference:

The no. of boats to be supplied and transported from each location to each destination is shown as highlighted in purple in the Variables tables above.

----------------------------------------------------------------------------------------------------------------------------------------------------

In case of any doubt, please ask through the comment section before Upvote/downvote.


Related Solutions

A firm need to produce the following number of units during the next three months; month...
A firm need to produce the following number of units during the next three months; month 1, 200 units; month 2, 300 units; month 3, 300 units. For each unit produced during months 1 and 2, a $9 variable cost is incurred; for each unit produced during month 3, a $12 variable cost is incurred. The inventory cost is $2.50 for each unit in stock at the end of a month. The cost of setting up for production during a...
firm need to produce the following number of units during the next three months; month 1,...
firm need to produce the following number of units during the next three months; month 1, 200 units; month 2, 300 units; month 3, 300 units. For each unit produced during months 1 and 2, a $9 variable cost is incurred; for each unit produced during month 3, a $12 variable cost is incurred. The inventory cost is $2.50 for each unit in stock at the end of a month. The cost of setting up for production during a month...
You can pay $91 per month, starting next month, for the next 5 years to have...
You can pay $91 per month, starting next month, for the next 5 years to have a lawn mowing service. Alternatively, you can purchase a riding lawn mower and pay $506 today and mow your own lawn for 5 years, starting next month. If you decide to mow your own lawn, how much do you save in PV terms if your investments earn 3.31% APR, compounded monthly? Note: If you would lose money, make your answer with a negative sign...
You can pay $110 per month, starting next month, for the next 5 years to have a lawn mowing service.
You can pay $110 per month, starting next month, for the next 5 years to have a lawn mowing service. Alternatively, you can purchase a riding lawn mower and pay $587 today and mow your own lawn for 5 years, starting next month. If you decide to mow your own lawn, how much do you save in PV terms if your investments earn 4.92% APR, compounded monthly? Note: If you would lose money, make your answer with a negative sign...
The Versatech Corporation has decided to produce three new products. Five branch plants now have excess...
The Versatech Corporation has decided to produce three new products. Five branch plants now have excess production capacity. The unit manufacturing cost of the first product would be $31, $29, $32, $28, and $29 in Plants 1, 2, 3, 4, and 5, respectively. The unit manufacturing cost of the second product would be $45, $41, $46, $42, and $43 in Plants 1, 2, 3, 4, and 5, respectively. The unit manufacturing cost of the third product would be $38, $35,...
For this question, assume that you expect the market to drop over the next month.  You have...
For this question, assume that you expect the market to drop over the next month.  You have four possible strategies: Short the SPY ETF Short S&P500 futures contracts with May delivery Sell Call Options on SPY, with May expiration Buy Put Options on SPY, with May expiration Critically evaluate both the return and risk of each of these strategies.  Be sure to justify all answers.
Q6. Chitin is used to produce a certain type of surgical thread. a) What physical and...
Q6. Chitin is used to produce a certain type of surgical thread. a) What physical and chemical properties make it an ideal material for this purpose? b) Propose another product that chitin could be used for in everyday life. c) Why should products made of Chitin be relatively inexpensive to mass produce? Q7. Why do proteins have more diverse functional role in a cell than do carbohydrate? Q8. Why do the elements 8,16,and 34 belong to the same family on...
In a certain population, 25% of the person smoke and 7% have a certain type of...
In a certain population, 25% of the person smoke and 7% have a certain type of heart disease. Moreover, 10% of the persons who smoke have the disease. What percentage of the population smoke and have the disease? What percentage of the population with the disease also smoke?
The Immanuel Company has the capacity to produce 75,000 bins per month. - Fixed production costs...
The Immanuel Company has the capacity to produce 75,000 bins per month. - Fixed production costs are $120,000 per month, and the company currently sells 70,000 bins at $13 each based on the following unit costs: - Variable production cost $5.60 - Fixed production costs 1.60[Based on capacity] - Variable selling expense 1.00 The Immanuel Co has just obtained a request for a special order of 6,000 bins to be shipped at the end of the month at a selling...
The Molis Corporation has the capacity to produce 15,000 haks each month. Current regular production and...
The Molis Corporation has the capacity to produce 15,000 haks each month. Current regular production and sales are 10,000 haks per month at a selling price of $15 each. Based on this level of activity, the following unit costs are incurred:    Direct materials $5.00 Direct labor $3.00 Variable manufacturing overhead $0.75 Fixed manufacturing overhead $1.50 Variable selling expense $0.25 Fixed administrative expense $1.00 The fixed costs, both manufacturing and administrative, are constant in total within the relevant range of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT