|CLICK HERE FOR INDEX PAGE
|V. Ryan © 2002 - 2010
A spreadsheet is a piece of software that deals with numbers and calculations. A good example is Microsoft Excel which is probably one of the most common and professional spreadsheets available. Spreadsheets can help with the costing of a project. Below is an example of an order that is to be sent to a local company for components that are needed for a project. Read the sheet carefully.
The first piece of information is the address of the company that the order is to be sent to. There are several columns starting with:
Part Number: This allows the company to identify precisely identify the component you are ordering.
Quantity (Qnty): The number of parts/components ordered.
Description: A description of the part/component ordered. This allows the company to double check that they are sending the right part/component.
Unit Cost: If a number of the same part/component are ordered there is still a need to state the cost of an individual part/component.
Discount: The company may offer a discount (reduction in cost) if large numbers of each component/part are ordered.
Total: This is the total cost of each type of part/component.
An overall TOTAL including VAT (Value Added Tax) is the final part of the order.
Cost a project of your choice using a spreadsheet. Dividing it into rows and columns (as seen in the example above).