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

Mpho is an avid seamstress and want to sew and sell high quality, reusable, designer face masks during the current Covid-19 pandemic. She will design and sew the masks herself and use her automatic embroidery machine to put her logo on each mask sold. With the help of her son, deliveries will be made all over Gauteng within 3 days of placing the order. Every mask will have a unique threelayer design with adjustable straps to ensure comfort and fit. Mpho’s only expense is the material needed to sew the masks and delivery costs. At this stage, Mpho’s target market is limited to Gauteng. Draw a diagram to illustrate the transformation process of Mpho’s new business. Be sure to include all relevant elements, headings and arrows to indicate the flow of products/ services
1. Which of the following quantities has no effect on the first period’s ATP calculation? a) Current on-hand Inventory b) Booked customer orders for the first periods c) MPS quantity for the first period d) Forecasted demand for the first period 2. Which one of the following is an MRP lot-sizing rule that attempts to minimize the amount to minimize the amount of average inventory? a) Periodic order quantity (POQ), WITH P=2 b)Fixed order quantity (FOQ) c) Economic order quantity (EOQ) d)Lot for Lot (L4L). 3. Which of the following statements about lot-sizing rules for MRP is true? a) The periodic order quantity (POQ) rule generates a higher level of average inventory since it creates inventory remnants. b) FOQ is a dynamic lot-sizing rule which reduces the amount of inventory, by doing a better job of matching the order quantity to the projected on-hand inventory quantity. c) The lot for lot rule minimizes inventory investment but maximizes the number of orders placed. d) In…
Evaluate the ethical considerations involved in inventory optimization, including its social and environmental implications.
S/O rule. Using the following information, determine an order processing sequence using the S/Opriority rule.OrderProcessingTimeRemaining(days)Due Date(days)Number ofOperationsRemainingA 20 30 2B 11 18 5C 10 6 2D 16 23 4
How do the mixed-model sequencing benefit?
Mgt-314 (Operations Management) MCQ:
Which item would be considered an order winner in an automobile developed for high-end users? Voice-activated music system Compact disc players Full-sized spare tire Air bags
Dana’s Ribbon World makes award rosettes. Following is information about the company: Variable cost per rosette $ 2.00 Sales price per rosette $ 6.00 Total fixed costs per month $ 6000.00 Required: 1. Suppose Dana’s would like to generate a profit of $1,120. Determine how many rosettes it must sell to achieve this target profit. 2. If Dana’s sells 2,140 rosettes, compute its margin of safety in units, in sales dollars, and as a percentage of sales. 3. Calculate Dana’s degree of operating leverage if it sells 2,140 rosettes. 4a. Using the degree of operating leverage, calculate the change in Dana’s profit if unit sales drop to 1,819 units. 4b. Prepare a new contribution margin income statement to verify change in dana's profit.
Please do not give solution in image format thanku
In each of the following, name the term defined or answer the question. Answers are listed at the bottom.1. The model was most appropriate for making a one-time purchase of an item.2. The model most appropriate when inventory is replenished only in fixed intervals of time—for example, on the first Monday of each month.3. The model most appropriate when a fixed amount must be purchased each time an order is placed.4. Based on an EOQ-type ordering criterion, what cost must be taken to zero if the desire is to have an order quantity of a single unit?5. The term used to describe demand that can be accurately calculated to meet the need of a production schedule, for example
Each Triam Deluxe gamer computer system consists of two speakers, a monitor, a system unit, a keyboard, and an installation kit. These pieces are packed together and shipped as a complete kit. In MRP terms, all of these items are level 1 items that make the level 0 kits. Complete the MRP records, using the following information: • Production plans for complete kits are as follows: Start assembling 4,500 kits in week 2 Start assembling 1,000 kits in weeks 3, 4, and 5 Start assembling 8,000 kits in week 6 • The gross requirements for the system unit have already been given to you. For the remaining items, you will need to figure out the gross requirements. • All scheduled receipts, lead times, and beginning inventory levels are shown. Click the icon to view the MRP records. Construct the material requirements plan for item System unit (enter your responses as whole numbers). System unit: Lead Time = 1 week; Minimum order quantity = 3,500 Week 1 2 3 Gross requirements 4,500 1,000…
Josh Smith, the materials manager at a retail store, has determined that a particular product experienced 5 turns last year, with an annual sales volume of $15 million. What was the average inventory value for this product last year? $2.5 million $2.75 million $3 million $5 million

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)