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

  Provide and explanation of the amount

Will Brittany be liable for the moneys withdrawn from her account? Explain why or why not. If she is liable, provide and explanation of the amount.

  Explain how the design of the distribution network affects

explain how the design of the distribution network affects the cost of the four supply chain drivers.

  Explore essential aspects and levels of controls

Examine methods and systems used to control and sustain process improvements. Explore essential aspects and levels of controls for sustainable performance improvement.

  Elucidate how many cans of cat food should cli order

LI uses the economic order quantity as their fixed order size. Suppose the opportunity cost of capital also all other inventory cost is 15percent annually also that there 50 weeks in a yr. Elucidate how many cans of cat food should CLI order at a ..

  A company needs to ship 100 units from seattle to denver at

a company needs to ship 100 units from seattle to denver at the lowest possible cost. the costs associated with

  What is the breakeven volume

How do the two plants compare with respect to the cost of labor for making a car? For each location, what is the breakeven volume and what is the total cost at breakeven?

  Push-based production with pull-based production strategies

Compare and contrast push-based production strategies with pull-based production strategies. What are the primary capabilities, advantages, and disadvantages of each?

  Role of the human resource manager in the company

Why might this be the case? If you were human reource specilaist interviewing with this company for an open position, what would this practice imply for the role of the human resource manager in thar company?

  Borders prices the book to its customers

A publisher sells books to Borders at $12 each. Borders prices the book to its customers at $24 and expects demand over the next two months to be normally distributed

  Explain what is iso standards

Explain what is ISO standards

  Riordan virtual organization and environmental scan paper

Decide which competitive advantages Riordan has in common with the companies researched last week, and estimate which competitive strategies Riordan could use to improve innovation and sustainability of business operations in the global market.

  Discuss the various types of radiation

Discuss the various types of radiation that a safety professional might encounter and some methods for protecting oneself against it

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