Spreadsheet: 752291d1634691217-autopopulate-a-cell-on-one-sheet-based-on-a-calculation-on-another-sheet-frp-in-progress
Sheet: Set-Up

 | Flat Rate Pricing Set-Up
 | Labor Items
 | How Much Do You Charge for Travelling To A Location To Diagose A Problem For A Customer? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95
 | (This is often referred to as a Service Call Fee, Diagnostic Fee, or [NAME])
 | What is the desired percentage of profit you are aiming for on your service and installation labor rates? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4
 | (This will automatically populate on the Labor Calulator, and is a vital component of your pricing program)
 | Do you charge a percentage of each service call to cover in-house warranty programs? (Warranty Reserve) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03
 | (This is commonly used to provided extended parts warranties, or cover for return trips, callbakcs, etc..)
 | Materials Markup
 | Please Enter A Number that will be used as a materials multiplier for each of the ranges below
 | If The Materials Cost is More than: |  |  |  |  |  |  |  |  |  |  |  |  |  | And Less Than: |  |  |  |  |  |  |  |  |  |  |  | The Multiplier Should Be:
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  | 5
 | 10.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  | 5
 | 25.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  | 4
 | 50.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  | 4
 | 100.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  |  |  |  |  |  |  |  |  |  |  | 3
 | 200.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 350 |  |  |  |  |  |  |  |  |  |  |  | 2
 | 350.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  | 2
 | 500.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 750 |  |  |  |  |  |  |  |  |  |  |  | 1.5
 | 750.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 |  |  |  |  |  |  |  |  |  |  |  | 1.5
 | 1000.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500 |  |  |  |  |  |  |  |  |  |  |  | 1.5
 | 1500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000 |  |  |  |  |  |  |  |  |  |  |  | 1.25
 | 3000.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4500 |  |  |  |  |  |  |  |  |  |  |  | 1.25
 | 4500.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6000 |  |  |  |  |  |  |  |  |  |  |  | 1.15
 | 6000.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7500 |  |  |  |  |  |  |  |  |  |  |  | 1.15
 | 7500.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  | 1.15
 | Contract Customer Benefits
 | What is the discount  that you offer customers who are part of your contract program? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.85
 | To Obtain A Discount Of…… |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter This number
 | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9
 | 0.15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.85
 | 0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8
 | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75
 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7
 | 0.35 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.65
 | 0.4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6