# 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

please answer within 30 mins. and explain properly with correct answer.
Vaibhav
Determine the lot sizing technique that has the minimum cost given thefollowing gross requirements for 6 weeks. There are 10 units on hand, ordering cost isPhp150.00 per order, and inventory cost is Php5.00 per unit per week. Need answer asap. Please include the solution/computation. Thank you
• What is the Reorder Point (ROP)? • What is the fill rate? What is the average inventory? • What is the average flow time? Given Data: Coefficient of variation (CV) = 0.24 Average weekly demand = 540 units Standard deviation = 130 units Lead time=2 Lot size = 1641 Safety inventory: NORMSINV(0.95) = 1.64 Standard deviation * sqrt(2) * 1.64 130*√√2*1.64 301.51 301 = 301 units
The partially completed inventory record for the rotor subassembly in the table below shows gross requirements, scheduled receipts, lead time, and current on-hand inventory. a. Complete the last three rows of the record for an FOQ of 160 units. (Enter your responses as integers. A response of "0" is equivalent to being not applicable) Item: Rotor subassembly Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts 15 1 65 160 H 2 10 3 50 4 35 Lot Size: FOQ-160 units Lead Time: 2 weeks Week 5 80 6 80 7 80 8 80 000 0000 0000
You have developed the following simple product structure of items needed for your gift bag for a rush party for prospective pledges in your organization. You forecast 200 attendees. Assume that there is no inventory on ha nd of any of the items. Explode the bill of material. (Subscripts indicate the number of units required.)
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: 2,200 January 1,400 May February 1,600 June 2,200 March April 1,800 1,800 July August 1,800 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August.
2) Life Cycle Assessment of Glass. Inventory Analysis Determine, as an example, the second phase (Inventory Analysis) of the Life Cycle Assessment of the glass used for the manufacture of soda bottles.
Using the information given and assuming that 2500 ModelA fountains are scheduled for completion, calculate the grossrequirements of each component. Use the beginning inventories given
Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 190 Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 2 280 125 680 770 3 400 170 280 4 290 265 640 650 5 250 150 390 6 260 265 965 840 7 250 240 715 8 290 125 1295 870 555 9 310 190 985
K Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 Gross requirements 30 Develop a lot-for-lot solution (enter your responses as whole numbers). Period Gross requirements On-hand at beginning of period On-hand at end of period Order receipt Order release 2 40 3 40 1 30 U 4 2 *Holding cost = $2.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40. 5 6 7 30 70 20 3 40 8 4 9 10 10 80 5 6 7 30 70 20 8 11 9 10 D 12 50 10 11 12 80 50
Briel y describe how supply chain planning and control is managed in an ERP system.

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