You are asked to prepare a forecasted budget for Le Bistrot coffee shop at Kaslik area...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
Part A Answer The forecasted revenue for le Bistrot coffee shop for the first year of operatio... View the full answer
Related Book For
Operations Management Managing Global Supply Chains
ISBN: 978-1506302935
1st edition
Authors: Ray R. Venkataraman, Jeffrey K. Pinto
Posted Date:
Students also viewed these accounting questions
-
As a summer intern, you are asked to prepare a spreadsheet calculating the project free cash flow associated with a project your employer is considering. Initially your boss assumes that no debt will...
-
You are asked to prepare a pH = 3.00 buffer solution starting from 1.25 L of a 1.00 M solution of hydrofluoric acid (HF) and an excess of sodium fluoride (NaF). (a) What is the pH of the hydrofluoric...
-
You are asked to prepare a pH = 4.00 buffer starting from 1.50 L of 0.0200 M solution of benzoic acid (C6H5COOH) and an excess of sodium benzoate (C6H5COONa). (a)What is the pH of the benzoic acid...
-
The following is information for Palmer Company. \ table [ [ , Year,Year 2 , Year 1 ] , [ Cost of goods sold,$ 6 3 3 , 8 2 5 , $ 4 1 6 , 6 5 0 , $ 3 8 1 , 3 0 0 The following is information for...
-
(a) Prepare general journal entries for the following transactions in the appropriate funds and General Capital Assets and General Long-Term Liabilities accounts of a county, the county school...
-
You work for Apple. After toiling away on $10 million worth of prototypes, you have finally produced your answer to Google Glasses: iGlasses (the name alone is genius). iGlasses will instantly...
-
A governmental auditor is performing an audit of the city of Pawtucket, Rhode Island. The auditor's objective is to determine whether the city's financial statements are presented fairly in all...
-
The following information is extracted from the accounting records of the Shelton Corporation at the beginning of 2007: Accounts Receivable .........$63,000 Allowance for Doubtful Accounts.....1,400...
-
Dr . Steven Smith is a cardiologist who owns a profitable practice in the Bronx. He is contemplating adding a gym to his practice within the same building that houses his medical practice. This...
-
Kiss Cosmetics Inc. has a 4-year 5% coupon bond (annual coupon payments) with a face value of $1,000. The spot rate term structure is shown in the table below. A) Calculate the discount factors, PV...
-
You want to purchase a new car since the prices have dropped so low due to the current economic condition. You can purchase the car for $18,000. You know that you can get a loan at 4.5% (compounded...
-
2. Let {X, X2, . . . , Xn} a random sample of n observations obtained from a pop- ulation having a mean of and a variance of o. Consider the following esti- mators of : 1 3 - = = n 3 n i=1 1 - 1 3...
-
Consider the following two equations: P = 47 0.1Q (it's demand curve) Q =70 + 30P (it's supply curve) Calculate the market equilibrium and represent it graphically
-
3 ok ces Consider the market for ice cream. a. Illustrate the effect that soaring summer temperatures would have on the market for ice cream. Instructions: Use the line tool provided "Curve" to draw...
-
2. a. b. C. d. Consider the following Autoregressive Distributed Lagged, ARDL (1, 1,0) model for three variables Yt, Xt, and Zt is as follows: Yt Bo + B1Yt-1 + BX1 + B3Xt-1 + B4Zt + et Define the...
-
bill and dan opened up HEB Inc. on September 1, 2013. During the first month of operations the following transactions occurred. Date Transaction 9-1-13 Common Stockholders invested $40,000 cash in...
-
Write C++ program to take input in variables "n" and "L" from user and print following character pattern. For reference, ASCII chart is also given below. Sample inputs and output are shown below n=5,...
-
Walker, Inc., is an all-equity firm. The cost of the company's equity is currently 11.4 percent and the risk-free.rate is 3.3 percent. The company is currently considering a project that will cost...
-
The registration desk at the exclusive Le Meridien Hotel has four staff agents to check in the hotel guests. Guests arrive at the registration desk at an average rate of 40 per hour (Poisson...
-
Describe briefly how the capacity planning process works.
-
In single-period inventory systems, how would a high level of service affect the optimal stocking policy?
-
Calculate the volatility and the current price of oil futures implied by the call 1600 August and the call 1700 August of Figure 19.8 by using the Black-Scholes formula with \(T=.25\). OIL CRUDE OIL...
-
Consider a continuous-time environment, with \(e\) as a variable outside of the market. (a) Suppose the final payoff is \(V\left(x_{e}, T ight)=x_{e}(T)\). Find \(V\left(x_{e}, t ight)\). (b) Find a...
-
Mr. Smith wants to buy a car and is deciding between brands A and B. Car A costs \(\$ 20,000\), and Mr. Smith estimates that at the rate he drives he will sell it after 2 years and buy another of the...
Study smarter with the SolutionInn App