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
PRIN.OF OPERATIONS MANAGEMENT-MYOMLAB
- Following their early success and growth, Listo hired a number of new managers and employees. In response to the expansion of staff, Listo reorganized by adding layers of supervisors and managers between executive management and line staff; however, growth occurred so rapidly that proper training was not provided to the new employees. Management was less concerned with the employees’ opinions and was more focused on production and profit. Instead of enlisting employees’ opinions, more directive orders were given. The change and increased complexity associated with adding new layers to the hierarchy resulted in the organization’s goals and objectives becoming unclear. Employees began to complain about the new bureaucratic processes and the slow pace of decision-making. While the organization has been growing in size, productivity has slowed and quality has decreased. The turnover rate is higher than it has ever been, and the number of sick days that people take has doubled over the past…arrow_forwardFollowing their early success and growth, Listo hired a number of new managers and employees. In response to the expansion of staff, Listo reorganized by adding layers of supervisors and managers between executive management and line staff; however, growth occurred so rapidly that proper training was not provided to the new employees. Management was less concerned with the employees’ opinions and was more focused on production and profit. Instead of enlisting employees’ opinions, more directive orders were given. The change and increased complexity associated with adding new layers to the hierarchy resulted in the organization’s goals and objectives becoming unclear. Employees began to complain about the new bureaucratic processes and the slow pace of decision-making. While the organization has been growing in size, productivity has slowed and quality has decreased. The turnover rate is higher than it has ever been, and the number of sick days that people take has doubled over the past…arrow_forwardDiscuss in detail any five types of authority. give citations and referencearrow_forward
- Can you guys help me with this? Thank you! Business Environment: Provide insights into the guidelines for conducting business in the chosen country and working there as an expatriate. This information is vital for understanding the practicalities of engagement in that particular environment. The country in here is India Put the answer as bullet points, provide sources that have relevant information for the answer on economic factorsarrow_forwardCan you guys help me with this? Thank you! Intriguing Facts: Incorporate engaging facts about the country that enhance its value and uniqueness within the global supply chain landscape. These can include cultural anecdotes, technological innovations, or historical achievements. The country in here is India Put the answer as bullet points, provide sources that have relevant information for the answer on economic factorsarrow_forwardCan you guys help me with this? Thank you! Economic Factors: Evaluate the country's economic performance by analyzing key indicators such as GDP (Gross Domestic Product), GDP per capita, exports, and imports. These metrics provide insight into the country's economic prowess and its position in global trade. The country in here is India Put the answer as bullet points, provide sources that have relevant information for the answer on economic factorsarrow_forward
- provide scholarly reseach and define legal and complince risk and reputational risk in banking. Additionally 1. What more can be done about it 2. the department where the risk is exposed to 3. what strategy can be used 4. responsible personarrow_forwardRead the case in the link below and Develop a risk management programme appropriate for this case using the attached template. https://finopsinfo.com/investors/citis-900m-blunder-casts-light-on-poor-loan-ops/arrow_forwardDo the inherent differences between private and public sector objectives—profit versus publicgood—render private sector category management practices unsuitable for public sectorpurchasing, where open tendering is the norm?You have now undergone the Category Management classes and your superiors have requestedfor your input on how to integrate some of the learnings into the public sector policy. Discuss and elaborate what are the activities and governance you would introduce in yourrecommendations without violating the principle of transparency and accountability withinyour organisation. This is based on Singapore context. Pls provide a draft with explanation, examples and useful links for learning purposes. Citations will be good too. This is a module in SUSS called category management and supplier evaluationarrow_forward
- provide scholarly answers for what risk was associated with the Citibank bank loosing 50 million in August 2020arrow_forwardConclusion: The report recommendations and broad conclusion to the essay. TOTAL 5 100arrow_forwardAs part of your new role, as a strategy consultant and member of the steering committee, discuss what logistics and transportation strategies you will execute to achieve operational efficiencies and facilitate economic growth in SA. The committee would like to have a implementable strategic transport and logistics plan to realise the roadmap vision based on the subsection numbering given below! QUESTION ONE Introduction: Must include an overview and history of South Africa's Road, rail and freight transport network. Marks 5arrow_forward
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningPractical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
- MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing

