Calculating a quotation for printing and assembling Roll-up Banners.

The user's business has a large format printer to do full colour printing. The user needs to quote a client for the supply of 4 full colour roll-up banners, standard size: 2050mm x 850mm.

We have entered the following parameters in the Hourly Rate Calculator, according to our overhead expenses, employees, profit, handling expenses, VAT and the average ink cost per square metre.

1. Our Hourly Rate is R300.00
2. We are a small business with two employees and the owner is also part of production.
3. We have a profit mark-up of 33%.
4. Our handling expenses are 10%.
5. The average ink cost per square metre for our single large format printer is R45.00.
6. We are not registered for VAT.

Run the SignQuote SA program. Click on Open the Estimate Calculator to open the calculator.(Fig.12.1)

Fig.12.1

The Estimate Calculator opens. Enter the following information in the form: (Fig.12.2)

Length: 2050

Width: 850

Quantity: 4

Artwork: R150.00 (a once off cost which is used "as is". No profit or handling charges are added)

Fig.12.2

In the Labour Cost group, we open the Printing form and enter the time it will take to print the 4 full colour banners. (Fig.12.3 and Fig.12.4) Except for the printing, we also need to work out a price for assembling the roll-up banners. (Fig.12.4a)

Fig.12.3

Fig.12.4

Fig.12.4a

We are going to use the average default ink cost per square metre and we therefore do not have to change the ink cost per square metre.

In the Database group open the Materials database. (Fig.12.5)

Fig.12.5

We choose to print on an Anti-curl PVC banner material as this is best suited for roll-up banners. We then click on Material 1 and the name, description and price will be entered into the row. (Fig.12.6)

Fig.12.6

We also need the price of the roll-up banner mechanisms. Open the Consumables database (Fig.12.7)

Fig.12.7

In the database we look for Display Stands & Roll-ups and click on the row with the cheapest product, as the client didn't specify a specific type. We then click on Consumable 1 and the name, description, unit and price will be entered into the row. (Fig.12.8)

Fig.12.8

But instead of doing the total calculation, we still have to supply the quantity of roll-ups we are going to use. A form pops up to ask the quantity. (Fig.12.9) Because the price works on percentages we must enter the percentage and not the quantity we are going to use. Roll-ups are sold in units, so in this case we'll enter 400 as a percentage.

We now have all the factors in place to calculate the estimated price of the 4 roll-ups. Click on Calculate Costs on the calculator form. The Estimated Totals form opens on the All Totals Summary page. (Fig.12.10)

Fig.12.10

By selecting the Materials, Substrates and Consumables tab at the top of the page, we can see the name and description of the material, substrate and the consumables and what the prices are, as well as the cost price of these items. (Fig.12.11)

Fig.12.11

By selecting the Labour Totals tab, we can see what these prices are. The form shows us the Printing and the Application amounts. (Fig.12.12)

Fig.12.12

If we now click back to the All Totals Summary tab and click on the Print a Quotation button, (Fig.12.13) the quotation form opens and shows us the information which will be printed. (Fig.12.14)

Fig.12.13

On the left side there is nothing in the text boxes and this needs to be filled in before a quotation can be printed or saved to PDF.

Fig.12.14

We now fill in the client's details for his quotation. (Fig.12.15)

Fig.12.15

By clicking on the Print Preview icon in the toolbar or by using the menu, a preview of our print form opens. (Fig.12.16)

Fig.12.16

We exit the print preview and on the Print a Quotation form we click on the printer icon in the toolbar or click on it in the menu. The print dialogue opens and we can then choose to print the form or save it as a PDF file which we can email to our client. (Fig.12.17) To save as a PDF file, the user needs a Print to PDF program, which can be downloaded as free-ware from several suppliers.

Fig.12.17

This ends the tutorial on calculating an estimate price for the manufacturing of the four roll-up banners. To do the next tutorial, where we calculate a quotation for the printing and installation of a sign board, please click here.

Order your copy of SignQuote SA now for only R849!