# Inventory Record Analysis for Driveshaft Subassembly## OverviewThis section analyzes the partially completed inventory record for a driveshaft subassembly. The table provided details the gross requirements, scheduled receipts, lead time, and current on-hand inventory. It helps in understanding materials requirement planning (MRP) for manufacturing processes.## InstructionsComplete the last three rows (Projected on-hand inventory, Planned receipts, and Planned order releases) for a Fixed Order Quantity (FOQ) of 55 units. Enter your responses as integers, where '0' indicates that the particular action is not applicable.### Item: Driveshaft Subassembly#### Input Parameters:- **Lot Size**: FOQ = 55 units- **Lead Time**: 3 weeks### TableThe table is structured across a span of 8 weeks to record the inventory data accurately.| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 ||------|---|---|---|---|---|---|---|---|| **Gross requirements** | 30 | 20 | 20 | 20 | 45 | 45 | 50 | 50 || **Scheduled receipts** | 70 | - | - | - | - | - | - | - || **Projected on-hand inventory** | 10 | - | - | - | - | - | - | - || **Planned receipts** | - | - | - | - | - | - | - | - || **Planned order releases** | - | - | - | - | - | - | - | - |### Explanation**Gross requirements** list the total demand for the driveshaft subassemblies each week. **Scheduled receipts** indicate any existing orders expected to be added to the inventory during that specific week.**Projected on-hand inventory** tracks the expected inventory remaining at the end of each week after accounting for the gross requirements.**Planned receipts** are the quantities expected to be delivered based on the planned order releases.**Planned order releases** are the quantities to be ordered to meet future gross requirements considering the lot size and lead time.### Objectives1. Keep the projected on-hand inventory from going negative by planning orders.2. Determine the correct timing and quantities to place orders to ensure there are sufficient materials for production.To accomplish this, consider the FO

Lot Size: FOQ = 55 units.Lead time = 3 weeks.Project on hand inventory = 10 units.We will use the…

Answered: The partially completed inventory…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

State the types of data that would be carried in the bill-of-materials i le and the inventoryrecord file.
A) Completely fill in the Transportation table including the Production Plan. B) Create a Summary Table of the plan (including ending inventories). C) Calculate the cost of the Production Plan.
What will be projected on hand inventory of item S in week6?
Wal Mart, although they are not a manufacturing company, uses sophisticated computer software to forecast sales and order products to be stocked in their stores so that they do not run out of the things shoppers are looking for. What kind of software system does Wal Mart likely use? Group of answer choices a) Inventory control b) Just-in-time ordering c) E-procurement d) Materials Requirement Planning (MRP)
A factory has just received an order for 100 units of an end item, which are to be shipped at the start of week 8. Relevant information of the end item and the components is as follows. Item Lead Time (weeks) On Hand Inventory Scheduled receipts Order Policy Direct Components End item 2 30 lot for lot A(4), B(3), C(2) A 3 20 54 at week 3 lot for lot D(2) B 2 10 68 at week 4 lot for lot D(5) C 1 100 multiple of 60 D 1 20 min. of 500 Develop the material requirements plan (please print out an empty MRP table to work with), and determine what the "projected available balance" is for component D at week 8. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Explain the difference between a materials requirement planning (MRP) and Master Production Schedule. Provide examples how each are applied in the supply chain.
Prepare a master schedule based on the following information: Week 1 2 3 4 5 6 7 8 Forecast 1000 1000 1200 1200 1500 1500 1800 1800 Orders 1060 940 650 400 210 90 20 0 1. Currently there are 1450 units in inventory. Policy calls for a fixed order quantity of 2500 units. 2. Can you receive another order for 500 items in week 1? Why? 3. How many orders can be received in each period without altering the plan. 4. If there are 2500 items in stock, what would be the answer of questions 2 and 3?
Figure shows the BOMs for two products, A and B. Table 1 shows the MPS quantity start date for each one. Table 2 contains data from inventory records for items C, D, and E. There are no safety stock requirements for any of the items.a. Determine the material requirements plan for items C, D, and E for the next 8 weeks.b. What specific managerial actions are required in week 1?c. Suppose that a very important customer places an emergency order for a quantity of product A. To satisfy this order, a new MPS of 200 units of product A is now required in week 5. Determine the changes to the material requirements plan if this order is accepted and note any problems that you detect. MPS Quantity Start Dates Date Product 1 2 3 4 5 6 7 8 A 125 95 150 130 B 80 70 Inventory Record Data Item Data Category C D E Lot-sizing rule L4L POQ 1P = 32 FOQ = 800 Lead time 3 weeks 2 weeks 1 weeks Scheduled receipts 200 (week 2) None 800 (week 1) Beginning…
The table given below shows a partially completed MPS record for product A. What is the remaining ATP inventory (discrete) for week 7 after the company receives a 20 units of customer order for week 6? Order policy: 60 units Lead time: 1 week Item: A Quantity on hand: 30 Week 3 30 7. 34 11 4. Forecast requirements Customer orders (booked) Projected on-hand inventory MPS quantity MPS start ATP inventory 22 24 18 27 36 28 26 12 24 O a 59 Ob. 29 OcO Od. 49 Oe. 39
In the following MRP planning schedule for Item J, indicate the planned order releases to meet the gross requirements. Lead time is one week and there is no inventory on hand and no safety stock.
Grace Greenberg, production planner for Science and Technology Labs, in New Jersey, has the master production plan shown here: Lead time= I period; setup costs = $200; holding cost = $10 perweek; stockout cost = $10 per week. Develop an ordering planand costs for Grace, using these techniques:a) Lot-for-lot. b) EOQ.c) POQ. d) Which plan has the lowest cost?
Master production schedule is a medium-range planning and it is used for quantity and timing of components and raw material Finished goods Both A & B

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS