Suppose that you work at a local food manufacturer and are given the task of investigating your company's seasonal sales patterns over the past 10 years (2011 to 2020). After adjusting your sales values for inflation, you calculate the following seasonal sales averages (in millions): Spring: 39 Summer: 46 Fall: 32 Winter: 23 Use this information to seasonally adjust your 2021 Winter sales total of 29 million. Round your answer to two decimal points
Q: New York City is the most expensive city the United States for lodging. The mean hotel room rate is…
A:
Q: Discuss the following statement: “Economists are predicting that interest rates willcontinue to be…
A: Forecasting is the main function of predicting the future using the information available for…
Q: Use the sales data given below to determine: (a) the least squares trend line, and (b) the predicted…
A: Formulas Used: Mean = Sum of values/ Number of values Equation: y = a + b x where, a = (Mean of y)…
Q: Sales are 30 000 units in September of 2021. The seasonal index for the month of September is 0.75.…
A: The computing method of seasonal adjustment was simple and easy and can lend to spreadsheets to…
Q: Time left 0:30:09 The predicted monthly sales for a company over the first six months of 2010 are…
A: Standard Deviation, s: 41.043472887497 Count, N: 6 Sum, Σx: 1939 Mean, x̄: 323.16666666667…
Q: Using the data in the following table, calculate the return for investing in Boeing stock (BA)…
A: Return on investment: It is a performance measure used to evaluate the efficiency or profitability…
Q: An investor is worried that his/her investment price movement is very volatile. What type of trader…
A: The trader is worried about the volatility of the market. He doesn't have the capacity to bear the…
Q: Why is a cross-sectional model of stock price returns likely to produce a more accurate forecast of…
A: How average returns fluctuate across various stocks or portfolios in a cross section.
Q: This type of analysis is most appropriate when the past is a good predictor of the future.
A: The provided statement is related to the time series analysis.
Q: The Fitter Snacker company sold 6,435 cases of snack bars in June of the previous year. They are…
A: To calculate the sales forecast for June, multiply the no. of cases sold in June of the previous…
Q: Which of the following serves as a basis for all doomsday forecasts from past to present? The…
A: It is a symbol for likelihood of manmade catostrophe globally, which is maintained by bulletin of…
Q: You are also given the following table of average returns over the last 50 years: Stocks T-Bonds…
A: (a) Utilizing the historical methodology, the estimate to calculate risk premium for Steel Products…
Q: For Incomediary model Qatar Vodafone company Give an international example (company, or website)…
A: Incomediary model means collecting the data of the customers and providing the data to the…
Q: Which of the following statements are correct? [Select multiple answers] Income gap ratio (IGR)…
A: The below given statement is correct:-
Q: Your boss would like your help on a marketing research project he is conducting on the relationship…
A: Your task is to take this ____information___ and construct a graphical representation of the data.…
Q: Do you agree that all students in tertiary level (college, university, etc.) need to take at least…
A: The employee can be defined as the person who is hired by an organization to perform a specific role…
Q: Assume a company's Income Statement for Year 12 is as follows: Year 12 (in 000s) Income Statement…
A: Operating Profit Margin:- Operating margin of profit could be a profitability or performance ratio…
Q: Engage: Inventory Planning: Forecasting during Uncertainty Inventory Planning: Forecasting During…
A: ''Since the third part of the question is subjective based question, solution for first 2 questions…
Q: e many stock analysts, Lydia believes that program trading greatly decreases the volatility of stock…
A: Program trading helps in use of computer generated algorithms that can facilitate trading of stocks…
Q: policy or mechanism could solve any informational imbalances
A: An EVPI (expected value of perfect information) is the difference between actual highest return and…
Q: 1. Business valuation is typically conducted when a company is looking to sell all ora portion of…
A: A business valuation is a process of determining the economic value of a business or a company. It…
Q: Seasonal patterns often occur in time series. The ratio-to-moving-average method facilitates the…
A:
Q: 19. The marginal propensity to consume (MPC) is: a. the proportion of total disposable income that…
A: The marginal propensity to consume (MPC) is the change in consumption divided by the change in…
Q: Suppose you were preparing two-way tables of percentages for the following pairs of variables. How…
A: In an economy, the business cycle plays a significant role in deciding the level of output produced,…
Q: expenditure on food, gas and clothing for a family living in the USA in 2010. Read the description…
A: The above graph seems to be a result of a research. The research process can be defined as the…
Q: Asymmetric information and imperfect information tend to distort market price and quantity. The use…
A: asymmetric information and imperfect information tells about how some sellers contain more than one…
Q: A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand…
A:
Q: the price of a stock on July 1 is $30. A trader buys 100 call options on the stock with a strike…
A:
Q: Answer the following guide questions below: What are the different problems faced by companies? How…
A: Note: “Since you have asked multiple questions, we will solve the first question for you. If you…
Q: The long-term financial forecast plays a crucial part in the company's long-term strategic plan.…
A: This statement is TRUE.
Q: Cell phone sales for a California-based firm over the last 10 weeks are shown in the following…
A: Formula:
Q: Sales of Volkswagens have grown steadily at auto dealerships in Nevada during the past 5 years (see…
A: Tred projection or linear regression forecast is a method that uses the variation and trend in past…
Q: A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data…
A: Given data is
Q: Discrete random variable Continuous random variable Annual inflation Decision tree branch Simulation…
A: ANSWER: DISCRETE RANDOM VARIBALE: COUNTABLE, ISLOATED REASON: If random variable can present…
Q: All MBA students have to take entry test for admission to AUAF. Scores are normally distributed with…
A: Quality refers to the degree of excellence of something. Quality has some standard on the basis of…
Q: Suppose that you are given the following sales data for the last three years, with Q1 being Quarter…
A: Solution a) 1. Calculate average demand per season by dividing annual demand by number of quarters…
Q: É Salespersons use the direct comparison approach to estimate the value of a property. Which of the…
A: Ans. The direct comparison approach is a method of estimating the value of a property which says…
Q: Hello: I am trying to fine-tune this question in quotes below to become a qualitative response…
A: Market Basket Sales Market Basket Sales is a technique used by large retailers. This technique is…
Q: Professional Federal Reserve watchers and economic forecasters utilize the same basic methods that…
A: Economic forecasting refers to a scenario whereby financial institutions uses historical data in…
Q: perfect information on all cars
A: EVPI (expected value of perfect information) indicating the loss of unknow market state…
Q: Engage: Inventory Planning: Forecasting during Uncertainty Inventory Planning: Forecasting During…
A: Uncertainties in consumer demand - Start with the information. You would like to remember that the…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
- A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?You are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.
- Based on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)You want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).The annual demand for Prizdol, a prescription drug manufactured and marketed by the NuFeel Company, is normally distributed with mean 50,000 and standard deviation 12,000. Assume that demand during each of the next 10 years is an independent random number from this distribution. NuFeel needs to determine how large a Prizdol plant to build to maximize its expected profit over the next 10 years. If the company builds a plant that can produce x units of Prizdol per year, it will cost 16 for each of these x units. NuFeel will produce only the amount demanded each year, and each unit of Prizdol produced will sell for 3.70. Each unit of Prizdol produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. a. Among the capacity levels of 30,000, 35,000, 40,000, 45,000, 50,000, 55,000, and 60,000 units per year, which level maximizes expected profit? Use simulation to answer this question. b. Using the capacity from your answer to part a, NuFeel can be 95% certain that actual profit for the 10-year period will be between what two values?
- When you use a RISKSIMTABLE function for a decision variable, such as the order quantity in the Walton model, explain how this provides a fair comparison across the different values tested.Based on Grossman and Hart (1983). A salesperson for Fuller Brush has three options: (1) quit, (2) put forth a low level of effort, or (3) put forth a high level of effort. Suppose for simplicity that each salesperson will sell 0, 5000, or 50,000 worth of brushes. The probability of each sales amount depends on the effort level as described in the file P07_71.xlsx. If a salesperson is paid w dollars, he or she regards this as a benefit of w1/2 units. In addition, low effort costs the salesperson 0 benefit units, whereas high effort costs 50 benefit units. If a salesperson were to quit Fuller and work elsewhere, he or she could earn a benefit of 20 units. Fuller wants all salespeople to put forth a high level of effort. The question is how to minimize the cost of encouraging them to do so. The company cannot observe the level of effort put forth by a salesperson, but it can observe the size of his or her sales. Thus, the wage paid to the salesperson is completely determined by the size of the sale. This means that Fuller must determine w0, the wage paid for sales of 0; w5000, the wage paid for sales of 5000; and w50,000, the wage paid for sales of 50,000. These wages must be set so that the salespeople value the expected benefit from high effort more than quitting and more than low effort. Determine how to minimize the expected cost of ensuring that all salespeople put forth high effort. (This problem is an example of agency theory.)The method for rating teams in Example 7.8 is based on actual and predicted point spreads. This method can be biased if some teams run up the score in a few games. An alternative possibility is to base the ratings only on wins and losses. For each game, you observe whether the home team wins. Then from the proposed ratings, you predict whether the home team will win. (You predict the home team will win if the home team advantage plus the home teams rating is greater than the visitor teams rating.) You want the ratings such that the number of predictions that match the actual outcomes is maximized. Try modeling this. Do you run into difficulties? (Remember that Solver doesnt like IF functions.) EXAMPLE 7.8 RATING NFL TEAMS9 We obtained the results of the 256 regular-season NFL games from the 2015 season (the 2016 season was still ongoing as we wrote this) and entered the data into a spreadsheet, shown at the bottom of Figure 7.38. See the file NFL Ratings Finished.xlsx. (Some of these results are hidden in Figure 7.38 to conserve space.) The teams are indexed 1 to 32, as shown at the top of the sheet. For example, team 1 is Arizona, team 2 is Atlanta, and so on. The first game entered (row 6) is team 19 New England versus team 25 Pittsburgh, played at New England. New England won the game by a score of 28 to 21, and the point spread (home team score minus visitor team score) is calculated in column J. A positive point spread in column J means that the home team won; a negative point spread indicates that the visiting team won. The goal is to determine a set of ratings for the 32 NFL teams that most accurately predicts the actual outcomes of the games played.
- Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.When you use @RISKs correlation feature to generate correlated random numbers, how can you verify that they are correlated? Try the following. Use the RISKCORRMAT function to generate two normally distributed random numbers, each with mean 100 and standard deviation 10, and with correlation 0.7. To run a simulation, you need an output variable, so sum these two numbers and designate the sum as an output variable. Run the simulation with 1000 iterations and then click the Browse Results button to view the histogram of the output or either of the inputs. Then click the Scatterplot button below the histogram and choose another variable (an input or the output) for the scatterplot. Using this method, are the two inputs correlated as expected? Are the two inputs correlated with the output? If so, how?Continuing the previous problem, assume, as in Problem 11, that the damage amount is normally distributed with mean 3000 and standard deviation 750. Run @RISK with 5000 iterations to simulate the amount you pay for damage. Compare your results with those in the previous problem. Does it appear to matter whether you assume a triangular distribution or a normal distribution for damage amounts? Why isnt this a totally fair comparison? (Hint: Use @RISKs Define Distributions tool to find the standard deviation for the triangular distribution.)