: What is the expected annual profit of the salon? show solution using excel Case 1: Joint ProbabilitiesMr. X is planning to open a new salon. Annual revenue will depend on how successful the marketing campaignis, and the potential outcomes are as follows:Marketing CampaignHigh successModerate successLow successRevenue10%1,000,000.0070%700,000.0020%500,000.00Costs are difficult to predict as the price of hair products and the labor market are volatile. The best estimatesfor the average costs are as follows:Materials:Percentage of revenue540%1050%1510%Labor:Percentage of revenue4020%4550%5030%The fixed overhead of the salon is expected to be P10,000 per month.

Here, the cost is in proportion to the revenue, and the revenue is given as per the market campaign…

Case 1: Joint Probabilities Mr. X is planning to open a new salon. Annual revenue will depend on how successful the marketing campaign is, and the potential outcomes are as follows: Marketing Campaign High success Moderate success Low success Revenue 1,000,000.00 10% 70% 700,000.00 20% 500,000.00 Costs are difficult to predict as the price of hair products and the labor market are volatile. The best estimates for the average costs are as follows: Materials: Percentage of revenue 5 40% 10 50% 15 10% Labor: Percentage of revenue 40 20% 50% 45 50 30% The fixed overhead of the salon is expected to be P10,000 per month.

Case 1: Joint Probabilities Mr. X is planning to open a new salon. Annual revenue will depend on how successful the marketing campaign is, and the potential outcomes are as follows: Marketing Campaign High success Moderate success Low success Revenue 1,000,000.00 10% 70% 700,000.00 20% 500,000.00 Costs are difficult to predict as the price of hair products and the labor market are volatile. The best estimates for the average costs are as follows: Materials: Percentage of revenue 5 40% 10 50% 15 10% Labor: Percentage of revenue 40 20% 50% 45 50 30% The fixed overhead of the salon is expected to be P10,000 per month.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

You have been given sales data for TOMMY's Fall/Winter/Spring/Fall New Collection for the last 4 years (16 periods). Forecast sales figures for the next year 2022 (periods 17 to 20). Season Winter Spring Summer Fall 2018 108 95 120 80 2019 100 96 117 79 2020 101 94 117 77 2021 110 87 120 75
Taking actual 2015 sales of $48000 as the forecast for 2016, what sales would you forecast for 2017, 2018, and 2019, using exponential smoothing and a weight on actual values of (a) 0.4 and (b) 0.8 ?
Relationship of Waterfall Methodology to Cost and Profit Estimates
Describe a good or service where you have worked or with which you are familiar where a breakeven analysis would be useful.
Given this data, compute the standard cost for one seafood dinner. What would the suggested menu price for the seafood dinner be assuming that the target food cost percent is 40 percent? Ingredient Serving Size (OZ) Edible Yield (%) AP Price Per Pound Fish 12 75 $8.98 Rice 4 100 $0.22 Beans 4 90 $0.65 Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Why Use ABC Analysis and what are their limitation?
A not-for-profit organization includes: Religious organizations All of the options listed Library Sports club
Suppose that you have a service business such as house painting. Describe how you would use cost-plus pricing in developing an estimate for a potential customer.
Danny Meyer Leads His Company through the Challenges of Eliminating Tips What happens when your CEO wants to remove the tip structure from your restaurant? Do you complain about the new prices as a customer? Do you worry about your paychecks as a server? Danny Meyer, CEO of Union Square Hospitality (home to some of the most successful New York restaurants), discovered these answers when he began eliminating the tip structure in most of his restaurants. He had seen firsthand the largest negative impact of a tipping culture: employees stuck in front-line positions with no chance to advance to management without taking significant pay cuts. Meyer began by first involving the affected employees in town-hall talks. These town halls happened months before any publicity was released. Meyer then hosted town halls with customers to explain the importance of fair wages for all his employees at the restaurant, not just the few who served the food. The transition period for each restaurant to…
The following quantitative technique is used to forecast the demand of a product. O a. Market research O b. Customer opinion O c. Delphi method O d. Simple moving average
Please simply answer this easy question posted below
Gretchen is proposing to present the sales from her lemonade stand as a pie chart, tracking how much she sells each day to track the overall trend. Explain why this plan will not work and what she could use instead.