The model is constructed in Microsoft Excel™ with a number of macros that allow it to function properly. The cost model exists as an Excel workbook made up of four worksheets:
1. Read Me
2. Input Table
3. Assumption Table
4. Cost Summary
The model’s workbook takes the user inputs from the Input Table worksheet and calculates a cost summary displayed on the Cost Summary worksheet. The cost summary is based on user inputs and underlying assumptions from the Assumption Table worksheet. Each of the worksheets, Input Table, Assumption Table, and Cost Summary, contains sections in the user guide that describe their contents. Additionally, the sheets have embedded comments in column headings to help guide the user.
The Input Table is the engine that drives the cost model. It is comprised of numerous input columns into which the user must input data. These user input columns are segmented into the following sections:
1. Descriptive and number/type of joining applications (Joining technique, Segment, Sub-Segment, Component, Number of applications, Substrate, etc.)
2. Part/Surface preparation (Cutting, Folding, Shaping, Cleaning, Coating Removal, etc.)
3. Joining Process (Will vary depending on type of joining process selected)
4. Post Joining Processes (i.e.Autoclave, clamping, etc. specific to adhesives)
5. Other Costs (e/g overhead, square feet required, annual capital expenditure, energy usage, etc.)
To make the model manageable the input columns a user sees depends upon which button is selected. Each button runs a macro that hides rows and columns that are not needed for the type of bonding/joining method chosen. The four buttons available are:
Also, where possible the user input choices are from “drop down” boxes that allow the user to choose from among a list of inputs. For example, one of the user input columns under the Adhesive & Sealant view is Technology. By choosing from the list of formulations, the model fills in a specific gravity column from the assumption table. The specific gravity value in turn is an input for calculating the grams of adhesive used per bond, which in turn is used in calculating the cost of adhesive material used per bond.
Access Companies Who Have Rights to the Cost Model