Use the following data for questions below. Week New Cars Sold May 15 June 11 July...

Use the following data for questions below.

Week	New Cars Sold
May	15
June	11
July	14
August	17
September	13
October	14
November

Using two month moving average, what is the forecast for November?

14
13.5
15
17

Using the three month weighted average with 0.2, 0.3, 0.5 as weights (0.5 is the weight on the most recent data), what is the forecast for November?

13.3
14.9
14.3
14.7

Using two exponential smoothing with an alpha of .4 and assuming May sales is 15, what is the forecast for November?

15
13.4
14.8
14.1

Expert Solution

orchestra answered 1 year ago

3) Use the data below to answer the questions that follow X 7 9 11 15...

3) Use the data below to answer the questions that follow X 7 9 11 15 15 17 21 21 21 29 33 34 35 35 Y 22 20 17 17 16 12 10 10 7 4 4 3 1 0 a) Calculate the correlation coefficient “r” b) Explain what your value for r means for this data c) Determine the equation for the linear regression line of this data d) What does your equation predict for...

use below data: Year Month Demand (u) 2017 May 147 2017 June 181 2017 July 154...

use below data: Year Month Demand (u) 2017 May 147 2017 June 181 2017 July 154 2017 August 215 2017 September 179 2017 October 166 2017 November 227 2017 December 245 2018 January 223 2018 February 271 2018 March 260 2018 April 248 2018 May 316 2018 June 272 2018 July 378 2018 August 355 2018 September 371 2018 October 366 2018 November 426 2018 December 418 You plan to use an exponential smoothing method to forecast demand. Find the...

Use the following data to answer the questions below:

Use the following data to answer the questions below: Q VC MC AVC 1 $10 ___ ___ 2 16 ___ ___ 3 20 ___ ___ 4 25 ___ ___ 5 31 ___ ___ 6 38 ___ ___ 7 46 ___ ___8 55 ___ ___9 65 ___ ___ a. Calculate the marginal cost and average variable cost for each level of production.b. How much would the firm produce if it could sell its product for...

Use the information below to answer questions 11-15. A random sample of 1000 voters registered in...

Use the information below to answer questions 11-15. A random sample of 1000 voters registered in the state of Montana showed that 490 voted in the last general election. A random sample of 800 voters in the state of Arizona showed that 368 voted in the most recent general election. Do these data indicate that the population percentage of voter turnout in Arizona is lower than that in Montana? 11. Choose the appropriate null and alternate hypotheses. a. Null: The...

Use the following information from June 17, 2020 to answer the questions below. COVID-19 case data...

Use the following information from June 17, 2020 to answer the questions below. COVID-19 case data by county - Connecticut County Total Cases New London 1,217 Fairfield 16,475 Windham 579 Hartford 11,405 Litchfield 1,467 Middlesex 1,259 New Haven 12,185 Tolland 895 Based on the data from 6/17/20, which county is at the 75th percentile for total number of cases by county. Based on the data from 6/17/20, what is the percentile rank for New London? Please show all your work,...

11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next...

11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table summarizes the number of new cars sold during each of the past 12 weeks: (PLEASE ANSWER BY USING EXCEL) week number sold 1 22 2 26 3 23 4 27 5 21 6 25 7 28 8 26 9 29 10 29 11 27 12 31 (a) Provide a forecast by using a 3-week weighted moving average technique with weights...

Use the following information to answer questions 11 – 15. First American is considering buying a...

Use the following information to answer questions 11 – 15. First American is considering buying a new machine to increase production. It will cost $3,000. Shipping will be $300. It has a three-year class life. At the end of one year they plan to sell the machine for $2,000. The new machine will allow FA to increase revenues by $1,800 each year but expenses will increase by $400 each year. If the new machine is purchased, inventory will decrease by...

Use the chart of data below to answer the following questions. This data represents enrollment for...

Use the chart of data below to answer the following questions. This data represents enrollment for the Fall semesters 2013 – 2017 years. Part a: Is being part time dependent upon gender? Part b: Is the probability of being a male student enrolled (or female) dependent upon year? Part c: Create a probability tree, with the appropriate probabilities using the data from the table. Assume the tree is showing the PT or FT probabilities given the gender of the student....

Use the information below for ABC Co. to answer the following questions (#15 – 26). Balance...

Use the information below for ABC Co. to answer the following questions (#15 – 26). Balance Sheet December 31 2005 2004 Assets Cash $ 20,000 $ 10,000 Accounts receivable 160,000 110,000 Inventories 80,000 50,000 Prepaid Rent 15,000 10,000 Investments 100,000 75,000 Plant assets 210,000 250,000 Accumulated depreciation (65,000) (60,000) Total $520,000 $445,000 Liabilities and Stockholders' Equity Accounts payable $ 50,000 $ 40,000 Interest payable 20,000 5,000 Income tax payable 5,000 10,000 Note payable 130,000 140,000 Common stock 155,000 100,000 Retained earnings 160,000 150,000 Total $520,000 $445,000 Income Statement For the Year Ended December 31, 2005 Sales $800,000 Cost of goods sold 480,000 Gross Profit 320,000 Operating expenses (including Depreciation Expense) 120,000 Interest expense 20,000 Income tax expense 25,000 Total 165,000 Income before Gains...

April May June July Sales 600,000 900,000 500,000 400,000 Cost of Goods sold 420,000 630,000 350,000...

April May June July Sales 600,000 900,000 500,000 400,000 Cost of Goods sold 420,000 630,000 350,000 280,000 Gross Margin 180,000 270,000 150,000 120,000 Selling and admin expenses selling expense 79,000 120,000 62,000 51,000 administrative 45,000 52,000 41,000 38,000 total selling and administrative expenses 124,000 172,000 103,000 89,000 net operating income 56,000 98,000 47,000 31,000 a. sales are 20% for cash and 80% on account b. sales on account are collected over a three month period with 10% collected in the...

Question