# Retailer Quotes

Adding retailer quotes into the RFP

Go to the retailer quotes tab to enter all your retailer quotes

Click on Add to add the quotes

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/Ypmimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/Ypmimage.png)

Enter the Retailer that the quote is for.

If this is the current retailer, put a tick on

Select the ICP that this quote is for

Put in a description

EA Levy and Meter charge will populate from Retailer selected

After you have saved, tabs become available

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/i6nimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/i6nimage.png)

---

##### Retailer Quote Import

Prepare the import file from the Retailer Quote

See sample file - [Retailer 5yr Flat.xlsx](https://hugeerp10.co.za/hsofmanual/attachments/38)

Enter both WD and WE OR BD and NBD

under each other

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/CJuimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/CJuimage.png)

Here is a sample of a 3 Year Stagged file

Sample attached - [Retailer 2-3yr.xlsx](https://hugeerp10.co.za/hsofmanual/attachments/39)

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/YkXimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/YkXimage.png)

Here is a sample of a 5 year flat file

Sample Attached - [Mercury 5yr Flat.xlsx](https://hugeerp.co.nz/manual/attachments/19)

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/Uhgimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/Uhgimage.png)

Once the Excel files are prepared, go to Retailer quote import

Fill in the information as to the Type, Rate, Years and Start Period

Then Upload and Import

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/BgVimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/BgVimage.png)

After import is done, it will populate all Tabs with cost data

- Costs
- Energy Cost
- Network Cost
- Total Cost

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/pHGimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/pHGimage.png)