Question: Please use given MRP planning schedule for item J to answer the following questions: $8 $45 Unit Cost Setup cost Inventory holding cost per week

Please use given MRP planning schedule for item J

Please use given MRP planning schedule for item J to answer the following questions: $8 $45 Unit Cost Setup cost Inventory holding cost per week Beginning inventory Lead time Week 0 1 Demand 18 2% of unit cost 30 1 week 2 22 3 55 4 46 5 17 a. Select adequate EOQ model to calculate the optimal order quantity Blank 1 (round-up the decimal to integer). b. Indicate the correct net requirements, planned-order receipts, and planned order releases to meet the demand in the provided table c. Calculate the total inventory holding cost and fixed ordering cost for these 5 weeks in the provided table (keep two decimals for the costs). TC 1 18 2 22 3 55 4 46 5 17 0 0 0 0 0 12 123 68 22 5 Week: Item: J Gross requirements OH: Scheduled receipts LT: Projected available balance Net requirements Q: Planned order receipts Planned order releases Inventory Holding Cost SS: 0 10 0 0 0 0 133 0 0 0 133 0 lo 0 0 Blank Blank Blank Blank Blank Blank Fixed Ordering/Set-up Cost Blank Blank Blank Blank Blank Blank Blank

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The worksheet Base Data in the Excel file Credit Risk Data provides information about 425 bank customers who had applied for loans. The data include the purpose of the loan, checking and savings...

Please use given MRP planning schedule for item J to answer the following questions: Unit Cost $8 Setup cost $45 Inventory holding cost per week 2% of unit cost Beginning inventory 30 Lead time 1...

Please use given MRP planning schedule for item J to answer the following questions: Unit Cost $20 Setup cost $60 Inventory holding cost per week 1.5% of unit cost Beginning inventory 60 Lead time 1...

Type or paste question here Please use given MRP planning schedule for item J to answer the following questions: Unit Cost $20 Setup cost $60 Inventory holding cost per week 1.5% of unit cost...

Please use given MRP planning schedule for item to answer the following questions: Unit Cost $20 Setup cost $60 Inventory holding cost per week 1.5% of unit cost Beginning inventory 60 Lead time 1...

QUESTION 22 Please use given MRP planning schedule for item) to answer the following questions: Unit Cost $20 Setup cost $60 1.5% of unit cost Inventory holding cost per week Beginning inventory 60...

QUESTION 14 Please use given MRP planning schedule for item to answer the following questions: SR $45 Unit Cost Setup cost Inventory holding cost per week Beginning inventory Lead time 2% of unit...

Please use given MRP planning schedule for item to mower the following questions $$ Unit Cow Setup cost Inventory holding cout per week Beginning inventory Lead time $45 2% of it.com 1 week 0 1 3 4 5...

McKeag Corporation manufactures agricultural machinery. At a recent staff meeting, the following direct-labor variance report for the year just ended was presented by the controller. McKeags...

A coin that is balanced should come up heads half the time in the long run. A coin is tossed 4040 times and gives 2085 heads. Is the coin biased? Use Alpha = .05. (State the Hypothesis Scenario,...

19. If sea levels rise twenty feet worldwide, then coastal cities from New York to Sydney will be inundated. If the ice sheets on Antarctica slip into the sea, then sea levels will rise twenty feet...

Roberts Company manufactures home cleaning products. One of the products, Quickclean, requires 2 pounds of Material A and 5 pounds of Material B per unit manufactured. Material A can be purchased...