Collaborate on Hourly Billing Template for Logistics with Ease Using airSlate SignNow

Hourly billing template for Logistics

all right hi everyone thanks so much for joining I wanted to introduce our 3pl webinar series here today my name is Janice and I'm the product marketing manager here at Antico and the series will be hosted by Steve Stallings who is the Dynamics 365 supply chain specialist at of Antico so for today's session this is the first session out of four and for today's session we'll be starting with the pain points and gaps in Erp software in a 3pl industry and then we'll jump into the solution by advano and how it features solve for these pain points the first feature that we'll go over is contracts and how to easily Define and manage contract terms for all of your customers within Microsoft Dynamics 365 then we'll go over billable activities and how to accurately invoice your customers for value added Services as well as other billing activities and charges that may have not been buil previously then we'll go over sales orders and invoices and how to automate these to reduce manual tasks as well as go over the customer portal to enhance customer service client Communications and insights then the last Fe feature that we'll walk over is analytics and Reporting and how to track your spending identify discrepancies and resolve issues quickly with predefined reports and real-time data in powerbi and really quickly for everyone on the call here here I did want to let you know that we're hosting two halfday inperson events both focused on Microsoft Dynamics 365 Supply Chain management they'll be hosted in Southern California on June 12th and June 13th from 9:00 a.m. to 1:00 p.m. Pacific time we are also hosting additional webinars for this series the first session is today and the next session will be May 30th which will be focused on warehouse management and Freight reconciliation then on the third session on June 20th we'll go over complex pricing for value added services and then in the last session we'll do a deep dive into the 3pl customer portal we also do have a webinar series that's focused on our multi company Finance automation software and the first will be on May 23rd and it'll be focused on streamlining journals as well as third party Integrations and the session after that will be on July 11th and focus on eliminating manual work by automating reporting and now I will pass it on to Steve good morning uh or afternoon depending on where you're dialing in from um we're going to spend a little bit of time today to finding why we built this solution for the 3pl industry and then we'll jump into what the solution is and today's session is intentionally an overview we'll dig a lot deeper into it in subsequent sessions but to to take a look at where the industry is today um most 3pl uh customers spend an inordinate amount of time on spreadsheets and manual effort to define the value added services that they that they provide to their clients and convert those into invoices so they can be uhu uh they can bill for and collect for those Services we're our Focus because of our first few clients in this industry was to streamline that billing and invoicing process and automate as much of it as possible to eliminate that manual labor and those delays um the other thing that we realized is that not all of our clients were going to be on the Dynamics warehouse management system so there was a across the board lack of integration with the systems that clients were using to uh pull in those value added services and Define them as billable activities to put on those invoices so we provided a seamless integration method across warehouse management systems and other business solutions to capture all those billable activities and um automate that billing process and then finally um we wanted to maintain a high level of customer support and and service for those 3pl customers so to do that we provided a portal that allows them to communicate effectively with those their clients and provide that U invoicing billing information to them in a way that enhances payment um or accelerates payments reducing sales outstanding and cash flow requirements as well as um disputed invoices so those were the key industry challenges that we addressed of course there's a whole lot more to the the 3pl industry as we get into the solution you'll see many other features that we've addressed as well but this was the impetus for our solution go ahead Janice okay so if we look at the U the key things we're going to focus on today the automated billing process that supports the increased billing frequency which improves cash flow and uh reduces the Day sales outstanding and disputes reduction in manual errors a huge error where uh area of improvement because of all the the tens of thousands to millions of transactions that our 3pl clients have to deal with um identifying new revenue streams as we've rolled out this product we've uh introduced our clients to new Reven new streams that they never thought possible and save them millions of dollars in the process and I'll go through a couple of examples as we get into the details and then our warehouse agnostic solution allows clients to quickly adopt this and it doesn't matter what warehouse management system they're running on whether it's the Dynamics warehouse management system or any number of others that 3pl companies typically use go ahead so the way we've deployed this product is it is um in the Microsoft app Source it is an isv product that literally bolts on to your core Dynamics 365 Erp system it sits primarily within the finance area and it completely automates the AR process within your finance application so for 3p billing clients it uses the same database it uses the same forms it uses all the same business processes but it augments those with the new features that we've added um while operating within your Dynamics environment and it can work with the Dynamics warehouse management solution or any other Warehouse Management Solutions that you happen to be using and it's ideal for situations where you want to um get up and running quickly and then gradually convert your warehouses over time okay all right so these are the building blocks on which we built the system and I'm going to go through these in the demonstration pretty much in this order um first we're going to start out with contracts which is how you define the agreement between you and the people that keep their in in your 3pl Warehouse based on the value added services that you're going to provide and what you're going to charge for those Services those are defined as billable activities in our solution and those are the things that end up in the invoicing process um we're going to spend a little bit of time on how all those transactions occur in the physical environment for fulfillment orders and for warehouse management regardless of the warehouse system today um so that you can understand how we capture and track all these billable activities we'll spend a whole lot more time on warehousing uh in the next session in May um then we'll get into the 3pl invoicing process and how we've automated that and then finally we'll jump out to customer portals for um providing that information to clients in a consumable way whether they um are high-tech or not and then finally reporting and analytics on your 3pl business process so that you can manage the process effectively okay with that let's jump into a couple more slides here and then we'll go into the live system so this is the process we're defining for data coming into our um automated building engine on the left you see data coming in from either the Dynamics Warehouse or thirdparty warehouses in the case of Dynamics Warehouse it comes in through our API in real time in the case of external warehouses it's near real time you can set up these batch jobs to run every minute every 10 minutes every half hour however often you want to pull this data in and the key to the way we automate the AR process and keep it simple is all of these billable activities come in as unassigned then based on the client contract we determine which ones are build at which rates to which of your clients and they automatically go on to billable sales orders if they fail any edits in that process they get dumped down to the bottom row you see there as billable activity error logs that's the only manual intervention we want your people to have to have in the AR process as errors occur they have to be manually corrected and put back into the unassigned category so they can automatically be assigned without error the rest of the process should be fully automated which allows you more frequent billing uh cycles and uh better control of your uh sales and billing process from there they go into the billable sales orders which automatically get converted B billable invoices and at that point you can automatically send them out to clients or you could them for review and approval before sending your choice so that's the essence of our process that we're going to go through today next slide this is the environment we operate in so on the left you have your 3pl clients in the large gray rectangle you have your warehouse management system regardless of what it is and there are multiple processes coming out of that warehouse system one is fulfillment orders which can be in Dynamics or not those are the orders that you process on behalf of your clients to receive their goods to stock their goods to Kit their goods to pack and ship their goods those don't have an invoice they are simply fulfillment shipment orders The Black Rows below that though are the billing process and there's no shipping involved here it's simply uh invoicing of the services that you're providing so all those billable activities that we captured recommend represent the services you're providing and those go out through the invoicing and the portal process based on the contracts next slide please given that this is the minimum footprint we need within Dynamics our system can live completely within the AR module and pull data from product information management and that's all we really need is a minimum footprint within Dynamics but we can go a great deal farther than that next slide we can include the Fulfillment services within Dynamics as well and finally last slide in the series we can include the warehouse management as well so our footprint within Dynamic starts within the finance AR module and a little bit of data from the product information management and from there it can go all the way to the the full finance and supply chain application if you desire that okay with that I think we're about ready to jump into the live demo next slide please yes we are okay um so I'm going to bring up the demonstration and share my screen then okay and we're going to start with the U the Dynamics finance and supply chain and I'll give you just a a brief uh understanding of where we are this is the typical landing page for a user when they log onto the system now I'm a system administrator so I have every one of the 50 or more tiles here that a user might see typical users see one to four of these tiles depending on their roles but these tiles are workspaces that represent the type of work that a user would do so I'm going to jump down here to the billable activities workspace and what you'll see here is a series of tiles that represent the work that the um person in this role has to do today and then some reports as well so I've got one uh pending billable activity that's waiting to be assigned to an order I've got 84 failed billable activities that's my manual effort I've got uh uh 11 open buildable activity sales orders I've got some contracts I've got some assigned billable activities that have been automatically assigned to these 11 sales orders and I've got a total of 251 buildable activities in total out here um so I can take a look at any of this data we're going to start with contracts first well let's go a little bit farther back and let's start with products first and then we'll go into contracts so as I mentioned our solution lives on top of the accounts receivable module but it uses data from the product module we're defining the services that you're going to provide so as we give this a moment to open I'm going to go down here and type in the word service and pick product type and we're looking at the services that you're providing not the products that you're storing on behalf of your clients so if we look at Freight as an example that service item is defined as a billable activity this form has been added to the item Master this is unique to our product this is the only thing we've changed in the item master so we defined this as ailable activity it's in the type Transportation it's a freight charge and it will create Freight bills and then we have a upcharge on this so stating that we're going to charge our clients 20% more than we're build on these Freight bills to turn this from a cost center to a profit Center that's the only thing we need at the item Master Level to Define these Services everything else we do within the AR module so I'm going to go back here to that workspace and now we're going to take a look at contracts okay so a contract is between the 3pl provider and their clients that store materials in their warehouse and I'm going to use contract 41 as my primary example today but we'll look at a couple of them and a contract has a number of characteristics that make it very different from a typical price list in Dynamics 365 um one of the key differences is that we have by Design changed the onus of updating contracts from the 3pl provider to their clients if you understand pricing tables within Dynamics they have two dates an effective start date and an expiration date and anything that happens after the expiration date occurs at zero cost because there is no zero price I should say because there is no price beyond that expiration date that would create tons of errors in a high-speed operation a like 3pl environments and you'd have to go back and manually correct all those prices or you'd be billing your clients zero we've changed the whole pricing Rules by adding a number of additional dates here that include not only the expiration date but an original uh expiration date followed by a renewal date which you'll notice is one day later an auto renewal period and then an autor renewal cycle that can be set to run multiple times so we could renew this contract every two years years uh every year however often you want to do that and that eliminates the need to have a u work done after an expiration date that doesn't have a subsequent contract covering it the other thing we've done here is we've defined the rules around those contract dates so the the um 3pl client gets a contract price when their contract is effective when it's open if they suspend the contract due to a dispute we go to a list price which in in this case is 6% higher if the contract expired and it's going to be renewed we stay at the contract price but if it lapsed we again default to the list price Which is higher so this puts the onus on the 3pl client to renew their contracts in a timely manner so they don't get hit with higher prices if they decide to cancel their contract before its effective end date we put them into an offboarding price which is even higher than the list price so we can control the prices that you're charging your clients based on the dates and statuses of a contract we can also set automatic price increases so here you see that we've got a uh it's called a default rule could be any rule you want to name it that says we're going to change prices by 2% or the greater of 2% or the employment cost index every year so even though these contracts if you saw up here run two years we're going to change prices every year not for necessarily everything but based on a set of criteria that you'll predefine over here in the contract terms and then finally the last thing in our contract header is uh branding information many 3pl uh many many companies that use 3pl um providers want to make sure that the products go out from the 3pl provider branded as if they were shipped by the original manufacturer or the uhu the company that's the 3pl client so here we have information about their addresses their contacts their their logos that can be used on packing slips and other documents that would be sent out on their behalf to have their branded information if the document requirements are more extensive than this we also have add additional tools for that that we'll be talking about later okay so let's get into the actual contract details contracts can have a number of different charge types and Within These charge types we can have a number of different billable activities or value added services so a one-time charge would typically be used to set up a new client so we might have a $500 or ,000 charge to uh initiate a new contract with a client to um uh add their initial inventory into our warehouse to set up our EDI profiles with them whatever it is we do these are one-time charges that can be defined when needed recurring charges are set up on a monthly basis typically could be weekly could be quarterly but these recurring charges are a flat rate that is determined by a contract line that says is that as a normal Administration charge we're going to be charging you x amount per month or whatever those terms are when we get into minimum charges they're um based on other charges so what we're saying here is we have a minimum charge that is $30,000 a month okay $35,000 a month if they're on list and that charge is based on these four charges the combination of shipping charges receiving charges storage charges and Warehouse operations charges will be totaled up and if they end up at let's say 24,000 for the month then we would charge an additional 6,000 in these minimum charges to bring the total up to 30,000 so these can be based on any other charge type or combination of charge types that you've got identified here and of course if those charge types exceed the minimum this would be ignored on a regular basis so these typically are monthly charges Miss laneous charges can be similar they can be just about anything and I'll show you some examples of those in a different contract when we get into storage charges these are what we call calculated charges rather than date-based charges so storage charges are typically calculated based on either an average or a peak inventory and the inventory snapshots can be made multiple times a day once a day once a week however often you want to do that the interval again in this case is weekly instead of mon month l so I'm going to build weekly for these and I'm going to build based on um a typical Warehouse could be uh depending on which warehouse this client keeps their goods in um and a quantity in cubic feet here so this is storage space not individual products and we can base this on anything uh this one happens to be based on average but we've got uh let's see where there's my average calculation but we can have this on average in inventory over that period Peak inventory over that period or aged inventory over that period And if it's aged inventory over that period then we'll Define what the Aging periods are so maybe if it's inventory that's Z to 30 days old there's a uh a rate for that inventory but if it's 31 to 60 days old there's a higher rate because the inventory is not moving and we don't want to be have sitting on aged inventory if it's 61 to 90 days it might be even a higher rate so we can Define the different inventory storage rates and fees based on um Peak average or age of inventory if the client is using Dynamics warehouse management then we'll use this category called Warehouse operations and I want to spend some time on this one for two reasons one is to Define how we integrate with the Dynamics warehouse management solution and the other is to look at Future rates so what you see here in the green are the rates we're charging now these are the active rates and we have a hitting rate and a picking rate for work being done in the warehouse and those are based on the sales type work orders in the warehouse in the Dynamics warehouse and there's a charge for those over here at the right based on the order for the um what was the first one here the kitting rate and based on the quantity for the picking rate so these can be based on different criteria they can have different rates and of course based on in this case weekly time periods so this is our billing rates for current activities what you see in yellow down here are those same rates for the next year uh starting in August of this year so these rates will become effective at the next iteration of pricing so this is an example of where we've said pricing will increase by 2% uh this year over or next year over this year and we've predefined what categories of billable activities are in included in that price increase so in this case our warehouse activities prices will go up when uh the new contract date um of August 1st 2024 uh arrives Okay so we've looked at warehouse operations let's look at um typically receiving and shipping uh cycle counting these are uh things can be done in the um any warehouse management system so we'll grab shipping here and you'll notice we have different rates for pack and ship and there's three different rates here for ship the reason is I have shipment in cases shipment in boxes and shipment in pallets so I'm going to have different handling rates for those different units of measure depending on what my costs are for handling that type of shipping so here we can you can see the flexibility of our pricing Matrix here we can Define as many different criteria for the value added Services you provide in as many units of measure Warehouse combinations billing period combinations as you wish to Define and when we get into advanced pricing in the third webinar I'll show you a great deal more that can be done with tiered pricing and uh other types of of rate methods that we can employ for pricing as well Okay so we've looked at those there's a very different one down here when we get into transportation and uh I I will spend a moment here on purchasing in materials before I go to Transportation purchasing can come from the dynamic system or any other purchasing system and this is is the concept that we have to buy special material for a client maybe it's to pack their goods in they want a special box for the holiday season or they want a bundle that has two different products in a box that uh fits them very uh in a very specific way so if we have to go out and purchase materials on behalf of a client we can charge those POs directly to the client as well as the process of of bundling and packing those materials when we use those products if we're using our materials for those products like um slip sheets pallets shrink wrap and other uh packing products we can also Define those as consumables that are billable uh to the client transportation's a little different for transportation we don't set a rate you'll notice this also has a current rate and future rates but that's not the point here what we're looking at is here you'll see that the contract price for transportation is zero because if you remember when we looked at the transportation service item we didn't put a price on it there we said that we were going to have a 20% markup on the actual cost of Transportation so we don't set the price here in the contract we take the product or the the um um carriers price that they Quote us when they pick up the goods and give us a tracking number so that tracking number includes a a two-day delivery rate or a three-day rate or a ground rate of a certain amount will take that contract price and then we'll add a 20% up charge on that and that will be what we charge our clients for transportation now the way we reason we can do that is that typically the 3pl company is a much larger company than their clients and they can um contract or they can U negotiate much better contract rates with ups and DHL and FedEx and others than their clients could so if they can get a 30% 35% better rate than their clients and then charge a 20% upcharge both of them are still saving money so in this case it's the actual Transportation Cost Plus an upcharge that gets put on the contract Okay so we've looked at contracts and we've looked at the billable um categories here but let's go back and take a look at the billable activities as they occur so back here we said that there were um uh 166 total billable activities assigned to orders these are those billable activities for picking packing shipping heat shrinking uh receiving Etc that we're charging for and then over here to the right are the details for that billable activity with all the information we need to process it so these get automatically assigned to sales orders based on the billable activity type in the contract and the the uh duration in the contract weekly monthly Etc okay so if we look at uh bu un assigned billable activities this is the one that's sitting out here in our queue right now waiting to be assigned to a billable sales order and if we look at the errors then these are the only ones we want people to have to actually look at these are the items that have something wrong with them that we're going to have to correct and over here to the right you'll notice that it's plain English uh descriptions of what needs to be done to fix it in this case we've got a zero quantity we go out here and we go into edit mode we put in the quantity correct that and then it can go ahead and be processed so that can be processed back to a pending buildable activity and then it'll be picked up and automatically assigned to a sales order so I keep talking about this automatic assignment to sales orders let's go look at one and uh show you what that's all about at the beginning of each billing interval let's take uh shipping which was on a weekly billing interval the system looks to see if there's a sales order for the customer whose contract we just received a billable activity for that already exists if a sales order exists the billable line will simply be added to it if the sales order doesn't exist then the system will create a new billable sales order for that customer for that period and add the billable activity to it and then all subsequent billable activities will be added to that during that week or month that that sales order is open so let's grab 128 here as an example so this billable sales order has been open for a period of time and a number of transactions have been charged against it and what we're going to see on the sales order is a summary of the transactions charged against it so we've had a number of different receiving fees some Freight charges some shipping fees and if we grab this individual line here and go to billable activity details then we can to see what was assigned to this sales order so these are the freight charges that were actually assigned and if we grab one of these and scroll down here we can see the details of that freight charge the way Bill number or tracking number the freight charge that was applied all the information that um is defined as well as the um fulfillment order that this corresponds to so each time a new line gets assigned whether it's a shipping line receiving line or whatever it gets added to this billable activity list and it becomes part of this sales order so at the summary level we have the total charges for the sales order and it's value at the detail level we've got all the billable activities that were charged but keep in mind for a typical 3pl client they're dealing with t of thousands of billable lines a day maybe millions in a month so as a result they have a um overwhelming amount of data that they have to process and if they're doing this manually in Excel it can take weeks to put together these sales orders convert them to invoices and get them out to their clients and without having all all this detail automatically accumulated for them the possibility of errors and therefore delays and um um postpone payments are very high so by automating this process automatically creating the billable activities based on the contracts automatically creating the sales orders and adding the billable activities to the sales orders and then automatically converting the sales order to an invoice at the end of its duration weekly monthly whatever it is we've eliminated the potential for a lot of errors and we've eliminated a lot of manual effort one of our clients told us that we would essentially eliminate almost a million dollars worth of um a effort per year on an ongoing basis and that might even grow higher uh as their company grows we also help them uh to eliminate an estimated 15 million in Day sales outstanding in cash flow requirements by shortening the interval from uh the time billable activities occur until they can actually collect from their clients so as a result this is a huge value add for our clients and this automation eliminates so much effort that really all the uh the user is left with is dealing with those those errors that might occur on a periodic basis Okay so we've looked at um the billable activities we've looked at contracts we've looked at sales orders let me catch up on my notes here um uh let's take a look at the at the portal so as this information is is presented to clients it can go out a number of ways this uh uh invoice can be mailed to the client it's typically not it can be via EDI which is typical of large companies but many uh 3pl um companies are or many clients of 3pl companies are not large companies and they're not EDI capable so they may also want to have access to that information via a portal where they can pull it down and look at it on their own so we offer a portal I've just logged onto our portal here of course this is branded for the Dynamics I mean the uh avano example uh your portal would look like you wanted it to look and would have your functions here across the top but this is representative of our standard portal as we deliver it now to say that I don't know of any of them that have been actually implemented as delivered because clients usually request add a lot more things to the portal but this is the base as it it comes delivered and can be built upon from here so at the home level we're at the beginning page of the portal and we have multiple pages that clients can look at for the different uh levels of support that are offered uh possibly videos product overviews uh Services frequently asked questions Etc um but from there they can go into their company View and they can see their data online now this can be simply um their their um information about who in their company is is allowed to use this portal it can be their account balances it could be other documents that are associated with their their contract or other information uh under billing they can take a look at their multiple company invoices if they are a multi- company client they can look at their individual transactions their credit memo requests uh consu uh uh customer service requests they can actually create a new request for support so they can go out here and create a customer service request they can look at frequently ask questions and get answers to questions that uh We've shared online and they can do a search if we go back to viewing company information and I bring up balances they can actually bring up their invoices and let's grab this one here and go to the down arrow go to view details and they can see all those behind the invoice details that we showed you online so all the information that was provided as background to a sales order or an invoice in this case is also provided online so the idea here is that we're providing the client with a tool so they can get at their transactions quickly they can review them they can pay them um they can see outstanding balances on them they can look at um customer service requests where they have questions that they need to have answered Etc um the kinds of things that have been added to this portal is uh some of our clients have requested that we add under the company view banking information so that we can facilitate a transactions uh from their company to ours for payment we've got uh requests for inventory visibility and other things that uh clients have requested in their portals as well so the portal allows small companies to have access to all this data in a rapid way and get down to the level of detail that they need download these transactions to their current environments so that they can uh go ahead and pay us on in a timely manner okay so finally the way I want to wrap up this webinar is with reporting we've developed some powerbi reporting that allows 3pl clients to evaluate where their spend is where their revenue is and take a look at where they should be spending their limited resources on improving their internal processes so this is a view of Revenue by type of billable activity or value added service and Warehouse so in this case we're seeing that UPS ground is the most valuable thing that we're doing right now because that's where we're generating $1.55 million in Revenue over this time period And by the way these graphs are all um U manipulated um by simply using slider bars and other tools so we can change the data at a moment's notice and look at this data very differently um we can see that they're spending a lot of money on um USPS as well okay uh one $2.8 million over this time frame that I've now looked at here we can then look at this by individual warehouse and see how little one Warehouse is spending but taking a different example how much another Warehouse is costing them or spending so we can take a look at where our volumes are and where our um in investment should be in improvements and and uh operational changes in those environments we can also take a look at that same type of information by customer and again I can change the values over time I can look at different customer sets based on ship warehouses that these customers ship out of and other information as well I can look at Services by period so here I'm looking at it by months I can collapse these and look at it by quarters or I can collapse it further and look at it simply by years so I've got different information available to me based on the uh the way I want to review the data as well as time periods again so all of this information is dynamic depending on what I change on the form this looks lets me look at quantity of services versus value of services so my item handling for inbound products that's putting away Goods that have been received in my warehouse is what I spend the most time by quantity on and yet my priority mail is what I spend the most money on so this can allow me to look at um here's my item handling outbound which doesn't generate a great deal of money at all but you can see that item handling is a very high value over here so quantity of services versus value of servic Services allows me to match those things where I need additional resources or uh need to fine-tune my warehouse operations and then finally Services build this is similar to the first one but without looking at the individual warehouses we're simply looking at The Individual Services who's using them and how much so a lot of different um types of analyses that we provide to our clients and this again we teach you how to uh we provide these powerbi examples and we teach you how to build powerbi analyses so that you can extend your reporting requirements to whatever you need to run your business okay well I've spent about 45 minutes on this at this point I'm going to turn this presentation back over to Janice but before I do I just want to say that what I hope to have conveyed today is that the approach we took with 3pl um Solutions here is to address one of the biggest needs in the industry which is the volume of data that a 3pl client must process in order to get their billing done and the automation of that data so that they can get it done efficiently so they can get paid quickly and so they can run a profitable business operation so given that I'll turn it back over to Janice I think we also did briefly want to cover this selected customer outcome slide as well oh yeah let's go back to the PowerPoint for that sure okay so let me minimize this so I can get back into that okay so um are you presenting that because I'm not seeing it yes uh where am I supposed to be here okay um oh there we go sh sorry I was on the wrong page I apologize so I mentioned a few of these things as I was going through the presentation these represent uh savings that some of our clients have reported to us over time um I mentioned this one uh the very first one uh just a few minutes ago and that is a first year Savings of $15 million based on the ability to process invoices more frequently and therefore decrease their Day sales outstanding in their cash flow requirement um by being able to collect from their clients on a faster basis the second one the full-time equivalent Savings of AR people by having all this automated and only having to deal with errors and eliminate the need to have people manually going through spreadsheets and building invoices is Savings of almost a million dollars a year and that's going to increase over time uh and that includes savings on month-end close and manual processing and a lot of other compliance and Reporting is included in that number if you drop down a little bit they also had an IT Savings of uh $50,000 a year by eliminating a number of different software packages that they were doing this in previously um that were all Consolidated into adamx Finance in our um 3pl solution and then finally we helped them identify over $200,000 a year in new revenue streams for billable activities that they didn't realize they could be billing their clients for now obviously to gain those they're going to have to renegotiate their contracts with their clients and add those new billable activity types in but that gives them the opportunity to continue to grow their revenue um over time with their existing clients and as they add new clients that'll grow even larger to give you another example that's not on this page we helped one of our clients that is a Marketplace um kind of like an Amazon where they they not only ship on behalf of their clients but they collect on behalf of their clients we save them $3.7 million a year by turning the credit card fees that they were paying as they collected on behalf of their clients into a billable Revenue stream for them so the value that we're offering here is millions of dollars in savings to our clients based on automation of the billing process for 3pl perfect thank you so much so before we end here today just just want to remind everyone really quickly that we are hosting two half day free in-person events both focus on Microsoft Dynamics 365 Supply Chain management both will be hosted in Southern California on June 12th and June 13th from 9:00 a.m. to 1:00 p.m. just let us know if you're interested in attending and please try to join us for our next webinars as well uh our next session on 3pl will be on May 30th and that'll be focused on WMS and Freight reconciliation and then the next session on June 20th will be focused on unlocking new revenue streams for complex pricing for value added services and the last session will be on July 25th and we'll be a deep dive into the customer portal then we'll also be hosting our webinar series on our finance automation software as well and those sessions will be on May 23rd as well as July 11th thank you very much thank you bye