1.Speedy, Inc. is a company that produces automotive electrical components. A151 is acommon part for all its products. Consider the following gross requirements and inventorydata for A151 part:Week[Gross requirements1345673040307020Inventory Data:Lead timeBeginning inventoryScheduled receiptsHolding cost[Setup cost1 week40$2.50/unit/week$150(i)Based on the L4L lot-sizing rule, develop a Material Requirements Plan (MRP) for the next8 weeks for A151 part.Item: A151WeekLot size: L4L3468Lead time: 1Gross RequirementsScheduled ReceiptsOn Hand InventoryNet RequirementsPlanned Order ReceiptsPlanned Order Releases

MRP stands for material requirements planning, and it is a technique for determining the materials…

Answered: L4L lol-sizng rule, develop a Material…

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

Describe the 3 differences between a fixed-quantity (Q) and a fixed-period (P) inventory ns4 a. system? Fixed Quality Inventory Fixed Period Inventory
A manufacturing company produces two products X and Y. Each product X requires one A and two Bs. Each B requires one C and one D. Each product Y requires 1 C and 4Ds. Table Q5A shows data from the inventory records of components. Table Q5A Data category A B C D Lot - sizing rule Fixed order quantity = 250 Lot for lot Lot for lot Fixed order quantity = 1000 Lead time 3 weeks 2 weeks 1 week 2 weeks Beginning inventory 70 0 200 800 The MPS for products X and Y is given in Table Q5B. The on-hand inventories are as follows: X = 100, Y = 30. The only scheduled receipts are 250 units of X in period 2.The lead times are as follows: X = 2 weeks, Y = 3 weeks. The chase strategy is used for both products. Table Q5B Demand in period Product SS 1 2 3 4 5 6 7 8 X 50 300 200 250 Y 30 400 Required: a) Draw a product structure tree for each product. b) Develop…
DETERMINING INVENTORY MODELS FSYHILD is a manufacturing company of made to order face shield. It is producing products at a constant rate with a requirement of 5,500 face shields per quarter throughout the year. If ordering costs are P35.00 per order, unit cost is P10.00 per face shield, and annual inventory holding cost are charged at 30% of the units cost. A. What is the EOQ for this component? B. What is the expected time between orders? C. What are the total annual inventory and holding cost associated with your EOQ recommendation? D. Assuming a lead time of 5 days, what is the reorder point? E. What is the total cost if the management decides to increase the demand by 75%?
Reorder Point Ordering: Average demand per day () is 25 units, with a std. dev. of (od) 15 units. Lead time (LT) is 49 days. Find demand during lead time (DDL), safety stock (SS) and reorder point (ROP ) for 4-sigma (z = 4). DDL= 500 units, SS = 1225 units, ROP = 1645 units DDL= 1,645 units, SS=420 units, ROP = 1225 units DDL= 1,225 units, SS = 420 units, ROP = 1645 units DDL= 0 units, SS = 1225 units, ROP = 420 units DDL= 420 units, SS = 1645 units, ROP = 420 units
Determine an A-B-C classification for these items:Item Unit Cost Annual Volume (00)1 $100 252 80 303 15 604 50 105 11 706 60 857 10 60b. Find the EOQ given this information: D = 4,500 units/year, S = $36, and H = $10 per unit per year. I just need help with part b.
3. Tristar workshop in Jeddah uses 1600 Batteries during the course of a year. These batteries are purchased from a supplier in Dubai. The following information is known about the batteries. Annual Demand - 1600 units Holding cost per battery per year = SAR 4 Order cost per order - SAR 50 Working days per year Lead time for order Based on the above data: - 300 = 3 Days What is the Economic Order Quantity (EOQ) for this product? • How many orders should be processed per year? What is the expected time between orders? Determine total annual cost • Calculate the Re Order Point (ROP).
Define each of the following terms: c. Economic Ordering Quantity (EOQ); EOQ model; EOQ range
Reorder Point Ordering: Average daily demand ( d) is 5 units with a std. dev. (od) of 1 unit. Average lead time ( LT) is 24 days with a std. dev. (OLT) of 1 day. The inventory manager wants to operate within 3 std. deviations (z = 3). Find the reorder point (ROP) and safety stock (S). ROP=141, SS=120 ROP=141, SS=21 ROP=120, SS=21 ROP=21, SS=141
Why do we use "Specifications or bill of material" in the dependent inventory model?
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round individual dollar volumes to two decimal places. Also round percentage of dollar volume to two decimal places.) L. Houts Plastics Charlotte Inventory Levels Item Code Avg. Inventory (units) Value ($/unit) Dollar % of Dollar Volume Volume 1289 360 4.00 2347 300 4.00 1,200 36.20 2349 120 2.50 300 9.05 2363 75 1,50 2394 60 1.75 105 3.17 2395 35 2.00 6782 20 1.15 23 0.69 7844 12 2.05 24.6 0.74 8210 5 1.60 8310 7 2.00 14 0.42 9111 3.00 18 0.54 3,315.1 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item number…
Micro-Electronics Warehouse Headset and Webcam Sale Item Type Reg. Price After Savings Price BuddyChat 200 Headset $34.72 $24.40 BuddyChat 300 Headset $41.27 $34.91 BuddyCam HD Webcam $83.54 $61.46 You have decided to purchase the headset with the greatest markdown percent and the BuddyCam HD webcam in order to take advantage of an "Extra $15 Rebate" offer when you purchase both. What is the markdown percent on your total purchase including the rebate?
4) Rane Brake Linings gathered information for its brake lining components as presented in the table below. How would the firm classify these items according to an ABC classification system? Initial Information Part # Unit Cost Annual Demand 10 10 200 11 30 125 12 9 100 13 12 5000 14 50 195 15 6 300 16 100 70

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

L4L lol-sizng rule, develop a Material Requirements Plan (MRP) Jor the n 8 weeks for A151 part. Item: A151 Week Lot size: L4L 4 5 6. 7 8 Lead time: 1 Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts Planned Order Releases