Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Operation Management Expert

I need an expert in OM to do this MRP assignment

BIS 312 - Excel, MRP

846_Create the MRP tables for all parts.png

Forecasted demand for cabinets:
Week 4: 100 Week 7:100 Week 10: 100

Item  Beginning Inventory  Scheduled Receipts  Lot Size Rule  LT 
CD Cabinet   0 None  L4L  1
Cabinet Top  120 None  FOQ= 144  3
Cabinet Bottom  20 Week 3- 144  FOQ = 144  3
Cabinet Door  120 Week 3- 216  FOQ= 216  3
Cabinet Sides  0 Week 3- 216  FOQ=216  3
Cabinet Shelves  0 None  L4L  2
Shelf Supports  0 None  FOQ=2500  1
Door Magnet  12 None  FOQ= 250  2
Door Hinge  0 Week 3- 932  FOQ=932  4
Door Handle  50 Week 3- 200  FOQ=200  3
Door Screws  500 None  FOQ=2000  1
Door Catch  0 None  FOQ=252  1
Feet  0 Week 3- 576  L4L  4

Using the MRP Forms I posted, create the MRP tables for all parts of the CD cabinet for a 12 week planning period.

Note: You need to adjust the forms to work with this assignment by adding the required information

Attachment:- Template.xlsx

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M91521843
  • Price:- $35

Priced at Now at $35, Verified Solution

Have any Question?


Related Questions in Operation Management

1 why can we say that the hawaiian kingdom government was

1. Why can we say that the Hawaiian Kingdom government was illegally overthrown, but not the country called the Hawaiian Kingdom? Explain the difference between the Hawaiian government and the Hawaiian State. Give histor ...

1 describe a scenario that an excel spreadsheet instead of

1. Describe a scenario that an excel spreadsheet instead of a database would be fine to use.Think of one you have used recently. 2. Describe a scenario of when an excel spreadsheet would not work and a full database is r ...

1 explain the role of cloud computing traceability rfid and

1. Explain the role of cloud computing, traceability, RFID and other ERP solutions as per your experience which you gained from this project. 2. Propose how infographics convey information efficiently. Give and example. ...

Be aware that these are not short answer questions you

Be aware that these are NOT short answer questions. You might also want to review "How to Approach Case Study Essay Questions" presented in week 1. Questions you will be answering: Q1 (Synthesis) - Can the basic interper ...

1 which is more effective trait or behavior approaches to

1. Which is more effective: trait or behavior approaches to leadership? WHY? 2. When presenting in Power Point, what types of visual aids to you find helpful or beneficial to your message delivery? Explain, in detail, in ...

1 donald bought a car from robert and used it for four

1. Donald bought a car from Robert and used it for four months before discovering that it had been stolen. Donald then had to hand over the car to the true owner. Advise Donald whether he could recover the full amount he ...

1 which of the following is not a potential advantage for

1. Which of the following is NOT a potential advantage for sellers to sell their products/services on a Platform? 1. None of the listed choices 2. Access to buyers 3. Access to data on consumer behaviours 4. Lower transa ...

1 the treatment of two or more individuals with a mental

1. The treatment of two or more individuals with a mental health disorder by behavioral, cognitive, psychoanalytic, psychodynamic, or psychophysiological means to improve functioning or well-being is called __________. F ...

Consider all you have learned in the course so far and the

Consider all you have learned in the course so far and the trends that have been discussed, particularly around leaders being able to strategize and execute to results. Using the module readings, the Argosy University on ...

What happens in the absence of controlgive an example of a

What happens in the absence of control? Give an example of a standard for sustainability. What impact would achieving Six Sigma quality have on a company’s costs? If one activity costs the most, how would you decide if t ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As