4. The partially completed MPS for a product is given below.Item: Ball bearingsOrder Policy: 500 unitsLead Time: 1 weekWeekQuantityon Hand:5 6 740034810Forecast550300400450300350200300450400Customerorders300350250250200150100100100100(booked)Projectedon-handinventoryMPS quantity500MPS startAvailable-to-promise (ATP)inventorya. Develop the MPS for the product.b. Four customer orders arrived in the following sequence. As they arrive, you must decidewhether to accept or reject them. Which orders would you accept for shipment? Why?

Concept- A master production schedule (MPS) is a system for having individual goods delivered at a…

Answered: 4. The partially completed MPS for a…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Sunny Park Tailors has been asked to make three dif-ferent types of wedding suits for separate customers. The table below highlights the time taken in hours for (1) cutting and sewingand (2) delivery of each of the suits. Which schedule finishes sooner:first come, first served (123) or a schedule using Johnson’s rule?Times Taken for Different Activities (hours)SUIT CUT AND SEW DELIVER14 227 736 5
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 order
Transcribed Image Text On hand: 35 Planning time fence: 10 Lot size: 200 Demand time fence: 2 Period 2 4 6. 7 9. 10 11 12 Forecast 30 40 40 50 40 40 30 40 40 50 40 40 Customer Orders 31 35 29 21 17 14 33 11 5 2 Projected Available Available to Promise MPS 200 200 3. a. 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 for a 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? I only need question D and E answered
A partially completed inventory record for the motor sub-assembly is shown in Figure 11.39.a. Complete the last three rows of the record by using theL4L rule.b. Complete the last three rows of the record by using thePOQ rule with P = 2. c. Complete the last three rows of the record by using thePOQ rule with P = 2.d. If it costs the company $1 to hold a unit in inventory fromone week to the next, and the cost to release an order is$50, which of the lot sizing rules used above will providethe lowest inventory holding + order release cost?
Job Costing Johnson Inc. is a job-order manufacturing company that uses a predetermined overhead ratebased on direct labor hours to apply overhead to individual jobs. For the current year, estimated direct laborhours are 95,000 and estimated factory overhead is $617,500. The following information is for Septemberof the current year. Job A was completed during September, and Job B was started but not finished.[LO 4-3, 4-4, 4-5]September 1, InventoriesMaterials Inventory $ 7,500Work-in-Process Inventory (All Job A) 31,200Finished Goods Inventory 67,000Material purchases 104,000Direct materials requisitionedJob A 65,000Job B 33,500Direct labor hoursJob A 4,200Job B 3,500Labor costs incurredDirect labor ($8.50/hour) 65,450Indirect labor 13,500Supervisory salaries 6,000Rental costsFactory 7,000Administrative offices 1,800Total equipment depreciation costsFactory 7,500Administrative offices 1,600Indirect materials used 12,000Required1. What is the total cost of Job A?2. What is the total…
The following table lists the components needed to assemble an end item, lead times, and quantities on hand. Item End B C D E F G H LT (wk) 1 3 2 2 2 1 2 1 Amount on hand 0 10 9 25 11 32 3 0 a. If 18 units of the end item are to be assembled, how many additional units of E are needed? (Hint: You don't need to develop an MRP plan to determine this.) Additional units b. An order for the end item is scheduled to be shipped at the start of week 14. What is the latest week that the order can be started and still be ready to ship on time? (Hint: You don't need to develop an MRP plan for this part either.) The latest week
1. A company that produces golf carts has just received an order for 200 carts, which must be ready for delivery at the start of week 8. Information concerning the product structure, lead times and quantities on hand is shown in the following table. Parts list for golf cart Lead time Quantity on hand Golf cart Top Base 1 1 1 0 40 20 Top Supports(4) Cover 1 1 200 0 Base Motor Body Seats (2) 2 3 2 300 50 120 Body Frame Controls Wheel assemblies(4) 1 1 1 35 0 240 You are required to: a) Construct a product tree.
1. A company that produces golf carts has just received an order for 200 carts, which must be ready for delivery at the start of week 8. Information concerning the product structure, lead times and quantities on hand is shown in the following table. Parts list for golf cart Lead time Quantity on hand Golf cart Top Base 1 1 1 0 40 20 Top Supports(4) Cover 1 1 200 0 Base Motor Body Seats (2) 2 3 2 300 50 120 Body Frame Controls Wheel assemblies(4) 1 1 1 35 0 240 You are required to: a) Construct a product tree. b) Determine the low level codes for all the components. c) Develop a material requirements plan that will provide 200 golf carts by week 8 assuming lot for lot ordering.
An end item’s demand forecasts for the next 10 weeks are 30,20, 35, 50, 25, 25, 0, 40, 0, and 50 units. The current on-handinventory is 80 units. The order policy is to produce in lots of100. The booked customer orders for the item, starting withweek 1, are 22, 30, 15, 9, 0, 0, 5, 3, 7, and 0 units. At present,no MPS quantities are on-hand for this item. The lead time is2 weeks. Develop an MPS for this end item.
An 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)?
Chuck’s Custom Boats (CCB) builds luxury yachts to customer order. CCB has landed a contract with a wealthy customer. Relevant data are shown in the table below. The complication is that the customer wants delivery in 32 weeks or he will impose a penalty of $375 for each week his yacht is late. Activity Immediate Predecessor Normal Time (NT) Weeks Crashing Cost 1st Week 2nd Week A ― 9 $410 $415 B A 7 125 -- C A 5 45 45 D B 4 300 350 E C 6 50 -- F D, E 5 200 225 G F 8 -- -- H F 7 85 90 I G 6 90 -- Construct a network diagram for the project Indicate the critical path when normal activity times are used. Develop a crashing schedule. Note: No activity can be crashed more than two weeks. Show breakdown of work
The following table lists the components needed to assemble an end item, lead times, and quantities on hand. Item End B C D E F G H LT (wk) 3 1 1 1 1 3 1 3 Amount on hand 0 9 10 24 10 33 4 0 a. If 17 units of the end item are to be assembled, how many additional units of E are needed? (Hint: You don't need to develop an MRP plan to determine this.) Additional units b. An order for the end item is scheduled to be shipped at the start of week 15. What is the latest week that the order can be started and still be ready to ship on time? The latest week is

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS