Question

One unit of A is made of two units of B, three units of C, and...

One unit of A is made of two units of B, three units of C, and two units of D. B is composed of one unit of E and two units of F. C is made of two units of F and one unit of D. E is made of two units of D. Items A, C, D, and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D; lots of size 50 and 180 are used for Items E and F, respectively. Item C has an on-hand (beginning) inventory of 15; D has an on-hand inventory of 50; all other items have zero beginning inventories. Construct :

a) simple product structure tree and the low-level-coded BOM

b) indented and the summarized parts lists.

Homework Answers

Answer #1

0 1 2 3 4 5 6 7 8
Gross Requirement 0 0 0 0 0 0 0 20
Item A Scheduled receipt 0 0 0 0 0 0 0 0
OH=0 Proj. Available balance 0 0 0 0 0 0 0 0 0
LT=1 Net requirement 0 0 0 0 0 0 0 20
SS=0 Planned order receipt 0 0 0 0 0 0 0 20
Q=L4L Planned order release 0 0 0 0 0 0 20 0
Gross Requirement 0 0 0 0 0 0 40 0
Item B Scheduled receipt 0 0 0 0 0 0 0 0
OH=0 Proj. Available balance 0 0 0 0 0 0 0 0 0
LT=2 Net requirement 0 0 0 0 0 0 40 0
SS=0 Planned order receipt 0 0 0 0 0 0 40 0
Q=L4L Planned order release 0 0 0 0 40 0 0 0
Gross Requirement 0 0 0 0 0 0 60 0
Item C Scheduled receipt 0 0 0 0 0 0 0 0
OH=15 Proj. Available balance 15 15 15 15 15 15 15 0 0
LT=1 Net requirement 0 0 0 0 0 0 45 0
SS=0 Planned order receipt 0 0 0 0 0 0 45 0
Q=L4L Planned order release 0 0 0 0 0 45 0 0
Gross Requirement 0 0 0 0 40 0 0 0
Item E Scheduled receipt 0 0 0 0 0 0 0 0
OH=0 Proj. Available balance 0 0 0 0 0 10 10 10 10
LT=2 Net requirement 0 0 0 0 40 0 0 0
SS=0 Planned order receipt 0 0 0 0 50 0 0 0
Q=50 Planned order release 0 0 50 0 0 0 0 0
Gross Requirement 0 0 0 0 80 90 0 0
Item F Scheduled receipt 0 0 0 0 0 0 0 0
OH=0 Proj. Available balance 0 0 0 0 0 100 10 10 10
LT=1 Net requirement 0 0 0 0 80 0 0 0
SS=0 Planned order receipt 0 0 0 0 180 0 0 0
Q=180 Planned order release 0 0 0 180 0 0 0 0
Gross Requirement 0 0 100 0 0 45 40 0
Item D Scheduled receipt 0 0 0 0 0 0 0 0
OH=50 Proj. Available balance 50 50 50 0 0 0 0 0 0
LT=1 Net requirement 0 0 50 0 0 45 40 0
SS=0 Planned order receipt 0 0 50 0 0 45 40 0
Q=L4L Planned order release 0 50 0 0 45 40 0 0

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Product A is made from components B and C. Item​ B, in​ turn, is made from...
Product A is made from components B and C. Item​ B, in​ turn, is made from D and E. Item C also is an intermediate​ item, made from F and H.​ Finally, intermediate item E is made from H and G. Note that item H has two parents. The following are item lead​ times: Item A B C D E F G H Lead Time​ (weeks) 1 1 2 2 6 4 4 6 a. What lead time​ (in weeks)...
The beginning inventory on November 1 includes 15 units at a cost of $8.00 per unit....
The beginning inventory on November 1 includes 15 units at a cost of $8.00 per unit. Following information is related to purchases made during November: Units Unit Cost Nov. 8 Purchase 60 units $8.60 17 Purchase 30 units $8.40 25 Purchase 45 units $8.80 A physical count of merchandise inventory on November 30 reveals that there are 50 units on hand. Assume a periodic inventory system is used. Cost of ending inventory under FIFO is
Product Y is made from one component P, three components Q, and one 2 components R.  P...
Product Y is made from one component P, three components Q, and one 2 components R.  P is made from two parts S, Q is made from one S, and R is made from two part S and three part T.  Other data includes: Part                 Lead time             Lot size                   On hand                 Scheduled receipts         Safety Stock Y                         1                                 lot-for-lot               30                                              none                                          5 P                        2                                   40                              15                                              none                                          none Q                        2                                 100                               8                                               none                                          8 R                        3                                 120                             30                                              none                                          none S                         2                                 500                             20                                              500, week 1                          20 T                         2                                 600                           370                                             none                                          50 a.    Draw the BOM for product Y. b. Complete the MRP explosion for product Y.  Identify any problems, and discuss possible solutions Master Production Schedule Finished...
Consider an item by the name of Z which has components 2X’s and one Y. Gross...
Consider an item by the name of Z which has components 2X’s and one Y. Gross Requirements for Z are 0, 35, 55, 60 respectively. The inventory status of each as well as lead times is as below. Find the 4 week MRP schedule for all components.                               On Hand              Lot Size                Lead Time Z                            100                        LFL                    1 X                               20                     100 +                  1 Y                               10                     150+                   1                                a. What is the On Hand Inventory of Z...
Production of Product B has been budgeted at 200,000 units for November. One unit of Product...
Production of Product B has been budgeted at 200,000 units for November. One unit of Product B requires 2.5 lbs. of raw material. The projected beginning and ending materials inventory for November are: Beginning inventory: 5,000 lbs. Ending inventory: 70,000 lbs. How many lbs. of material should be purchased during November? A. 525,000 B. 548,000 C. 577,000 D. 565,000
Assume that Product Z is made up of four units of A and two units of...
Assume that Product Z is made up of four units of A and two units of C and two units of D. A is made of three units of D. The total demand for Z is 2000 units Additional information is the following:                                     Item Z A C D On hand 750 500 460 2,000 Safety stock 0 120 140 200 Allocated 0 80 160 200 Scheduled Receipts -- 500 in Week 1 1,500 in Week 1 -- Provide the...
40. 40. Inventory is reported on the balance sheet statement at: Select one: a. Cost b....
40. 40. Inventory is reported on the balance sheet statement at: Select one: a. Cost b. Market value c. Lower of cost or market value d. None of the above 41. A perpetual inventory system offers all the following advantages except: Select one: a. inventory balances are always current b. it is less expensive than a periodic system c. it enhances internal control d. it helps sales people determine whether there is a sufficient supply of inventory on hand to...
PROBLEM THREE Wilson Beverages bottles two soft drinks under license to Cadbury Schweppes at its Manchester...
PROBLEM THREE Wilson Beverages bottles two soft drinks under license to Cadbury Schweppes at its Manchester plant. All inventory is in direct materials and finished goods at the end of each working day. There is no work-in-process inventory. The two soft drinks bottled by Wilson Beverages are lemonade and diet lemonade. The syrup for both soft drinks is purchased from Cadbury Schweppes. Wilson Beverages uses a lot size of 1,000 cases as the unit of analysis in its budgeting. (Each...
The demand for subassembly S is 120 units in week 7. Each unit of S requires2...
The demand for subassembly S is 120 units in week 7. Each unit of S requires2 units of T and 1 unit of U. Each unit of T requires 1 unit of​ V,1unit of​ W, and1 unit of X.​ Finally, each unit of U requires 2 units of Y and 3 units of Z. One firm manufactures all items. It takes 2 weeks to make​ S,1week to make​ T, 2 weeks to make​ U, 2 weeks to make​ V, 3...
1.    A firm desires to control inventory levels so as to minimize the sum of holding...
1.    A firm desires to control inventory levels so as to minimize the sum of holding and order costs. It costs the firm $20 to place an order. The firm estimates its yearly inventory carrying costs at 20%. Weekly demand is 100 units, and there are 50 weeks in the work year. The item costs $10 per unit. The EOQ is approximately: A. 316 B. 224 C. 145 D. 45 E. 32 2.    One end item A requires three component...