Show workings please.

5) Forecast November and December using the method you believe to be the most accurate. Question 2: Refer to the gasoline sales time series data in Table below to answer the following (Copy the file to Excel when done submit here) 1. Compute Three- week, four-week and five-week moving averages for the time series. 2. Compute the MSE for Three- week, the four-week and five-week moving average forecasts. (Look over the PowerPoint) 3. Create a new column to show the trend line (y- matb) for the table below 4. What appears to be the best number of weeks of past data (three, four. or five) to use in the moving average computation? 5. Plot gasoline sales time series after obtaining the contract with the Vermont state police 6. Plot gasoline sales time series and three-week moving average Forecasts 7. Plot gasoline sales time series and add the trend line to graph 121 1 words IN Type here to searchSuppose that a fishery is characterized by the following relationship between total fish stock and annual growth (ignore the third column for now): Stock (thousand tons Annual Growth (tons) Number of Boat Trips biomass) Required to Catch Annual Growth 10 0 20 800 2,300 30 1,600 2,200 40 2,300 2, 100 50 2,800 2,000 60 3,100 1.600 70 3,200 1,300 80 3,000 1,000 90 2,700 800 100 2,300 600 p 509 110 1.800 400 120 1,200 200 130 500 100 140 0 a) First, construct a graph showing the relationship between stock and growth, similar to Figurel4. I-IrConsider a perfectly competitive market. Suppose that all rms are identical and have the same cost function G (q) = 4g. 32 (a) What is the equilibrium price, 310, facing a rm? Compute the market equilibrium quantity demanded if the market demand is g = 10 p. [In what follows, consider the monopolist's problem facing the demand q = 10 p. Cost is the same as above] (b) Compute the monopolist's optimal output, q\