Brown and Brown Electronics manufactures a line of digital audiotape(DAT) players. The bill of materials, showing the number of each itemrequired is shown below follows:F(2)C(1)I(2)F(2)H(1)I(2)Data for A: Gross requirement is 100 units on 9th week, Lead time is 2weeks, Lot for lotAG(2)D(2)Data for C: Lead time is 1 weeks, Lot for lotData for D: Lead time is 2 weeks, schedule receipt is 30 on 1st week, lotsize 170 unitsData for F: Lead time is 1 weeks, scheduled receipt is 60 on 1st week,on hand inventory is 15, lot for lotData for G: Lead time is 1 weeks, scheduled receipt is 100 on 1st week,on hand inventory is 50, lot for lotData for H: Lead time is 1 weeks, scheduled receipt is 50 on 1st week, lotsize is 200Data for I: Lead time is 1 weeks, scheduled receipt is 60 on 1st week,on hand inventory is 15, lot for lotPrepare an MRP schedule to satisfy the demand.

Instructions and formula used: Projected on hand = Planned order receipts + ending inventory…

Answered: Brown and Brown Electronics…

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

WSS company makes weatherproof surveillance systems for parking lots. Demand estimates for the next four quarters are 25, 9, 13, and 17 units. Prepare an aggregate plan that uses inventory, regular time and overtime and back orders. Subcontracting is not allowed. Regular time capacity is 15 units for quarters 1 and 2, 18 units for quarters 3 and 4. Overtime capacity is 3 units per quarter. Regular time cost is $2000 per unit, while overtime cost is $3000 per unit. Back order cost is $300 per unit per quarter; inventory holding cost is $100 per unit per quarter. Beginning inventory is zero. Questions At the end of quarter 3, what is the ending inventory of finished systems? Answer: No ending Inventory =0 What is the total cost? 15*2000 + 6*2300 +4*2600 + 9*2000 + 13*2000 + 17*2000 =$132, 200 What is the average cost per unit? Answer 132200 / 64 = $2,066.
Describe the following types of bills of material:a. Product tree.b. Multilevel bill.c. Single-level bill.d. Indented bill.e. Summarized parts list.f. Planning bill
A phone production company must prepare the production planning for the next 9 weeks. Complete the below table considering this information: Lead Time = 3 Weeks On-hand inventory of 52 phones from week 1. Receipt from an outside supplier of 15 phones at start of week 7 We need to supply 75 phones on week 4. We need to supply 120 phones on week 9. Product A Week 1 2 3 4 5 6 7 8 9 Gross Requirement On-hand inventory Planned order
WSS company makes weatherproof surveillance systems for parking lots. Demand estimates for the next four quarters are 25, 9, 13, and 17 units. Prepare an aggregate plan that uses inventory, regular time, and over time, and backorders. Subcontracting is not allowed. The regular time capacity is 15 units for quarters 1 and 2, 18 units for quarters 3 and 4. Overtime capacity is 3 units per quarter. The regular time cost is $2000 per unit, while the overtime cost is $3000 per unit. Backorder costs $300 per unit per quarter; inventory holding costs $100 per unit per quarter. The beginning inventory is zero. How many total units will be produced in quarter 1 for delivery in quarter 1? How many units in total will be used to fill back orders over the four quarters? What is the cost to produce one unit in Quarter 4 using overtime to fill a back order in quarter one?
Consider the following product structure (bill of material). One hundred and fifty (150) units of Product A are needed in week 10. Assuming no on-hand inventory of A exists, explode the bill of material, and use the following information to construct a net requirements plan for all the items. You must use the template provided by the instructor and provide all the information needed on the template. There are no scheduled receipts for all the items. Item On-hand Inventory Lead time (weeks) A 0 2 B 20 2 C 10 1 D 0 3 E 5 1 F 10 3 Item: LT= 1 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements Scheduled Receipts Projected on Hand Net Requirements…
An end item’s demand forecasts for the next 10 weeks are 30, 30, 30, 30, 20, 20, 30, 30, 30, and 30 units. The current onhand inventory is 100 units. The order policy is to produce in lots of 75. The booked customer orders for the item, starting with week 1, are 15, 38, 7, 5, 0, 3, 10, 0, 0, and 0 units. The lead time is 2 weeks.a. Develop an MPS for this end item.b. The marketing department has received five orders for this item in the following sequence:Order 1 is for 20 units to be delivered in period 1Order 2 is for 75 units to be delivered in period 4Order 3 is for 90 units to be delivered in period 6Order 4 is for 75 units to be delivered in period 7Order 5 is for 90 units to be delivered in period 10Assuming that the prospective MPS you developed in part (a) does not change, which orders would you be able to accept based on the available to promise (ATP)?
The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amounton Hand Direct Components End 3 0 L(2), C(1), K(3) L 3 12 B(2), J(3) C 4 17 G(2), B(2) K 4 22 H(4), B(2) B 3 30 J 4 29 G 4 3 H 3 0 a. 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 develop an MRP plan.)Additional units b. An order for the end item is scheduled to be shipped at the start of week 13. What is the latest week that the order can be started and still be ready to ship on time? (Hint: You don’t need to develop an MRP plan.) The latest week
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 following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amount Direct Components on Hand End 1 0 L(2), C(1), K(3) L 1 10 B(2), J(3) C 2 14 G(2), B(2) K 2 19 H(4), B(2) B 1 34 J 2 25 G 2 7 H 3 0 a. If 43 units of the end item are to be assembled, how many additional units of B are needed? b. An order for the end item is scheduled to be shipped at the start of week 9. What is the latest week that the order can be started and still be ready to ship on time?
An end item’s demand forecasts for the next 10 weeks are 30,20, 35, 50, 25, 25, 0, 40, 0, and 50 units. The current on-handinventory is 80 units. The order policy is to produce in lots of100. The booked customer orders for the item, starting withweek 1, are 22, 30, 15, 9, 0, 0, 5, 3, 7, and 0 units. At present,no MPS quantities are on-hand for this item. The lead time is2 weeks. Develop an MPS for this end item.
A partially completed inventory record for the motor sub-assembly is shown in Figure 11.39.a. Complete the last three rows of the record by using theL4L rule.b. Complete the last three rows of the record by using thePOQ rule with P = 2. c. Complete the last three rows of the record by using thePOQ rule with P = 2.d. If it costs the company $1 to hold a unit in inventory fromone week to the next, and the cost to release an order is$50, which of the lot sizing rules used above will providethe lowest inventory holding + order release cost?
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 300 attendees. Assume that there is no inventory on hand of any of the items. Explode the bill of material. (Subscripts indicate the number of units required.) K(1) L(5) M(3) J Determine the number of units of each item required. Item K: Item L: Item M:

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

Brown and Brown Electronics manufactures a line of digital audiotape (DAT) players. The bill of materials, showing the number of each item required is shown below follows: F(2) I(2) C(1) G(2) H(1) A D(2) F(2) I(2)