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

Draw Home Insert Formulas Page Layout Data View Tell me Review X Calibri (Body) Carrara V 9 Wrap Text & A ' ' Paste BIU v = = A v v += = Conditional Formatting Merge & Center Font Alignment Clipboard Huger D9 fx Food Sales for Hot Dogs will 1 by 4.3% C D A 4 Benchmark Figures New Store Forecast Assumptions $3,600,000.00 $600,000.00 $300,000.00 $900,000.00 $350,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 0% $301,751.00 $359,941.00 $171604.00 $720,000.00 $6,720,000.00 Beverage Sales for Coca-Cola Freestyle Drinks will + by 3% Beverage Sales for Beer will 1 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 Coca-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 wa 24 Hot Dogs 25 Fries & Onion Rings Dec 26 Desserts 27 Shares 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 43 INTEREST 44 DEPRECIATION $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 $45,262.65 $71.988.20 $32,604.76 $149,855,61 $1,856,255.61 $4,863,744.39 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 Winesales Calculate Total Cost of Beverage Sales Calculate TOTAL COST OF SALES Calculate GROSS PROFIT $817,918.36 $2,016,000.00 $1,072928.00 $3,906,846.36 $956,898.03 $300,000.00 $125,000.00 $150,000.00 Controllable Expenses for Fixed Salaries and Wages will by $S2000 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 OCCINT,DEP TAX Controllable Expenses for OCCUPANCY COST will be same Controllable Expenses for INTEREST will be same Controllable Expenses for DEPRECIATION will be same Budget A + esc 0 Ba 090 F1 F2 F3 F4 F5 F6 67 FB 2 A ! 1 #3 $ 4 % 5 2 6 7 8 Q W E R T Y tob Fem 192 Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 9 ' ab Wrap Text Corral Paste BIU v a. Av Merge & Carter % 9 0 00 Condit Forma Clipboard Font Alignment Number D9 Xfx Food Sales for Hot Dogs will by 4.3% A B C D $300,000.00 $125,000.00 $150,000.00 $381,898.03 5.68% 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 PROFIT MARGIN 42 OCCUPANCY COST 43 INTEREST 44 DEPRECATION 45 PROFIT 46 PROFIT MARGIN 47 48 49 SO 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 85 86 87 Budget A + esc 8 H. FT 000 000 F F4 F2 F3 F5 F6 97 A #3 % 5 1 2 & 7 4. 6 & Q W E R T Y tab