1	Floral Shop Simulation Helen Teague, for OOPS: Our Overnight Planning System
2	Floral Shop Activity: Preparation Take out a sheet of paper and put your heading on it. Open a Word Document, Minimize the document window. Open an Excel window, Minimize the spreadsheet window.
3	Floral Shop Directions You will be responding to actual events in the operation of a floral store on its biggest holiday of the year. On your paper, number 1 and 2. For #1, name your floral shop. #2). Tell me how long you have been in business in our town.
4	Floral Shop Costs Create a spreadsheet for your bouquet costs using the data below. Use your business name as the title of the spreadsheet. Format attractively and Save the spreadsheet as “floralshop” Flowers~cost per dozen $4.00 Vases~ $.75 each • Plastic Wrapping~$.50 Ribbon~per bouquet $.50 Labor~$1.00 Gift Cards~ $.02
5	Floral Shop Delivery You estimate that each delivery will be no more than 10 miles round trip and that gas for deliveries will run $.85 per delivery. Add the gasoline category to your spreadsheet. Total the cost of all 7 expenses. This is what each bouquet will cost you. Save but don’t print.
6	Floral Shop Profit Projections #3.) How much money do you have to spend on bouquet contents if you have 250 orders placed already? Place this as your answer to #3. #4.) How much additional should you spend for additional, last-minute orders? #5.) If you want to make a 25% profit on each bouquet, what should you charge? Add an amount if you want to make a higher profit.
7	Floral Shop Advertisements Using MSWord, Clip Art, Word Art, AutoShapes and attractive colors and fonts, design an advertisement to run in our local paper advertising your bouquets and deliveries. Save as floralshopad. Do not print until your file is approved.
8	Floral Shop Production Est. #6.) As of today, you have an additional 25 orders for a total of 275 orders. It takes 10 minutes to construct one deliverable bouquet, how long will it take to construct all 275 orders?
9	Floral Shop Personnel #7. Can you create all 275 bouquets alone? #8. Do you need to take on part-time help? #8b.)If you decide to take on part-time help, where can you find someone on such short notice?
10	Floral Shop Considerations #9) You hear that a rival floral shop has just let one of their employees go. Should you give this employee a chance? Why or why not? #9b.)List at least 3 of the duties for which a floral shop employee must be responsible?
11	Floral Shop Order Processing Just hung up the phone: several members of the university fraternity saw your ad in the newspaper and ordered 100 bouquets for their sister sorority. #10.) Name at least 5 things you have to do and put each activity in the proper order of which needs to be done 1^st, 2^nd, 3^rd, 4^th, 5th. #11.) Does this change the decision you made in #9?
12	Floral Shop Hit by Paintballs On Friday, you arrive at your store and find the front display window case has been hit by paint balls. #12.) Name at least 5 things you have to do right now. Put each activity in the proper order of which needs to be done 1^st, 2^nd, 3^rd, 4^th, 5th.
13	Floral Shop Shipment Receipt After dealing with the paint ball incident, you unpack the delivery shipment and find that half of the vases in the shipment are broken. #13.) What do you do? Be specific.
14	Floral Shop Freeze Warning It is 6:00 pm and the meteorologist predicts an unexpected freeze. #14.) What are at least 3 preparations you need for your greenhouse? Be specific.
15	Floral Shop Sick Employee It is early morning on Saturday and your delivery guy calls in sick. #15.) It is your biggest/busiest day so far !!! All these orders!!! What do you do?
16	Floral Shop Delivery Route #16.) You decide to call the workforce commission for help. They send a driver. Given that you have 375 orders and each delivery run takes a minimum of 15 minutes, how many orders can your driver make in an hour? #17.) At this rate how long will it take to deliver all 375 orders? What can be done?
17	Floral Shop Delivery Est. #18.) Most people want their orders delivered by 2:00 pm. What can be done?
18	Floral Shop: Burning Daylight #19.) It is 4:00pm and 15 orders remain undelivered because no one was home or at their office to receive their bouquets. You promised delivery. What do you do?
19	Floral Shop Forget-Me-Nots It is midnight. You drag yourself home and remember that you have forgotten the flowers you promised your beloved. What do you do now? J