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

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 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 Back to School Bag (prepared) Study Pack (2 each per bag) Sanitizing Pack (3 each per bag) Lead Time 1 day 2 days 2 days Requirements Scheduled Receipts 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 Beginning 1234567 Time Inventory Gross Projected on hand Net On-Hand 20 30 25 Requirements Planned- order 20 pts 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 Beginning Inventory Item, Lead Time Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned- order receipts Planned- order releases MRP Table for Study Packs Item, Lead Time Gross Requirements Scheduled Receipts 1234567 Beginning Inventory 1234567 Item, Lead Time Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned- order receipts Planned- order releases Beginning Inventory MRP Table for Sanitizing Packs Item, Lead Beginning Time Inventory Gross Requirements Scheduled Receipts Projected on hand 1234567 1234567 MRP Table for Sanitizing Packs 12pt Item, Lead Time Gross Requirements Scheduled Receipts Paragraph Projected on hand Net Requirements Planned- order receipts Planned- order releases Edit View Insert Format Tools Table 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] Beginning Inventory 1234567 BIUA 2 Tv|

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!

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

Case Study: Amazon.com, Inc: Driving Disruptive Change in US grocery market. Answer all question based on mark given; 1) State the case? ( 20 marks) 2) Identify the problem and its symptoms based on...

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

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

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

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

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

ATTENTION TUTORS PLEASE HELP ME IN ANSWERING THIS ATTACHMENT WORKSHEET I NEED IT FOR CLASS IN ACCOUNTING THANK YOU HAVE THE ANSWERS IN YELLOW PLEASE SEE ATTACHMENT Question 1 of 15 1. A small...

Read the following Case 9B20M035: " BOEING 737 MAX: DETHRONED OF COMPETITIVE RIVALRY?" Please answer the following question fully: Problems definition: Define and rank in order of importance the...

1-Please provide 5 cross-examination questions for: Chris Moss Dr. Gerry Stein Sydney Payne Terry Preece Leslie Brown Alex Lloyd 2-Explain why/how/if you would use exhibits A, B, C, and D. 3-What...

When one company acquires control of another, how are the acquired companys assets and liabilities recorded?

Use the table to calculate the followings Product 1 product 2 Product 3 direct material cost $25,000 $30,000 $35,000 Direct labor cost $30,000 $40,000 $50,000 Direct labor hours 1200 hours 1,800...

A debit to Raw Materials Inventory indicates a. Raw Materials were purchased b. Raw Materials were requisitioned c. Raw Materials were put into production d. Raw Materials were ordered

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