Principles Of Operations Management
11th Edition
ISBN: 9780135173930
Author: RENDER, Barry, HEIZER, Jay, Munson, Chuck
Publisher: Pearson,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 13, Problem 16P
Summary Introduction
To determine: The minimum cost using transportation method.
Introduction: Aggregate planning using transportation method helps to attain the minimum cost with the optimal plan. The major advantage of transportation method is to achieve the optimal solution using optimal plans.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A large St. Louis feed mill, Robert Orwig Processing,prepares its 6-month aggregate plan by forecasting demand for50-pound bags of cattle feed as follows: Ja nuary, 1,000 bags;February, I ,200; March, I ,250; April, 1,450; May, I ,400; and June,I ,400. The feed mill plans to begin the new year with no inventoryleft over from the previous year, and backorders a re not permitted.It projects that capacity (during regular hours) for p roducingbags of feed will remain constant at 800 until the end of April, andthen increase to 1,100 bags per month when a planned expansionis completed on May I. Overtime capacity is set at 300 bags permonth until the expansion, at which time it will increase to 400bags per month. A friendly competitor in Sioux City, Iowa, is a lsoavailable as a backup source to meet demand but can provideonly 500 bags total during the 6-month period. Develop a 6-monthproduction plan for the feed mill using the transportation method.
Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60
units. The MPS rule is to schedule production if the projected on-hand Inventory would be negative without it.
Customer orders (committed) are as follows:
Week
1
2
3
Customer Orders
54
38
25
20
Use a production lot size of 73 units and no beginning inventory. (In the ATP row, enter a value of 0 (zero) In any
perlods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required.)
June
July
MPS
ATP
Forecast
Customer Orders
Projected On-Hand Inventory
60
54
2
60
38
3
60
25
4
60
20
5
60
0
6
60
0
7
60
0
8
60
0
Electro Fans has j ust received an order for one thousand 20-inch fans d ue week 7. Each fan consists of a housing assembly, two grill s, a fan assembly, and an electrical unit.The housing assembly consists of a frame, two supports, and a handle. The fan assembly consists of a hub and five blades. The electrical unit consists of a motor, a switch, and a knob.The following ta ble gives lead times, on-hand inventory, and scheduled receipts.a) Construct a product structure.b) Construct a time-phased product structure.c) Prepare a net material requirements plan.
Chapter 13 Solutions
Principles Of Operations Management
Ch. 13 - Make the case for, and then against, this pricing...Ch. 13 - Prob. 1DQCh. 13 - Why are SOP teams typically cross-functional?Ch. 13 - Prob. 3DQCh. 13 - Prob. 4DQCh. 13 - Prob. 5DQCh. 13 - Prob. 6DQCh. 13 - Prob. 7DQCh. 13 - Prob. 8DQCh. 13 - Prob. 9DQ
Ch. 13 - Prob. 10DQCh. 13 - Prob. 11DQCh. 13 - Prob. 12DQCh. 13 - Prob. 13DQCh. 13 - Prob. 14DQCh. 13 - Prob. 1PCh. 13 - Prob. 2PCh. 13 - The president of Hill Enterprises, Terri Hill,...Ch. 13 - Prob. 4PCh. 13 - Prob. 5PCh. 13 - Prob. 6PCh. 13 - Consuelo Chua, Inc., is a disk drive manufacturer...Ch. 13 - Prob. 8PCh. 13 - Prob. 9PCh. 13 - Prob. 10PCh. 13 - Prob. 11PCh. 13 - Southeast Soda Pop, Inc., has a new fruit drink...Ch. 13 - Ram Roys firm has developed the following supply,...Ch. 13 - Jerusalem Medical Ltd., an Israeli producer of...Ch. 13 - Prob. 15PCh. 13 - Prob. 16PCh. 13 - Prob. 17PCh. 13 - Prob. 18PCh. 13 - Dwayne Cole, owner of a Florida firm that...Ch. 13 - Prob. 20PCh. 13 - Prob. 21PCh. 13 - Prob. 22PCh. 13 - Prob. 23PCh. 13 - Prob. 24PCh. 13 - Prob. 25PCh. 13 - Prob. 26PCh. 13 - Evaluate the various configurations of operating...Ch. 13 - Prob. 2CSCh. 13 - After researching revenue (yield) management in...Ch. 13 - The Magic used its original pricing systems of...Ch. 13 - Prob. 1.3VC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Week 1 3. 4 Forecast 45 45 45 45 Customer Order 42 45 42 50 Given the following data, calculate the projected available balance. The demand time fence is the end of week 3, the order quantity is 100, and 40 are available at the beginning of the periodarrow_forwardPrepare a master schedule based on the following information: Week 1 2 3 4 5 6 7 8 Forecast 500 500 600 600 750 750 900 800 Orders 540 470 325 200 105 45 10 0 Currently there are 700 units in inventory. Policy calls for a fixed order quantity of 1250 units. Can you receive another order for 250 items in week 1? Why? How many orders can be received in each period without altering the plan. If there are 1250 items in stock, what would be the answer of questions 2 and 3?arrow_forwardAn end item’s demand forecasts for the next 10 weeks are 30, 30, 30, 30, 20, 20, 30, 30, 30, and 30 units. The current onhand inventory is 100 units. The order policy is to produce in lots of 75. The booked customer orders for the item, starting with week 1, are 15, 38, 7, 5, 0, 3, 10, 0, 0, and 0 units. The lead time is 2 weeks.a. Develop an MPS for this end item.b. The marketing department has received five orders for this item in the following sequence:Order 1 is for 20 units to be delivered in period 1Order 2 is for 75 units to be delivered in period 4Order 3 is for 90 units to be delivered in period 6Order 4 is for 75 units to be delivered in period 7Order 5 is for 90 units to be delivered in period 10Assuming that the prospective MPS you developed in part (a) does not change, which orders would you be able to accept based on the available to promise (ATP)?arrow_forward
- A phone production company must prepare the production planning for the next 9 weeks. Complete the below table considering this information: Lead Time = 3 Weeks On-hand inventory of 52 phones from week 1. Receipt from an outside supplier of 15 phones at start of week 7 We need to supply 75 phones on week 4. We need to supply 120 phones on week 9. Product A Week 1 2 3 4 5 6 7 8 9 Gross Requirement On-hand inventory Planned orderarrow_forwardAn end item’s demand forecasts for the next 10 weeks are30, 30, 30, 30, 20, 20, 30, 30, 30, and 30 units. The current on-hand inventory is 100 units. The order policy is to produce inlots of 75. The booked customer orders for the item, startingwith week 1, are 15, 38, 7, 5, 0, 3, 10, 0, 0, and 0 units. The leadtime is 2 weeks.a. Develop an MPS for this end item.b. The marketing department has received five orders forthis item in the following sequence:Order 1 is for 20 units to be delivered in period 1Order 2 is for 75 units to be delivered in period 4Order 3 is for 90 units to be delivered in period 6 Order 4 is for 75 units to be delivered in period 7Order 5 is for 90 units to be delivered in period 10 Assuming that the prospective MPS you developed in part (a)does not change, which orders would you be able to acceptbased on the available to promise (ATP)?arrow_forward3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Week On hand 30 30 30 1 2 3 4 5 6 7 8 40 40 40 45 45 13 8 4 Item: P24 Forecast Orders Projected available balance 20 Available-to-promise MPS a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Amount 40 Order Desired Week 1 4 2 6 3 30 2 4 25 3 30 4882 7623arrow_forward
- Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information.Month1 2 3 4 5 6Demand 160 150 160 180 170 140CapacityRegular 150 150 150 150 160 160Overtime 10 10 0 10 10 10Cost Per UnitRegular time $50Overtime 75Subcontract 80Inventory holding, per month 4Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero.Develop a plan that minimizes total cost. No back orders are allowed. Regular capacity = Regularproduction.arrow_forwardMusa's Cashmere Sweaters has authorized the following MPS for her exclusive line of cashmere sweaters. She wants to use the MPS record for promising future orders. Current order promises are included. The MPS order quantity is 60 units. Beginning Inventory is 0. Complete the following MPS record. Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 15 15 15 15 20 20 20 20 25 25 25 25 Customer orders 12 10 8 25 40 0 15 30 30 0 0 40 Projected available Available-to-promise MPS 60arrow_forwardAggregate Planning and Master Scheduling Planners of the company are about to prepare the aggregate plan that will cover 6 months. Assuming that the company identified the following forecast for the next 6 months: Period Jan Feb March April May June Forecast 270000 275000 245000 255000 335000 270000 They now want to evaluate a plan that calls for a steady rate of regular output (250000 boxes/month). Mainly using inventory, regular time and overtime, and backorders. They intend to start with zero inventory on hand in the first period. The maximum amount of overtime output per period is 30,000 box per month. The regular production cost per box is 30 LE while the overtime cost per box is 35 LE. The holding cost is 5 LE per box per month and the backorder cost is 10 LE per box per month. Then, prepare a master schedule to identify the available to promise amounts, knowing that the policy calls for a fixed order quantity of 350000 units, and currently there are 276000 units in inventory. 5…arrow_forward
- Planners for a company that makes several models of skateboards are about to prepare the aggregate plan that will cover six periods. They have assembled the following information. Period 1 2 3 4 5 6 Total Forecast 200 200 300 400 500 200 1,800 Costs Output Regular time=$2 per skateboard Overtime =$3 per skateboard Subcontract =$6 per skateboard Inventory =$1 per skateboard per period on average inventory Back orders =$5 per skateboard per period They now want to evaluate a plan that calls for a steady rate of regular-time output, mainly using inventory to absorb the uneven demand but allowing some backlog. Prepare an aggregate plan and determine its cost using the preceding information.arrow_forwardA forecast of 240 units in January, 320 units in February, and 240 units in March has been approved for the seismic-sensory product family manufactured at the Rockport facility of Maryland Automated, Inc. Three products, A, B, and C, comprise this family. The product mix ratio for products A, B, and C for the past 2 years has been 35 percent, 40 percent,and 25 percent, respectively. Management believes that the monthly forecast requirements are evenly spread over the 4 weeks of each month. Currently, 10 units of product C are on hand. The company produces product C in lots of 40, and the lead time is 2 weeks. A production quantity of 40 units from the previous period is scheduled to arrive in week 1. Thecompany has accepted orders of 25, 12, 8, 10, 2, and 3 units of product C in weeks 1 through 6, respectively. Prepare a prospective MPS for product C and calculate the availableto-promise inventory quantities.arrow_forward16. Complete the following schedule and then answer Problems 16 and 17. Forecast requirements In transit On Hand 1 35 50 Projected available balance 30 Planned Shipments Shipping quantity = 50, Lead time = 1, Safety stock = 25 2 30 Period 3 45 What will the planned shipments be for periods 2, 3, and 4? a) 25 units for each period b) 50 units for periods 2 and 4; zero units for period 3 4 65 c) 50 units for each period d) 100 units in period 2, zero units in period 3, and 50 units in period 4 e) 75 units in period 2, 35 units in period 3, 20 units in period 4 17. What is the projected available balance for period 4? a) 50 units b) 55 units c) 60 units d) 65 units e) 75 units 5 30arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY