You are asked to prepare a forecasted budget for "Le Bistrot" coffee shop at Kaslik area knowing that it opens at breakfast, lunch and dinner time. It has a capacity of 85 seats and closes every Monday as per the decision of the owners/operators.After doing a market study, SWOT analysis, density per square meter and competitors pricing strategy, you came out with the following estimations: 1. Turnover rate breakfast 150%, with an average check of 8$2. 2. Turnover rate Lunch-200%, with an average check of 16 $3. 3. Turnover rate Dinner-70%, with an average check of 18 $ A-You are requested to prepare a forecasted revenue for "le Bistrot" coffee shop for the first year of operation based on the above mentioned figures. B-You are requested to prepare an income statement and to calculate the GOP of "Le Bistrot" coffee shop as per the international standard given the following information: a. Salaries-25 % from sales b. Rent-6 % from sales c. F&B=27 % from sales d. Utilities=2 % from sales e. Telephone=4000 $ f. Insurance=2 % from sales g. Stationary-2800 $ h. Advertising & Marketing-3 % from sales i. Laundry-8000 $ j. Payroll taxes-0.5 % from sales k. Repairs & Maintenance-2 % from sales N.B; YOU ANSWERS MUST BE ON AN EXCEL SHEET AND THEN BROWSE IT TO THE FILE. You are asked to prepare a forecasted budget for "Le Bistrot" coffee shop at Kaslik area knowing that it opens at breakfast, lunch and dinner time. It has a capacity of 85 seats and closes every Monday as per the decision of the owners/operators.After doing a market study, SWOT analysis, density per square meter and competitors pricing strategy, you came out with the following estimations: 1. Turnover rate breakfast 150%, with an average check of 8$2. 2. Turnover rate Lunch-200%, with an average check of 16 $3. 3. Turnover rate Dinner-70%, with an average check of 18 $ A-You are requested to prepare a forecasted revenue for "le Bistrot" coffee shop for the first year of operation based on the above mentioned figures. B-You are requested to prepare an income statement and to calculate the GOP of "Le Bistrot" coffee shop as per the international standard given the following information: a. Salaries-25 % from sales b. Rent-6 % from sales c. F&B=27 % from sales d. Utilities=2 % from sales e. Telephone=4000 $ f. Insurance=2 % from sales g. Stationary-2800 $ h. Advertising & Marketing-3 % from sales i. Laundry-8000 $ j. Payroll taxes-0.5 % from sales k. Repairs & Maintenance-2 % from sales N.B; YOU ANSWERS MUST BE ON AN EXCEL SHEET AND THEN BROWSE IT TO THE FILE. You are asked to prepare a forecasted budget for "Le Bistrot" coffee shop at Kaslik area knowing that it opens at breakfast, lunch and dinner time. It has a capacity of 85 seats and closes every Monday as per the decision of the owners/operators.After doing a market study, SWOT analysis, density per square meter and competitors pricing strategy, you came out with the following estimations: 1. Turnover rate breakfast 150%, with an average check of 8$2. 2. Turnover rate Lunch-200%, with an average check of 16 $3. 3. Turnover rate Dinner-70%, with an average check of 18 $ A-You are requested to prepare a forecasted revenue for "le Bistrot" coffee shop for the first year of operation based on the above mentioned figures. B-You are requested to prepare an income statement and to calculate the GOP of "Le Bistrot" coffee shop as per the international standard given the following information: a. Salaries-25 % from sales b. Rent-6 % from sales c. F&B=27 % from sales d. Utilities=2 % from sales e. Telephone=4000 $ f. Insurance=2 % from sales g. Stationary-2800 $ h. Advertising & Marketing-3 % from sales i. Laundry-8000 $ j. Payroll taxes-0.5 % from sales k. Repairs & Maintenance-2 % from sales N.B; YOU ANSWERS MUST BE ON AN EXCEL SHEET AND THEN BROWSE IT TO THE FILE.