Given the following MRP record and an EOQ of 200 units, calculate the planned order receipts...

Given the following MRP record and an EOQ of 200 units, calculate the planned order receipts using the economic order quantity. Next, calculate the period order quantities and the planned order receipts. In both cases, calculate the ending inventory and the total inventory carried over the 10 weeks.

Please show all work

Week	1	2	3	4	5	6	7	8	9	10	Total
Net Requirements	75	70	60	0	100	80	70	65	0	80
Planned Order Receipt
Ending Inventory

Solutions

Expert Solution

Below is the required MRP schedule -

Week	1	2	3	4	5	6	7	8	9	10	Total
Net Requirements	75	70	60	0	100	80	70	65	0	80	600
Planned Order Receipts	200		200				200				600
Ending Inventory	125	55	195	195	95	15	145	80	80	0	985

Below is the screenshot of the formula applied -

keosha answered 4 hours ago

Next > < Previous

Related Solutions

1. A. (EOQ) Calculate the EOQ quantity given: a. Fixed cost per order of $40 b....

1. A. (EOQ) Calculate the EOQ quantity given: a. Fixed cost per order of $40 b. holding cost per inventory unit of $2.00 c. estimated demand for inventory of 200,000 Solve EOQ using the information listed above: B. Calculate the total cost associated the EOQ amount calculated in part A: C. The company wants to keep Safety Stock of an additional; 8 units. Calculate the cost associated with the safety stock and the total cost of the EOQ amount...

Q5: Minimum order quantity is 500 units, lead time is 1 week. What is/are the Planned Receipts for week 9?

Week 7 8 9 10 11 12 Gross Requirements 0 300 400 400 400 200 Scheduled Receipts 500 Projected ending inventory: 100 100 Net requirements Planned Receipts ??? Planned orders Q5: Minimum order quantity is 500 units, lead time is 1 week. What is/are the Planned Receipts for week 9? a. None of these answers are correct. b. 100 units. c. 0 units. d. 500 units. e. 400 units. Week 7 8 9 10 11 12 Gross Requirements 0 300...

If EOQ = 360 units, order costs are $5 per order, and carrying costs are $0.20...

If EOQ = 360 units, order costs are $5 per order, and carrying costs are $0.20 per unit, what is the usage in units? How many orders will be placed in a year if there are 250 working days per year and lead time is 5 days?

For this item, you are asked to calculate the EOQ – Economic Order Quantity. A good...

For this item, you are asked to calculate the EOQ – Economic Order Quantity. A good place to start is by watching this week’s video. When determining the numbers for the variables needed to perform the calculation, be realistic. Research what the actual numbers could be and provide an explanation/rationale for choosing the numbers. Perform the calculation and explain what the result means to your business.

Calculate the EOQ for the following items based on the information given. Annual Demand Annual Holding...

Calculate the EOQ for the following items based on the information given. Annual Demand Annual Holding Cost (per unit) Order Cost Item #1 30000 $0.75 $25.00 Item #2 15000 $3.15 $30.00 Item #3 55000 $2.50 $20.00 Item #4 80000 $2.00 $40.00 EOQ Item #1 Item #2 Item #3 Item #4

For an EOQ ordering quantity of 750 units, an ordering cost of $5 per order, a...

For an EOQ ordering quantity of 750 units, an ordering cost of $5 per order, a holding cost of $10 per unit per year, and an annual demand of 900 units, what is the annual total cost for this value of Q?

Using the scheduled receipts, calculate the ATP. There are zero units on hand.

Using the scheduled receipts, calculate the ATP. There are zero units on hand.On-hand inventory0Week12345678910Customer Orders1010601610MPS505050ATP-- Total Customer Orders before Next MPS-- Temp ATP

Using the EOQ model, if a firm's order quantity is 500 units and its annual holding...

Using the EOQ model, if a firm's order quantity is 500 units and its annual holding cost is greater than its annual setup cost, then what can we say about the optimal order quantity? A. Optimal order quantity = 500 units B. Optimal order quantity < 500 units C. Optimal order quantity > 500 units D. Not enough information is given to answer the question

1. Consider the basic EOQ model (no uncertainty). Optimal order quantity (Q ∗) is 1,800 units....

1. Consider the basic EOQ model (no uncertainty). Optimal order quantity (Q ∗) is 1,800 units. What is the average inventory level (I ∗)? a. 900 units b. 1,800 units c. 600 units d. 1,000 units e. 3,600 units 2. Consider the basic EOQ model (no uncertainty). Annual holding cost (AHC) is $2,400. Find annual ordering cost (AOC). a. Cannot be answered because there is missing information b. AOC=$0, since there is no uncertainty c. $1,200, since AOC=AHC/2 at economic...

Which of the following is NOT an assumption of the traditional economic order quantity (EOQ) model?...

Which of the following is NOT an assumption of the traditional economic order quantity (EOQ) model? a. Holding and ordering costs are stable and known. b. Demand is constant and known. c. Supply lead time is constant and known. d. Quantity discounts are possible. Kim’s Nail Salon uses a weighted moving average method to forecast demand. She assigns a weight of 5 to the previous month’s demand, 3 to demand two months ago, and 2 to demand three months ago....

Subjects