Cutting Charges By Lift Part Two

Ok, now that you have entered your BHR into the excel sheet with your minimum setup time in minutes you are now ready to enter this data into PrintSmith. There are 2 methods that you can use to setup the charges, the Job Aware method and the Cutting Charge method. The results are identical, so it doesn’t matter which one you choose. Since a picture is worth a thousand words here is a link to a 3 Page PDF that shows how to setup your charges both ways.

Cutting By Lifts Screen Shots

For each charge you simply take the Setup Charge from the Excel sheet and enter it into the Setup field. Then take the rate per lift from the Excel sheet and enter it into the Rate field. Finally, enter the default number of sheets per lift into the “In Sets” field. If you would like this field to be adjustable, simply check the Adjustable Sets box. Make sure that you have selected the “Press” and the “x Signatures” radio buttons near the bottom and you are ready. Just repeat the process for each charge.

If you have any questions, the PDF should be able to give you answer. If not, send me an email.

Cutting Charges By Lift Part One

PrintSmith is setup to calculate cutting by the number of cuts, but did know that you could also set it up to calculate cutting by the number of lifts? Why would you want to do that? For a very simple reason, the PrintSmith manual tells you up front that the number of cuts is only an estimate and that it may not be accurate.

So, with the help of fellow PrintSmith user Mitch Eaton I changed our cutting charges over to cutting by lift back in 2001. I reviewed those prices this past month and I created an excel spreadsheet to help me figure those prices. You can download the excel file by clicking on the link below. In my next post I will explain how to enter the data from the excel sheet into PrintSmith.
Simple Cutting By Lift

Quick Calculator for New Charges

Don’t you hate it when you are presented with an estimate for a charge that isn’t already in PrintSmith and you aren’t sure what to charge? Or, you buy something from a vendor and you have no idea how much you want to charge or how much profit you want to make? I run into these scenarios fairly often so I created a little excel sheet to help me out.

If you read this blog you can have download my excel sheet.

Simplified Price Calculator

There is one rule, only change the numbers in the Yellow boxes and the rest of the fields will be automatically calculated for you. The chart on the left is for use with BHR’s if you know them. I personally use John Stewart’s BHR Guide to get the figures so I don’t need to use the Efficiency column. The nice thing about the chart on the left is that it shows you the difference between Profit Margin and Markup.

The chart on the right is mainly for items that are outsourced. Just plug in the price and it automatically calculates prices and profit for over 15 levels of profit!

Small Quirk in Delivery Ticket Manager Status

I just found a small quirk in the Delivery Ticket Manager that had me scratching my head and the folks at PrintSmith. Turns out is a non issue, but it may be frustrating if you run into it.

Here is the situation: Open an invoice that already has a Delivery Ticket, and then open the Delivery Ticket. Click on the Status tab and then try to Update the Location on an job that you select. It won’t update the location. Why? Because of locked records when the invoice is open.

The Solution?: Close the invoice window and leave the Delivery Ticket window open. Now it will change the location!!

Creating a Job Template

One of the quickest ways to speed up the estimating process is to create Job Templates. If you know how to create a job then you are 95% of the way there!! Simply create a job on estimate (or invoice) like you normally would for One job or One Multi-part job. When everything is perfect and just the way you want it you are ready to create a Job Template. Don’t forget to add a Product and try to make the template usable for any quantity or any paper.

To create a Job Template open the Job window. (If a multi-part job open the first job or what is called the “control job
for the entire thing.)

Now, go to the File menu.
Scroll to Save As.
This automatically opens your Template folder.
Simply give your job template a name, click save and you’re done!
you just created a JOB template, there are 2 kinds: Job and Invoice.

(I personally don’t like Invoice templates for reasons I’ll explain some other day.)
Now, test it out!
Create a new estimate.
Instead of double clicking to create a new job do this:
Go to File > Open Template
Find your template, click Open, and say yes to updating the prices.
There you have it!!

I would also save this in the estimate history for reference later on. I created an account called Templates strictly for this purpose. Why?

2 Reasons:

1. The estimate history is automatically updated when each new version is released. Templates in the Templates folder do not get updated, that is why there a Template Converter utility.

2. You have a backup template that is easily accessible in case your Template gets damaged, or lost.

Excellent Site Council Meeting!

The PrintSmith Site Council meeting went very well in my opinion. We had around 20 users from around the
country (plus about 8 EFI staff) and Chuck Gehman took down extremely detailed notes about our issues and concerns. It was all handled very professionally and I felt that it was a very constructive and positive environment that will result in actually getting things done. I look forward to attending more of these meetings if they have them.

One small side note: I have a whole new respect for the process that the
developers must go through!! I don’t envy their job.

My only wish was that this meeting really should have taken place about 2 years ago.

So the question remains, when will it “work”?
It really depends which features your company needs. They do have a timeline but at this point it is not exactly clear what features will be included and at what dates on the timeline. Of the 20 “major” items on my list about half will make the cut for sure in the next release. Following that, about half of my remaining items will make it in the 2nd release. (Yes, I’m being vague on purpose!)

Think about it, they are partners with Xerox, Adobe, and XmPie. In the long run, they should have the best e-commerce solution out there. Until then, we will have to take a few more “patience” pills.

PrintSmith Site Council Wish List

The PrintSmith Site Council is tomorrow which is a great opportunity for me to post my wish list:

Updated 2006 Site Wish List
(The competition already has many of these features, and I’m not certain which ones have already been addressed)

1.We have several customers who need to see an Automatic Inventory
calculation on their forms from inventory. When they order 50 forms they want to see the inventory reduced by 50 immediately.

2.We have a several customer who need 3rd party approvals on their orders.

3.We want our customers to be able to view their Job Status.

4.Our customers complain about Logins and passwords and us not having the
ability to help them. Need an “As They See it” feature. (This was already mentioned by Bill & Sheila today, but has been on on my list since 2003)

5.Our customers want to make changes to their orders after they were sent.
Very nice for minor mistakes on Composer Business Cards.

6.We need the ability to customize emails sent to our customers.

7.We need to present a 1 Up business card Proof File, but have the
Production PDF file come in to us 4 Up. In other words, there are 2 types of files: 1 for Proofing, and 1 for Production.

8. We need a Drop Down Menu for address locations on Composer Business
Cards. (We have a customer with 14 locations. On Site Composer, we needed 14 Cards.) Does XMPie address this?

9. Browser Based Administration. (I think this one may be fixed in 2.0)

10. Need a “View All” feature that allows the customer to
see All of their forms instead of being forced to go deeper into each Category.

11. Integration of the entire ordering process with the customer’s email
address. Estimating the job, Receiving the order, Viewing the Proof, Notifying the customer of job status, etc.

12. Unit Pricing: I think this one may be fixed but we need to be able to give a price for any qty from 1-50,000.
(Example: The form is already printed, the price is always $.15 each, we just need it to do the math.)

13. We will still need some sort of 3rd party web integration via email and a place to store 3rd party web job numbers that is searchable.

Hope to see everyone in Pittsburgh tomorrow!

How Do I Import my Logo into PrintSmith?

How do I import my logo into PrintSmith?
That question gets asked so often that it amazes me!

In short, you must create a file that can be opened by 3rd party software and then “copied and pasted” into PrintSmith.
The Windows platform requires a JPG or a GIF, and the Mac platform requires a PICT. (Be sure that your logo looks good and is at least 300 dpi, do not import a 72 dpi image.)

On the Windows platform you need to use a 3rd party program like Imaging or Paint to open any JPG or GIF. (Go to Programs > Accessories > Imaging.) Then select the image and Copy it to the clipboard.

On the Mac platform most every program will put both a native & PICT format on the clipboard during a Copy and Paste operation.

On the PrintSmith MASTER, open the Document Preferences under Admin menu, select the Customize Form button, and then select the Images tab. The button next to the Logo ID icon (orange) will open the Image Viewer and that is where you Paste the image from the clipboard. (Do not do this on a workstation unless you plan on copying it to the Master.)

This process creates a file called PS Customizer – User.rsr file on the Master and it will need to be distributed to all the other workstations, the best way to do this is to place the file in the Prices folder on the Master, then perform a Pricing Update on all workstations.

You then may need to size it properly with the parameters using the Form Layout Tab and Logo Base fields.

Starting Record Number for Reporting

If your Report Writer reports take a long time to run, then it is probably time to change the starting record number.

The starting record number is located in the Data Source (Filing Cabinet
Icon). When you click on this the Select Data Source window will appear and
it will tell you what your Data Source is. If you are using “Documents” your
data source is Invoices by default. If you are using a “List Data” note
which database you are using.

Now the trick is to find out what starting record number you need.
The best way is to go to the Downloader and use the Browse function.
Next to “File to Browse” choose the database your are using as your data
source for your report.
In the upper right corner is the number of “Records in File”. This is the
total. At the bottom is the “Go to record” button and a field to enter a number.

Try entering a number that you think might be close and then scan the data.

The number you enter into the Data Source will be the record that the Report
Starts with. It will automatically eliminate all records that precede it.
Thus, the report runs faster because there is less data.

Workstations “Dropping Off”

When we upgraded our Windows 2000 Master computer to Windows Service Pack 3 (WSP3) we started experiencing problems with our workstations “dropping off”. We would try to open an invoice from the pending list and it just would freeze up on us, no warning message or anything. So we had to go into the Task Manager and shut down the application. This would take several minutes and then restart PrintSmith.

As you can imagine, this doesn’t go over too well with our production personnel because it is a big waste of time. In fact, we cannot use Tracker because of it. So, we have upgraded to Windows Service Pack 4 for Windows 2000 and are in the middle of testing it.

We are also testing the Port Speed Adjustment (Admin > Prefs > Network) again to see if that helps. So far setting it Zero makes it worse. We are going to leave it at 30 for now.

I will update this as I learn more.