Price Quote
Budget: $50 – $0 USD
This should be a very simple project. I've partly created it. I need my tech to put in part cost, how many hours and the sheet automatically calculate a Flat Rate Price. The only tricky part for us was it needs to read a price scale so excel knows what percent to mark it up. The tech will not input mark up. SHEET 1 or view 1, The tech view should only have the part cost field, how many hours it will take him, it then calculate the flat rate. Sheet 2 or customer view should only show the Quoted Price. I have attached my excel attempt and the scale of the mark up. The price scale I sent you will need to be changed. You can call me at 559 217-3556