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?

2 Exam #1 Q1-C (2) AutoSave OFF OFF EU- Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 ~ A A ab Wrap Text v General HE Hv Insert 9X Delete Paste BIU A Merge & Center V $ v % 9 6.80 Ideas Conditional Format Cell Formatting as Table Styles Styles Sort & Filter Sensitivity Format v Find & Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity J29 fx Total Amount Needed in Pounds D E F H K M N P Q R S S T U V 1 2 Total Customers per day Customers buying Burgers and Sandwiches BURGES # Sold Selling Prike Food Cost Total Customers per week Consuption Factor (Burgers and Sadwiches Total Sales in Total Food Cost in $$ $$ Menu Max 20% 18% 11% Ingredient and Portion Sure in Os Total Amount Needed in Pounds 25% 29% 6 3% $6.59 $5.99 $6.99 $7.99 $7.29 $7.89 $7.69 $7.39 $7.19 $7.19 Ground Meat Ground Meat Ground Me Ground Me Ground Me Ground Meat % 32% 26% 32% 2% 7% 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 Custard 12 6 12 32% 7% 5% 28% 35% % 15% 12% Chicken Breast Chicken Breast Sold Selling Price Food Cost% Consuption Factor (Shakes and Custards) Total Sales in Total Food Costin SS Menu M SS 15% Ingredient and Portion Sure in Os Total Amount Needed in Gallons 25% 27% 33% 13% 3% $4.49 $5.79 $4.49 $5.79 $5.19 $5.19 $5.39 $4.99 $6.29 $6.29 32% 26% 32% 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 OREAD SHAKES 24 RED VELVET SHAKES 25 OMC. Concretes 26 KEY LIME Concretes 27 28 Customers buying Fries and Rings 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 2% 8% 8% Frozen Dessert Me Frozen Dessert Me Frozen Dessert Me Frozen Dessert Mix Frozen Dessert Mix Freren Dessert Mix Frozen Dessert Me Froren Dessert Mix Frozen Dessert Mix Froren Dessert Mix 12 18 12 18 16 16 16 16 10 10 26% 28% 28% 5% 18% 14% Sold Selling Price Food Cost Ingredient and Portion Size in og Total Amount Needed in Pounds $3.59 $4.69 $ $6.99 $4.59 $5.49 12 18 Consuption Factor Fries and Rings) Total Sales in Total Food Costin Menu Mb SS SS 25% 15% 11% 27% 18% 30% 33% 28% 35% 32% French Fries French Fries French Fries Onion Rings Onion Rings 24 16 24 Total Sales Total Costs Average Check 37 38 39 40 41 42 43 44 45 Q1-C + + 85% Exam #1 Q1-C (2) AutoSave OFF OFF EU- Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 ~ A A ab Wrap Text v General IH HE Hv Insert v 9X Delete Paste BIU A V $ v % Merge & Center Ideas 6.80 Format v Conditional Format Cell Formatting as Table Styles Styles Sort & Filter Sensitivity Find & Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity J29 fx Total Amount Needed in Pounds D E F H 1 K M N O P Q R S T U V Chicken Parmesan Chicken Breast Supreme Rossini Chicken Breast Supreme Formage Chicken Supreme Cacciatore Montego Bay Chicken Supreme Lemon Herb Chicken Supreme Peeled Smoked Pork Chop Roasted Pork Loin Julie Roasted Stuffed Pork Loin Sacciata A 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 83 Manilla Clams with Linguini 84 22 Sam's Lobster Roll 85 White wine garlic, butter, and fresh herbs Seafood Paello 86 Manilla Clams with tinguin Seafood Risotto 87 Seafood Spaghetti 88 22 Shrimp Scampi and Linguin 89 Italian pancetto, leeks, chi floke and fresh thyme 90 Seafood Spaghetti 91 92 23.95 Prowns, mussels, clams, fresh fish and boy scallops in a spicy 93 tomato sauce 94 Seafood Risotto 95 96 24.95 Octopus, bay shrimp, scallops, mussels and cloms with tomato 97 and fresh herbs 98 Cioppino 99 100 26.95 Sovory shelfish stew with cracked Dungeness crab, prowns, 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 forms Italian chard and a 105 creamy horseradish sauce 106 Crab Cakes 107 108 23.95 Crispy fried outside with most interior, coleslow, Old Boyfries 109 and remoulade sauce 110 Seafood Paella 111 112 34.95 Traditional Spanish rice, day boat scallops, prowns, mussels, 113 clams, calamari, soffron and smoked paprika 114 Beer Batter Fried Prawn's 115 116 22.95 Q1-C + + 85% Exam #1 Q1-C (2) AutoSave OFF OFF EU- Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 . - AP ab Wrap Text v General LE HE Hv Insert DX Delete Paste BIU CA Merge & Center V $ % % 6.80 Ideas Find & Select Format Sort & Filter Sensitivity Conditional Format Cell Formatting as Table Styles Styles Font Alignment Number Cells Editing Ideas Sensitivity Clipboard J29 x fx Total Amount Needed in Pounds A D E H H 1 M N O P Q R s T U V 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 Boyfries and coleslaw 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 Chicken Parmesan served with mozzarella and Romano cheeses and covered in Rastreif's rich tomato sauce 143 Chicken Breast Supreme Rossini A roasted 1002. whole chicken breast with drummette attached. Served in a light red wine sauce with expertly sauted onions and mushrooms. 144 Chicken Breast Supreme Formace A roasted 1002 whole chicken breast with drummette attached, Served with sauted broccoli, mushrooms, red onions and covered with Colby and Mozzarella cheeses. 145 Chicken Supreme Cacciatore A roasted 100 whole chicken breast with drummette attached. Green peppers, tomatoes, mushrooms, red onions, garlic and white wine give this chicken breast a phenomenal flavor. 146 Montego Bay Chicken Supreme A roasted 100% whole chicken breast with drummette attached. Served with pineapple and red peppers, sauted onions and our own sweet sauce to give this an 147 Lemon Herb Chicken Supreme Aroasted 100 whole chicken breast with drummette attached. Covered in a zesty lemon and herb seasoning 148 Pork 149 Brolled Smoked Pork Chop Athick full pork We then cut a 1203chop and broil it to enhance the flavor. 150 Roasted Pork loin Julie Fresh boneless pork loin slowly roasted with fresh garlic, salt, pepper and rosemary 151 Roasted Stuffed Pork Loin Saccata Fresh boneless pork loin stuffed with Italian sausage and slowly roasted with fresh garlic, 152 153 154 155 156 157 158 159 Q1-C + + 85% 2 Exam #1 Q1-C (2) AutoSave OFF OFF EU- Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 ~ A A ab Wrap Text v General HE Hv Insert 9X Delete Paste BIU A Merge & Center V $ v % 9 6.80 Ideas Conditional Format Cell Formatting as Table Styles Styles Sort & Filter Sensitivity Format v Find & Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity J29 fx Total Amount Needed in Pounds D E F H K M N P Q R S S T U V 1 2 Total Customers per day Customers buying Burgers and Sandwiches BURGES # Sold Selling Prike Food Cost Total Customers per week Consuption Factor (Burgers and Sadwiches Total Sales in Total Food Cost in $$ $$ Menu Max 20% 18% 11% Ingredient and Portion Sure in Os Total Amount Needed in Pounds 25% 29% 6 3% $6.59 $5.99 $6.99 $7.99 $7.29 $7.89 $7.69 $7.39 $7.19 $7.19 Ground Meat Ground Meat Ground Me Ground Me Ground Me Ground Meat % 32% 26% 32% 2% 7% 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 Custard 12 6 12 32% 7% 5% 28% 35% % 15% 12% Chicken Breast Chicken Breast Sold Selling Price Food Cost% Consuption Factor (Shakes and Custards) Total Sales in Total Food Costin SS Menu M SS 15% Ingredient and Portion Sure in Os Total Amount Needed in Gallons 25% 27% 33% 13% 3% $4.49 $5.79 $4.49 $5.79 $5.19 $5.19 $5.39 $4.99 $6.29 $6.29 32% 26% 32% 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 OREAD SHAKES 24 RED VELVET SHAKES 25 OMC. Concretes 26 KEY LIME Concretes 27 28 Customers buying Fries and Rings 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 2% 8% 8% Frozen Dessert Me Frozen Dessert Me Frozen Dessert Me Frozen Dessert Mix Frozen Dessert Mix Freren Dessert Mix Frozen Dessert Me Froren Dessert Mix Frozen Dessert Mix Froren Dessert Mix 12 18 12 18 16 16 16 16 10 10 26% 28% 28% 5% 18% 14% Sold Selling Price Food Cost Ingredient and Portion Size in og Total Amount Needed in Pounds $3.59 $4.69 $ $6.99 $4.59 $5.49 12 18 Consuption Factor Fries and Rings) Total Sales in Total Food Costin Menu Mb SS SS 25% 15% 11% 27% 18% 30% 33% 28% 35% 32% French Fries French Fries French Fries Onion Rings Onion Rings 24 16 24 Total Sales Total Costs Average Check 37 38 39 40 41 42 43 44 45 Q1-C + + 85% Exam #1 Q1-C (2) AutoSave OFF OFF EU- Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 ~ A A ab Wrap Text v General IH HE Hv Insert v 9X Delete Paste BIU A V $ v % Merge & Center Ideas 6.80 Format v Conditional Format Cell Formatting as Table Styles Styles Sort & Filter Sensitivity Find & Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity J29 fx Total Amount Needed in Pounds D E F H 1 K M N O P Q R S T U V Chicken Parmesan Chicken Breast Supreme Rossini Chicken Breast Supreme Formage Chicken Supreme Cacciatore Montego Bay Chicken Supreme Lemon Herb Chicken Supreme Peeled Smoked Pork Chop Roasted Pork Loin Julie Roasted Stuffed Pork Loin Sacciata A 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 83 Manilla Clams with Linguini 84 22 Sam's Lobster Roll 85 White wine garlic, butter, and fresh herbs Seafood Paello 86 Manilla Clams with tinguin Seafood Risotto 87 Seafood Spaghetti 88 22 Shrimp Scampi and Linguin 89 Italian pancetto, leeks, chi floke and fresh thyme 90 Seafood Spaghetti 91 92 23.95 Prowns, mussels, clams, fresh fish and boy scallops in a spicy 93 tomato sauce 94 Seafood Risotto 95 96 24.95 Octopus, bay shrimp, scallops, mussels and cloms with tomato 97 and fresh herbs 98 Cioppino 99 100 26.95 Sovory shelfish stew with cracked Dungeness crab, prowns, 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 forms Italian chard and a 105 creamy horseradish sauce 106 Crab Cakes 107 108 23.95 Crispy fried outside with most interior, coleslow, Old Boyfries 109 and remoulade sauce 110 Seafood Paella 111 112 34.95 Traditional Spanish rice, day boat scallops, prowns, mussels, 113 clams, calamari, soffron and smoked paprika 114 Beer Batter Fried Prawn's 115 116 22.95 Q1-C + + 85% Exam #1 Q1-C (2) AutoSave OFF OFF EU- Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 . - AP ab Wrap Text v General LE HE Hv Insert DX Delete Paste BIU CA Merge & Center V $ % % 6.80 Ideas Find & Select Format Sort & Filter Sensitivity Conditional Format Cell Formatting as Table Styles Styles Font Alignment Number Cells Editing Ideas Sensitivity Clipboard J29 x fx Total Amount Needed in Pounds A D E H H 1 M N O P Q R s T U V 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 Boyfries and coleslaw 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 Chicken Parmesan served with mozzarella and Romano cheeses and covered in Rastreif's rich tomato sauce 143 Chicken Breast Supreme Rossini A roasted 1002. whole chicken breast with drummette attached. Served in a light red wine sauce with expertly sauted onions and mushrooms. 144 Chicken Breast Supreme Formace A roasted 1002 whole chicken breast with drummette attached, Served with sauted broccoli, mushrooms, red onions and covered with Colby and Mozzarella cheeses. 145 Chicken Supreme Cacciatore A roasted 100 whole chicken breast with drummette attached. Green peppers, tomatoes, mushrooms, red onions, garlic and white wine give this chicken breast a phenomenal flavor. 146 Montego Bay Chicken Supreme A roasted 100% whole chicken breast with drummette attached. Served with pineapple and red peppers, sauted onions and our own sweet sauce to give this an 147 Lemon Herb Chicken Supreme Aroasted 100 whole chicken breast with drummette attached. Covered in a zesty lemon and herb seasoning 148 Pork 149 Brolled Smoked Pork Chop Athick full pork We then cut a 1203chop and broil it to enhance the flavor. 150 Roasted Pork loin Julie Fresh boneless pork loin slowly roasted with fresh garlic, salt, pepper and rosemary 151 Roasted Stuffed Pork Loin Saccata Fresh boneless pork loin stuffed with Italian sausage and slowly roasted with fresh garlic, 152 153 154 155 156 157 158 159 Q1-C + + 85%