CLICK HERE FOR INDEX PAGE

SPREADSHEETS

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.

NAME AND ADDRESS OF SUPPLIER

K&M (WHOLESALE SUPPLIERS) LTD, UNIT 24

LION PARK, HOLBROOK INDUSTRIAL ESTATE, NEW STREET,
HALFWAY, SHEFFIELD, S20 3G - FAX - 0114 2475335
PART OR QNTY DESCRIPTION UNIT DISCOUNT TOTAL
CAT. NO. COST
VACUUM FORMING SHEETS
1 POLYSTYRENE, RED, 508 X 458 X 1mm 0.99 0.99
1 CLEAR PVC, 508 X 458 X .7mm 1.14 1.14
ABRASIVES - GLASS PAPER SHEETS 280X230mm
1 GRIT - F2, PER 100 6.60 6.60
DRILLS - STRAIGHT SHANK JOBBERS
1 1 mm 0.63 0.63
1 PAINT BRUSHES 1/2 INCH, BLACK HANDLED 0.42 0.42
SE2280 2 DOUBLE SIDED TAPE, 12mmX33M 2.20 4.40
TOTAL 14.18
TOTAL+VAT 16.66

 

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).

 

   

CLICK HERE FOR DESIGN PROCESS INDEX PAGE

   
 
Google
 
Web www.technologystudent.com