Posts

Tip #1207 – Using Sales IQ to Identify Sales Problems

The dynaMACS  Sales IQ feature is a powerful tool that allows you to monitor and analyze all of your sales and commission performance.  Did you know you can also identify customers that have not bought in a period of time?

Example

In the following example we will look at a quick and simple way in Sales IQ to see what customers have not purchased from a particular manufacturer in the past three months.

  1. From the dynaMACS main screen select the Sales IQ button.Main Screen
  2. From the Sales IQ Home screen select the Manufacturers tab.Sales IQ Home 1
  3. As you can see in the list of manufacturers displayed below, there are 4 manufacturers with a negative YTD Variance, B.C. Industries being one of them.
  4. To view the customer sales activity for this manufacturer we will select and right click on the manufacturer B.C. Industries and then select Show Customers from the drop down box.Sales IQ Home 2
  5. From the Sales IQ:  Drill-Down (1) Manufacturer>Customers screen select 3 Months from the No Sales Activity In: drop down box which is in the lower right hand corner of the screen.
  6. Select the Refresh button.Sales IQ Home 3Note
  7. The list will refresh displaying the 15 customers that buy from B.C. Industries that have NOT purchased in the past 3 months.
  8. As you can see, the YTD Variance is a negative value in most cases.
  9. The customer All Others displays the combined values of all other customers that HAVE purchased from B.C. Industries in the past 3 months.
  10. The last two columns show what percent of the total sales for B.C. Industries each customer represents, this Year-To-Date and Last Year Total.  Using these values you can determine the significance of each customer.Sales IQ Home - Drill Down 1
  11. By using the Up  or  Down  arrows in the upper left hand corner of the screen you can quickly go from manufacturer to manufacturer to identify other customers meeting the same criteria of no sales in 3 months.Sales IQ Home - Drill Down 2

Case Study: Metra Associates Inc.

“I wish we would have started using dynaMACS years ago. It’s a great tool, and everyone loves it.”

Herb Schneider, General Manager
Metra Associates, Inc.

Metra_LogoClient Challenge

They say hindsight is 20/20. Looking back, Herb Schneider, General Manager of Metra Associates, wishes he had started using dynaMACS years ago. However as many people are when it comes to technology, “I’m a creature of habit, I didn’t want to change,” Schneider explains. He was concerned about losing valuable historical data when transitioning to the new software; and was so familiar with the keystrokes of the previous CAS software that he thought the data entering process would not be as user friendly.

METRA_Associates_StatisticsdynaMACS Solution

A few months ago, Schneider “bit the bullet.” “I wanted the sales reps to have up-to-date information, and we simply couldn’t do that with the old software. dynaMACS would enable me to distribute data on each territory electronically to reps. There would be no waiting for paper reports, no sifting through paperwork to find crucial data. dynaMACS provided so many benefits that outweighed my reluctance to make the switch.”

Now that Schneider and his sales force have been using dynaMACS, the consensus is “I wish we would have started using dynaMACS years ago. Everyone – the sales reps, the sales manager, the owner and I – love it.”

Regarding the transition, Schneider says it couldn’t have gone smoother. Within an hour, all of the agency’s historical data was transferred with no losses.” As for the learning curve involved in using new software, “It was a non-issue. I had a quick training session with dynaMACS support, and we were up and running with no down time and no lost productivity.” In fact, the agency is more productive than ever.

Schneider filters data from commission reports by territory and sends to sales reps via email. Schneider and the outside sales manager access data in real-time via the company network, and can slice and dice information by manufacturer, customer or sales rep, and drill down for more details. “We couldn’t be happier with the product and the dynaMACS support team, who is always available to answer questions.”

Tip #1206 – dynaMACS Quarterly Tax Reporting

In dynaMACS Sales IQ you can retrieve quarterly commission numbers which can assist you in expediting your tax reporting.  If you need to report by state, you can do so by using the Sales Analysis reports feature OR filter by state/region in Sales IQ.

Sales IQ Agency Comm (3Mos) – Example

In the following example we will generate a report using Sales IQ for quarterly commissions by manufacturer for commissions received July – September 2012.

  1. From Manufacturers tab in the Sales IQ screen select Commissions Received from the Source drop down list.Note: If you do not have the Commission Reconciliation module then you can pull the data from Shipments vs. Commissions Received.
  2. Select the Agency Comm (3 Mos)option from the Data drop down list.
  3. Select September from the As-of drop down list.
  4. Select 2012 for the As-of year from the drop down list.
  5. The quarterly commissions received will appear in the column Totals for Jul 12, Aug 12,u Sep 12.Sales IQ Home

Sales Analysis Commission Received by State – Example

In the following example we will generate a report using Sales Analysis for quarterly commissions by state for commissions received July thru September 2012.

  1. Select Commission Rec’d from the Selected Source of Data drop down list box.Note: If you do not have the Commission Reconciliation module then you can pull the data from Shipments vs. Commissions Received.
  2. Select Sales and Agency Commission from the Select Column Set (Headings) drop down list box.
  3. Select Customer State/Region from the Select Sub Totals Group drop down list box.
  4. Enter 09 and 2012 in the Print As-of Month/Year
  5. Select 3 Months from the Replace Current Month With drop down list box.
  6. Select the Print button.Sales Analysis Reports
  7. The following report is displayed showing the commissions received for Jul – Sept 12 by state.State Report

Case Study: PG Tool Sales Agency, LLC

“dynaMACS is always innovating and continually enhancing the software. I would recommend dynaMACS to anyone.”

Diane Geiger, Treasurer / Inside Sales
PG Tool Sales Agency

PG_Tool_LogoClient Challenge

PG Tool Sales Agency had been a customer of dynaMACS’ predecessor, MACS software, since 1989. When dynaMACS was introduced in 2003, PG Tool didn’t hesitate to upgrade. “We’d been happy with the software from the beginning. When dynaMACS came out, we wanted to have the newest product – the latest and greatest version,” says Diane Geiger, Treasurer and Inside Sales Director for PG Tool. “We went with dynaMACS because of our good track record with MACS – and we are glad we did. It’s been great.”




PG_Tool_StatisticsdynaMACS Solution

In fact, long-time customers like PG Tool have helped make dynaMACS the most powerful, easy-to-use software on the market. “The dynaMACS team is very open to input. They’ve listened to our feedback over the past 25 years, and they constantly work to improve the product based on how sales agencies like ours use the software on a day-to-day basis. dynaMACS is truly designed for professional sales agencies that need multi-level sales and commission analysis,” Geiger says.

Geiger says dynaMACS delivers intelligence on customers and manufacturers that help the sales team be more effective. “We can recognize trends by customer, manufacturer and sales reps. This helps us determine the types of promotions to offer based on the income generated. It also helps with up-sells and cross-sells.

The agency also knows who is not buying, or whose purchasing has dropped off, so salespeople can spend their time on the accounts that need the most attention. Salespeople can use their time more efficiently, by sorting customers by zip code, analyzing sales and setting up call days and planning the most efficient routes.  

What’s next? PG Tool is preparing to step into the next-generation of innovation. dynaMACS recently introduced processing on the Cloud. PG Tool will be among the first dynaMACS customers to process on the Cloud. This gives salespeople access to real-time data that is accessible from anywhere, on most smart devices, like smart-phones and tablets, at any time.

Tip #1205 – Did you know that you can share eSi data maps with other agencies that are using dynaMACS eSi?

If you share a manufacturer with another agency that uses dynaMACS eSi, you can easily exchange data maps without the risk of sharing your agency data.  Using the Send Map and Receive Map* options in dynaMACS will eliminate having to create new maps.  The following examples will explain how to send and receive maps to and from other agencies.

Sending a Map to another Agency

Sending a map to another agency requires that you have created and saved a map in dynaMACS eSi.

  1. From the dynaMACS main menu, select eSi then Send Map from the drop down menu.Main Screen 1
  2. From the Export Catalog dialog box select the file to be exported
  3. Select the Export button.eSi Import Catalog Record
  4. The file location of the exported map will be displayed in the FYI dialog box.  Select the OK button.FYI Diolog Box 2
  5. Once the file has been exported you can email it to the agency that you are sharing it with.

Case Study: Kelly Mincks

“When comparing dynaMACS and our old software, the screens are easier, the report format is more useful and the networking capability is more convenient.”

Bill Kelly, Partner
Kelly-Mincks

Kelly_Mincks_LogoClient Challenge

As part of re-structuring after a failed merger, Kelly-Mincks decided it was time to take a look at the agency sales software, to see if it could be better serving the agency and its operations. The agency compared its old software and a competitor side-by-side. How did the softwares stack up?

Kelly_Mincks_StatisticsdynaMACS Solution

“For me, personally dynaMACS is a better system,” says Partner Bill Kelly. He surmised that “the screens are easier, the report format is more useful and the networking capability is more convenient.” Plus, dynaMACS has a feature that Kelly-Mincks’ old software didn’t have: mobile, the ability for sales rep to take sales and commission information with them on the road.

Kelly-Mincks has 3 mobiles for its sales team, and each rep can access sales and commission data for his territory at any time. The reps’ information is as up-to-date as the offices’. “We really like the ease of getting information out to the laptops,” Kelly says.

Furthermore, dynaMACS is installed on the agency’s network, to allow access by all users at different computers. “Previously, we only had access from one computer, so one person couldn’t be printing reports if another was entering data,” Kelly explains. Due to the powerful reporting and analysis capabilities of dynaMACS, the agency decided that multiple users would need to access dynaMACS concurrently.

Kelly also likes the reporting functionality. “Converting raw sales data into meaningful information is easy.” With dynaMACS’ powerful report generator, Kelly-Mincks can produce summary or detailed reports and choose from pre-defined or customizable formats. The agency creates the reports it needs from thousands of possible combinations. Activity is viewed in many different ways from viewing commission expected to comparing sales this year against last or viewing total agency performance by sales rep.