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 10 pts 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 2 pts b) What are the gross requirements for the Sanitizing packs to fill this order 2 pts c) What are the net requirements for the Study packs to fill this order 2 pts d) When should the order for Sanitizing packs be released 2 pts e) When should the order for Study packs be received 2 pts

The Answer is in the image, click to view ...

Question: 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

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 [10 pts].

**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? [2 pts]

b) What are the gross requirements for the Sanitizing packs to fill this order? [2 pts]

c) What are the net requirements for the Study packs to fill this order? [2 pts]

d) When should the order for Sanitizing packs be released? [2 pts]

e) When should the order for Study packs be received? [2 pts]

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!

Rewrite these sentences to reflect your audience's viewpoint. a. Your e-mail order cannot be processed; we request that you use the order form on our website instead. b. We insist that you always...

Question 4 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...

4: Decision Making and Improving Supply Chain Management (Excel Exercise) Due: March 25, 2012 Total Score: 30 Points Part A: Springville School District Student and Teacher Ratio Problem Attention:...

Read above case study and answer questions below: Establish reporting and communication protocols. How will the PMO communicate with project stakeholders? Make sure there are clear channels for...

What things are going wrong at RW Citrus & Juice? What are the root causes of these issues? RW CITRUS & JUICE: INTERIM GENERAL MANAGER It was November 19, 2016, and David Ross watched Nadine Berry...

1-l need long introduction about (RW CITRUS & JUICE: INTERIM GENERAL MANAGER) case study. 2_I need long answer for this question in the same case (3. What is the bare minimum that needs to be in...

1. A SWOT analysis is a commonly used method to evaluate the strengths, weaknesses, opportunities, and threats of an organization. It involves drawing upon facts to identify internal strengths and...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

CASE STUDY HOME DEPOT CASE This case has been produced for assessment purposes only. It has been sourced directly from the articles indicated within the bibliography, which are available in the...

Berkeley Elementary School is a small private school that has retained your services as a systems analyst to assist in the development of a new information system for the schools administrative...

Discuss the major assumptions of the growth duration model. Why could these assumptions present a problem?

456 Inc is one of the cooperatives of fishermen located by the Laguna Lake in Calamba City. For the past five years, they have continued to plea to the City Government of Calamba to build around the...

4. Light passes from air into glass. If the angle of incidence is 42 deg what is the angle of refraction? (a) less than 42" (b) 42 deg (c) more than 42 (d) 90

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...