I need to help to complete this excel speed sheet. Here is the info needed to complete. You are new district manager for burger fl. Next month is the grand opening a new store in Orlando. The vice president of operations requested from you the forecast of sales and costs. He also wants to have an idea of how much product is needed for opening week. You are provided with a the list of menu items the selling price, the food cost%, and the standard portions size for each menu item. The vp of operations is waiting for you call to discuss your findings. Based on the performance of previous stores the assumptions are Expected number of customers will be 1250 per day. The consumption factor for burgers and sandwiches will be 85 % The consumption factor for shakes and custard will be 30 % The consumption factor for fries and rings will be 65% Provide the following information What are the number of items sold by category per week? What are the total sales for opening week? What is the total food cost in $ for opening week ? What are the amount of needed for all the menu items per week? What is the average check?
ab Wrap Text Paste General BIU BE a var Merge & Center Clipboard $ % 9 98 00 Font J29 Alignment Conditional Format Cel Formatting as Table Style Styles fx Total Amount Needed in Pounds Number D E E F G H 1 L Chicken Parmesan Chicken Breast Supreme Rossini thicken Breast Supreme Formage Chicken Supreme Cacciatore Montego Bay Chicken Supreme Lemon Herb Chicken Supreme Broiled Smoked Pork Chop Roasted Pork Lain Juslie Roasted Stuffed Pork Loin Sacciacta A B 78 Sam's Lobster Roll Beer Batter Fried Prawns 79 Cioppino 80 22.95 Crab Cakes Delicious Maine lobster lightly tossed with butter on a toasted 81 specialty bun, potato chips and coleslaw Shrimp Scampi and Linguini 82 Shrimp Scampi and Linguini Jumbo Prawns Stuffed B3 Manilla Clams with Linguini 84 22 Sam's Lobster Roll 85 White wine, garlic, butter, and fresh herbs Seafood Paella 86 Manilla Clams with Linguini Seafood Risotto 87 Seafood Spaghetti 88 22 Shrimp Scampi and Linguini 89 Italian pancetta, leeks, chili flake and fresh thyme 90 Seafood Spaghetti 91 92 23.95 Prawns, mussels, clams, fresh fish and bay scallops in a spicy 93 tomato sauce 94 Seafood Risotto 95 96 24.95 Octopus, bay shrimp, scallops, mussels and clams with tomato 97 and fresh herbs 98 Cioppino 99 100 26.95 Savory shellfish stew with cracked Dungeness crab, prawns, 101 mussels, clams and rock fish 102 Jumbo Prawns Stuffed 103 104 26.95 With Dungeness crab and wrapped in smoked bacon with roasted garlic mashed potatoes, daylight farms Italian chard and a 105 creamy horseradish sauce 106 Crab Cakes 107 108 2395 Crispy fried outside with moist Interior, coleslaw, Old Bay fries 109 and remoulade sauce 110 Seafood Paella 111 112 34.95 Traditional Spanish rice, day boot scallops, prowns, mussels, 113 clams, calamori, saffron and smoked paprika 114 Beer Batter Fried Prawns 115 116 22.95 Q1-C + X Calibri (Body) V 11 ' ab Wrap Text General Lv DET X De Paste BIU V a. Av 60 $ % 9 Merge & Center .00 000 Conditional Format Cell Formatting as Table Styles Styles Fo Clipboard Font Alignment Number Ce J29 X fx Total Amount Needed in Pounds B C D E F G H K L M N 1 2 A Total Customers per day Customers buying Burgers and Sandwiches BURGES # Sold Total Customers per week Consuption Factor (Burgers and Sadwiches) Total Sales In Total Food Cast in Menu Mix $$ $$ 20% Selling Price Food Cost Ingredient and Portion Size in Oz. Total Amount Needed in Pounds 6 18% 11% 3% 6 6 12 4 BURGERFI CHEESEBURGER 5 BURGERFI BURGER 6 BURGERFI BACON CHEESEBURGER 7 THE CEO 8 BREAKFAST ALL DAY BURGER 9 CONFLICTED BURGER 10 VEGEFI BURGER 11 BEYOND BURGER 12 GRILLED CHICKEN SANDWICH 13 FED CHICKEN SANDWICH 14 15 Customers buying Shakes and Custards $6.59 $5.99 $6.99 $7.99 $7.29 $7.89 $7.69 $7.39 $7.19 $7.19 25% 29% 30% 32% 26% 32% 32% 34% Ground Meat Ground Meat Ground Meat Ground Meat Ground Meat Ground Meat 2X 6 12 7% 7% 5% 15% 12% 28% 4 Chicken Breast Chicken Breast 35% 4 #Sold Selling Price Food Cost% Ingredient and Portion Size in Oz Total Amount Needed in Gallons Consuption Factor (Shakes and Custards)) Total Sales in Total Food Cost in $$ Menu Mix S$ 15% 15% 13% 3% 2% SHAKES AND CUSTARDS 16 17 CUSTARD CUPS VANILLA (small) 18 CUSTARD CUPS CHOCHOLATE (Large) 19 CUSTARD CUPS CHOCOLATE (small) 20 CUSTARD CUPS VANILLA (large) 21 VANILLA SHAKES 22 CHOCOLATE SHAKES 23 OREAO SHAKES 24 RED VELVET SHAKES 25 O.M.C. Concretes 26 KEY LIME Concretes 27 28 Customers buying Fries and Rings $4,49 $5.79 $4.49 $5.79 $5.19 $5.19 $5.39 $4.99 $6.29 $6.29 25% 35% 27% 33% 32% 26% 32% Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix 12 18 12 18 16 16 16 16 10 10 8% 8% 5% 26% 28% 28% 18% 14% Consuption Factor (Fries and Rings) Total Food Cost In Menu Mix $$ # Sold Total Sales In SS Selling Price Ingredient and Portion Size in Oz. Total Amount Needed in Pounds Food Cost 30% % 33% FRIES AND RINGS 29 30 HAND-CUT FRIES (Small) 31 HAND-CUT FRIES (Large) 32 HAND-CUT FRIES (Family) 33 ONION RINGS (Small) 34 ONION RINGS (Large) 35 36 37 $3.59 $4.69 $6.99 $4.69 $5.49 25% 18% 11% 27% 28% 35% French Fries French Fries French Fries Onion Rings 12 18 24 16 32% 18% Onion Ring 24 Total Sales Total Costs Average Check 39 40 41 42 43 45 > Q1-C + ab Wrap Text Paste General BIU BE a var Merge & Center Clipboard $ % 9 98 00 Font J29 Alignment Conditional Format Cel Formatting as Table Style Styles fx Total Amount Needed in Pounds Number D E E F G H 1 L Chicken Parmesan Chicken Breast Supreme Rossini thicken Breast Supreme Formage Chicken Supreme Cacciatore Montego Bay Chicken Supreme Lemon Herb Chicken Supreme Broiled Smoked Pork Chop Roasted Pork Lain Juslie Roasted Stuffed Pork Loin Sacciacta A B 78 Sam's Lobster Roll Beer Batter Fried Prawns 79 Cioppino 80 22.95 Crab Cakes Delicious Maine lobster lightly tossed with butter on a toasted 81 specialty bun, potato chips and coleslaw Shrimp Scampi and Linguini 82 Shrimp Scampi and Linguini Jumbo Prawns Stuffed B3 Manilla Clams with Linguini 84 22 Sam's Lobster Roll 85 White wine, garlic, butter, and fresh herbs Seafood Paella 86 Manilla Clams with Linguini Seafood Risotto 87 Seafood Spaghetti 88 22 Shrimp Scampi and Linguini 89 Italian pancetta, leeks, chili flake and fresh thyme 90 Seafood Spaghetti 91 92 23.95 Prawns, mussels, clams, fresh fish and bay scallops in a spicy 93 tomato sauce 94 Seafood Risotto 95 96 24.95 Octopus, bay shrimp, scallops, mussels and clams with tomato 97 and fresh herbs 98 Cioppino 99 100 26.95 Savory shellfish stew with cracked Dungeness crab, prawns, 101 mussels, clams and rock fish 102 Jumbo Prawns Stuffed 103 104 26.95 With Dungeness crab and wrapped in smoked bacon with roasted garlic mashed potatoes, daylight farms Italian chard and a 105 creamy horseradish sauce 106 Crab Cakes 107 108 2395 Crispy fried outside with moist Interior, coleslaw, Old Bay fries 109 and remoulade sauce 110 Seafood Paella 111 112 34.95 Traditional Spanish rice, day boot scallops, prowns, mussels, 113 clams, calamori, saffron and smoked paprika 114 Beer Batter Fried Prawns 115 116 22.95 Q1-C + X Calibri (Body) V 11 ' ab Wrap Text General Lv DET X De Paste BIU V a. Av 60 $ % 9 Merge & Center .00 000 Conditional Format Cell Formatting as Table Styles Styles Fo Clipboard Font Alignment Number Ce J29 X fx Total Amount Needed in Pounds B C D E F G H K L M N 1 2 A Total Customers per day Customers buying Burgers and Sandwiches BURGES # Sold Total Customers per week Consuption Factor (Burgers and Sadwiches) Total Sales In Total Food Cast in Menu Mix $$ $$ 20% Selling Price Food Cost Ingredient and Portion Size in Oz. Total Amount Needed in Pounds 6 18% 11% 3% 6 6 12 4 BURGERFI CHEESEBURGER 5 BURGERFI BURGER 6 BURGERFI BACON CHEESEBURGER 7 THE CEO 8 BREAKFAST ALL DAY BURGER 9 CONFLICTED BURGER 10 VEGEFI BURGER 11 BEYOND BURGER 12 GRILLED CHICKEN SANDWICH 13 FED CHICKEN SANDWICH 14 15 Customers buying Shakes and Custards $6.59 $5.99 $6.99 $7.99 $7.29 $7.89 $7.69 $7.39 $7.19 $7.19 25% 29% 30% 32% 26% 32% 32% 34% Ground Meat Ground Meat Ground Meat Ground Meat Ground Meat Ground Meat 2X 6 12 7% 7% 5% 15% 12% 28% 4 Chicken Breast Chicken Breast 35% 4 #Sold Selling Price Food Cost% Ingredient and Portion Size in Oz Total Amount Needed in Gallons Consuption Factor (Shakes and Custards)) Total Sales in Total Food Cost in $$ Menu Mix S$ 15% 15% 13% 3% 2% SHAKES AND CUSTARDS 16 17 CUSTARD CUPS VANILLA (small) 18 CUSTARD CUPS CHOCHOLATE (Large) 19 CUSTARD CUPS CHOCOLATE (small) 20 CUSTARD CUPS VANILLA (large) 21 VANILLA SHAKES 22 CHOCOLATE SHAKES 23 OREAO SHAKES 24 RED VELVET SHAKES 25 O.M.C. Concretes 26 KEY LIME Concretes 27 28 Customers buying Fries and Rings $4,49 $5.79 $4.49 $5.79 $5.19 $5.19 $5.39 $4.99 $6.29 $6.29 25% 35% 27% 33% 32% 26% 32% Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix Frozen Dessert Mix 12 18 12 18 16 16 16 16 10 10 8% 8% 5% 26% 28% 28% 18% 14% Consuption Factor (Fries and Rings) Total Food Cost In Menu Mix $$ # Sold Total Sales In SS Selling Price Ingredient and Portion Size in Oz. Total Amount Needed in Pounds Food Cost 30% % 33% FRIES AND RINGS 29 30 HAND-CUT FRIES (Small) 31 HAND-CUT FRIES (Large) 32 HAND-CUT FRIES (Family) 33 ONION RINGS (Small) 34 ONION RINGS (Large) 35 36 37 $3.59 $4.69 $6.99 $4.69 $5.49 25% 18% 11% 27% 28% 35% French Fries French Fries French Fries Onion Rings 12 18 24 16 32% 18% Onion Ring 24 Total Sales Total Costs Average Check 39 40 41 42 43 45 > Q1-C +
