Rotational Molding Scheduling Spreadsheet

1
Rotational Molding Scheduling Spreadsheet

• Group Members
• Cory Gardner
• Brad Hollingsworth
• Charles Milligan
• Craig Morgan
• Matt Sikora

2
Introduction

• Goal
• Increase the efficiency of Rotational Molding
  Scheduling
• Stock vs. On order ratio
• Definition
• Spreadsheet
• To coordinate variables

3
Methodology

• Spreadsheet
• Variables
• Utilize existing software Microsoft Excel
• Two Worksheets
• Dolls Parts
• Simplification of complex product line
• Based on Stock vs. On order ratio

4
Example
5
Example (cont.)

• Add a new doll
• Enter data for new doll
• Auto-filter Buttons
• Change Stock vs. On order ratio
• Calculations on Parts sheet
• No Data in Formula Cells

6
Recommendations

• Test using Reva Shick Caucasian Dolls
• One month to check for changes
• Investigate File Protection
• Microsoft Access
• Scheduling Guideline
• Based on desired Stock vs. On order ratio