June 20th, 2013, 04:06 PM
|
#2 (permalink)
|
Senior Member
- Join Date:
- Jun 2011
- Location:
- Auckland, N.Z.
- Posts:
- 369
- Liked:
- 47 times
|
Re: Just made a ton of updates to Printavo
I use XERO accounting software. Our production system is a wall with printed magnets with info and checklist that we whiteboard marker info onto. It works really well mostly. My fall down is metrics. I want to know jobs to analyse timings more, and capture art time to jobs, sales reps (I want to prove reps who manage their account for better art from the customer need to alter or charge more because they accept low res word and jpg against other reps who dig for better files) also capturing art time and cost to job and customers.
My next and biggest requirement: we have 3,000 odd screens, and run numbering system in tatty old manual books. I want to put this into numbered database electronically for the repeats, but to capture screen meshes and what else is up on the screen - we often have 2 to 4 seperations to a screen.
And these need to link to a design, to a customer.
Here is the thing. A lot of jobs run for events, or annually, or six monthly. Or be kept for maybe three months life of a campaign in case of re-orders. We have screens up for years that don't reorder, others we strip and have to make again. These screens have a value of $30k, and we need to factor remeshing, insurance, and rent on the space so I thought it would be good to charge for keeping screens up. Our setup film and screenmaking charge is $30 each, quite low compared to all our competitors and we win a lot of work. My goal is to charge $1.50 per sep/screen per month. That will potentially give us revenue of $4,500 to $10,000 a month, more than enough to cover the whole factory rent and then some. Talking to all our bigger and some small customers we wouldn't loose any customer at all with this, they all accept the cost being nominal to them to keep their jobs up.
I want this system to be billed in advance, so for an event they may order shirts and pay for an extra month in case of reorder, a school uniform would prepay the year, and perhaps an add campaign may prepay five months life of campaign. We then need to generate list of expired strippers and view mesh count and frame size would be handy, but also to link back to sales and generate a reminder a month in advance. As a prompt the reps have a reason to re-engage the client and push for reorder, customer satisfaction and relationship call, ask them for next project, repeat order, new campaign etc.
So in part this is database, part revenue gathering and part crm prompt.
I have been looking at hire and lease company systems and book lending library systems but can't really find ideal application to suit.
Your thoughts?
|
|
|