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?

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 + J29 Xfx Total Amount Needed in Pounds Alignment Number Styles c B D E F G H L M N + 114 Beer Batter Fried Prawns 115 116 22.95 Old Bay seasoned fries and coleslaw fried seafood combination 117 Fried Seafood Combination: Calamari, Prawns, Crab Cake and 118 Pollock 119 120 29.95 121 Served with Old Bay fries and coleslaw 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 129 served with mozzarella and Romano cheeses and covered in Rastrelli's rich tomato sauce. A roasted 10oz. whole chicken breast with drummette attached. Served in a light red wine sauce with expertly sauted onions and mushrooms. A roasted 10oz. whole chicken breast with drummette attached. Served with sauted broccoli, mushrooms, red onions and covered with Colby and Mozzarella cheeses. A roasted 10oz. whole chicken breast with drummette attached. Green peppers, tomatoes, mushrooms, red onions, garlic and white wine give this chicken breast a phenomenal flavor A roasted 1002, whole chicken breast with drummette attached. Served with pineapple and red peppers, Sauted onions and our own sweet sauce to give this an A roasted 10oz. whole chicken breast with drummette attached. Covered in a zesty lemon and herb seasoning 140 141 142 Chicken Parmesan 143 Chicken Breast Supreme Rossini 144 Chicken Breast Supreme Formage 145 Chicken Supreme Cacciatore 146 Montego Bay Chicken Supreme 147 Lemon Herb Chicken Supreme 148 Pork 149 Broiled Smoked Pork Chop 150 Roasted Pork Loin Juslie 151 Roasted Stuffed Pork Loin Sacclacta 152 153 154 155 156 157 158 A thick full pork We then cut a 12oz.chop and broil it to enhance the flavar. Fresh boneless pork loin slowly roasted with fresh garlic, salt, pepper and rosemary Fresh boneless pork loin stuffed with Italian sausage and slowly roasted with fresh garlic, 159 01-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 + J29 Xfx Total Amount Needed in Pounds Alignment Number Styles c B D E F G H L M N + 114 Beer Batter Fried Prawns 115 116 22.95 Old Bay seasoned fries and coleslaw fried seafood combination 117 Fried Seafood Combination: Calamari, Prawns, Crab Cake and 118 Pollock 119 120 29.95 121 Served with Old Bay fries and coleslaw 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 129 served with mozzarella and Romano cheeses and covered in Rastrelli's rich tomato sauce. A roasted 10oz. whole chicken breast with drummette attached. Served in a light red wine sauce with expertly sauted onions and mushrooms. A roasted 10oz. whole chicken breast with drummette attached. Served with sauted broccoli, mushrooms, red onions and covered with Colby and Mozzarella cheeses. A roasted 10oz. whole chicken breast with drummette attached. Green peppers, tomatoes, mushrooms, red onions, garlic and white wine give this chicken breast a phenomenal flavor A roasted 1002, whole chicken breast with drummette attached. Served with pineapple and red peppers, Sauted onions and our own sweet sauce to give this an A roasted 10oz. whole chicken breast with drummette attached. Covered in a zesty lemon and herb seasoning 140 141 142 Chicken Parmesan 143 Chicken Breast Supreme Rossini 144 Chicken Breast Supreme Formage 145 Chicken Supreme Cacciatore 146 Montego Bay Chicken Supreme 147 Lemon Herb Chicken Supreme 148 Pork 149 Broiled Smoked Pork Chop 150 Roasted Pork Loin Juslie 151 Roasted Stuffed Pork Loin Sacclacta 152 153 154 155 156 157 158 A thick full pork We then cut a 12oz.chop and broil it to enhance the flavar. Fresh boneless pork loin slowly roasted with fresh garlic, salt, pepper and rosemary Fresh boneless pork loin stuffed with Italian sausage and slowly roasted with fresh garlic, 159 01-C +