User Account

All Pages

Create the mrp tables for all parts of the cd cabinet

Assignment Help Operation Management
Reference no: EM13861085

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

Reference no: EM13861085

Questions Cloud

Display to the screen the first 20 numbers : Design an algorithm that will display to the screen the first 20 numbers, with their squares and cubes, as follows: Number Square Cube
The ph of an aqueous solution is a measure : Microsoft Word - HW#9.docx In chemistry, the pH of an aqueous solution is a measure of its acidity. A solution with a pH of 7 is said to be neutral, a solution with a pH greater than 7 is basic, and a solution with a pH less than 7 is acidic.
Design a program that will read a file of employee records : Design a program that will read a file of employee records containing employee number, employee name, hourly pay rate, and regular hours worked and overtime hours worked. The company pays its employees weekly, according to the following rules:Regular..
The development process includes planning : The development process includes planning, coding and debugging of code to create the programs that solve real-world applications. Before embarking on a project, one must do a fair amount of project planning as well to maintain documentation througho..
Create the mrp tables for all parts of the cd cabinet : Using the MRP Forms - 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
Design a program that will read a file of product records : Design a program that will read a file of product records, each containing the item number, the item name, and the quantity sold this year and the quantity sold last year. The program is to produce a product list showing the item number, the item nam..
Formulas and use functions to do calculations : For this project, pretend you're going to go on a trip to visit three places. You should have estimated costs for transportation, hotels, and meals. Create a spreadsheet to calculate the total costs for each item, total cost, and percent of the total..
Why does tomcats first servlet request take so long : Why does Tomcat's first servlet request take so long? How do I disable port 8080? I want Tomcat to run only through my Web server, not directly through Tomcat.
What should sheila have done to avoid interviews like this : What should Sheila have done to avoid interviews like this one. Explain why Sheila, not Pete, should make the selection decision.

Reviews

Write a Review

Operation Management Questions & Answers

  Considered an important location consideration

With respect to globalization, which of the following would not be considered an important location consideration?

  What are arguments for and against the concept of corporte

What are the arguments for and against the concept of corporate social responsibility?

  How lead time demand is distributed normally

Given this information: Expected demand during lead time 300 units Standard deviation of lead time demand 30 units determine each of subsequent, assuming that lead time demand is distributed normally.

  Why is it important to continuously update

Why is it important to continuously update the implementation and communication of a strategic plan? Who should be responsible for updating

  Describe the possible risk events for the project

Describe the possible risk events for the project. Identify the high probability, high-impact risk events. For each of those risk events, identify the possible actions to mitigate the risk. Describe how changes to the risk management plan will be ..

  Which variables would you choose contain ten dimensions

your information mart and 5 indicating that the dimension offers the lowest value and does not desire to be in your information mart. Which variables would you choose if your information mart could only contain 10 dimensions.

  Explain what are the sources of value creation

Is NMC an example of related or unrelated diversification. what are the sources of value creation. What were the main incentives for its diversification.

  The following is not a way to manage stress in a healthy way

Stress can be defined as the process by which we perceive and respond to situations that challenge or threaten us. Which of the following is not a way to manage stress in a healthy way

  Newly appointed minister of international trade

The country of Utopia has a newly appointed Minister of International Trade

  Why are processes important in terms of managing logistics

Why are processes important in terms of managing logistics? Suggest how the processes of plan, source, make, deliver and return might differ in the case of the two factories Simple and Complex?

  Four areas of the johari window model

Question 1: "Identify and explain the four areas of the Johari Window Model." Question 2: How can you use the Johari Window Model, as a tool to understand interpersonal communications?

  Leader refused to change their leadership style

Discuss a situation when a leader refused to change their leadership style or did not recognize a need for change in order to achieve desired results. What were the reasons for the change? What were the results?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd