SavingYouHours.com Sit back and relax with SavingYouHours.com - Your expert in Excel and Access!




Case Study

MyPrettyCurves.com

Myprettycurves.com is a successful online reseller of plus size clothes. Their business has grown considerably in the last few years and they have struggled to have reliable and current data. Although there profit and loss showed good profits, there Net Profit percentage was falling. They identified they had stock issues and also did not know what their profit/loss for each clothes stock line was.

They approached Saving You Hours as they did not have many overhead staff to manually produce this information and found the cost of a ERP system prohibitive. As Wei Ling said (owner of MyPrettyCurves)

“We hunted around looking for a financial system that could help us but the cost was way too expensive,  one of my friends recommended Saving You Hours, I had a look at there web site and was impressed particular as we got a fixed quote and did not have to pay any money up front”

We decided they needed an integrated Access and Excel solution that was fully automated (see a page dump of the Access Front End):

We set up a Access front end and back end, we aligned the stock numbers with the suppliers stock codes and automated downloading the stock invoices from the suppliers. The whole database is live linked to the web sites SQL database so all of the sales are reflected live. We also have linked financial information from there Accounting package enabling us to have a complete and detailed financial and non financial picture of Myprettycurves.com.

A later release, Myprettycurves.com partnered with some affiliates and we were also able to link with there web pages allowing all sites to have up to date stock holding and sales data. This enables the staff to get up to the minute enquires and reports of stock levels, sales, purchases and the profit/loss of each dress.

This has revolutionized the way myprettycurves.com operates and manages its stock. Access also produces key stock reports for the managers which is exported to their intranet (see an example below) these reports all use conditional formating to highlight exceptional performers good or bad and can be produced by Product Group, By Stock Code even down to clothes sizes.

Key Stock Report

Once we had tackled the complete lack of information available we had to ensure staff was not bombarded with unnecessary detail. So we produced a executive information system that prepares standard reports for different levels of the organization (see below an example of a report for the cost controller). These reports are all color coded, are graphical in nature and enable staff/management to see trends as well comparing key stats with financial data

So now myprettycurves.com has a reporting system that highlights performance but allows for detail examination using the same source data which ensures accuracy.

Wei ling stated,
“When we rolled out the system my staff were very worried about the amount of extra work they would have to do, but infact their work loads were significantly reduced!. The managers and owners are amazed at how easy the reports are, yet we can drill down to find detail if necessary, All this at the fraction of the cost of any ERP systems. We are extremely happy with the performance of SavingYouHours.com and would recommend them to anyone!”

Cost Summary

So If you want us to review your spreadsheeting and/or database project and provide you with an obligation free quote, just Click here now. (or email us direct at info@savingyouhours.com). We will get back to you ASAP.

Sincerely,

Ross Beatson
www.savingyouhours.com