Sunday, May 29, 2011

Learning More About Getting Data out of my Database and Into my Blog

EDIT: I do not know why this is the only post now showing on "Page 1", maybe it's a Blogger thing...  You can see all my older posts by clicking the Older Posts button at the bottom of the post, or look along the right side to view any article.  Hey, I'm still trying figure out all this stuff here!
.....

The closest thing I have to a "day job" is that I get weekly sales data from our company in Peru (via email on MS Excel), pour into my database (MS Access, an SQL database) and look for helpful trends so that our company can better buy bearings (anticipate sales, etc.).  The below took me awhile to figure out how to do.  Since I do not know any HTML jazz, I just try to do the simplest thing possible.  I sent the below to Excel, and I did not see any simple solutions there, so I re-sent on over MS Word.  There is a way to save the information "as it will look on the Web".  Banzai.

Codigo is our internal reference for each bearing we sell.  Bearings prefixed with "02" (KBC brand) and "11" (Iljin brand) are from KOREA!  We are their Exclusive Distributors for their products in Peru.  This is the kind of thing I do when not thinking about, writing about or buying gold!  These bearings are ranked from best selling down.  I mentioned to you earlier that all that we had no May sales of our "02-6007-RS" bearing, which was really bad because it is our top seller (front wheel bearing for the "Daewoo Tico", a very small car popular in Peru -- for those interested).  Blanks below signify no sales in that month.  But, it came out of Peruvian Customs and over to us on May 19.  7030 pcs sold in three days!  I can hardly wait to get last week's sales data...


Codigo
Total_Qty
Total_Sales
01-Jan
02-Feb
03-Mar
04-Apr
05-May
02-6007-RS    
20670
$67,450.74
2400
8361
2879
7030
02-6204-2RS   
5681
$11,900.32
664
1291
1388
696
1642
02-6000-2RSC  
7620
$11,059.69
1472
2603
1805
1740
02-6205-RSC3  
4682
$10,767.89
774
1018
1347
443
1100
13-38BWD22    
731
$9,814.06
74
122
229
306
11-IJ-113002  
172
$7,901.89
38
23
62
14
35
11-IJ-111001  
395
$6,264.88
276
119
02-6002-2RS   
4031
$5,561.41
316
1002
536
217
1960
C3-RCT283SA   
503
$5,044.97
231
61
112
99
02-68149G/11  
1164
$4,870.87
292
449
270
153
03-12649/10   
1026
$4,840.10
40
415
195
132
244
03-DAC3872-8  
299
$4,616.50
46
28
113
91
21
02-6302-2RS   
2300
$4,562.72
30
2270
11-IJ-111003  
210
$3,970.23
65
35
56
28
26
03-48548/10   
679
$3,624.09
30
256
105
137
151
11-IJ-113015  
75
$3,471.30
26
3
26
20
02-38KW01CG5  
686
$3,373.18
196
60
225
108
97
11-IJ-111009  
231
$3,100.15
174
57
02-TR285216G  
605
$3,019.14
100
52
251
130
72
13-M3874W     
243
$2,966.17
47
43
42
90
21
Posted by at

7 comments:

  1. donpauloMay 29, 2011 at 8:19 PM

    just curious but what is the reason for the demand drop in April ?

    ReplyDelete
  2. Robert MixMay 29, 2011 at 9:29 PM

    Our biggest problem in April was that we did not have any inventory of some of our best sellers. That can cause knock-on problems: "Oh, you don't have that..." they then buy something verry similar from a competitor and maybe other items as well...

    JAPAN makes lots of nice bearings, and we sell some we get at fairly high prices on the "Gray Market", but there is really too much competition in Peru re Japanese and Chinese, so we are going with the guys giving us quality AND price: Korea!

    ReplyDelete
  3. RockyRacoonMay 30, 2011 at 4:06 PM

    You could use IrfanView to copy your chart/graphic as a .jpg, adjust the size to suit you, and then post it just like a photo.
    Forge ahead!

    ReplyDelete
  4. donpauloMay 30, 2011 at 11:56 PM

    I see, the demand on 02-6007-RS is out to lunch.

    are you just selling what you have in stock which would be a supply issue ?

    If so I can drop by a bearing plant next time I am over korea way. Its just 2 hours from my door.

    ReplyDelete
  5. Robert MixMay 31, 2011 at 10:21 AM

    donpaulo, LOL, Ameru could you send over as our Director of Asian Operations...

    We are almost every day in touch with both KBC and Iljin (their Sales Departments). Our problem is that Hyundai is kicking ass all over world, so it is hard for us to get them to produce the pieces we need. But, we did just get 12,000. But they will likely be gone in a week or two. SCREAM! Again.

    ReplyDelete
  6. donpauloMay 31, 2011 at 10:14 PM

    I am serious RM. I do get over to Korea from time to time and it would be interesting to get a tour of a bearing factory depending on where it is on the peninsula.

    A business model that sells out of its supply is an appealing one

    ReplyDelete
  7. Robert MixMay 31, 2011 at 10:33 PM

    donpaulo, let me think this over and talk with my in-laws there in Peru. If we want to explore this further, we will need to know more (like see your resume, etc.).

    I just thought of something maybe for you though. If (and I know it's a low probability thing) neither KBC nor Iljin has representation in any country where you have SOLID BUSINESS CONTACTS (like in small S. American countries or in Central America), I can hook YOU up with KBC and/or Iljin. Email me at the usual dochenrollingbearing@gmail.com if you want to explore this idea further.

    For dialogs like this, email probably works better.

    ReplyDelete

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)