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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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