Share
Explore BrainMass

Central Tendency

Forecast

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

McKenzie Corporation: Capital Budgeting

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

Forecast Analysis

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

Tim-Series Data - Weighted Moving Average

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

expected profit per sale

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 w

Six Sigma Analysis: Taguchi Loss Function and Expected Loss

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

Calculating expected price of a common stock

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

Forecast

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

2009 Sedans, General Electric, money market yield, football

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.

Present values of the expected costs and the expected after-tax cash profits.

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

Minimax regret criterion, Expected value of perfect information

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

Statistics Quiz - 10 Multiple Choice Questions

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

Finance

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

Forecast Computer Demand For A University Bookstore For Next Fall Semester

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

Moving Average Forecast for Closing Value of Stock

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

Quantitative Analysis for Management

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

risk averse investor

# 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

Forecast Accuracy Measure

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

Weighted Moving Average Forecast and MAD in EXCEL

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

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

Expected completion time and variance for the overall project completion time

Determine the expected completion time and variance for each activity, the expected completion time and variance for the overall project completion time, and answer questions a, b, and c below. 2. Determine the expected completion time and variance for each activity, the expected completion time and variance for the overall p