he MRP process can provide production planning and determine net requirements. However, it does not tell you when and how much to order. Your textbook covers three lot-sizing methods that can be used to answer the question of when and how much to order. The three methods are Lot-for-lot, Economic order quantity (EOQ), and Periodic order quantity (POQ). Your task is to use all three methods to determine the best lot size to order.

The setup cost for each order will run the company $150 each time and will take one week to fulfill each order. If you have extra inventory, then the holding cost is $1 per week per unit. Assuming that you started with an initial inventory of 30 and based on the requirements and planned order receipts shown in the chart, calculate the lot sizing.

Week12345678910
Gross Requirements302535020300252545
Planned order receipts02535020300252545

Assignment

Use Excel OM for lot sizing and calculate Lot-for-lot, EOQ, and POQ. Submit one spreadsheet containing a tab for each method. On a fourth tab summarize the cost of each of the methods, the number of orders for each method and determine the method that provides the lowest total cost.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

If this is not the paper you were searching for, you can order your 100% plagiarism free, professional written paper now!

Order Now Just Browsing

All of our assignments are originally produced, unique, and free of plagiarism.

Free Revisions Plagiarism Free 24x7 Support