Finally II October 24, 2020
When we bought our building about 15 years ago, the back two thirds had tenants so we had the put everything in the first two bays, about 6,000 square feet. To make it work, we put all the raw materials and the saws in the center of the machine shop. We then put the welding, paint and press break in the assembly area. About 12 years ago, one tenant moved out and we were able to spread out. The welding and saws were moved to the back bay which is about 5,000 square feet while painting and shipping were moved to the middle bay, another 2,000 square feet. We did not, however, move the paint booth because it would be a major project which would also require new wiring. Well last week, our painter, Joe, was all caught up so Karl decided “Now is the time”. This week, he completely disassembled the booth and started pressure washing it. It will be reassembled in the paint bay where new wiring will be installed and the ducting relocated. We will also remove all the old fluorescent lights and replace and add LEDs. Not only will this improve our efficiency and work flow but it will also make a lot more room in the assembly area. Now all we have to do is move the press break but since that will require hiring riggers, it will have to wait.
Back to Normal? October 14, 2020
I am still trying to get back in the groove of doing a weekly blog and I am not quite there yet. I have spent the last week going to the office everyday instead of quarantining at home. We have implemented the new data base and are doing parallel entry into it and the old data base. I need to make more fixes than I had hoped so I have been busy doing that all week.
Meanwhile, Larry and Mike are back on the road again. Larry is mostly back in his same routine and really doesn’t have to worry too much about travel restrictions except in California. Mike is planning his first major solo demo trip for the end of the month. He is hampered a little by travel restrictions in the North East but does have a couple of trips planned. In the mean time, he spent two weeks at Eastlake providing tournament support for the Tour Championship. That’s John Patterson from Atlanta Athletic Club also providing support using Mike’s demo machines they unloaded from his truck, while the competitors’ machines sat idle for the whole time. It sounded like every one from the general manager to the PGA rep was happy with the course improvement as a result of using our grinders. While this was a step towards normalcy, the lack of spectators shows that we are not there yet.
Last week, Mike went to a field day sponsored by our local dealer, Everglades Equipment. That went really well. It was well attended with people in and out of the van all morning, a great lunch, and a round of golf in the afternoon. I guess there was some bar hopping that night, but Mike chickened out.
Heee's Back October 7, 2020
I know it has been a while since I posted here and for that I truly apologize. I have been working feverishly on finishing our AM6 Database. Just to bring everyone up to speed, I have been using Filemaker for about twenty years for our production control software, which includes, Vendors, Purchase Orders, Customers, Sales Orders, Invoices, Employees, Time Tracking (missing from any affordable off the shelf software), Inventory and Work Orders. We used an off the shelf accounting software for everything else. This required us to double enter a lot of information so about six years ago, I rewrote the software to include all accounting functions including payroll which makes Melissa much more efficient.
About two years ago, Filemaker decided to deprecate the peer to peer sharing of a database and will require the use of a dedicated server running their server software. This is a good thing because it provides a more bullet proof system with better security and backup protocols, plus they. provide it for free with a multiuser license. The downside is that I had to rewrite the software to work properly on the server. I decided to rewrite the whole thing again to make it more bullet proof and to make it faster. And I think I have finally achieved that. Last week, I finished the data base and today I finished the first testing phase. I have been doing this from home primarily because of Covid but also, I get fewer interruptions. Tomorrow, I will go out the office and begin the process of updating all of the computers and installing AM6. Once everything is installed, we will be running parallel systems until we are confident everything is working properly. As I do that, I should start going to the office on a more regular basis. I am not sure that I am needed there anymore because Karl, Melissa and Mike seem to be getting along fine without me.
Special Projects July 27, 2020
Yes, I know. I missed a week again, and for that I am truly sorry. As you may know, I have been working on my Accounting for Manufacturing Database in Filemaker and I am working on the last module, Inventory. This is probably the second most complex module after payroll and it requires a lot of concentration. I hope to finish it in about two weeks and then I can start testing and debugging, which should take another two weeks. Then the real fun starts when I bring it on line.
In the mean time back at the shop, we are working on several special projects. The problem is when business is good and you can afford these projects, you are too busy. When business is slow, like it is now, you have plenty of time but no money. So we pick the projects that give us the most bang for the buck. We have a strip along the road which is maintained irregularly by the county. A few years back, we tried putting in some plants but the county just mowed them down and the weeds grew back up. This time, we did it right with weed barrier, mulch and shrubs. I think we probably still need to put up a “Do Not Mow” sign. We also repaired the chain post with a much bigger foundation. People come to the back of our building where it is dark and dump their trash. The last time, some one drove into the chain and pulled the post from the ground. If they do it again, it should cause a lot more damage to their vehicle. The last improvement project is repainting the block on our building for probably the first time in 40 years. Joe, our painter, has taken on the task and is doing a great job using rollers and brushes. We initially thought we were going to have to buy a sprayer but after only a week, he is half way done.
We also have some special projects for new and improved products but I can’t tell you about them yet.
Backup your backup of your backup. July 7, 2020
The three most important things to remember in real estate is location, location and location. The three most important things to remember on your computer is backup, backup and backup. As you might remember, I have been working on a major update to our database which controls all aspects of our company. My primary motivation for doing this was that the software was going to require a dedicated server and server software. The second reason was that Karl, my son, had his computer crash frequently when ever he was entering work orders. I initially thought that it was a problem with the way I had programmed it but, as you may also remember, it turned out to be a bad ethernet cable. Last week, I started working on the Work Order Module and, while I knew there were some problems, I did not realize how bad it was. Out of 14 years of data, only the last two months were not corrupted. I spent two days looking at the backups I had. No one backup had all of the data so I had to restore from four different backups, the first was a 2018 year end backup and the other three were from Time Machine’s incremental backups. Once I had identified those backups, it took me about a day to make a copy of the file with good data. That file was out of sync with our regular file by a couple of days but it only took about 15 minutes to update the regular file. Now our file is completely restored and I don’t feel anal about having so many backups. A few weeks ago, I told you I had 16 different backups. One of those backups is Time Machine which automatically makes hourly backups for the past 24 hours, daily backups for the past month, and weekly backups for all previous months. The oldest backups are deleted when the backup disk is full. I have also added a separate weekly back up schedule so instead of 16 backups, I will have as many as 67 plus the incremental Time Machine backup. After what I went through last week, that doesn’t seem excessive.
Previous Quarter Next Quarter