[Solved] Business Finance – Operations Management Week One Assignment

Assignment Prompt & Instructions

[>Operations Management homework help](https://www.sweetstudy.com/fields/business-finance-operations-management)

**files (3)**

– ## WeekOneAssignment1InstructionsHM.docx

– Week1-MRPAssignment.xlsx
– Week1-CapacityPlanningSheet.xlsx

**## WeekOneAssignment1InstructionsHM.docx**

Week One Assignment

Top of Form

| | |
| — | — |
| |
| Turnitin™ | |
| This assignment will be submitted to Turnitin™. |
| Instructions | |
| **The main tool this week is Material Requirements Planning (MRP).**

PIMS, Inc., has been manufacturing plumbing equipment since 1999. Because of the depressed economic conditions, component parts are assembled in batch runs. At any given time, each level of production has several partially assembled components. Given the following assembly and inventory information, construct a product structure diagram for the oil leak valve, and plan the order releases necessary to assemble 400 oil leak valves for period 10.

**Description of the Production Process**

Production of the valve begins with the base. The base is placed and secured in a housing. Ball bearings are then installed on opposing sides of the base housing. The rear base cover is fitted on and held while the front cover is secured with U-bolts. Next, the anchor assembly is connected. Finally, two sets of brackets are screwed on and the oil leak valve is checked before shipping.

**Assume** the use of the multiple of fixed lot sizes technique.

1. First, draw a diagram of the B.O.M. for this product.

2. Then, using Excel, complete the MRP record for the Oil Leak valve and all subcomponents. Use this template:
[**Week 1 – MRP Assignment.xlsx**](https://navigate.nu.edu/content/enforced/7793-SCM630-020416/Week%20One/Week%201%20-%20MRP%20Assignment.xlsx)

3. Next, using the attached spreadsheet, consider the options for the next six months for short-range capacity planning for Oil Leak valve assemblies as discussed on pg. 218. Determine which approach allows for the lowest total cost given:
[**Week 1 – Capacity Planning Sheet.xlsx**](https://navigate.nu.edu/content/enforced/7793-SCM630-020416/Week%20One/Week%201%20-%20Capacity%20Planning%20Sheet.xlsx)

·

·

| | |
| — | — |
| **Data** | |
| Beginning Inventory | 0 |
| Beginning Workers | 20 |
| St. Time Hrs. per worker per month | 160 |
| Max. OT Hours per worker per month | 40 |
| Hiring Cost per worker | $4,000 |
| Layoff Cost per worker | $5,000 |
| St. Time Pay per worker per hour | $18 |
| OT Pay per worker per hour | $25 |
| Labor Hours per unit produced | 10 |
| Raw Materials Cost per unit | $10 |
| Holding cost per unit per month | $2 |
| Shortage Cost per unit per month | $5 |
| Subcontracting Cost per unit | $120 |

4. Finally, explain what you did in this assignment with regards to MRP and Capacity Planning as if you were describing the concepts to someone unfamiliar with Operations and Supply Chain Planning. |

Bottom of Form

**Rubric Name: Week One assignment rubric**


## image1.png

**Week1-MRPAssignment.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/week1-mrpassignment-xlsx)

**Week1-CapacityPlanningSheet.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/week1-capacityplanningsheet-xlsx)

**Week1-CapacityPlanningSheet.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/week1-capacityplanningsheet-xlsx)

**## WeekOneAssignment1InstructionsHM.docx**

Week One Assignment

Top of Form

| | |
| — | — |
| |
| Turnitin™ | |
| This assignment will be submitted to Turnitin™. |
| Instructions | |
| **The main tool this week is Material Requirements Planning (MRP).**

PIMS, Inc., has been manufacturing plumbing equipment since 1999. Because of the depressed economic conditions, component parts are assembled in batch runs. At any given time, each level of production has several partially assembled components. Given the following assembly and inventory information, construct a product structure diagram for the oil leak valve, and plan the order releases necessary to assemble 400 oil leak valves for period 10.

**Description of the Production Process**

Production of the valve begins with the base. The base is placed and secured in a housing. Ball bearings are then installed on opposing sides of the base housing. The rear base cover is fitted on and held while the front cover is secured with U-bolts. Next, the anchor assembly is connected. Finally, two sets of brackets are screwed on and the oil leak valve is checked before shipping.

**Assume** the use of the multiple of fixed lot sizes technique.

1. First, draw a diagram of the B.O.M. for this product.

2. Then, using Excel, complete the MRP record for the Oil Leak valve and all subcomponents. Use this template:
[**Week 1 – MRP Assignment.xlsx**](https://navigate.nu.edu/content/enforced/7793-SCM630-020416/Week%20One/Week%201%20-%20MRP%20Assignment.xlsx)

3. Next, using the attached spreadsheet, consider the options for the next six months for short-range capacity planning for Oil Leak valve assemblies as discussed on pg. 218. Determine which approach allows for the lowest total cost given:
[**Week 1 – Capacity Planning Sheet.xlsx**](https://navigate.nu.edu/content/enforced/7793-SCM630-020416/Week%20One/Week%201%20-%20Capacity%20Planning%20Sheet.xlsx)

·

·

| | |
| — | — |
| **Data** | |
| Beginning Inventory | 0 |
| Beginning Workers | 20 |
| St. Time Hrs. per worker per month | 160 |
| Max. OT Hours per worker per month | 40 |
| Hiring Cost per worker | $4,000 |
| Layoff Cost per worker | $5,000 |
| St. Time Pay per worker per hour | $18 |
| OT Pay per worker per hour | $25 |
| Labor Hours per unit produced | 10 |
| Raw Materials Cost per unit | $10 |
| Holding cost per unit per month | $2 |
| Shortage Cost per unit per month | $5 |
| Subcontracting Cost per unit | $120 |

4. Finally, explain what you did in this assignment with regards to MRP and Capacity Planning as if you were describing the concepts to someone unfamiliar with Operations and Supply Chain Planning. |

Bottom of Form

**Rubric Name: Week One assignment rubric**


## image1.png

**Week1-MRPAssignment.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/week1-mrpassignment-xlsx)

**Week1-CapacityPlanningSheet.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/week1-capacityplanningsheet-xlsx)

**## WeekOneAssignment1InstructionsHM.docx**

Week One Assignment

Top of Form

| | |
| — | — |
| |
| Turnitin™ | |
| This assignment will be submitted to Turnitin™. |
| Instructions | |
| **The main tool this week is Material Requirements Planning (MRP).**

PIMS, Inc., has been manufacturing plumbing equipment since 1999. Because of the depressed economic conditions, component parts are assembled in batch runs. At any given time, each level of production has several partially assembled components. Given the following assembly and inventory information, construct a product structure diagram for the oil leak valve, and plan the order releases necessary to assemble 400 oil leak valves for period 10.

**Description of the Production Process**

Production of the valve begins with the base. The base is placed and secured in a housing. Ball bearings are then installed on opposing sides of the base housing. The rear base cover is fitted on and held while the front cover is secured with U-bolts. Next, the anchor assembly is connected. Finally, two sets of brackets are screwed on and the oil leak valve is checked before shipping.

**Assume** the use of the multiple of fixed lot sizes technique.

1. First, draw a diagram of the B.O.M. for this product.

2. Then, using Excel, complete the MRP record for the Oil Leak valve and all subcomponents. Use this template:
[**Week 1 – MRP Assignment.xlsx**](https://navigate.nu.edu/content/enforced/7793-SCM630-020416/Week%20One/Week%201%20-%20MRP%20Assignment.xlsx)

3. Next, using the attached spreadsheet, consider the options for the next six months for short-range capacity planning for Oil Leak valve assemblies as discussed on pg. 218. Determine which approach allows for the lowest total cost given:
[**Week 1 – Capacity Planning Sheet.xlsx**](https://navigate.nu.edu/content/enforced/7793-SCM630-020416/Week%20One/Week%201%20-%20Capacity%20Planning%20Sheet.xlsx)

·

·

| | |
| — | — |
| **Data** | |
| Beginning Inventory | 0 |
| Beginning Workers | 20 |
| St. Time Hrs. per worker per month | 160 |
| Max. OT Hours per worker per month | 40 |
| Hiring Cost per worker | $4,000 |
| Layoff Cost per worker | $5,000 |
| St. Time Pay per worker per hour | $18 |
| OT Pay per worker per hour | $25 |
| Labor Hours per unit produced | 10 |
| Raw Materials Cost per unit | $10 |
| Holding cost per unit per month | $2 |
| Shortage Cost per unit per month | $5 |
| Subcontracting Cost per unit | $120 |

4. Finally, explain what you did in this assignment with regards to MRP and Capacity Planning as if you were describing the concepts to someone unfamiliar with Operations and Supply Chain Planning. |

Bottom of Form

**Rubric Name: Week One assignment rubric**


## image1.png

**Week1-MRPAssignment.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/week1-mrpassignment-xlsx)

**Week1-CapacityPlanningSheet.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/week1-capacityplanningsheet-xlsx)