: 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

1. Explain the price in 4Ps. 2. Explain the marketing price of jewelry. 3. Explain the statistic based on picture.
In 1996, McDonald’s (MD) launched Campaign 55, reducing the prices ofits “flagship” sandwiches with the objective of regaining market share. Beforethe launch, suppose MD’s management envisioned two possible outcomes: astrong customer response or a weak response. Industry experts were notvery optimistic about the campaign. They assessed the probability of a strong response to be .40. MD predicted an expected profit of $50 million if theresponse proved to be strong. If the immediate customer response was weak,management believed that all was not lost. If MD could persuade themajority of its franchisees to back and help fund the campaign, the resultingprofit would be $20 million. However, if the majority rose up against thecampaign, the red ink would fly, and McDonald’s profit would be -$100million. MD considered these two outcomes to be equally likely.a. Given these assessments, construct a decision tree to determine MD’sexpected-profit-maximizing course of action.b. Suppose that MD has…
Somet Health Insurance Company wants to sell a health insurance product for $700 permonth. There is no requirement for healthy people to have insurance coverage. Thecompany conducts a survey to see how different populations respond to the proposed cost.People with no illnesses and disabilities, generally the young and healthy, respond that theydo not spend $700 on healthcare in an entire year, and most feel they would not waste somuch money on premiums when the chance of needing surgery or expensive healthcaretreatments is so small. However, older, sicker people think that $700 per month is a greatdeal, as most of them spend far in excess of this amount on healthcare. It seems like agreat deal for them. What will happen to the costs of the health insurance if only the older, sicker peopleenroll?
The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 166.125 (thousand units). Fill in the missing values assuming there is no trend. Round seasonal indexes to 4 decimal places. Report Averages accurate to at most 2 decimal places. Report Actual sales ('000) accurate to the nearest integer. Year Year Seasonal Year 1 Year 2 Average 4 Index Quarter 205 211 182 1.1768 1 Quarter 152 170 158 156 2 Quarter 182 190 198 193 3 Quarter 128 112 113 0.7178 4
Assume a company's Income Statement for Year 12 is as follows: Year 12 (in 000s) Income Statement Data Net Revenues from Footwear Sales $ 580,000 370,000 40,000 75,000 15,000 90,000 Cost of Pairs Sold Warehouse Expenses Marketing Expenses Administrative Expenses Operating Profit (Loss) Interest Income (Expense) Pre-tax Profit (Loss) Income Taxes Net Profit (Loss) (15,000) 75,000 22,500 $ 52,500 Based on the above income statement data and assuming the company has 20 million shares of common stock outstanding , the company's operating profit margin and EPS were Copyright O by Glo-Bus Software, Inc. Capying, distributing, ar 3rd party website posting isexpressly prohibited and constitutes copyright vialation. 15.52% and $4.50. O 9.05% and $3.75. 13.79% and $1.75. O 12.93% and $3.75. O 15.52% and $2.63.
What kind of prediction model will be more suitable for an enterprise that introduced a new product?
1) Choose the best answer The post-earnings drift is inconsistent withI The weak form efficient market hypothesisII The semi-strong form efficient market hypothesisIII The strong form efficient market hypothesis a) I, II, and III b) I and II c) None of I, II, and III d) I
6 For Clear Segment (CS) company TAM is 500K with the Premium Segment being 20% of themarket, the Midsegment being 25%, and the Budget Segment 55% of the market.The premium version of CS’s offering is sold for $1000 with a 60% UCM; the middle versionis sold for $600 with a 35% margin, and the budget version is sold for $300 with a 20% margin. Calculate the market sizes, Product UCMs, and possible contributions of eachsegment.
1.You are a new brand manager for a product line of Coach purses. You are considering the purchaseof customer data from a company that sells a large variety of women’s products online. In additionto the name, mailing address, and e-mail address of customers, the data provides an approximateestimate of customers’ annual income based on the zip code in which they live, census data, andthe highest level of education achieved. You could use the estimate of annual income to identifylikely purchasers of your high-end purses and use e-mail addresses to send e-mails announcing thenew product line and touting its many features. List the advantages and disadvantages of such amarketing strategy. Would you recommend this means of promotion in this instance? Why or whynot? 2. When asked about Google releasing personal information to law enforcement agencies, Google’sCEO Eric Schmidt told CNBC: “If you have something that you don’t want anyone to know, maybeyou shouldn’t be doing it in the first…
An electronic appliance manufacturer wants to know if there is a relationship between percentage change in deposable personal income which is reported quarterly by the government, and the percentage change in appliances sold by the manufacturer following same years of quarterly data. Brenda Chee and Clarence Paulus lead an analyst team has obtained data for the past 10 quarters. Table 3 Quarter Percent change in income Percent Change in appliance sold Quarter Percent change in income Percent Change in appliance sold 1 -2.3 -2.5 6 -1.0 1.0 2 -1.5 -1.0 7 0.7 1.4 3 2.8 7.4 8 5.2 3.4 4 0.5 2.6 9 -2.5 -0.5 5 4.6 8.5 10 1.7 1.8 1) What forecasting model should be used for this data.Why? 2) Develop the forecasting model that you have proposed in(a). 3) Compute the relationship for these data. In your opinion, is the relationship between independent variable strong enough to base a predictive the…
3. To understand the attitude toward luxury online purchase, you did a comprehensive literature review, and found that a model showing three predictors (materialism, exclusivity and product quality) is good to predict attitude toward online luxury purchase. You want to use the measurement items, but yet need to check whether they are good to be used or not. Discuss how to decide, which measurement item(s) are good to be used, or not. Explain the following things: a. Definitions of reliability and validity b. Elaborate different types of reliability and validity c. Which types of reliability and validity that you are going to use, if you are going to analyze the data using PLS? d. What are the expected values for each of the test criteria, for measurement items to be considered reliable and valid?
Use a pivot table to display the quarterly sales and estimate the percentage of sales in each quarter. (Hint: Q1 = approx. 25%; all hints are all approximate values,