Problem
I currently have frame A on my rack, its cost was $50 with a retail price of $100. I now receive an identical frame B and the cost went up to $60 so I need to sell it at $120 to maintain my margins. What do I do?
Solution
The solution to this depends on whether you are dealing with a store, or group of stores, selling at ONE retail price for ALL stores. Solution #1 discusses the cost and retail differences when receiving the identical frame but at different cost prices and impact this has on the Current Inventory report. If you are selling the same frame at different prices in various locations, then we must introduce "Regions" to the setting of retail pricing.
Stores selling at ONE global retail price:
You have two options here:
- You can update the selling price of the frame to $120 when you receive it. Wink will record the selling price of both frame A and B at $120. If your frames are tagged, then scanning either frame will enter a selling price of $120 in your worksheet.
Even though each of your frames have unique serial numbers, there can only be one price for a specific frame. It would be odd to have two identical frames on the shelf at different price points.
If your frame tags have prices on them, you would need to reprint Frame A's tag with the new price of $120. - An alternative would be to take an average price for both frames and adjust the selling price to $110. This approach maintains your margins while giving the best possible price to your customers.
In either case, the cost of your inventory in Wink would be the $50 cost of Frame A plus the $60 for B for a total of $110.
Stores Selling the Identical Frame at a Different Price:
You may have a store in BC selling a particular frame at $100 retail price, and another store in NS selling the exact frame at $80.00 retail price, simply due to market fluctuations between the regions where they are sold. To handle this, you must set up "Regions" where all stores within a particular Region will sell at one retail price, and stores within another Region will sell at a different retail price. Here's how to set up your regions and use them in your Frame code descriptions:
1. Set up your various Regions:
A Region can be anything you want it to be, depending on the size of your stores and their geological locations. For instance, a customer in Cornwall, ON may not expect to pay the same amount as a customer in Toronto, ON. Or, you may just decide to make it provincial and have all stores within a particular province pay the same price. Maybe you have two stores in the northern end of a province and 3 stores in the southern end ... you can make each store their own Region ... the possibilities are endless, but they are customized by YOU.
For my example, I am using two provinces, Ontario and British Columbia:
When you want to group stores together in a particular Region, you click on "New" in the above screen to open a list of stores contained within that Region. This list can be added to at any time, keeping in mind that the stores added to this particular Region will have the same retail pricing on their frames and lenses.
Click the "Edit" button to add/change/delete any Store or Lab Catalog from your lists in this Region.
Now that your Region(s) are established, let's see how to add the Region pricing to the frames and lenses in the Stores in the Regions:
Frames Pricing:
When entering a Frame into your database, simply specify the Region you are using to set the retail pricing for the frame. "Default" will apply to ALL Regions.
Use the same principal when adding lenses to your Lens Tree:
Comments