Tool Design Spreadsheet

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

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.