• Facebook
  • Twitter
  • Linkedin
  • YouTube
Margin Master

Margin Master - User Tips

RetailerSoft Logo

Margin Master User Tips
Fixing MSU's in E4W

1) Open up Margin Master, click on the "MSU Pricing" tab, select "Show ALL MSU Items", then "Refresh Data".
2) Compare "Current Price" and "Future Price" and look for anything that differs by an order of magnitude (as opposed to just differing by some incremental amount).
3) Open up IMU, in E4W, and also open up an Acenet screen. 
4) Take your improperly set up MSU sku numbers, from Margin Master, then enter them into IMU and change your information to what Acenet says it should be. 
5) After updating the price in IMU, click on "Codes" (still in IMU) and then click on the down arrow next to "Multiple Selling Unit Code" and make sure that it is set up correctly to sell by the roll/bucket/box/whatever.
To double check your work, keep a POS screen pulled up and test each SKU that you fix to make sure that it rings up properly.

How to find merchandise that you're selling for below cost

1) Click on "More Selections"  then click "Margin" "Is < Than" "0".  Click "Refresh".  Surprised?

Finding odd location codes

1) Click on "More Selections" then scan down the list of "Location Codes".  Click on any that don't look right. 
2) Click "Refresh" to get a list of just the merchandise with odd location codes then click the picture of the printer-- and export to "Excel". 
3) In Excel, delete all of the columns except SKU, Location and QOH. 
4) Print out the list you just created and have your employees assign valid location codes and correct them in E4W.

 Dead/Missing Inventory

1) Click on "More Selections" and look at the box that says "Last 12".
2) Check "=0" and then "OK"
3) Look at the box that says "On Hand" and check "<>0". 
4) Click "Refresh"

 This will show you all the inventory that you haven't sold in the past year.  Most likely causes include:

 1) You actually have 0 on the shelf, even though your computer says otherwise.
2) Your pricing is way out of line and needs to be fixed.
3) It's truly a dead item and needs to be put on clearance and no reorder.

 If you're new to Margin Master...

...don't know what strategy to use, you can start by taking your existing prices and just click on "Rounded Future Price" and "Apply".  You should make lots of money with just those two clicks.

 If you have thousands of price changes and don't know where to start

1) Start by sorting based on "CP-FP-Var" [That's Current Price/Future Price Variance].  To have this column show up on your screen, right-click, "Insert Column" then check "CP-FP-Var". 
2) look at the extremes on both ends.  Everything that is 20% too high or too low should get your first attention.

 Searches that will give you something to wonder about

1) Under the Basic Selection tab there are two Velocity option choices:  Store-Vel and (your vendor or co-op's name)-Vel.  Go to "(your vendor or co-op's name) Vel" and click "A" then "Refresh" to get your vendor/co-op's  A items that you stock.

2) Right-click on a column name and click "Insert Column" then "Store Vel".

3) Compare your store's velocity and try to figure out why your items are C's and D's.

4) Try other combos for more head scratching data.


How I typically use Margin Master: (only read this is you're reasonably familiar with using Margin Master)
1) Start up the program, let it automatically update and then import the latest store files that were generated by running the MMASTER queue.
2) Click on "More Selections" and then scan to the bottom of the "Locations" list.  I check "Blank" and "ZZZZZ".
3) Then click "On Hand" and "=0" and "Refresh".
4) Once I see all the Blank and ZZZZZ location coded items that have 0 on-hand, I click on "Data" and "Delete Displayed SKUs".  That reduces the number of skus that my strategy will have to modify (saving time).
5) Once my strategy has executed, I insert the "CP-FP-Var" column (see above) and sort by that column (click on the A-Z icon on the upper right part of your screen to do this sort).
6) I look at all the price decreases and see if there are any that need my attention.  If not, I click "Data" "Remove Any Price Decreases" "From ALL Selections".  (Actually, I have a neat way of cherry-picking only the price decreases I want to implement, but I don't want to make this article longer than it needs to be.)
7) Next I select "Price Selection" "Future Price" "Is=to" "0" and click "OK".  Then "Refresh".
8) Click "Data" "Delete Displayed SKUs".  (This, once again, drastically reduces the size of the database.)
9) Now that my database only consists of price increases, I export them, print bintags and update retail pricing in E4W.

If you have some Margin Master Tips you would like to share, please let us know.