Solution-Sweetwater bakery has been using a forecast model

Sweetwater bakery has been using a forecast model

Reference no: EM13967762

Sweetwater Bakery has been using a forecast model for two years to predict quarterly sales and now decide to test it using MAD and a tracking signal. Moreover, they want your help in developing a new forecasting model that takes into account the seasonality in sales and any detectable trend. You believe there is a seasonal factor associated with quarterly sales. Here is quarterly data from the past two years.

Questions:

a) Find the tracking signal. Is the current forecasting routine acceptable?

b) Prepare a forecast for the upcoming year using decomposition.

Please show calculations wherever required.

Attach File

Period	Forecast	Actual Sales	Period	Forecast	Actual Sales
Quarter 1	250	300	Quarter 5	400	416
Quarter 2	500	540	Quarter 6	800	760
Quarter 3	950	885	Quarter 7	1100	1191
Quarter 4	650	580	Quarter 8	800	760

Reference no: EM13967762

Questions Cloud

Downstream of the customization point : In general, would you expect to see production lines upstream or downstream of the customization point in a supply chain? What about job shops? Explain.

Where is the artwork located : Statements that answer: Source? Where is the artwork located? Who made the work? What type of art is it? When was it made? Other statements you think are necessary to introduce the art, artist, venue, location

Which properties of limits are applicable : Which properties of limits are applicable to find the limit of a rational function at a particular point?

Discuss their visions of america in terms of adams : First, choose either Crevecoeur's Letter or Barack Obama's November 7, 2007 speech ("Agenda to Reclaim the American Dream"). Describe their vision of life in America in terms of both its promise and its problems. Discuss their visions of America i..

Sweetwater bakery has been using a forecast model : Sweetwater Bakery has been using a forecast model for two years to predict quarterly sales and now decide to test it using MAD and a tracking signal. Moreover, they want your help in developing a new forecasting model that takes into account the seas..

What is the rationale of transfer of technology : What is the rationale of transfer of technology? Describe different non-equity forms of technology transfer by TNCs and Small and Medium Enterprises.

Find per-unit subtransient current at fault, in generator : All resistances may be ignored. The generator is supplying rated apparent power and voltage at a power factor of 0.85 lagging, when a three-phase synchronous fault occurs at the terminals of the motor. Find the per-unit subtransient current at the..

Web site for the project management institute : 1. Visit the Web site for the Project Management Institute at www.pmi.org. What types of educational material are available for project managers? What types of profes- sional certification programs? What do you think a professional project mana..

What logic does he use to make his point : Read the "What to the slave is the Fourth of July" What logic does he use to make his point

User Account

All Pages

Sweetwater bakery has been using a forecast model

Reference no: EM13967762

Reference no: EM13967762

Questions Cloud

Reviews

Write a Review

Science Questions & Answers

Static electricity discharge and fire prevention

Describe the impact of aids

Deoxyribonucleic acid (dna) profiling

Measures of health

List the fundamental categories of earths chemical

Affect your social surroundings

What geologic eras and periods do they occur

Water cycle related issues

What is your overall philosophy of life

For this assignment use the same hypothesis and the

How does sociology help us to understand social issues

The main greenhouse gases issues

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT