Concept explainers
a)
To determine: The optimal plan using the transportation method.
Introduction: Aggregate planning using transportation method helps to attain minimum cost using the optimal plan. The major advantage of transportation method is to achieve the optimal solution using optimal plans.
a)
Answer to Problem 17P
The optimal plan using the transportation method has been developed.
Explanation of Solution
Given information:
The following information has been given:
Quarter |
| Regular time | Overtime | Subcontract |
1 | 500 | 400 | 80 | 100 |
2 | 750 | 400 | 80 | 100 |
3 | 900 | 800 | 160 | 100 |
4 | 450 | 400 | 80 | 100 |
Initial inventory is given as 250 units, regular time cost is $1 per unit, overtime cost is $1.50 per unit, and subcontract cost is $2 per unit. Carrying cost is given as $0.5 per unit per quarter and backorder cost is $0.5 per unit per quarter. Initial inventory would incur $0.2 per unit.
Develop optimal plan using transportation model:
Develop cost matrix:
Cost matrix | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Ending inventory | Supply |
Beginning inventory | 0.2 | 0.4 | 0.6 | 0.8 | 1 | 250 |
Regular time 1 | 1 | 1.2 | 1.4 | 1.6 | 1.8 | 400 |
Over time 1 | 1.5 | 1.7 | 1.9 | 2.1 | 2.3 | 80 |
Subcontract 1 | 2 | 2.2 | 2.4 | 2.6 | 2.8 | 100 |
Regular time 1 | 1.5 | 1 | 1.2 | 1.4 | 1.6 | 400 |
Over time 1 | 2 | 1.5 | 1.7 | 1.9 | 2.1 | 80 |
Subcontract 1 | 2.5 | 2 | 2.2 | 2.4 | 2.6 | 100 |
Regular time 1 | 2 | 1.5 | 1 | 1.2 | 1.4 | 400 |
Over time 1 | 2.5 | 2 | 1.5 | 1.7 | 1.9 | 80 |
Subcontract 1 | 3 | 2.5 | 2 | 2.2 | 2.4 | 100 |
Regular time 1 | 2.5 | 2 | 1.5 | 1 | 1.2 | 400 |
Over time 1 | 3 | 2.5 | 2 | 1.5 | 1.7 | 80 |
Subcontract 1 | 3.5 | 3 | 2.5 | 2 | 2.2 | 100 |
Demand | 500 | 750 | 900 | 450 | 2570 | |
2600 |
Excel worksheet to generate the above table:
Develop optimal plan:
Optimal plan | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Ending inventory | Dummy |
Beginning inventory | 100 | 150 | ||||
Regular time 1 | 400 | |||||
Over time 1 | 80 | |||||
Subcontract 1 | 100 | |||||
Regular time 1 | 400 | |||||
Over time 1 | 80 | |||||
Subcontract 1 | 100 | |||||
Regular time 1 | 800 | |||||
Over time 1 | 40 | 100 | 20 | |||
Subcontract 1 | 100 | |||||
Regular time 1 | 400 | |||||
Over time 1 | 50 | 30 | ||||
Subcontract 1 | 100 | |||||
Demand | 500 | 750 | 900 | 450 |
The given demand and supply should be separated and the remaining supply and demand should be used as a dummy value.
b)
To determine: The total cost of the optimal plan.
Introduction: Aggregate planning using transportation method helps to attain minimum cost using the optimal plan. The major advantage of transportation method is to achieve the optimal solution using optimal plans.
b)
Answer to Problem 17P
The optimal cost of the plan is $2,641.
Explanation of Solution
Given information:
The following information has been given:
Quarter | Forecast (units) | Regular time | Overtime | Subcontract |
1 | 500 | 400 | 80 | 100 |
2 | 750 | 400 | 80 | 100 |
3 | 900 | 800 | 160 | 100 |
4 | 450 | 400 | 80 | 100 |
Initial inventory is given as 250 units, regular time cost is $1 per unit, overtime cost is $1.50 per unit, and subcontract cost is $2 per unit. Carrying cost is given as $0.5 per unit per quarter and backorder cost is $0.5 per unit per quarter. Initial inventory would incur $0.2 per unit.
Develop optimal plan using transportation model:
Develop cost matrix:
Cost matrix | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Ending inventory | Supply |
Beginning inventory | 0.2 | 0.4 | 0.6 | 0.8 | 1 | 250 |
Regular time 1 | 1 | 1.2 | 1.4 | 1.6 | 1.8 | 400 |
Over time 1 | 1.5 | 1.7 | 1.9 | 2.1 | 2.3 | 80 |
Subcontract 1 | 2 | 2.2 | 2.4 | 2.6 | 2.8 | 100 |
Regular time 1 | 1.5 | 1 | 1.2 | 1.4 | 1.6 | 400 |
Over time 1 | 2 | 1.5 | 1.7 | 1.9 | 2.1 | 80 |
Subcontract 1 | 2.5 | 2 | 2.2 | 2.4 | 2.6 | 100 |
Regular time 1 | 2 | 1.5 | 1 | 1.2 | 1.4 | 400 |
Over time 1 | 2.5 | 2 | 1.5 | 1.7 | 1.9 | 80 |
Subcontract 1 | 3 | 2.5 | 2 | 2.2 | 2.4 | 100 |
Regular time 1 | 2.5 | 2 | 1.5 | 1 | 1.2 | 400 |
Over time 1 | 3 | 2.5 | 2 | 1.5 | 1.7 | 80 |
Subcontract 1 | 3.5 | 3 | 2.5 | 2 | 2.2 | 100 |
Demand | 500 | 750 | 900 | 450 | 2570 | |
2600 |
Excel worksheet to generate the above table:
Develop optimal plan:
Optimal plan | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Ending inventory | Dummy |
Beginning inventory | 100 | 150 | ||||
Regular time 1 | 400 | |||||
Over time 1 | 80 | |||||
Subcontract 1 | 100 | |||||
Regular time 1 | 400 | |||||
Over time 1 | 80 | |||||
Subcontract 1 | 100 | |||||
Regular time 1 | 800 | |||||
Over time 1 | 40 | 100 | 20 | |||
Subcontract 1 | 100 | |||||
Regular time 1 | 400 | |||||
Over time 1 | 50 | 30 | ||||
Subcontract 1 | 100 | |||||
Demand | 500 | 750 | 900 | 450 |
The given demand and supply should be splitted and the remaining supply and demand should be used as a dummy value.
Calculate the total optimal cost:
It is calculated by adding the multiple of values in the optimal plan table and the value in the cost matrix to the respective value.
Hence, the total optimal cost is $2,641.
c)
To determine: The number of units remained unused in regular time capacity.
Introduction: Aggregate planning using transportation method helps to attain minimum cost using the optimal plan. The major advantage of transportation method is to achieve the optimal solution using optimal plans.
c)
Answer to Problem 17P
No, the regular time capacity remains unused.
Explanation of Solution
Given information:
The following information has been given:
Quarter | Forecast (units) | Regular time | Overtime | Subcontract |
1 | 500 | 400 | 80 | 100 |
2 | 750 | 400 | 80 | 100 |
3 | 900 | 800 | 160 | 100 |
4 | 450 | 400 | 80 | 100 |
Initial inventory is given as 250 units, regular time cost is $1 per unit, overtime cost is $1.50 per unit, and subcontract cost is $2 per unit. Carrying cost is given as $0.5 per unit per quarter and backorder cost is $0.5 per unit per quarter. Initial inventory would incur $0.2 per unit.
Develop optimal plan:
Optimal plan | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Ending inventory | Dummy |
Beginning inventory | 100 | 150 | ||||
Regular time 1 | 400 | |||||
Over time 1 | 80 | |||||
Subcontract 1 | 100 | |||||
Regular time 1 | 400 | |||||
Over time 1 | 80 | |||||
Subcontract 1 | 100 | |||||
Regular time 1 | 800 | |||||
Over time 1 | 40 | 100 | 20 | |||
Subcontract 1 | 100 | |||||
Regular time 1 | 400 | |||||
Over time 1 | 50 | 30 | ||||
Subcontract 1 | 100 | |||||
Demand | 500 | 750 | 900 | 450 |
The given demand and supply should be separated and the remaining supply and demand should be used as a dummy value.
Determine whether the regular time capacity remain unused:
From the above table, it is clear that no regular time capacity remains unused. All the regular time capacity has been used in respective quarters.
d)
To determine: The extent of backordering in units and dollars.
Introduction: Aggregate planning using transportation method helps to attain minimum cost using the optimal plan. The major advantage of transportation method is to achieve the optimal solution using optimal plans.
d)
Answer to Problem 17P
The total unit of the backordered is 40 units and the total cost of producing the backorders are $20.
Explanation of Solution
Given information:
The following information has been given:
Quarter | Forecast (units) | Regular time | Overtime | Subcontract |
1 | 500 | 400 | 80 | 100 |
2 | 750 | 400 | 80 | 100 |
3 | 900 | 800 | 160 | 100 |
4 | 450 | 400 | 80 | 100 |
Initial inventory is given as 250 units, regular time cost is $1 per unit, overtime cost is $1.50 per unit, and subcontract cost is $2 per unit. Carrying cost is given as $0.5 per unit per quarter and backorder cost is $0.5 per unit per quarter. Initial inventory would incur $0.2 per unit.
Develop optimal plan:
Optimal plan | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Ending inventory | Dummy |
Beginning inventory | 100 | 150 | ||||
Regular time 1 | 400 | |||||
Over time 1 | 80 | |||||
Subcontract 1 | 100 | |||||
Regular time 1 | 400 | |||||
Over time 1 | 80 | |||||
Subcontract 1 | 100 | |||||
Regular time 1 | 800 | |||||
Over time 1 | 40 | 100 | 20 | |||
Subcontract 1 | 100 | |||||
Regular time 1 | 400 | |||||
Over time 1 | 50 | 30 | ||||
Subcontract 1 | 100 | |||||
Demand | 500 | 750 | 900 | 450 |
The given demand and supply should be separated and the remaining supply and demand should be used as a dummy value.
Determine the extent backordering in units and dollars:
The colored cell is the only cell in the optimal plan, which is used for backordering. Hence, the backordering in units is 40 units. It is given that backorder cost is $0.50 per unit per quarter.
Hence, the total unit backordered is 40 units and the total costs of producing the backorders are $20.
Want to see more full solutions like this?
Chapter 13 Solutions
Principles Of Operations Management
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?arrow_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardCorral Cartage leases trucks to service its shipping contracts. Larger trucks have cheaper operating costs if there is sufficient business, but are more expensive if they are not full. CC has estimates of monthly shipping demand. What comparison method(s) would be appropriate for choosing which trucks to lease?arrow_forward
- Acadia Logistics anticipates that it will need more distribution center space to accommodate what it believes will be a significant increase in demand for its final-mile services. Acadia could either lease public warehouse space to cover all levels of demand or construct its own distribution center to meet a specified level of demand, and then use public warehousing to cover the rest. The yearly cost of building and operating its own facility, including the amortized cost of construction, is $15.00 per square foot. The yearly cost of leasing public warehouse space is $24.50 per square foot. E Click the icon to view the expected demand requirements. a. The expected value of leasing public warehouse space as required by demand is S (Enter your response as a whole number.) More Info Requirements (in sq. ft) Probability 230,000 430,000 630,000 830,000 0.35 0.4 0.2 0.05 Print Donearrow_forwardAcadia Logistics anticipates that it will need more distribution center space to accommodate what it believes will be a significant increase in demand for its final-mile services. Acadia could either lease public warehouse space to cover all levels of demand or construct its own distribution center to meet a specified level of demand, and then use public warehousing to cover the rest. The yearly cost of building and operating its own facility, including the amortized cost of construction, is $15.00 per square foot. The yearly cost of leasing public warehouse space is $24.50 per square foot. E Click the icon to view the expected demand requirements. a. The expected value of leasing public warehouse space as required by demand is $ 10290000 . (Enter your response as a whole number.) b. The expected value of building a 230,000-square-foot distribution center and leasing public warehouse space as required if demand exceeds the need for 230,000 square feet of space is $ (Enter your response…arrow_forward3 Problems seen in the situation of the Company: 1. It does not earn too much but it makes sales enough for maintenance, salaries, income, and savings. 2. Company B makes use of a traditional inventory wherein they manually count their stocks and money. 3. They only have one supplier for liquors. For other supplies which are accessible, they usually buy from the wet market nearby. Proposed Solutions: Solution for no. 1- Digital marketing Solution for no. 2 – Perpetual Inventory System Solution for no. 3 – Supplier Quality Management System Hello, can someone help me? How am I going to create a decomposition diagram for these three solutions?arrow_forward
- 1. A company would like to develop an aggregate plan and evaluate its cost using the transportation method. Solve using Excel of the QM software. Note: do not do this manually Related data are shown in the tables below Demand forecast Period Demand (Unit) 1 80 2 90 3 40 Supply Capacity available (units) Regular time 40 65 30 Period 1 2 3 Other Data Beginning Inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost Overtime 20 12 10 30 R 100 R 150 R 200 R 5 Subcontract 10 5 5arrow_forwardRam Roy's firm has developed the following supply, demand, cost, and inventory data. Allocate production capacity to meet demand at a minimum cost using the transportation method. What is the cost? Assume that the initial inventory has no holding cost in the first period and backorders are not permitted. supply available period initial inventory regular-time cost per unit Overtime cost per unit subcointract cost per unit carrying cost per unit per month 1 2 3 Regular Tim overtime subcontrac demand forecast 30 35 30 15 $ LA LA LA L $ $ $ 90.00 110.00 120.00 3.00 15 10 10 5 5 5 50 50 40arrow_forwardAfter applying the NWC Rule for the initial tableau of the given transportation model, evaluate the vacant cells. What is the cell which has the most negative evaluation value and what is the cell evaluation value? DESTINATION SOURCE DEMAND X Y N OX-R; 1 OY-S; -1 OX-S; -1 OY-S; -2 P 75 8 12 EI 11 Q 80 5 8 11 R 120 7 10 10 S 50 11 13 14 SUPPLY 100 125 100 325arrow_forward
- Ram Roy’s firm has developed the following supply, demand, cost, and inventory data. Allocate production capacity to meet demand at a minimum cost using the transportation method. What is the cost? Assume that the initial inventory has no holding cost in the first period and backorders are not permitted. Initial Inventory 20 Units Regular Time cost per unit $100 Overtime cost per unit $160 Sub contract cost per unit $250 Carrying cost per unit per month $6 Supply Table Period Regular Time Overtime Subcontract Demand Forecast 1 30 15 5 40 2 30 15 5 45 3 40 15 5 55arrow_forwardJordan Airline routinely overbooks its flights from Dallas to Florida. Overbooking discounted seats can be expensive because providing a bumped passenger with a last-minute flight on a competing carrier can cost $2,200. A 150-passenger jet costs about $150,000 to operate from Raleigh to Atlanta. The average ticket price is $2,000. Table. The frequency of no-shows NO-SHOWS FREQUENCY 1 15 2 10 3 10 4 5 5 5 6 5 a. how many seats should be overbooked? (show your calculations) b. Korean Airline increased the average ticket price from $2,000 to $3,000 on its Atlanta/Seoul route for the holidays. How would the increased ticket price affect the number of seats overbooked? (show your calculations)arrow_forwardDetermine how many products to ship from each factory to each warehouse, or from each factory to each warehouse and direct to each end customer, to minimize shipping cost while meeting warehouse demands and not exceeding factory supplies Explain the above scenario using the problem given below: Warehouse Capucity Factory w, W, W. (Supply) 21 16 25 13 F. F, 17 18 14 23 13 32 27 18 41 19 Requirement 6 (Demand) 10 12 15 43 Use least cost Method to solve the problem. Using Transportation methodarrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning