| Homework Help Websites

BA 314: Fall 2018

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Assignment 2

Due in Canvas 11:59 pm PST, On Tuesday of Week 10



Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper




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.



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.



The “Assignment 2 ” spreadsheet contains five different worksheets:

  • MPS plans for Clodhopper and Clodbuster for the first three months of 2018.
  • 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 2018.
  • 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 2018 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. Use the comment function to show the formula for “projected on-hand inventory” calculations for both the MPS and MRP forms.
    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.


Assignment 2 Grading:

There are 50 points possible on this assignment.  Grading criteria include proper application of the planning methods, following all directions, and professional appearance of your work, including application of Excel.


Use the Excel file: BA 314 Assignment 2 F18 for the required information and forms


BA 314 Assignment 2 – Worksheet 1: MPS Approved plan
Item: A Clodhopper (Winter2018) Lot Size Rule:
Lead Time:
Safety Stock Level:
Current Inventory:
Jan 2018 Feb 2018 Mar 2018
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
Forecast 450 450 450 450 600 600 600 600 2400 2500 2600 2700
Customer Orders Booked 150 350 500 600 0 200 1000 0 0 2200 2000 0
Projected On-Hand Inventory
MPS Scheduled Receipts
MPS Quantity
MPS Start
Available to Promise
Item: B Clodbuster (Winter2018) Lot Size Rule:
Lead Time:
Safety Stock Level:
Current Inventory:
Jan 2018 Feb 2018 Mar 2018
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
Forecast 300 300 300 300 400 400 400 400 1000 1100 1100 1200
Customer Orders Booked 200 0 450 0 50 900 0 0 500 0 0 0
Projected On-Hand Inventory
MPS Scheduled Receipts
MPS Quantity
MPS Start
Available to Promise

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Great effort.
Customer 459155, May 4th, 2022
Nice job.
Customer 452441, April 6th, 2022
A job well done. Followed the instructions to the letter.
Customer 463679, April 24th, 2023
Excellent. Thank you. I am grateful and I am thankful. I hope you have a wonderful day :)
Customer 454227, May 10th, 2020
great work
Customer 454161, May 28th, 2020
Finance/Acc related
Excellent work.
Customer 460073, April 29th, 2022
Good job
Customer 456821, May 13th, 2022
Excellent job.
Customer 456821, May 11th, 2022
Good work.
Customer 462281, April 14th, 2022
A few mistakes but overall an excellent paper
Customer 453915, September 13th, 2022
Great Content!
Customer 463469, October 20th, 2022
Business and administrative studies
Great effort.
Customer 458115, May 2nd, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat