I'll start off with the standard disclaimer... I am a FM n00b.
I am building a job ticketing/invocing solution for my print shop. There are many variables that go into pricing a print job. My issue is how do I get FM to calculate the price based upon job quanity and with price breaks at certain quantities?
Job "A" cost $100 if printing 1000 pieces.
Job "B" cost $68 if printing 500 pieces.
Job "C" cost $49 if printing 250 pieces.
The quantities for price breaks are at 250, 500, and 1000. There is also typically a break for each additional 1000. The price break is different for different types of print jobs.
This is not very hard if people always ordered in quantities of 250, 500, 1000. The hard part is figuring out how to calculate 750 pieces.
The logic I'm looking at using is
Qty > 1000; Price of 1000 + (((Qty-1000)/1000)*Price of additional 1000);
Qty = 1000; Price of 1000;
Qty >= 500 and Qty < 1000; Price of 500 + (((Qty-500)/1000)*Price of1000);
Qty >=250 and Qty < 500; Price of 250 + (((Qty-250)/1000)*Price of 500);
Qty < 250 = Qty * (Price of 250/250);
I want to setup a product table that can be used in the job ticket to select the print job(via drop down list). However I do not want to clutter the product listing with multiple listing of the same job (different prices).
I also want to use the product listing for invoices.
So my questions are:
- Does my logic look right?
- Is it better to setup a seperate table for prices that is related to the product table or is it easy to filter the products that are shown in the job ticket.
Last bit of info is that we don't want everyone to be able to access the pricing, so I want to keep it out of the job ticket and only in the invoices.