Please see attached files for data. 1. Develop a four month moving average forecast for Wallace garden supply and compute the MAD. 2. Data collected on the yearly demand for 50 pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a three year moving average to forecast sales. Then
Sam McKenzie is the founder and CEO of McKenzie Restaurants, Inc., a regional company. Sam is considering opening several new restaurants. Sally Thornton, the company's CFO, has been put in charge of the capital budgeting analysis. She has examined the potential for the company's expansion and determined that the success of the
1. The Excel file Closing Stock Prices provides data for four stocks over a six-month period. a. Develop spreadsheet models for forecasting each of the stock prices using single moving average and single exponential smoothing. b. Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smo
I need to know why weighting is useful in calculating moving average and how it is calculated. The "how" I already have in technical terms, but I need it explained to me in laymen's terms. Also, I need help with the following: The yield on a 30-year treasury note at the end of each year since 1990 is recorded below. Comput
Dr. T Practices dentistry in International Falls, Minnesota. T tries hard to schedule appointments so that patients do not have to wait beyond their appointment time. His August 21 schedule is shown in the following table. SCHEDULED APPOINTMENT AND TIME EXPECTED TIME NEEDED ADAMS 9:30 AM 15 BROWN 9:45 AM 20 CRAWFORD 10:1
Fed up with the proliferation of poorly made U.S. vehicles on the market, you decide you are only going to sell European small cars. Your car dealership sells fi ve vehicles, the VW Golf, Saab 92X, BMW Z4 Roadster, Skoda Octavia, and the Lada Niva. After 12 months in business, you discover that only 10 percent of people
A computer chip is designed so that the distance between two adjacent pins has a specification of 2.000 ± 0.002 millimeters (mm). The loss due to a defective chip is $5. A sample of 25 chips was drawn from the production process and the results, in mm, are listed below. 1) Compute the value of k in the Taguchi loss function
Medical Corporation of America (MCA) has a current stock price of $36, and its last dividend (D0) was $2.40. In view of MCA's strong financial position, its required rate of return is 12 percent. If MCA's dividends are expected to grow at a constant rate in the future, what is the firm's expected stock price in five years?
You are considering an investment in the common stock of Crisp Cookware. The stock is expected to pay a dividend of $2 a share at the end of the year (D1 = $2.00). the stock has a beta equal to 0.9. The risk-free rate is 5.6% and the market risk premium is 6%. The stock's dividend is expected to grow at some constant rate g. The
1. Examine these two graphs and based on the demand pattern and axis scaling, recommend a forecasting technique (and the required parameters) that would work best for each one. Justify your recommendations. [Please refer to the attachment for the Graphs] 2. Develop forecasts for periods 7 through 10 for the demand data in th
(1) Briefly describe three situations in which the 'First In First Out' discipline rule is not applicable in queuing analysis. (2) Provide examples of four situations in which there are limited, or finite population. (3) Do you think the Poisson distribution, which assumes independent arrivals, is a good estimation of arri
See attached data file. Please show step-by-step including the formulas used in Excel. 3.11 The file Sedans contains the overall miles per gallon (MPG) of 2009 sedans priced under $20,000. 27 31 30 28 27 24 29 32 32 27 26 26 25 26 25 24 a. Compute the mean, medium, and mode.
Consider the following situation: PowerCo, a medium-sized power company, generates and sells electricity throughout several states in the southeast United States. The company has been in business for over 30 years and is the largest power generator in the region. The company believes that a significant increase in the demand for
Please show the working behind the correct choice. The new owner of a beauty shop is trying to decide whether to hire one, two, or three beauticians. She estimates that profits next year (in thousands of dollars) will vary with demand for her services and has estimated demand in three categories: low, medium and high. NUMB
1. A sample of n = 7 scores has a mean of M = 5. After one new score is added to the sample the new mean is calculated to be M = 6. The new score was X = 13. (Points: 1) True False 2. What is the mean for the following sample of scores? Scores: 1, 2, 5, 4 (Points: 1) 12 6 4
You have received two job offers. Firm A offers you $85,000 per year for two years. Firm B offers to pay you $90,000 for two years. Both jobs are equivalent. Suppose that firm Aâ??s contract is certain, but that firm B has a 50% chance of going bankrupt at the end of the year. In that event, it will cancel your contract an
The University Bookstore Student Computer Purchase Program Case Study Problem. Forecast Computer Demand For A University Bookstore For Next Fall Semester Please complete the case problem and show work also explaining which forecast method was chosen and why. Complete in the form of a paper. [Please refer to the attachm
1. The Fastgro Fertilizer Company distributes fertilizer to various lawn and garden shops. The company must base its quarterly production schedule on a forecast of how many tons of fertilizer will be demanded from it. The company has gathered the following data for the past 3 years from its sales records: Year
8. Given the following data on hotel check-ins for a 6-month period: Month Number of rooms July 70 August 105 September 90 October 120 November 110 December 115 a. What is the 3-month moving average for January? b. What is the 5-month moving average for January?
The closing value of the AMEX Airline Index for each trading day during a 1-year period is given in the file P13_17.xlsx. a. How well does the moving average method track this series when the span is 4 days; when the span is 12 days? b. Using the more appropriate span, forecast the closing value of this index on the next
Provide answers and calculations. An insurer sells a very large number of policies to people who each have the following identical loss (claims) distribution Loss/claim Probability 100,000 .005 60,000 .010 20,000 .020 10,000 .050 0 .915 1 A. Calculate the Expected claim cost p
Unit 8 Project Quantitative methods 16.12. In testing 9 sedans, Cars and Driver magazine rated each on 13 different characteristics, including ride, handling, and driver comfort. Each vehicle also received ... 18.5. Fit a linear trend equation to the following data describing average hourly earnings of U.S. production work
Chapter 15 Dr. Mark Greenberg practices dentistry in Topeka, Kansas. Greenberg tries hard to schedule appointments so that patients do not have to wait beyond their appointment time. His October 20 schedule is shown in the following table. Unfortunately, not every patient arrives exactly on schedule, and expected times to
# 12 You are a risk-averse investor who is considering investing in one of two economies. The expected return and volatility of all stock in both economies is the same. In the first economy, all stock move together—in good time all prices rise together and in bad times they all fall together. In the second economy, stock retur
RAP Computer assembles personal computers from generic parts it purchases at a discount, and it sells the units via phone orders it receive from customers responding to the company's ad in trade journal. The business has developed an exponential smoothing forecast model to forecast future computer demand. Actual demand for th co
The problem states that the manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (it biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City many competitors. The manager has collected the followi
Ratio to moving average method An analyst wants to use the ratio-to-moving average method to forecast a company's sales for the next few quarters. Beginning in Quarter 4 of 2006 , the analyst collects the following sales data (in millions of dollars). Estimate the seasonal index associated with Quarter 1 . Round your answe
Distributions/Quartiles : Assume that you work in the Planning D partment of the Century National Bank and report to Ms. Lamberg. You will need to do some data analysis and prepare a short written report. Remember, Mr. Selig is the president of the bank, so you will want to ensure that your report is complete and accurate. A copy of the data appears in Table 1 ... (Please see attachment)
Assume that you work in the Planning D partment of the Century National Bank and report to Ms. Lamberg. You will need to do some data analysis and prepare a short written report. Remember, Mr. Selig is the president of the bank, so you will want to ensure that your report is complete and accurate. A copy of the data appears in T
If he uses minimax regret criterion, how many new workers will he hire? If the manager thinks the chances of low, medium and high compliances are 20%, 30%, and 50% respectively. Find the best expected net revenues for the number of worker he will decide to hire. Find the expected value of the perfect information.
The local operations manager for the IRS must decide whether to hire 1, 2, or 3 temporary workers. He estimates that net revenues will vary with how well taxpayers comply with the new tax code. # of workers Low Compliance Medium Compliance High Compliance 1 $50 $50 $50 2
Moving Average Forecast, Exponential Smoothing Forecast, Adjusted Exponential Smoothing Forecast, Mean Absolute Deviation (MAD) and Mean Square Error (MSE)
Recent past demand for product ZXT is given in the following table: Month Actual Demand February 20 March 22 April 33 May 35 June 31 July 48 August 41 a) Determine the forecasted demand for May, June, July and August based on a three month moving average. b) Determine the forecasted demand for May, June, July and A