Consider the following information.PART XGross RequirementsScheduled ReceiptsProjected On-Hand Inventory 130Q-60, LT-3 weeks, Safety Stock - 20Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0".PART XGross RequirementsScheduled ReceiptsProjected On-Hand Inventory 130Planned Order Releases15050150130020WEEK3709920130120®®40WEEK3703005130x40305130200

Planned order releases are an important part of planning the requirement of material and inventory…

Answered: Consider the following information.…

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

Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Q = 60, LT= 3 weeks, Safety Stock = 5 1 70 70 PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Planned Order Releases 1 70 70 100 2 0 > X WEEK 3 40 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". 2 0 4 0 100 WEEK 3 40 5 160 60 4 0 40 0 X 5 160 Check My Work -60 0
Q6) Tracking signals track changes in control limits can lead to an increase in cumulative errors can capture changes in trends track changes in demand updates none of the above Q7) In an inventory problem, the fixed ordering costs are increased but all other factors remain the same. This change will increase the optimum order quantity change the demand pattern reduce the optimum order quantity change the stockout costs increase the optimum lead time Q8) In an MRP system, the lead time to acquire or produce components is used in calculating net requirement from gross requirements net requirements from available planned order releases from planned order receipts lot sizes for scheduled orders none of the above
Upon delivery, only the items quantity ordered on the PO(pruchase order) is received and a Daly Receiving Report (DRR)made by the supplier at the time of delivery. True or false?
Which of the following is ‘data’? i. Number of items in inventory in the store were 3,000 ii. Value of items in the store was OMR 5,000 iii. Total items with value OMR 1,500 to OMR 3,000 were 500
6. The demand for a particular part called SKU 005 is 1,500 units a year. The cost of one SKU 005 is $40.00. It costs $50.00 to place an order for SKU 005, and the user of SKU 005 has a per year inventory carrying cost of 25% of unit cost. Assume 250 working days in the year where SKU 005 is used. (Noteshaper: Scenario #26) а. What is the combined annual holding and ordering cost of an order size of 200 units for SKU 005? b. How many of SKU 005 should be ordered, to minimize combined ordering and holding costs? c. The vendor who sells SKU 005 has just offered a 5% discount for orders of 500 or more. Now how many should be ordered? d. Once the purchasing manager for SKU 005 places an order, the vendor requires 7 working days to deliver that order. What should be the purchasing manager's reorder point?
c) Even if there is substantial uncertainty in the parameters in the EOQ-model, it is still quite a useful model. Discuss why.
You are the executive chef at a large wedding facility, and a wedding with a confirmed count of 168 is scheduled for tomorrow at noon. Everything has been ordered except the shrimp, which was missing from the last purchase order. It will have to be a last-minute rush order, and only one supplier can get it to you in time. The purchase order will be for frozen raw, U 16-20, shrimp peeled, de-veined, tail-on, in 5-pound boxes (according to your spec for the product). You’ve dealt with this supplier before, and made a note to yourself on the jumbo shrimp spec that this vendor’s product averages 19 to 20 shrimp per pound and has a 96% yield. Catering policy dictates that a 10% buffer be provided for unexpected guests, and the catering menu states that 5 shrimp are to be served per person. If you have 4 pounds of good jumbo shrimp on hand, how much will you order for the wedding? Will there be any leftover product? How much?
(a) Give examples of independent and related dependent demand (b) APL company assembles and sales an electronics device (ED) on a contract basis. End item ED has composed of 3 units of subassembly BG and 5 units of component DD. BG is assembled using 3 DDs and 4 FCs. There are orders of 500 and 875 units of the device (ED) at the beginning of week 6 and week 8. In assembling BG, an extra 20 percent scrap allowance must be added. DD can only be ordered in whole cases of 400 units per case. One case of DD is received in each of week 1 and week 2. Also, there are 200 units of BG and 425 units of DD now on hand. The lead time for the item BG, DD, and FC is 2 weeks and that is for the item ED is 1 week.i. Calculate the required number of DD and FC for producing 100 units of ED. There is no stock of any item. ii. Prepare a material requirements plan for the component DD.
Romulo Drugstore sells 10 bottles of Paracetamol syrup Strawberry flavor 60 mL a day, and 15 bottles on holidays and weekends. It takes 5 days for the supplier to deliver the order; and on peak seasons and certain occasions, the supplier takes 10 days to deliver the ordered items. What should be the safety stock level of the said item? 20 bottles 25 bottles 100 bottles 175 bottles
Romulo Drugstore sells 10 bottles of Paracetamol syrup Strawberry flavor 60 mL a day, and 15 bottles on holidays and weekends. It takes 5 days for the supplier to deliver the order; and on peak seasons and certain occasions, the supplier takes 10 days to deliver the ordered items. What should be the safety stock level of the said item? 20 bottles 25 bottles 100 bottles 175 bottles What is the Average Lead Time? 5 days 10 days 15 None What is the Maximum Lead Time? 5 days 10 days 15 None What is the average daily use? 10 bottles 15 bottles 20 bottles 25 bottles 100 bottles What is the maximum daily use? 10 bottles 15 bottles 20 bottles 25 bottles 100 bottles Which of the following is NOT True? Cycle Stock Inventory must be maintained. Safety Stock Inventory must be secured. Monitoring of inventory movement facilitates the necessary adjustment of both the Cycle Stock and Safety Stock Inventory. Safety Stock inventory is also considered as a buffer stock. None of the choices.
Please explain me in brief about Pros and Cons of Re-Order Point Control and Re-Order Cycle Control Inventory control Systems.
Which one of the following is the most likely example of dependent demand for an MRP controlled item? Demand for spare parts Demand directly from customers Demand from quality control department for destructive testing Demand from MPS Which of the following quantities has no effect on the first period’s ATP calculation? Current on-hand inventory Booked customer orders for the first periods MPS quantity for the first period Forecasted demand for the first period

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