I need to help to complete with this Excel spreadsheet.

Here is the info needed to complete.

You are new district manager for burger fl. The vice president of finance requested from you an operating budget for a new store in Orlando.

The vp of finance provided you with the baseline operating budget as a benchmark, Based on the market research and expectations of performance a set of assumptions are given to you to develop the operating budget for the new store.

Based on the performance assumptions provided prepare the operating budget and provide the following information.

1 calculate sales

2 calculate cost

3 calculate gross profit

4 calculate controllable expenses

5 calculate other expenses ( occupancy costs, interest, depreciation, taxes)

6 calculate profits

7 calculate profit margin

AutoSave OFF Exam #1 Q2-A Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) ~ A A ab Wrap Text v ce V General . HE HA Insert v DX Delete Format v Paste BIU Merge & Center $ v % 9 68 69 Ideas Conditional Format Cell Formatting as Table Styles Styles Sort & Filter Find & Select Sensitivity Clipboard Font Alignment Number Cells Editing Ideas Sensitivity D9 X fx Food Sales for Hot Dogs will 1 by 4.3% B D E F G 2 3 4 BURGEREI Benchmark Figures New Store Forecast Assumptions $3,600,000.00 $600,000.00 $300,000.00 $900,000.00 $360,000.00 $240,000.00 $6,000,000.00 Food Sales for Burgers will by 6% Food Sales for Chicken Sandwiches will by 1.75% Food Sales for Hot Dogs will by 4.3% Food Sales for Fries & Onion Rings will by 6% Food Sales for Desserts will by 0.75% Food Sales for Shakes will by 2.5% Food Sales for Total Food Sales will by Ox $301,751.00 $359,941.00 $171,604.00 $720,000.00 $6,720,000.00 Beverage Sales for Coca-Cola Freestyle Drinks will by 3% Beverage Sales for Beer wil by 2.5% Beverage Sales for Wine will by 1.75% Calculate Total Beverage Sales Calculate TOTAL SALES Sales 5 6 Food Sales 7 Burgers 8 Chicken Sandwiches 9 Hot Dogs 10 Fries & Onion Rings 11 Desserts 12 Shakes 13 Total Food Sales 14 Beverage Sales 15 Coco-Cola Freestyle Drinks 16 Beer 17 Wine 18 Total Beverage Sales 19 TOTAL SALES 20 Cost of Sales 21 Cost of Food Sales 22 Burgers 23 Chicken Sandwiches 24 Hot Dogs 25 Fries & Onion Rings 26 27 Shakes 28 Total Cost of Food Sales 29 Cost of Beverage Sales 30 Coca-Cola Freestyle Drinks 31 Beer 32 Wine 33 Total Cost of Beverage Sales 34 TOTAL COST OF SALES 35 GROSS PROFIT 36 Controllable Expenses 37 Fixed Salaries and Wages 38 Variable Salaries, Wages, Benefits 39 Other Controllable Expenses 40 TOTAL CONTROLLABLE EXPENSES 41 INCOME BEFORE OCCINT,DEP, TAX 42 OCCUPANCY COST Budget A + $1,080,000.00 $168,000.00 $75,000.00 $207,000.00 $111,600.00 $64,800.00 $1,706,400.00 Cost of Food Sales for Burgers will be 30% of Burgers sales Cost of Food Sales for Chicken Sandwiches will be 28% of Chicken Sandwiches sales Cost of Food Sales for Hot Dogs will be 25% of Hot Dogs sales Cost of Food Sales for Fries & Onion Rings will be 23% of Fries & Onion Rings sales Cost of Food Sales for Desserts will be 31% of Desserts sales Cost of Food Sales for Shakes will be 27% of Shakes sales Calculate Total Cost of Food Sales Desserts $45,262.65 $71,988.20 $32,604.761 $149,855.61 $1,856,255.61 $4863,74439 Cost of Food Sales for Coca-Cola Freestyle Drinks will be 15% of Coca Cola Freestyle Drinks sales - Cost of Food Sales for Beer will be 20% of Beer sales Cost of Food Sales for Wine will be 19% of Wine sales Calculate Total Cost of Beverage Sales Calculate TOTAL COST OF SALES Calculate GROSS PROFIT $817,918.30 $2,016,000.0 $1,072,928.00 $3,906,846.36 $956,8980 $300.000.00l Controllable Expenses for Faed Salaries and Wages will by $50000 Controllable Expenses for Variable Salaries Wages, Benefits will be 30% of TOTAL SALES sales Controllable Expenses for Other Controllable Expenses will be Same Calculate TOTAL CONTROLLABLE EXPENSES Calculate INCOME BEFORE OCCJNT DEP TAX Controllable Expenses for OCCUPANCY COST will be same + 98% Exam #1 Q2-A AutoSave OFF OFF AESU- Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v AI ab Wrap Text v ce V General . IH HE Hv Insert v DX Delete Format v Paste BIU v A V $ % 9 Merge & Center Ideas 68 69 Conditional Format Cell Formatting as Table Styles Styles Sort & Filter Find & Select Sensitivity Clipboard Font Alignment Number Cells Editing Ideas Sensitivity D9 fx Food Sales for Hot Dogs will 1 by 4.3% D E F B >1,07228.00! $3,906,846.36 $956,898.03 $300,000.00 $125,000.00 $150,000.00 $381898.03 5.68% correre Toreroom Calculate TOTAL CONTROLLABLE EXPENSES Calculate INCOME BEFORE OCC. INT.DEP TAX Controllable Expenses for OCCUPANCY COST will be same Controllable Expenses for INTEREST will be same Controllable Expenses for DEPRECIATION will be same Calculate PROFIT Calculate PROFITMARGIN A w Uwer con Expenses 40 TOTAL CONTROLLABLE EXPENSES 41 INCOME BEFORE OCCINT,DEP, TAX 42 OCCUPANCY COST 43 INTEREST 44 DEPRECIATION 45 PROFIT 46 PROFIT MARGIN 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 Budget A + + 98% AutoSave OFF Exam #1 Q2-A Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) ~ A A ab Wrap Text v ce V General . HE HA Insert v DX Delete Format v Paste BIU Merge & Center $ v % 9 68 69 Ideas Conditional Format Cell Formatting as Table Styles Styles Sort & Filter Find & Select Sensitivity Clipboard Font Alignment Number Cells Editing Ideas Sensitivity D9 X fx Food Sales for Hot Dogs will 1 by 4.3% B D E F G 2 3 4 BURGEREI Benchmark Figures New Store Forecast Assumptions $3,600,000.00 $600,000.00 $300,000.00 $900,000.00 $360,000.00 $240,000.00 $6,000,000.00 Food Sales for Burgers will by 6% Food Sales for Chicken Sandwiches will by 1.75% Food Sales for Hot Dogs will by 4.3% Food Sales for Fries & Onion Rings will by 6% Food Sales for Desserts will by 0.75% Food Sales for Shakes will by 2.5% Food Sales for Total Food Sales will by Ox $301,751.00 $359,941.00 $171,604.00 $720,000.00 $6,720,000.00 Beverage Sales for Coca-Cola Freestyle Drinks will by 3% Beverage Sales for Beer wil by 2.5% Beverage Sales for Wine will by 1.75% Calculate Total Beverage Sales Calculate TOTAL SALES Sales 5 6 Food Sales 7 Burgers 8 Chicken Sandwiches 9 Hot Dogs 10 Fries & Onion Rings 11 Desserts 12 Shakes 13 Total Food Sales 14 Beverage Sales 15 Coco-Cola Freestyle Drinks 16 Beer 17 Wine 18 Total Beverage Sales 19 TOTAL SALES 20 Cost of Sales 21 Cost of Food Sales 22 Burgers 23 Chicken Sandwiches 24 Hot Dogs 25 Fries & Onion Rings 26 27 Shakes 28 Total Cost of Food Sales 29 Cost of Beverage Sales 30 Coca-Cola Freestyle Drinks 31 Beer 32 Wine 33 Total Cost of Beverage Sales 34 TOTAL COST OF SALES 35 GROSS PROFIT 36 Controllable Expenses 37 Fixed Salaries and Wages 38 Variable Salaries, Wages, Benefits 39 Other Controllable Expenses 40 TOTAL CONTROLLABLE EXPENSES 41 INCOME BEFORE OCCINT,DEP, TAX 42 OCCUPANCY COST Budget A + $1,080,000.00 $168,000.00 $75,000.00 $207,000.00 $111,600.00 $64,800.00 $1,706,400.00 Cost of Food Sales for Burgers will be 30% of Burgers sales Cost of Food Sales for Chicken Sandwiches will be 28% of Chicken Sandwiches sales Cost of Food Sales for Hot Dogs will be 25% of Hot Dogs sales Cost of Food Sales for Fries & Onion Rings will be 23% of Fries & Onion Rings sales Cost of Food Sales for Desserts will be 31% of Desserts sales Cost of Food Sales for Shakes will be 27% of Shakes sales Calculate Total Cost of Food Sales Desserts $45,262.65 $71,988.20 $32,604.761 $149,855.61 $1,856,255.61 $4863,74439 Cost of Food Sales for Coca-Cola Freestyle Drinks will be 15% of Coca Cola Freestyle Drinks sales - Cost of Food Sales for Beer will be 20% of Beer sales Cost of Food Sales for Wine will be 19% of Wine sales Calculate Total Cost of Beverage Sales Calculate TOTAL COST OF SALES Calculate GROSS PROFIT $817,918.30 $2,016,000.0 $1,072,928.00 $3,906,846.36 $956,8980 $300.000.00l Controllable Expenses for Faed Salaries and Wages will by $50000 Controllable Expenses for Variable Salaries Wages, Benefits will be 30% of TOTAL SALES sales Controllable Expenses for Other Controllable Expenses will be Same Calculate TOTAL CONTROLLABLE EXPENSES Calculate INCOME BEFORE OCCJNT DEP TAX Controllable Expenses for OCCUPANCY COST will be same + 98% Exam #1 Q2-A AutoSave OFF OFF AESU- Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v AI ab Wrap Text v ce V General . IH HE Hv Insert v DX Delete Format v Paste BIU v A V $ % 9 Merge & Center Ideas 68 69 Conditional Format Cell Formatting as Table Styles Styles Sort & Filter Find & Select Sensitivity Clipboard Font Alignment Number Cells Editing Ideas Sensitivity D9 fx Food Sales for Hot Dogs will 1 by 4.3% D E F B >1,07228.00! $3,906,846.36 $956,898.03 $300,000.00 $125,000.00 $150,000.00 $381898.03 5.68% correre Toreroom Calculate TOTAL CONTROLLABLE EXPENSES Calculate INCOME BEFORE OCC. INT.DEP TAX Controllable Expenses for OCCUPANCY COST will be same Controllable Expenses for INTEREST will be same Controllable Expenses for DEPRECIATION will be same Calculate PROFIT Calculate PROFITMARGIN A w Uwer con Expenses 40 TOTAL CONTROLLABLE EXPENSES 41 INCOME BEFORE OCCINT,DEP, TAX 42 OCCUPANCY COST 43 INTEREST 44 DEPRECIATION 45 PROFIT 46 PROFIT MARGIN 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 Budget A + + 98%