HW#5 Materials Requirements Planning

Please read the following concerning all homework:

1. When submitting by email, remember to use naming convention detailed in the syllabus. For online assignments, Word, Excel, or both types of documents can be submitted.

2. Please include a cover sheet with your name and date, that includes online submissions (I use this for making comments and grading).

3. Include a short synopsis of the problem, all assumptions, and definitions used at the beginning of each exercise.

4. Answer the problems as completely as possible. Neatness, accuracy, and overall clarity of work are important. Full credit will only be given for problems, which include the aforementioned items. I am looking for process and methodology not necessarily one correct answer.

5. Submit homework by the due date and time.

Remember: You are telling a "story" in the attempt to win a contract from a client, do your best to tell the story, win the contract, and get paid (or in this case get an excellent grade!)
 

Please submit the following problems:

The same instructions apply for all homework problems. It is vitally important that you do a good job defining the problem, stating assumptions, explaining your analysis, feel free to use graphs, tables, and/or any other means to get your point across. Simply writing an answer down is woefully inadequate (i.e., you will receive no points).

Please submit the following problems:

TAKE NOTE: THERE ARE TWO PARTS TO THIS HOMEWORK - THE PAIRED ASSIGNMENT AND THE INDIVIDUAL ASSIGNMENT, BOTH MUST BE COMPLETED AND SUBMITTED

Paired Assignment (y'all have done this once already so its easy)

I will be assigning two unique problems to the class. I will pair off students in the class (note, maybe one group has three and if your partner does not respond just send me your work and you will receive credit). One person will do one of the problems and the other person will do the other problem. Each pair of students will then be required to converse via email and correct each others work commenting on areas where improvement could be made. I expect at least four emails for each pair of students (2 per each student=4). Each email that is exchanged must be cc'd to Dr. Kros.

This exercise is to enhance interaction between you and your colleagues as well as foster interaction between the professor and all students. This exercise will be weighted 10% of the Homework #5 grade and those who complete the problems and discussion session will receive full credit for this portion of Homework #5.

THE PAIRINGS FOR HOMEWORK #5 ARE AS FOLLOWS:

Problem A



Problem B


last name first name email
last name first name email
Archer Dion archerd13@students.ecu.edu paired withh Archer Jennifer archerj14@students.ecu.edu
Bernleithner Richard bernleithnerr11@students.ecu.eduedu paired withh Baumeister Sarah baumeisters14@students.ecu.edu
Buckley Jennifer buckleyj13@students.ecu.edu paired withh Burnette Brandon burnetteb13@students.ecu.edu
Chadzutko Melissa chadzutkom11@students.ecu.edudu paired withh Gibbs Cameron gibbsc13@students.ecu.edu
Chaves Lavina chavesl12@students.ecu.edu paired withh Godwin Christina godwinc13@students.ecu.edu
Baldwin Pamela baldwinpa13@students.ecu.edu paired withh Janiga Justin janigaj12@students.ecu.edu
Farmer Sean farmers12@students.ecu.edu paired withh Kugler Matthew kuglerm13@students.ecu.edu
Forehand Ginger forehandg89@students.ecu.edu paired withh Lawrence Lopez Karen lawrencelopezk15@students.ecu.eduedu
Glasgow Tanya glasgowt12@students.ecu.edu paired withh Lawrenz Steven lawrenzs14@students.ecu.edu
Glover Kareem gloverk14@students.ecu.edu paired withh Lesinski Lisa lesinskili07@students.ecu.edu
Goetz Jason goetzj13@students.ecu.edu paired withh Lilly Michael lillym13@students.ecu.edu
Goldman Jason goldmanj12@students.ecu.edu paired withh Maine Derek mained15@students.ecu.edu
Harris Monica harrismo13@students.ecu.edu paired withh Makris Carrie makrisc12@students.ecu.edu
Heikal Yaheya heikaly11@students.ecu.edu paired withh Marcelino Amy marcelinoa13@students.ecu.edu
Johnson Christopher johnsonchri14@students.ecu.edudu paired withh Marini Bryon marinib13@students.ecu.edu
Joseph Danielle josephd15@students.ecu.edu paired withh Newkumet April newkumeta13@students.ecu.edu
Langston Patricia langstonp14@students.ecu.edu paired withh Parent Kayla parentk08@students.ecu.edu
Marks Stephen markss06@students.ecu.edu paired withh Robbins David robbinsd14@students.ecu.edu
Merendino Dario merendinod11@students.ecu.edudu paired withh Salopek Ashley salopeka12@students.ecu.edu
Munyak Marshall munyakm11@students.ecu.edu paired withh Schatz Christina schatzc14@students.ecu.edu
Perry Kevin perrykev14@students.ecu.edu paired withh Smith Geraldine smithg14@students.ecu.edu
Putnam Benjamin putnamb94@students.ecu.edu paired withh Stepps Matthew steppsm14@students.ecu.edu
Reutlinger Brian reutlingerb14@students.ecu.eduu paired withh Sutton Crystal suttoncr12@students.ecu.edu
Richardson Taylohr richardsonta14@students.ecu.edudu paired withh Vennard Justin vennardj09@students.ecu.edu
Singleton Brittany singletonb14@students.ecu.edu paired withh Wallace Christopher wallacec11@students.ecu.edu
Spicer Antonio spicera14@students.ecu.edu paired withh Wallot Katerina wallotk13@students.ecu.edu
Swisher Heather swisherh12@students.ecu.edu paired withh Williams Renesha williamsren13@students.ecu.edu
Ward Anita wardan12@students.ecu.edu paired withh Williamson Esau williamsone13@students.ecu.edu


Go to the following link:  OSCM Movies and select the movie clip assigned to you (e.g., if you are in the first column you are Problem A so click on any clip labeled HW#5 Problem A and vice versa for Problem B) under the Inventory Management section or the Materials Requirements Planning section.  There are multiple clips for the section.  However, you only have to chose one (1) clip and complete that one (1) clip. 

Then email the classmate you are paired with to exchange a greeting. Second step, watch the video clip and complete the Questions for Thought listed by the movie clip (i.e., either Problem A or B) and email your completed work to the classmate you are paired with. Finally, send an email back commenting on the classmate's work (these comments can be very simple and straightforward, such as "looks good" or "nice comments").

You must CC me on your emails to receive full credit for this part of the assignment. I will be monitoring email so I will be aware if you cannot get through to your assigned classmate or if the assigned classmate chooses not to respond or participate. Anyone not participating or responding will receive a zero for this portion of the assignment. Those making a "good faith" effort but get no response will receive credit.

Please email me if you do not understand or need assistance.

Individual Assignment:  Materials Requirements Planning




Item On Hand Scheduled Receipts
Lot Size
MPS
Circuit Board
11
0
1
270, period 8
Resistor B
51 0 1 ---
I/O Sub C
14
0
15
---
T-former D
20 0 25 ---
Screw E
125 0 15 ---
Bolt F
100 0 100 ---


Judy needs to know how much of each component to order and when to order them.  Help her set up an MRP schedule.  Also, Judy knows the following costs associated with each component.  Calculate what the total costs (purchase cost plus inventory cost) are for each MRP component schedule.  Click here for an Excel template to develop your MRP.  NOTE:  Peruse the XL template to ensure that all leadtimes and lot sizes are inputted correctly per the HW assignment.

Item Purchase Cost (per unit)
Inventory Holding Cost (per unit/per period)
Circuit Board A
$2,000$10.00
Resistor B
$150 $20.00
I/O Sub C
$200
$1.00
T-former D
$345 $5.00
Screw F
$20 $1.00
Bolt E
$2 $0.50