Complete the mps plans for both end items

Assignment Help Other Subject
Reference no: EM131297460

Assignment -

Background:

Your company has just acquired a new subsidiary that makes two products, Clodhopper and Clodbuster.  The Clodhopper is intended for the general consumer market and its demand is higher and more seasonal than the Clodbuster, which is intended for the commercial user market. Both products share a number of component parts and subassemblies, primarily differing in their engine and tiller subassemblies. You have been assigned to run this acquisition. The only planning information you have is historical data.

Assignment:

Your task is to complete the MPS plans for both end items and to create material requirements plans (MRP) for any 5 items in the BOM.

  • First complete all of the information in the MPS plans.
  • Then, using the MRP forms supplied in the spreadsheets. Fill in all appropriate data (lot size, ordering rule, etc).
  • Do not make any changes to the format/layout of the spreadsheet. This is one place in industry where creativity in presenting data is not appreciated since many of the cells in the forms are normally linked, and changes can lead to significant errors in the results.

Data:

The "Assignment" spreadsheet contains five different worksheets:

  • MPS plans for Clodhopper and Clodbuster for the first three months of 2016.
  • Bill of materials data for ClodHopper and ClodBuster, including quantities required per product and assembly times/lead times
  • Inventory records and lot-sizing rules for all subassemblies and component parts
  • Scheduled receipts (production commitments and purchase orders that have been scheduled by previous MPS and MRP plans for delivery in 2016.
  • MRP forms to use for your choice of five items in the BOM

Additional information:

  • Remember that the FOQ lot-sizing rule allows multiple orders. That is, if your plan requires 450 units in a given period, current inventory is 75 units, and the FOQ order size is 100 units, then you would request 400 units (four orders) from the vendor or assembly production line.
  • For items purchased using the POQ lot-sizing rule, consider that the time between orders begins at the start of the plans. That is, if the POQ period is 3, you can only have planned receipts (or scheduled receipts) in periods 1, 4, 7, and so on. Unlike the other ordering schemes where you first determine when a new order must be received and then schedule the order earlier according to the lead time, for POQ you look at future needs that must be satisfied until another POQ order can be placed.
  • Do not schedule MRP planned orders in the line for scheduled receipt items. Scheduled receipts have already been started or ordered on previous MRP plans for delivery in 2016 and you are not allowed to make any additional entries on this line. The values on this line are to be added to the projected on-hand inventory when each scheduled receipt arrives. Do not reflect the scheduled receipts into planned order releases.
  • Some parts and subassemblies have desired safety stock levels. Be sure to order enough or early enough to ensure these levels are maintained, limited only by any lead-time constraints. When there is no safety stock, maintain the projected on-hand greater than or equal to zero.
  • Use the power of Excel as much as possible for filling out your MPS and MRP forms. Doing so will save you considerable time in completing your assignment and is representative of how these processes are done in industry.
  • Hint: Entering new order quantities (planned receipts) when needed is best done manually whenever the on-hand inventory values indicate that you would not have enough unless an order is placed.

Attachment:- Assignment.rar

Reference no: EM131297460

Questions Cloud

Five general principles of prescription in your own words : 1. Write down the five general principles of prescription in your own words? 2. What are the things a researcher should do and keep in mind while taking consent from an individual for research and innovative treatment?
Monthly savings-save money to meet three objectives : Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with a retirement income of $26,500 per month for 20 years, with the first payment received 30 years and 1 month from now. If he c..
Identify and explain the strongest argument in each article : Identify and explain the strongest argument in each article. Discuss whether or not an inference is warranted. Determine whether arguments utilize inductive or deductive reasoning.
What is the value at date of perpetual stream : Given an interest rate of 4.1 percent per year, what is the value at Date t = 10 of a perpetual stream of $2,500 annual payments that begins at Date t = 20?
Complete the mps plans for both end items : BA 357 Fall 2016 Assignment. Your task is to complete the MPS plans for both end items and to create material requirements plans (MRP) for any 5 items in the BOM. First complete all of the information in the MPS plans
Project has annual cash flows : A project has annual cash flows of $5,000 for the next 10 years and then $9,000 each year for the following 10 years. The IRR of this 20-year project is 8.52%. If the firm’s WACC is 8%, What is the projects NPV?
Why the actions of the volkswagen management were unethical : In 2015, it was revealed that Volkswagen (VW) had installed software on its diesel cars in order to circumvent US emissions tests. Carefully, outline what this scandal involved, and explain why the actions of the VW management were unethical.
What is the present value? of this perpetuity : A perpetuity will pay $1,000 per? year, starting five years after the perpetuity is purchased. What is the present value? (PV) of this perpetuity on the date that it is? purchased, given that the interest rate is 11?%?
Present description of one actual capital project : Provide a paragraph with a description of the company and major reason why you believed it failed. Synthesize your one-paragraph position on what 3-5 specific factors you believe most likely to contribute to capital project analysis failure. Briefly ..

Reviews

len1297460

12/1/2016 11:42:12 PM

Your task is to complete the MPS plans for both end items and to create material requirements plans (MRP) for any 5 items in the BOM. Remember that the FOQ lot-sizing rule allows multiple orders. That is, if your plan requires 450 units in a given period, current inventory is 75 units, and the FOQ order size is 100 units, then you would request 400 units (four orders) from the vendor or assembly production line.

Write a Review

 

Other Subject Questions & Answers

  Community supported by various agencies and citizens

How are the arts in your community supported by various agencies and citizens? Do you think there is enough or not enough support of the arts by these entities? Explain why or why not. What is your role in the creation and support of art in your comm..

  The evolution of 20th century liberalism

The evolution of 20th century liberalism,Need the definition of 20th century liberalism, the context in which it emerged, and factors that contributed to its unraveling,

  Shape the relationship between business and society

In one paragraph, supported by evidence in your text and from other research, describe two forces that you believe shape the relationship between business and society.

  Why quantitative analysis takes more resources

Why quantitative analysis takes more resources (more expensive) than qualitative analysis? Is there an example you might provide

  French- speaking countries

How many French- speaking countries are there in South America?

  What is workplace violence

What is workplace violence? To what degree is workplace violence a problem in the United States? And what factors contribute to workplace violence?

  Compare and contrast whitman''s free verse with robert frost

Compare and contrast Whitman's free verse with Robert Frost's traditional verse. Compare not only the form of their poetry but their themes as well, as discussed by Professor Weinstein.

  Confidence interval for the population mean

Random sample of 42 college graduates revealed that they worked an average of 5.5 years on the job before being promoted. The population standard deviation was 1.1 years. Using the 0.99 degree of confidence, what is the confidence interval for the po..

  Patient food preparation and delivery process

The patient completes the menu card, marking his/her selections on the card. Nursing personnel on the floor check the menu card with the patient's prescribed diet. If the card is consistent with the diet of the patient, the card is sent to food servi..

  Develop a tool to explain learning theory to your students

Based on the information in this week's required reading from the text (Carey, 2014), develop a tool to explain learning theory to your students and/or their parents

  Branches of the government overpower another branch

What is the system that makes sure that no branches of the government overpower another branch?

  Explain the importance of situating a society cultural

Compare Gilgamesh and Odysseus as to their heroic qualities, noting similarities and differences, using specific examples from the epics. Summarize what this indicates about differences between ancient Mesopotamian and Greek cultures in their ide..

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!

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