Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!

1. The problem statement, all variables and given/known data:
Write an awk script that implements a report writer.
Here is what I need to do:
The report computes summary data on the [COLOR=blue ! important][COLOR=blue ! important]performance[/COLOR][/COLOR] of sales associates for our company "Lazy Acres, Inc.".
The awk script file name must be "report".
The awk script is invoked from the command line with an inputfile that contains data on products, associates and [COLOR=blue ! important][COLOR=blue ! important]sales[/COLOR][/COLOR]:
awk -f report inputfile
The lines in the input file use ":" as field separator and are of any of these 3 kinds:
lines that describe products have the following fields:
* product id: an integer number
* description: alphanumeric text
* price: floating point number, with 2 significant digits
lines that describe associates have the following fields:
* associate id: an integer number
* first name: alphanumeric text
* last name: alphanumeric text
* salary: an integer number
* position: alphanumeric text
lines that describe sales have the following fields:
* product id: an integer number
* quantity: an integer number
* date: in the form of mm/dd/yyyy
* associate id: an integer number
( click here for a sample inputfile )
The script should compute the sale amounts per associate for the year 2009 and print them in a sorted list ranked according to the sales amount.
Here is an example of the script invocation using the data provided in the example file:
$ awk -f report inputfile
Lazy Acres, Inc.
2009 Sales Associates Ranking
Name Position Sales Amount
==========================================
Buck, Fast Stock Boy 2630.78
Rush, George Salesman 1049.79
Worker, Susan Manager 360.00
Doe, John Clerk 134.01
Lindon, Rosemary Producer 31.00
Miller, Dennis Commedian 9.90
$

2. Relevant commands, code, scripts, algorithms:



3. The attempts at a solution (include all code and scripts):
This is what I have so far, I don't know what to do next:

Code:

Code:

  BEGIN{print "Lazy Acres, Inc"
      print "2009 Sales associates Ranking"
      print "Name        Position        Sales amount"
      print "========================================"
      FS=":"
      }

NF==3 {cost[$1]=$3}


NF==4 && $3 ~ /2009/ {tot = $2 * cost[$1]
                      emplId[$4] +=tot}

NF==5 {  emplId2[$1]
         first[$2]
         last[$3]
         position[$5]

      }

I think i need to get emplId to represent the person and position but I don't know how to do that, any help leading me in the right direction would be great, I've attatched the inpute file to view



4. Complete Name of School (University), City (State), Country, Name of Professor, and Course Number (Link to Course):
niu, dekalb, Il, ege, 330