Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Background: Wes and Steve are partners in a lunch truck company that operates a central kitchen and operates lunch trucks that travel to various
Background: Wes and Steve are partners in a lunch truck company that operates a central kitchen and operates lunch trucks that travel to various locations in Philadelphia, Monday-Friday. The lunch trucks deliver pre-packaged healthy sandwich and salad alternatives, fresh fruit and pre-packaged low-fat desserts and canned beverages. Together, the partners have to make many decisions about how to structure the operational aspects of the business so that it is cost effective, efficient and profitable. Current Situation: Quinn manufactures some of the equipment that Steve and Wes use in their central kitchen. She has developed a new food prep tool (ITEM A) that will be useful to them. The product structure tree, inventory levels, lead times and other relevant info are shown below. Quinn must produce 700 of the prep tool at the start of week 6 and 1,300 at the start of week 8. Given these shipping requirements and the data below, complete the attached MRP schedule for parts A, B, C and D ONLY. USE LOT FOR LOT ORDERING - DO NOT ORDER MORE THAN NECESSARY OR REQUIRED. You must document any/all ending inventory to successfully complete the quiz. ON-HAND LEAD TIME SCHEDULED RECEIPTS ITEM INVENTORY (in weeks) ORDER REQTS A 200 1 B 300 2 500 @start of week 6* C 350 2 D 100 1 250 at end of week 4 Minimum order of 1500 Ordered in batches of 500 ONLY Ordered in batches of 250 ONLY *Note: this is a backordered portion of a previously placed order (that's why it's not the minimum of 1500). Important Notes: A B (3) D (2) D (3) E (1) C(2) D (4) F(1) Instructions: Print this page, reproduce by hand or complete via computer. Complete for parts A, B, C and D only. When completed: Take a photo of THIS PAGE ONLY save file and upload via the corresponding Assignment link in Canvas by the due date. Do not cross out work; use whiteout or start over. Remember: No .HEIC files are permitted. Product: A Gross Requirements On hand/Scheduled Receipts Net Requirements Planned order release Product: Week 1 2 3 4 5 6 7 8 B Week 1 2 3 4 5 6 7 8 Gross Requirements On hand/Scheduled Receipts Net Requirements Planned order release Product: C Week 1 2 3 4 5 6 7 8 Gross Requirements On hand/Scheduled Receipts Net Requirements Planned order release Product: D Week 1 2 3 4 5 Gross Requirements On hand/Scheduled Receipts Net Requirements Planned order release 60 7 8
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started