Concept explainers
An end item’s demand
- Develop an MPS for this end item.
- 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 1.
Order 2 is for 75 units to be delivered in period 4.
Order 3 is for 90 units to be delivered in period 6.
Order 4 is for 75 units to be delivered in period 7.
Order 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 accept based on the available to promise (ATP)?
Want to see the full answer?
Check out a sample textbook solutionChapter 11 Solutions
Operations Management: Processes and Supply Chains (12th Edition) (What's New in Operations Management)
- 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.arrow_forwarda. Given the following master schedule, fill in the projected available and availableto promise rows: b. A customer wants an order of 100 in period 4. What can you tell him?c. The customer from part (b) cancels his request, but then says he wants 120 in period 5.What do you tell him now?d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs fora sales promotion. What do you tell them and why?e. What action (if any) should be taken in period 11? Why is it okay to take theaction?arrow_forwardWeek 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_forward
- Given the forecast and booked orders shown in the table, and a beginning inventory of 25, what should the master production schedule quantity be for period 4? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forwardSuppose we are formulating a Master Production Schedule (MPS) for an item. The lot-size policy for this item calls for a fixed quantity of 300 units. Lead time for this item is three weeks. Week O inventory for this item is 400 units. There are no safety stock requirements. Here are the demand forecast and the booked orders for this item.... Week 1 2 3 4 5 6 Forecast 120 120 100 100 100 120 Booked 115 121 71 0 0 0 When the master schedule is complete. what will be the Projected On-Hand in Week 4?arrow_forwardFigure shows a partially completed MPS record for 2 inch pneumatic control valves. Suppose that you receive the following orders at right for the valves (shown in the order of their arrival). As they arrive, you must decide whether to accept or reject them. Which orders would you accept for shipment?Order Amount (Units) Week Requested1 15 22 30 53 25 34 75 7arrow_forward
- Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6arrow_forward. Case: Flamingo Educational Services Flamingo Educational Services, a company located in the Tema metropolis, is a nationwide market leader in the publishing and distribution of textbooks for first and second cycle schools. Somehow, Flamingo does not use forecasts for production planning. Instead, the operations manager decides which books to produce and the batch size, based on orders and the amounts in inventory. The books that have the fewest amounts in inventory get the highest priority. Demand is uneven, and the company has experienced being overstocked on some items and out of others. Being under-stocked has occasionally created tensions with managers of the retail bookstores the company works with. Flamingo is on the verge of losing a lucrative contract with the Ghana Education Service over a complaint that the books produced over the last four months have defective binding as well as slight but noticeable variations in print quality and sizes of the…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. Item: P24 Forecast Orders On hand Week 12345678 30 30 30 40 40 40 45 45 13 8 4 Projected available balance Available-to-promise MPS 20 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. Order 1234 4 Amount 40 30 30 25 Desired Week 4 6 2 3arrow_forward
- As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 2 clamps and 1 housing. Each clamp has 1handle and 1 casting. Each housing has 2 bearings and 2 shafts. There is no inventory on hand. c) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock. Base: units (enter your response as a whole number). Spring: units Clamp: units Housing: units Handle units Casting: units Bearing: units Shaft: unitsarrow_forwardA manufacturing company produces single item product. Theproduction manager decide to arrange 6 periods for MPS. Data aboutdemand forecasts are 112, 157, 126, 176, 124 and 181 while data aboutcustomer orders are 128, 156, 196, 147, 152 and 175. On hand inventoryis 300 units and production batch is 300 units. The productionmanager also decide that 3 beginning periods are critical, so that nochanges are allowed. Arrange MPS for that situation ! When system’s bottleneck requires 10 minutes to finish a unit product,make analysis about capacity. What is your suggestion? please explain it using excel or attached the excel sheetarrow_forwardTuff-Rider, Inc., manufactures touring bikes and mountain bikes in a variety of frame sizes, colors, and component combinations. Identical bicycles are produced in lots of 110. The projected demand, lot size, and time standards are shown in the following table: i Item Demand forecast Lot size Standard processing time Standard setup time Touring 4,000 units/year 130 units 0.20 hour/unit 2 hours/lot Mountain 10,000 units/year 110 units 0.50 hour/unit 3 hours/lot The shop currently works 8 hours a day, 5 days a week, 48 weeks a year. It operates five workstations, each producing one bicycle in the time shown in the table. The shop maintains a 15 percent capacity cushion. How many workstations will be required next year to meet expected demand without using overtime and without decreasing the firm's current capacity cushion? The number of workstations required next year is. (Enter your response rounded up to the next whole number.)arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,