Skip to main content

Build a Spreadsheet by Georgianne

Dreaded words - build a spreadsheet. Well, at least they are dreaded by me but certainly not my husband, he's a whiz at those. Thank goodness I dragged the guy into working with me full time because I don't know what I'd do without him. Ok, back to the dreaded spreadsheet comment.... Actually, I love spreadsheets. I have no idea how to build them but man, I don't think I could live without them and so the inspiration for this business blog.

What spreadsheets do I use and love? Well, the hubby has built me a spreadsheet that I use for ordering wedding flowers. I put in the items needed such as bouquets, corsages, centerpieces, etc along with how many of each are needed. I fill in the flowers to be used, determine how many go in each and magically I get a grand flower total. As long as my math is good on giving the bride the correct number of flowers to fit the budget and I order that many flowers, everything works out perfectly. When the time comes to create each piece, I hand off my handy dandy spreadsheet to the designer and everything works out like a dream. No shorting the bride or stuffing the piece with extra flowers all done with very little hand holding being needed. The designer has everything he or she needs to create the wedding designs correctly.

Another spread sheet he built for me is one that I use for ordering my flowers each week. It breaks my order down to flowers, fillers, roses and greens and adds it all up so that I can stick to my budget. I send a copy to my wholesaler, put a copy in our incoming products book so the staff know what's coming in and when and then I can put my feet up and relax (just kidding on that one).

Anyway, I'd be happy to share a spreadsheet or two if you shoot me an email to georgianne@mondayflowers.com but truthfully, if you have a person at your company that is pretty good with Excel, they are easy to make. Sometimes the hardest part is making the connection between what can be done and how it can make your job easier!

Comments

Popular posts from this blog

Flash Reports, a Peek Inside Your Financials by Georgianne

Oh my.... Is it possible I'm taking the time to not only write a business blog today but I'm writing a blog about a topic that has to do with numbers? Wow, that's almost unheard of here at Monday Morning Flowers where the accounting is usually left up to Kevin and not me.

The last few weeks had Kevin and I traveling up to New England for the East Coast Floral Expo and then back down to Washington, DC for the Society of American Florist volunteer meetings and in both weekends, we spent lots of quality time with other florists. At the NEFE we were able to sit in on quite a few wonderful business seminars and we always take away so much from those events.

So, to the topic of this blog. About 3 years ago, we had a business consultant come into the operation to helps us with the "issues" we were having. Let's face it, it was during the recession and the environment at the shop was very stressful. I expressed a desire to understand what was going on with the com…

Incorporating a Little Kaizen by Kevin Vinicombe

A few weeks ago I made a point of discussing our Toss/Work Loss percentage with our Design Team. Over the summer months I noticed that our percentages had been "creeping" up. Basically when those percentages go up it could mean that we are “stuffing“ the arrangements with unpaid for flowers, tossing out too many flowers (perhaps proper rotation methods are not being followed) or we are purchasing too much for our current sales volume. I was trying to find a different approach with the staff and started thinking back to similar situations in my pre-floral career. I remembered the "Kaizen" concept I learned back in college. Kaizen was a concept I had used many times before in my previous corporate life.

Loosely defined Kaizen is the Japanese word for "Improvement" or "Change for Better". It's an ongoing, continuous process that never stops and teaches us to always look for a better, more efficient way to conduct our business. The process of co…

Shop to Shop

A lot of talk is happening right now in our industry about wire services, order gathers and the general condition of the flower business. I have many opinions on where we were and where we are going but this blog really isn't about that. My main concern right now is being able to handle my customers outgoing flower orders.
Truth be told, this past Mother's Day holiday became a nightmare. I know for sure, that there were nice, hard working shops out there that really wanted us to fill their orders and we wanted them to fill ours. The problem? Order gathers and even FTD.com completely choked up our computer systems by sending us orders for product that we did not have, below our stated minimums with unrealistic timelines. Yikes, we had orders coming in quicker than we could see if we could even do them to the point that my FTD mercury machine ended up being suspended for a good part of the holiday (not to mention that my modem broke and FTD was not able to get me a new one until…