Lion Elementary School Store has received an order for 100 back to school bags, which must be ready for delivery in 7 days. These back to school bags should contain the following - a study pack and a sanitizing pack. The store manager knows MRP from her SCM 301 class and will like to use that information to prepare those bags to meet all the quantities and due dates from the parents' orders for their kids back to school bags. The following table shows the product structure, lead times, and available quantities: Back to School Bag Materials Lead Time On-Hand
Back to School Bag (prepared) 1 day 20
Study Pack (2 each per bag) 2 days 30
Sanitizing Pack (3 each per bag) 2 days 25
Each Back to school bag contains 2 study packs and 3 sanitizing packs. Complete the following MRP tables [10 pts] and answer the next five questions based on the MRP tables.
MRP Table for Back to School Bags
Item, Lead Time Beginning Inventory 1 2 3 4 5 6 7
Gross Requirements
Scheduled Receipts
Projected on hand
Net Requirements
Planned-order receipts
Planned-order releases
MRP Table for Study Packs
Item, Lead Time Beginning Inventory 1 2 3 4 5 6 7
Gross Requirements
Scheduled Receipts
Projected on hand
Net Requirements
Planned-order receipts
Planned-order releases
MRP Table for Sanitizing Packs
Item, Lead Time Beginning Inventory 1 2 3 4 5 6 7
Gross Requirements
Scheduled Receipts
Projected on hand
Net Requirements
Planned-order receipts
Planned-order releases
a) What is the net requirements for the Back to school bags?
b) What are the gross requirements for the Sanitizing packs to fill this order?
c) What are the net requirements for the Study packs to fill this order?
d) When should the order for Sanitizing packs be released?
e) When should the order for Study packs be received?