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…

7 Years ~ How Can That Be?

I started this blog in 2009 to share my somewhat limited business knowledge with the floral public and how can it possibly be that it's been over 7 years since my last post? Oh gosh ~ just looking at that skinny me from 2012 makes me feel... well, I'm not sure what I feel but it isn't the best feeling! Oh well, you just attend a Farm to Vase event, stick some greens made by J Schwanke on your head and take a new picture, right?
This morning while driving into work listening to Marketing Matters on Business Radio (Sirius XM Business Radio Channel 132) I felt inspired to write another floral related business blog. You know how that is, you are in the shower and have a great idea for your business and you promise yourself that as soon as you get to work that you will put that plan in action.... Yeah, right. You walk in, the phone rings, a customer needs flowers, an employee asks you a question, you notice that your wedding flowers that came in yesterday for this weekend look …

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…