Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 125 units. The following is the BOM in indented form: ITEMDESCRIPTIONUSAGE Bracket X 1 assembly A Wall board 4 Hanger B 2 subassembly Hanger D 4 casting Ceramic E 1 knob Rivet head C 3 screw FMetal tong 4 GPlastic cap 2 Below is a table indicating current inventory levels: Item A B C D E F G Inventory 22 15 75 24 202 139 1,000 95 What are the Net Requirements for X, A, B, and C respectively?

Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 125 units. The following is the BOM in indented form: ITEMDESCRIPTIONUSAGE Bracket X 1 assembly A Wall board 4 Hanger B 2 subassembly Hanger D 4 casting Ceramic E 1 knob Rivet head C 3 screw FMetal tong 4 GPlastic cap 2 Below is a table indicating current inventory levels: Item A B C D E F G Inventory 22 15 75 24 202 139 1,000 95 What are the Net Requirements for X, A, B, and C respectively?

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

Inventory tracking is concerend both ith the quantity and the location of the goods in inventory. Select one: a. True. b. False.
A manufacturing company produces two products X and Y. Each product X requires one A and two Bs. Each B requires one C and one D. Each product Y requires 1 C and 4Ds. Table Q5A shows data from the inventory records of components. Table Q5A Data category A B C D Lot - sizing rule Fixed order quantity = 250 Lot for lot Lot for lot Fixed order quantity = 1000 Lead time 3 weeks 2 weeks 1 week 2 weeks Beginning inventory 70 0 200 800 The MPS for products X and Y is given in Table Q5B. The on-hand inventories are as follows: X = 100, Y = 30. The only scheduled receipts are 250 units of X in period 2.The lead times are as follows: X = 2 weeks, Y = 3 weeks. The chase strategy is used for both products. Table Q5B Demand in period Product SS 1 2 3 4 5 6 7 8 X 50 300 200 250 Y 30 400 Required: a) Draw a product structure tree for each product. b) Develop…
Black Instrument Company replenishes highly specialized replacement (service) parts based on statistical reorder point. One part is a 40-mm thumbscrew. Relevant data for the thumbscrew are: Planned stock out frequency= Six per year. Planned lead time = 2 weeks Forecast for next week= 300 Batch size = 400 Standard deviation of demand = 20 (per week) What is the reorder point? What would be the effect on the ROP if lead time were five weeks instead of two? What other factors might impact your decision on when to reorder parts?
Determine an A-B-C classification for these items: Which items are A, B, and C - explain how you derive the answers? Use a table or excel spreadsheet to illustrate your work. Item Unit Cost Annual Volume (000)1 300 252 90 303 30 604 50 105 15 706 100 407 10 60 Hint:Determine the Annual Dollar Value (Unit Cost * Annual Volume) for each item and the sum of the individual Annual Dollar Values. Arrange the items in descending order based on Annual Dollar Values. Then, determine the percentage of items and the percentage of…
David Alexander has compiled the following table of six itemsin inventory at Angelo Products, along with the unit cost andthe annual demand in units:IDENTIFICATION CODE UNIT COST ($) ANNUAL DEMAND(UNITS)XX1 5.84 1,200B66 5.40 1,1103CPO 1.12 89633CP 74.54 1,104R2D2 2.00 1,110RMS 2.08 961 Use ABC analysis to determine which item(s) should be care-fully controlled using a quantitative inventory technique and which item(s) should not be closely controlled.
Reorder PointConsider an economic order quantity case where annual demand D = 1,000 units, economic order quantity Q = 200 units, the desired probability of not stocking out P = .95, the standard deviation of demand during lead time σL = 25 units, and lead time L = 15 days. Determine the reorder point. Assume that demand is over a 250-workday year.
Economic Order Quantity and Reorder PointFind the economic order quantity and the reorder point, givenAnnual demand ( D )= 1, 000 unitsAverage daily demand ( d¯ ) = 1, 000 ∕365ordering cost ( S ) = $5 per orde rHolding cost ( H ) = $1.25 per unit per yearLead time ( L ) = 5 daysCost per unit ( C ) =$12.50What quantity should be ordered?
Catlea Merchandising is engaged in selling school shoesfor both boys and girls in their teenage years. Catlea needs 32,000 pairs of shoes in a year in order to satisfy the market demand. It costs ₱ 48 to place an order while ₱ 8 is needed to hold each quantity of shoe in Catlea's inventory. Upon checking on Catlea's supplier, it takes 8 days in between placing an order and eventually receiving it. a. Determine the Economic Order Quantityb. Determine the number of order per monthc. Determine the reorder point
Barbara Flynn's company has compiled the following 12.5 ata on a small set of products: ITEM A B C D E ANNUAL DEMAND ITEM NUMBER E102 D23 D27 R02 R19 $107 $123 U11 U23 V75 100 75 50 200 150 Perform an ABC analysis on her data. PX 12.6 Lynn Fish opened a new beauty-products retail store. There are numerous items in inventory, and Lynn knows that there are costs associated with inventory. However, because her time is limited, she cannot carefully evaluate the inventory policy for all products. Lynn wants to classify the items according to dol- lars invested in them. The following table provides information about the 10 items that she carries: UNIT COST $300 100 50 100 65 UNIT COST $4 $16 $8 $2 $8 $12 $1 $7 $1 $14 DEMAND (UNITS) 800 2,400 700 1,000 200 500 1,200 800 Use ABC analysis to classify these items into categories A, B, and C. PX 1,500 2,500 Problems 12.7-12.40 relate to Inventory Models for Independent Demand • 12.7 William Beville's computer training school, in Richmond, stocks…
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a servicelevel of .98. The order interval is 14 days, and lead time is 2 days. Average demand for one itemis 40 units per day, and the standard deviation of demand is 3 units per day. Given the on-handinventory at the reorder time for each order cycle shown in the following table, determine theorder quantities for cycles 1, 2, and 3.Cycle On Hand1 422 83 103
Company XYZ follows fixed order quantity model for Inventory planning. Annual Demand for the product is 1000 units; Cost per Order is $5, Inventory carrying cost per unit is $ 1.25, Lead time for procurement is 5 days and Cost per item is $ 12.5. With the given data calculate: a. EOQ-Economic Order Quantity b. Reorder Quantity c. Total cost of Inventory (answer by file attachment options)
Basic EOQ Model Item X is a standard item stocked in a company's inventory of spare parts. Each year, the firm uses about 2,000 units of Item X, which costs Php 1,000 per unit. Storage costs, which include insurance and cost of capital, amount to 18 percent of item unit cost. Placing an order for more of Item X costs Php 400. The company operates 360 days per year and Item X is received 9 days after placement of order. Including its total annual purchasing cost, how much would be Item X's total annual inventory cost? * None of the above O Php 2,016,971 O Php 2,008,485 O Php 2,000,000