Compute the forecasted demand

Assignment Help Operation Research
Reference no: EM13711303

Compute the forecasted demand with a moving average

I need help with the following:

The ABC Floral Shop sold the following number of geraniums during the last 2 weeks:

Day 1: Demand: 200

Day 2: Demand 134

Day 3: Demand 157

Day 4: Demand 165

Day 5: Demand 177

Day 6: Demand 125

Day 7: Demand 146

Day 8: Demand 150

Day 9: Demand 182

Day 10: Demand 197

Day 11: Demand 136

Day 12: Demand 163

Day 13: Demand 157

Day 14: Demand 169

Develop a spreadsheet to answer the following questions.

Problem- Calculate a forecast of the above demand using a 3- and 5-period moving average.

Part 1- Graph these forecasts and the original data using Excel. What does the graph show?

Part 2- Which of the above forecasts is best? Why?

You need to describe the forecasted demand with a moving average and solve the above problem.

Reference no: EM13711303

Questions Cloud

Explain how many grams of n2 at it''s melting point : The molar heat of fusion for nitrogen is 710 j/mole. How many grams of N2 at it's melting point, can be melted by 1080 joules of heat
Sketch the plot of electrical conductivity anainst titre : Sketch the plot of electrical conductivity anainst titre volume(A VS V) you would expect to observe when the strong acid HCl is titrated with the strong base NaOH. Explain the shape of the plot and clearly indicated the end point
Sketch a potential energy diagram for rotation : Sketch a potential energy diagram for rotation about the C-C bond in propane (eclipsed and staggered conformations)
Explain operation and improvement : I want more explanation about this process. I am inviting company to improve my business operation improvement process. As the vendor is providing.
Compute the forecasted demand : You need to describe the forecasted demand with a moving averag. Graph these forecasts and the original data using Excel. What does the graph show. Which of the above forecasts is best.
Determine the formula for the compound : Use Lewis theory to determine the formula for the compound that forms between the two elements listed
Substances in order decreasing magnitude of lattice energy : Arrange the following substances in order of decreasing magnitude of lattice energy. Rank from largest to smallest magnitude of lattice energy. To rank items as equivalent, overlap them.
What type of compound is likely to form : Atoms from an element in group IIA are allowed to react with atoms from an element in group VIIA. What type of compound is likely to form
Draw the product of cyclohexene oxide : Draw the product of cyclohexene oxide, sodium methoxide and hydronium workup. Draw the product of 2-methylpropene oxide, and hydrogen chloride in diethylether workup

Reviews

Write a Review

Operation Research Questions & Answers

  What balance to strike between offensive-defensive

Explain how to build scale economies and becoming adept at product innovation. Deciding which of the five generic competitive strategies to adopt, whether to be a risk-taker or risk-avoider and Illustrate what balance to strike between offensive an..

  Determine the monthly break-even volume for the company

The company's fixed monthly cost is $25,000, and its variable cost per pound of fertilizer is $0.15. Evergreen sells the fertilizer for $0.40 per pound. Determine the monthly break-even volume for the company.

  Research apple international presence

Research Apple's international presence, and detail out why they expanded out into the global marketplace. APA citation required, 250 word minimum.

  Describe the impact of megatrends in supply

Based on your experience or readings, discuss how these mega trends affect the Purchasing and Supply Management professional in the exercise of his/her duties and responsibilities.

  Describe stocks and finance

Trading stocks is much faster and less complicated if an individual investor has possession of the actual stock certificates.

  The case international coal

Write a report on International Coal

  Describe which coefficient reflects the occurrence

I need help to explain that which coefficient reflects the occurrence of perfect reliability and give an example.

  What is the best batch mix that optimizes total cost

He has at least ten hours of each activity to do each week, but refuses to more than twenty hours of any one of these activities to keep himself from getting bored with any one activity. How should he schedule his time to optimize his revenue?

  Describe processes codified in erp

Describe the different processes codified in ERP for organizations and describe the ways to reduce the risks. Does this limit innovation and if so, how can that risk be reduced.

  Explain performance measures to evaluate an organization

Identify and describe at least four performance measurements that can be used by an organization and describe. Why these are important to the organization's success.

  Discuss the implications of service outsourcing on employees

Discuss the implications of service outsourcing on employees, stockholders, consumers and host country economy when a company outsource a call center oversees.

  Conduct research by interviewing a staff member

Students are required to conduct research by interviewing a staff member of an organisation with experience in employee recruitment and selection (e.g. HR advisor, manager).

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd