Yann grew up in Normandy of France and then moved to the US working in hospitality...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Yann grew up in Normandy of France and then moved to the US working in hospitality consulting for almost 20 years. Always fascinated about his hometown cuisine, Yann wants to open a gourmet French restaurant in Dallas. Leveraging his experience in the hospitality industry, Yann has developed a pro-forma monthly cash flow analysis, which is shown in Exhibit 3.1, to better understand the profitability and feasibility of this business. Number of Customers Average Sales Direct Cost of Sales (per customer) Gross Margin Server Payroll Other Fixed Costs Total Operating Expenses Profit Exhibit 3.1: Monthly Cash Flow for Yann's Restaurant 2500 $30.00 per customer 40% of average Sales $ 45,000.00 $10 $8,000 $33,000 $ 12,000.00 =(Number of Customers) (Average Sales)*(1-Direct Cost Percentage) per customer =(Server Payroll per Customer)*(Number of Customers)+(Other Fixed Costs) =(Gross Margin)-(Total Operating Expenses) Unfortunately, just about every number in this analysis is uncertain. Yann wants to build a Monte Carlo simulation model to better understand the risks of this venture. From his interaction with restaurant owners in other cities, Yann estimates probability distributions for the variables in his pro-forma analysis as follows: Number of customers per month: This is very hard to predict. Yann is optimistic about the demand but recognizes the uncertainty and assigns a lognormal distribution with mean 2,500 and standard deviation 800. Average sales per customer: Yann's prices will be set according to his estimate of what customers are willing to pay. At this point, he is uncertain about the average sales per customer and assigns a normal distribution with a mean of $30.00 per customer and a standard deviation of $7.00. Direct cost of sales per customer as a percentage of Average Sales: This includes the costs of food served to customers as well as other incidental expenses (e.g., laundry), which are expected to be proportional to the average sales. Yann assigns uniform distribution between 20% and 60% to this percentage. Server Payroll costs per customer: Yann assigns a triangular distribution with a most likely value of $10, an optimistic value of $7 and a pessimistic of $15. Other fixed costs: Yann has identified a location in norther suburb of Dallas and estimates that rent, utilities, and insurance for that location will cost about $8,000 dollars per month. He is quite confident about this and does not feel the need to model it as uncertain. Build a simulation model of this venture to answer the following questions. For all questions, write your answers on the Answer Sheet for this problem (provided separately) and submit appropriate documentation with the answer sheet. a) What is the estimated expected profit per month? What is the probability that Yann will lose money for a given month? What about the probability of making more than $20,000 per month with this restaurant? (10 points) In his original analysis, Yann assumed that he has enough capacity in his restaurant to meet all demand. Upon reflection, he realizes that the size of the restaurant may limit the number of customers that he can serve and that his probability distribution for the number of customers represents actual demand rather than the number of customers he can actually serve. With his planned location (call it Location 1), he could serve at most 3,500 customers per month. If demand exceeds this level, customers would be turned away. This capacity constraint would limit the upside potential associated with very high demands. Thinking through this, he decides to reconsider two of the other locations he had considered previously to see how they might compare in light of the uncertainty about demand. The maximum capacity (in terms of customers per month) and fixed costs (rent, utilities and insurance, etc) for the locations are shown in Exhibit 3.2. These three locations are all comparable in other respects and the assumptions about demand (= the number of potential customers) and average sales, direct costs of sales and payroll are all as above. Exhibit 3.2: Candidate Locations for Yann Location 1 2 3 Maximum Capacity (Customers per month) 3500 2500 5000 Fixed Cost ($ per month) 8000 5000 12500 b) Revise your previous spreadsheet model and set it up as a parametrized simulation model (with location being the parameter). Run the three simulations, one for each location. What are the expected profits for these three locations? Based on this, which location is the best? (10 points) c) Suppose Yann is risk averse. To select a location, he needs to make the tradeoff between expected profit versus the risk associated with each location. Draw an overlay chart of the profits for the three locations based on your simulation in Part b) to determine if one location is riskier than the others. Can you rule out any of the locations for Yann? Namely, is there any location is dominated by another location in terms of profitability? (Hint: drawing the overlay chart in cumulative view with smooth line may be helpful!) (5 points) If you are using cloud-based ASP, you may report the standard deviation of the profits for the three locations based on your simulation in Part b) to determine if one location is riskier than the others. And then answer the questions accordingly. Yann grew up in Normandy of France and then moved to the US working in hospitality consulting for almost 20 years. Always fascinated about his hometown cuisine, Yann wants to open a gourmet French restaurant in Dallas. Leveraging his experience in the hospitality industry, Yann has developed a pro-forma monthly cash flow analysis, which is shown in Exhibit 3.1, to better understand the profitability and feasibility of this business. Number of Customers Average Sales Direct Cost of Sales (per customer) Gross Margin Server Payroll Other Fixed Costs Total Operating Expenses Profit Exhibit 3.1: Monthly Cash Flow for Yann's Restaurant 2500 $30.00 per customer 40% of average Sales $ 45,000.00 $10 $8,000 $33,000 $ 12,000.00 =(Number of Customers) (Average Sales)*(1-Direct Cost Percentage) per customer =(Server Payroll per Customer)*(Number of Customers)+(Other Fixed Costs) =(Gross Margin)-(Total Operating Expenses) Unfortunately, just about every number in this analysis is uncertain. Yann wants to build a Monte Carlo simulation model to better understand the risks of this venture. From his interaction with restaurant owners in other cities, Yann estimates probability distributions for the variables in his pro-forma analysis as follows: Number of customers per month: This is very hard to predict. Yann is optimistic about the demand but recognizes the uncertainty and assigns a lognormal distribution with mean 2,500 and standard deviation 800. Average sales per customer: Yann's prices will be set according to his estimate of what customers are willing to pay. At this point, he is uncertain about the average sales per customer and assigns a normal distribution with a mean of $30.00 per customer and a standard deviation of $7.00. Direct cost of sales per customer as a percentage of Average Sales: This includes the costs of food served to customers as well as other incidental expenses (e.g., laundry), which are expected to be proportional to the average sales. Yann assigns uniform distribution between 20% and 60% to this percentage. Server Payroll costs per customer: Yann assigns a triangular distribution with a most likely value of $10, an optimistic value of $7 and a pessimistic of $15. Other fixed costs: Yann has identified a location in norther suburb of Dallas and estimates that rent, utilities, and insurance for that location will cost about $8,000 dollars per month. He is quite confident about this and does not feel the need to model it as uncertain. Build a simulation model of this venture to answer the following questions. For all questions, write your answers on the Answer Sheet for this problem (provided separately) and submit appropriate documentation with the answer sheet. a) What is the estimated expected profit per month? What is the probability that Yann will lose money for a given month? What about the probability of making more than $20,000 per month with this restaurant? (10 points) In his original analysis, Yann assumed that he has enough capacity in his restaurant to meet all demand. Upon reflection, he realizes that the size of the restaurant may limit the number of customers that he can serve and that his probability distribution for the number of customers represents actual demand rather than the number of customers he can actually serve. With his planned location (call it Location 1), he could serve at most 3,500 customers per month. If demand exceeds this level, customers would be turned away. This capacity constraint would limit the upside potential associated with very high demands. Thinking through this, he decides to reconsider two of the other locations he had considered previously to see how they might compare in light of the uncertainty about demand. The maximum capacity (in terms of customers per month) and fixed costs (rent, utilities and insurance, etc) for the locations are shown in Exhibit 3.2. These three locations are all comparable in other respects and the assumptions about demand (= the number of potential customers) and average sales, direct costs of sales and payroll are all as above. Exhibit 3.2: Candidate Locations for Yann Location 1 2 3 Maximum Capacity (Customers per month) 3500 2500 5000 Fixed Cost ($ per month) 8000 5000 12500 b) Revise your previous spreadsheet model and set it up as a parametrized simulation model (with location being the parameter). Run the three simulations, one for each location. What are the expected profits for these three locations? Based on this, which location is the best? (10 points) c) Suppose Yann is risk averse. To select a location, he needs to make the tradeoff between expected profit versus the risk associated with each location. Draw an overlay chart of the profits for the three locations based on your simulation in Part b) to determine if one location is riskier than the others. Can you rule out any of the locations for Yann? Namely, is there any location is dominated by another location in terms of profitability? (Hint: drawing the overlay chart in cumulative view with smooth line may be helpful!) (5 points) If you are using cloud-based ASP, you may report the standard deviation of the profits for the three locations based on your simulation in Part b) to determine if one location is riskier than the others. And then answer the questions accordingly.
Expert Answer:
Answer rating: 100% (QA)
Based on the simulation model the expected profits for the three locations are as follows Location A ... View the full answer
Related Book For
Managerial Economics and Strategy
ISBN: 978-0321566447
1st edition
Authors: Jeffrey M. Perloff, James A. Brander
Posted Date:
Students also viewed these general management questions
-
Pro forma balance sheet Peabody & Peabody has 2015 sales of $10 million. It wishes to analyze expected performance and financing needs for 2017, which is 2 years ahead. Given the following...
-
Customer profitability analysis Using activity-based analysis, you have just prepared a customer profitability report for the sales manager that shows some customer groups are profitable but other...
-
The future is uncertain and so pro forma financial statements will almost certainly prove to be inaccurate. It is, therefore, a waste of time to prepare them. Comment.
-
Metro builds and operates traditional shopping malls. It holds a $25 million deferred tax asset relating to credit carryforwards at the state, local, and Federal levels. No valuation allowances...
-
Describe the two types of fed funds transactions.
-
Carpenter Corporation uses the weighted - average method in its process costing system. This month, the beginning inventory in the first processing department consisted of 6 0 0 units. The costs and...
-
Refer to the financial statements ofKrispy Kreme in AppendixA to answer the following: 1. Compute times interest earned for the fiscal years ended 2003, 2002, and 2001. Comment on Krispy Kremes...
-
1. How suitable is the just-in-time inventory management system for the University of Utah Hospital (as well as for other large hospitals)? 2. What recommendations would you make to the hospital in...
-
FINANCIAL ACCOUNTING II As of January 2, 2021, The Triple J Company had the following items in its capital structure: 12,000 shares of preferred stock issued, with a par value of $7, a market value...
-
1. Develop a simulation model for 52 weeks of operation at Ebony. Graph the inventory of soap over time. What is the total cost (inventory cost plus production change cost) for the 52 weeks? 2. Run...
-
Case: Lukes Diner has planned sales of $375, 000 for the upcoming spring/summer season. This is a 2% sales increase that could be attained this year due to the introduction and addition of a new...
-
I finished first in the high jump and third in the pole vault. In Exercises 2532, determine whether the data described are nominal or ordinal.
-
How do a trade acceptance and a bankers acceptance differ?
-
The number of students enrolled at a college In Exercises 3340, determine whether the data described are discrete or continuous.
-
Suppose that you were asked to collect some information about students in your class for a statistics project. Give some examples of variables you might collect that are ordinal, nominal, discrete,...
-
Discuss the primary forms of financing international trade. What are the advantages and disadvantages of each technique, from the perspective of the exporter? From the perspective of the importer?
-
pped EX 21-5 Equivalent units of production obj. 2 Direct mateals, 7700 units EX 21-6 Equivalent units of production obj. 2 a. Conversin. 74,095 units The Converting Department of Forever Fresh Towel...
-
Provide a few individual examples who revealed what aspects of emotional intelligence?
-
An incumbent firm, Firm 1, faces a potential entrant, Firm 2 that has a lower marginal cost. The market demand curve is p = 120 q1 q2. Firm 1 has a constant marginal cost of $20, where Firm 2s is...
-
Ford invites Clarion to set up a plant at Fords industrial complex in Brazil, where Clarion will build navigation systems for installation in the Ford cars produced there. If Clarion builds the...
-
Given the estimated demand function Equation 2.2 for avocados, Q = 104 40p + 20pt + 0.01Y, use algebra (or calculus) to show how the demand curve shifts as per capita income, Y, increases by $ 1,000...
-
Assume your U.S. firm currently exports to Mexico on a monthly basis. The goods are priced in pesos. Once material is received from a source, it is quickly used to produce the product in the United...
-
Using the information in the previous question, consider a proposal to price the exports to Mexico in dollars and to use the U.S. source for material. Would this proposal eliminate the exchange rate...
-
Assume that the dollar is expected to strengthen against the euro over the next several years. Explain how this will affect the consolidated earnings of U.S.-based MNCs with subsidiaries in Europe.
Study smarter with the SolutionInn App