I got the following data in a txt file,

```
Apple:Fruit:20:30
Leek:Vegetable:40:50

```

In a form where, (item description):(item category):(qty):(price). How to draw a table using shell script. Having an output

```
Item Description           Category          Qty       Price        Total Sales
--------------------------------------------------------------------------------
Apple                      Fruit             20         $30.00         $600.00
Leek                       Vegetable         40         $50.00         $2000.00

```

where Total sales is equal to qty x price. Please help. Thanks in advance!