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

  1. I am glad to say that this is a very useful post for me. its superb and intresting.one of the best post on social media. This inspired to creating a new blog on flowers. Thanks for sharing wonderful information .
    Mother’s day delivery Philippines

    ReplyDelete
  2. Your blog is very valuable which you have shared here about flowers. I appreciate your efforts which you have put into this article and also it is a gainful article for me, your post gives me more idea to purchase different flowers. Thank you for sharing this article here. florist in Cambridge

    ReplyDelete
  3. A Flower delivery Fort Worth tx is a retail establishment that sells cut flowers and ornamental plants. Thanks for sharing.

    ReplyDelete
  4. Thank You for sharing this post. I really Like your content. Hope you will share more information about
    flower shops in San Jose

    ReplyDelete

  5. Nice post. Please Look, we are the
    Flower Shops in Boston
    .

    ReplyDelete

Post a Comment

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

Compete with Yourself

We have two sayings we're fond of at Monday Morning Flower & Balloon Co. "Keep your eye on your competition but don't become obsessed with them" and "compete with yourself".  The first saying is self explanatory but the second warrants further discussion. Competing with yourself can be pretty straight forward and help you develop a strong business model. Basically look at what you've done previously, both good and bad, and try to take corrective action if it's bad or repeat if it was good. This concept can be extended to most area's of your business including one of the toughest and most boring - Budgeting. There are lots of articles and books written about budgeting even some great spreadsheet templates available. Nevertheless, if you use the "compete with yourself" concept it's much easier. Of course you need to know what you should target as a percentage of sales for the main expenses, Payroll, COGS etc. Once you know where

Society of American Florists Convention

Society of American Florists Originally uploaded by Georgianne at Monday Morning Flowers It's been awhile since I've written a blog for Speaking Florally but it's not for lack of something to say! First off, I want to thank both Rick Canale and Mandy Majerik, AIFD for sharing the stage with me at the Orlando Conference last month. It was not only wonderful for me to pass on whatever tips I had about Social Networking for Florists but it was wonderful to learn from them as well. Ok, which brings me to the point of this blog. What a wonderful time at the Conference I had. Kevin and I met so many amazing people and how inspiring they were! People that I have read about for years in the pages of floral magazines became real people to me. If you are in the floral industry and you are not a member of SAF, then you must become a member right away. I'm not going to twist your arm I'm going to let you find out for yourself. Visit their website at http://www.safnow.org/