Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven assembly with a minimumcost possible. Following table show gross requirements of their product for twelve weeks. Develop a Part Period Balancing (PPB) solution andcalculate the total relevant costs for the plan.WeekGross requirements130WeekGross requirementsOn-hand at beginning of week 40On-hand at end of weekOrder receiptOrder releaseTotal relevant cost for this plan is = $233013042540 70 20Also, for this plan the Holding cost = $2.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40 units.Use the table below to develop a PPB solution for MRP (enter your responses as whole numbers).3306 7 84540(enter your response as a whole number).6॥70910 7072010 118D12509 10 11 12107050

Inventory management refers to the process of overseeing and controlling a company's inventory of…

Answered: Best-Appliance makes high-powered…

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

Case Study 4: Inventory Management. I) A Furniture manufacturing company uses 1200 units of an item annually and the cost price is $250 per unit. The ordering costs are $600 per order and holding costs are $4.00 per item per annum. Required: Calculate the economic order quantity. Determine the number of orders per annum. Determine the annual stock holding cost. Determine the annual ordering cost.
Demand for chicken soup at a supermarket is always 25 cases a day and the lead time is always 4 days. Theshelves were just restocked with chicken soup, leaving an on-hand inventory of only 10 cases. No backorderscurrently exist, but there is one open order in the pipeline for 200 cases. What is the inventory position? Shoulda new order be placed?
2.7 Which of the following help explain how the Reorder Point (ROP) works in conjunction with the Economic Order Quantity (Q), the number of orders (N) and the time between orders (T)? a) The Economic Order Quantity (Q) and the Annual Demand (D) are used to determine the number of Order (N) b) The number of orders (N) and the number of days that a firm works (W) are used to determine the time span between orders (T) c) Orders are placed every T days unless the inventory on hand fall to or below the Reorder Point d) Only a and b e) f) Only b and c All of a, b and c 2.8 The objective of Inventory Management is to balance inventory investment (cost) and customer service. a) TRUE b) False 2.9 The Economic Order Quantity (EOQ), the number of orders, the Reorder Point (ROP), the time between orders are important analytics in Inventory Management. a) TRUE b) FALSE 2.10 The number of working days for a firm is an important input in calculating the components of the Economic Order Quantity…
Complete the master productin schedule based on thefollowing information:Week 1 2 3 4 5 6 7 8 9Forecast 320 100 30 110 40 240 290 60 410Customer Orders 60 50 80 20 60 60 0 0 0Projected On-Hand Inventory 600MPS ReleasedMPS DueAvailable-to-promise (ATP) Scheduled production whenever projected on-had inventory drops below 30MPS lot size: 300Production lead time or lead time for MPS releases 1
Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 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 Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text 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.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6
Given the following parents and components, construct a product tree. Figures inparentheses show the quantities per item. How many Gs are needed to make one A?
Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is determining a minimum-cost inventory plan for an upcoming phone to be launched in the market. She has collected the following information: • Annual demand: 1000 phones • Phone cost: $1,214 each • Phone RRP: $1,349 each • Net weight: 163 g each • Tare weight: 277 g each • Annual inventory holding cost: 15% • Cost per order to replenish inventory: $75 • Annual in-transit holding cost: 10% • Freight rate: $8.10 per kg • Time to process order for freight: 1 days • Freight transit time: 3 days Solve this problem using a non-linear programming (NLP) model to determine the followings:d. The total cost for holding the inventory e. The total cost for transportation f. The total cost for holding the phones during transit g. The total cost for this inventory plan h. The number of orders i. Ordering point j. The profit from this inventory plan
Explain how is ordering in small lot sizes essential for just in time implementation and what benefi are epected to be achieved ?
The Bawl Corporation supplies alloy ball bearings to automanufacturers in Detroit. Because of its specialized manu-facturing process, considerable work-in-process and rawmaterials are needed. The current inventory levels are$2,470,000 and $1,566,000, respectively. In addition, fin-ished goods inventory is $1,200,000 and sales (at cost) forthe current year are expected to be about $48 million. Ex-press total inventory asa. Weeks of supplyb. Inventory turns
How would these factors affect an EOQ analysis?(1) The use of just-in-time procedures.
Do prospects have the Monetary resources to make the purchase?
A hospital treating COVID patients needs to buy gloves, gowns, and masks for the health care professionals working at the facility. The hospital has two suppliers who can supply the items. The cost, and the maximum number of each item each supplier can provide is given below: Supplier A Supplier B Gloves (cost, max units) ($0.30/unit, 20,000) ($0.35/unit, 11,000) Gowns Masks ($2.00, ($2.50, 5000) 10,000) ($1.75, 7000) ($2.55, 9,500) The hospital immediately needs 30,000 units of gloves, 5500 units of gowns, and 12,500 masks. To account for the economies of scale in logistics, the Supplier A has a requirement of at least 25,000 units in the order, while Supplier B has a requirement of a minimum order size of 10,000 units and a maximum order size of 20,000. What is is the minimum total cost of order that the hospital needs to pay to the suppliers to get the items?

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