Billing Recommendations

Overview

Your Supermove account can be customized to automatically calculate and recommend the manpower and duration of moves based on variables, such as the inventory size or number of rooms. This article presents the steps involved in personalizing those settings.

Understanding the System Default Settings

By default, we've loaded your account with a few friendly default suggestions and settings for manpower and job duration recommendations. These can be found by going to your Supermove office app and navigating to Settings >> Billing Libraries >> Formulas.

A few of the most important ones to be aware of are as follows:

Recommended # of Movers

if(var("PROJECT_WEIGHT") < 1500, 2, if(var("PROJECT_WEIGHT") < 5000, 3, 3 + ceil((var("PROJECT_WEIGHT") - 5000) / 3000)))

This formula dictates how much manpower should be used on the move based on the customer's shipment weight. By default, our system setting can be understood as follows: if the shipment weight is less than 1500 lbs, then the job should involve 2 movers; if the shipment is less than 5000 lbs, then the job should involve 3 movers; if the shipment is is greater than 5000 lbs, then the job should involve 4 movers; and for every additional 3000 lbs after that, then the job should include an additional mover. 

While these are the defaults, you can edit and customize these weight thresholds to your own preferences. If helpful, you can even update this formula to use a different variable instead of weight, just as the number of rooms, cubic footage, etc.

For more information on billing variables, feel free to reference this article: https://supermovehelp.zendesk.com/hc/en-us/articles/10865484661908-Billing-Engine-In-Depth

Recommended # of Trucks

ceil(var("PROJECT_WEIGHT") / 10000)

This formula determines how many trucks should be involved on a move based on the shipment size. By default, the formula can be understood as follows: take the shipment weight and divide by 10000, then round up to the nearest whole number. For example, if the shipment is 2500 lbs, then 2500/10000 = 0.25; we then round up to the nearest whole number and get 1 truck.

Recommended # of Hours

if(var("JOB_CREW_LBS_PER_HOUR") > 0, ceil(var("PROJECT_WEIGHT") / (var("JOB_NUMBER_OF_MOVERS") * var("JOB_CREW_LBS_PER_HOUR"))), 0)

This formula offers a recommendation for the length of time we expect the crew may take to handle the shipment. By default, the formula can be understood as follows: take the shipment weight and divide it by the number of movers multiplied by the number of lbs a mover can handle per hour. For example, if the shipment weight is 2500 lbs, the crew size is 2 movers, and each mover can handle 250 lbs/hour, then the recommended length of time would be 2500 / (2 * 250) = 5 hours

Please note, the variable JOB_CREW_LBS_PER_HOUR is a job-level variable and can be customized per job. 

Hourly Rate Formula

ifs(var("JOB_NUMBER_OF_MOVERS") == 1, 6000, var("JOB_NUMBER_OF_MOVERS") == 2, 12000, var("JOB_NUMBER_OF_MOVERS") == 3, 18000, var("JOB_NUMBER_OF_MOVERS") == 4, 24000, var("JOB_NUMBER_OF_MOVERS") == 5, 30000, var("JOB_NUMBER_OF_MOVERS") == 6, 36000, var("JOB_NUMBER_OF_MOVERS") == 7, 42000, var("JOB_NUMBER_OF_MOVERS") == 8, 48000, var("JOB_NUMBER_OF_MOVERS") == 9, 54000, var("JOB_NUMBER_OF_MOVERS") * 6000)

This formula indicates the hourly rate price for each crew size. These defaults can be understood as follows:

• For 1 mover, the hourly rate is $60
• For 2 movers, the hourly rate is $120
• For 3 movers, the hourly rate is $180
• For 4 movers, the hourly rate is $240
• For 5 movers, the hourly rate is $300
• For 6 movers, the hourly rate is $360
• For 7 movers, the hourly rate is $420
• For 8 movers, the hourly rate is $480
• For 9 movers, the hourly rate is $540
• For each additional mover thereafter, increase by an additional $60

Applying Recommendations to Billing Items

In order for your recommendations to appear and work correctly on your fees, we need to make sure those recommendations are actually linked to those fees. If you use our default formulas, we suggest that your Hourly Rate Fee use the following layout:

Let's explain why we suggest this layout:

• The formula Recommended # of Movers is nested within the formula Hourly Movers Name. If you used the formula Recommended # of Movers, then the proposal to the customer would only show 2 instead of 2 movers. 
• The Hourly Movers Min Quantity and Hourly Movers Max Quantity will allow you to manually override the expected length of time for a move, if necessary, and also indicate a range of hours
• The Hourly Movers Price will apply the hourly rate formula that you've customized above

If questions emerge regarding your own billing formula and recommendation set-up, please contact us at [e-mail].