You will create an Excel workbook to do the following calculations:
- 1) Total Unit Cost
- 2) Break Even Point
- 3) Economic Lot Size
- 4) Punching Force
- For both round and rectangular punches
- Use inches, lbs, PSI
- Force to perforate (From TECH 3421: Punching Force)
- Stress in punch (From TECH 3401)
Minimum Requirements
- Must be in a single workbook
- Each numbered item (above) must be in its own sheet.
- Each sheet should clearly show the user how the calculation is performed.
- User input must be in a green cell with a bold border.
- Calculated values must be clearly evident, in a cell with a bold border.
- Units must be clearly shown by input cells.