Question: We are forecasting quarterly beverage sales using Winter's method. We have the following information Seasonal factors fall=0.8, spring=1.2, winter=0.7; Summer 1.3 Current base estimate =

We are forecasting quarterly beverage sales using Winter's method. We have the following information Seasonal factors fall=0.8, spring=1.2, winter=0.7; Summer 1.3 Current base estimate = 800 containers per quarter Current trend estimate = 30 packs per quarter The sale of 500 packages is now observed during the summer quarter a=0.2 (alpha) = 0.2 (beta) = 0.5 (Gamma) Use this information to update base, trend, and seasonal estimates (two decimal places)

Base estimate Response

Estimate Trend Response

Estimate Seasonality Response

After observing the summer demand, forecast the demand for the fall quarter, and the winter quarter.

Demand Fall Response Demand Winter Response

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

2 We are predicting quarterly sales for soda at Gordons Liquor Store using Winters method. We are given the following information: Seasonality factors: fall 0.8 spring 1.2 winter 0.7 summer 1.3...

What is the WACC for Cheesecake Factory as of 12/29/09 (using the Capital Asset Pricing Model to determine the cost of equity)?At that time, Cheesecake Factory's stock had a Beta of 1.25 and used a...

For the Ball Corporation, perform a Du Pont analysis on the ROE of the company, and discuss significant changes in ROE and the source of the change. UNITED STATES SECURITIES AND EXCHANGE COMMISSION...

I need this done using your own work. I need to see how you got the answers and try to show work s we look back on 2014, we are pleased with our accomplishments. We continued to focus for many...

Need help Please with the following.. Calculate the following ratios using Microsoft Excel : Current Ratio Quick Ratio Debt Equity Ratio Inventory Turnover Ratio Receivables Turnover Ratio Total...

Prepare Pro Forma 1996 and 1997 Financial Statements and conduct breakeven analysis to assess (1) breakeven $ sales, (2) whether CL could breakeven in 1996 or 1997 . 47 Exhibit 1 SELECTED MARKET...

I am unsure how to start this and how to fill out excel. Please help, question below. Question: Part 1 - Excel Sheet Prepare Ratios Ratios for National Beverage Corp. concerning liquidity, solvency,...

Part 1 - Excel Sheet Prepare Ratios Ratios for National Beverage Corp. concerning liquidity, solvency, profitability, DuPont, and stock performance as of April 30, 2016 and prior statement...

A beam of neutrons has the same de Broglie wavelength as a beam of photons. Is it possible that the energy of each photon is equal to the kinetic energy of each neutron? If so, at what de Broglie...

Wonder Amusements Limited (WAL) was incorporated over 40 years ago as an amusement park and golf course. Over time, a nearby city has grown to the point where it borders on WALs properties. In recent...

What is the discounted payback period using after tax cash flows

A product is manufactured using a flowline with 3 workstations. The data at each workstation are: Workstation 1 Work content including transfer time: 2 minutes Probability of breakdown: 0.025...

9. Think of any experience that has made a very strong impression on you, and where it did not go the way you thought it would. Imagine this experience as a movie in your inner theatre. Run this...

12. Think through the last week. If you could have changed some of your behaviour, what would you have changed? How would you have changed that? What would you seek to achieve by changing your...

The work role: This consists of service to others at your workplace.