3.1 Given the following net requirements, calculate the plannedorder receipts based on the period order quantity. The EOQ is250 units, and the annual demand is 4200 units.12 3 4 s 6 7 8100 85 90 0 85 80 90 100WeekNet Requirements630Planned Order Receipts 3.2 Given the following net requirements, and an EOQ of 200units, calculate the planned order receipts using the economicorder quantity. Next, calculate the ending inventory.12 3 4s678 9 10WeekTotalNet75 70 60 0 100 8o 70 65Requirements80Planned OrderReceiptEndingInventory

As per the Bartleby guidelines only one part has been answered.

Answered: 3.2 Given the following net…

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

. Given the following net requirements, calculate the planned order receipts basedon the period order quantity. The EOQ is 250 units, and the annual demand is4200 units.
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%?
Given this information:Lead-time demand 600 poundsStandard deviation of lead time demand 52 pounds (Assume normality.)Acceptable stockout risk during lead time 4 percenta. What amount of safety stock is appropriate?b. When should this item be reordered?c. What risk of stockout would result from a decision not to have any safety stock?
Joe Henry's machine shop uses 2,500 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The fo llowing information is known about the brackets: a) Given the information, what would be the economic order quantity (EOQ)?b) Given the EOQ, what would be the average inventory? What would be the annual inventory holding cost?c) Given the EOQ, how many orders would be made each year? What would be the annual order cost?d) Given the EOQ, what is the total annual cost of managing the inventory?e) What is the time between orders?f) What is the reorder point (ROP)?
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…
22. The order cost per order of an inventory is P400 with an annual carrying cost of P10 per unit. What is the Economic order quantity for an annual demand of 2,000 units?
If annual requirement (demand) is 900 units, ordering cost is OMR 36 per order and holding cost is 52 per unit, the Economic Order quantity (EOQ) will be: a. 57.584 units b. 43.912 units c. 39.263 units d. 35.300 units
JA manufacturing company produces finished products as well as re- placement parts. One particular product has the following bill of materials: 2. (4) D (30) (25) (20) The manufacturer independent demand requirements for both the parent item as well as the subassemblies for the next 8 weeks: Independent Period Demand 2 4 6. Assembly A Assembly B 25 25 25 15 15 15 70 100 70 100 25 25 25 25 25 Assembly C 15 15 15 15 15 Assemblies D and E are purchased from a supplier so they are not manufac- tured by the company, and therefore have no independent demand. CR
Roybow Corporation sells lawn mowers that cost $160 each to purchase and prepare for sale. Annual sales are 5,000 mowers , carrying costs are 20 percent of inventory costs , and Roybow icurs a cost of $32 each time an order is placed. a) what is the EOQ for the mowers b) what will be the total inventory costs if the EOQ amount is ordered?
Economic Order Quantity and Reorder PointFind the economic order quantity and the reorder point, givenAnnual demand ( D )= 1, 000 unitsAverage daily demand ( d¯ ) = 1, 000 ∕365ordering cost ( S ) = $5 per orde rHolding cost ( H ) = $1.25 per unit per yearLead time ( L ) = 5 daysCost per unit ( C ) =$12.50What quantity should be ordered?
03) Halifax Souvenir Company currently orders 500 units four times each year. Each order costs $12 and each unit costs $1.20 per year to carry. On average, it takes 5 days to receive an order from the supplier. The company operates 250 days per year. Required: 1. What is the EOQ? 2. Calculate total annual inventory cost under EOQ. 3. What is the current inventory cost? 4. What is the re-order point?
20. The expected annual usage of a particular material is 540,000 units, and the standard order size is 36,000 units The invoice cost of each unit is P900, and the ordering cost per order is P240. Assuming the company does not maintain safety stock. What is the average inventory?

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

3.2 Given the following net requirements, and an EOQ of 200 units, calculate the planned order receipts using the economic order quantity. Next, calculate the ending inventory.