The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand.Direct ComponentsL(2), C(1), K(3)B(2), 3(3)G(2), B(2)H(4), B(2)ItemEndLсKB3GHLead Time2NWWNWWNN2332332Amounton Hande11142031488HRDAH28Click here for the Excel Data Filea. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint You don't need to developMRP plan.)chapter13 03 v17.xlsx - Excel

Based on the Table showing Direct Components, we prepared a Product Tree Structure as shown…

Answered: The following table lists the…

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

. Consider the bill of materials (BOM) in Figure 11.33.a. How many immediate parents (one level above) doesitem I have? How many immediate parents does item Ehave?b. How many unique components does product A have at alllevels?c. Which of the components are purchased items?d. How many intermediate items does product A have at alllevels?e. Given the lead times (LT) in weeks noted on Figure 11.33,how far in advance of shipment must a purchasecommitment be for any of the purchased items identifiedin part (c)?
Should an MRP be used with dependent or independent demand items?
Table B shows a partially completed MPS record for ball Develop the MPS for ball Four customer orders arrived in the following sequences (Table B). Table A Order Quantity Week desired 1 500 4 2 400 5 3 300 1 4 300 7 Assume that you must commit to the orders in the sequence of arrival and cannot change the desired shipping dates or your MPS. Which orders should you accept? Table B Item: Ball bearings Quantity on hand: 400 Order policy: 500 units Lead time: 1 week Week 1 2 3 4 5 6 7 8 9 10 Forecast 550 300 400 450 300 350 200 300 450 400 Customer order booked 300 350 250 250 200 150 100 100 100 100 Projected on-hand inventory MPS quantity 500 MPS start Available to promise (ATP)
A restaurant is planning to introduce a through drive window for their meals. The service consists of two windows: first window to place orders, and the second window to receive orders. The design team of the company is assigned to perform the following tasks. Show how the data is obtained (survey, literature, actual from records). Justify any assumptions used in your analyses. Question) Manage the inventory of the drive-through window including the following: a. Decide on the types of inventories. b. Use periodic inventory control system model. c. Justify any assumptions used in your analysis.
Draw a simple bill-of-materials (BOM) for a smart phone given the following requirements: (a) clearly label the end item and each component, (b) the BOM must contain no more than ten items, (c) the BOM must contain at least three levels (you may count the end-item level zero).
Product A Order Qty = 400 Order Lead Time = 2 Forecast Demand Scheduled Receipts Projected Available Inventory 400 Planned Order Receipts Planned Order Releases 1 300 OD 4, 6, 2 300 400 Sketch and fill in the grid on scrap paper to use on upcoming questions In what periods would you incur a planned order release? OA 1.3, and 4 2.4, and 5 OC 3,5, and 6 and 7 3 300 PERIODS 4 300 5 300 6 300 7 100 8 100
As the production planner for Xiangling HuProducts, Inc., you have been given a bill of material fora bracket that is made up of a base, two springs, and fourclamps. The base is assembled from one clamp and twohousings. Each clamp has one handle and one casting. Eachhousing has two bearings and one shaft. There is no inventoryon hand. a) Design a product structure noting the quantities for eachitem and show the low-level coding.b) Determine the gross quantities needed of each item if youare to assemble 50 brackets.c) Compute the net quantities needed if there are 25 of thebase and 100 of the clamp in stock.
The following table lists the components needed to assemble an end item. Assume there is no on-hand inventories. Item Direct Components End item A(4), B(5), C(4) A E(3), F(2) B D(3), E(5) C F(4) D E F E(4) If 3 units of the end item are to be assembled, how many units of component E are needed? Input should be an exact number.
Shown below is a partially completed MPS record for hand drills. a. Develop the MPS record for the hand drills. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Hand drills Quantity on Hand: 30 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start 1 15 20 N 40 25 3 15 15 Week Available-to- promise (ATP) inventory b. A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order? The order should ship on week (Enter your response as an integer.) 4 20 20 Order Policy: 60 units Lead Time: 1 week 5 55 0 6 35 0
Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order-Processing Costs 3,000 $ 165,400 1,500 100,750 4,400 241,400 2,800 163,800 2,300 139,550 1,200 86,200 2,000 125,000 1 2 3 4 5 6 7 Required (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. $ 28,000 + $48.5 X (b.) Plot the data on a scatter diagram. Using the information from representative high-and low-volume months, develop a cost estimating equation for monthly order-processing costs. If needed, an Excel worksheet is provided in the following link in order to create the scatter diagram: Scatter_Diagram $ 15,000 X+ $53.14 X X
ssume you are the manager of a shop that assembles power tools. You have just received an order for 50 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30 Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.)
Requirement Classify each of the cost items (a-h) into one of the business functions of the value chain. Cost Item Value Chain Business Function a. Utility costs for the plant assembling the Latitude computer line of products b. Distribution costs for shipping the Latitude line of products to a retail chain c. Payment to David Newbury Designs for design of the XPS 2-in-1 laptop d. Salary of computer scientist working on the next generation of servers e. Cost of Dell employees' visit to a major customer to demonstrate Dell's ability to interconnect with other computers f. Purchase of competitors' products for testing against potential Dell products g. Payment to business magazine for running Dell advertisements h. Cost of cartridges purchased from outside supplier to be used with Dell…

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