I need all work completed in excel spread sheet with all, Ask an Expert

Management Studies

I need all work completed in excel spread sheet with all steps and formulas screen shoted. Any and all work done by hand needs to be shown how to complete. If it can be competed in excel, it must be completed in excel and show all steps.

Historical demand for a product is:

DEMAND

January 12

February 11

March 15

April 12

May 16

June 15

Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast. Remember to use the largest weight for the most recent month.

Using the simple three-month moving average, find the July forecast.

Using single exponential smoothing with an α of .20 and a June forecast of 13, find the July forecast. Make whatever assumptions you wish.

Using simple linear regression analysis, calculate the regression equation for the preceding demand data.

Using the regression equation in d, calculate the forecast for July.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M91391654

Have any Question?Write your Review or question?

Related Questions in Operation Management

After receiving a check in the mail for 9000 from

After receiving a check in the mail for $9,000 from Learnin’ Loans, Charis tells Learnin’ that the money got lost in the mail. Learnin’ cancels the check and sends Charis a new one. Charis then indorses the cancelled che ...

You wish to compete in the super premium ice cream market

You wish to compete in the super premium ice cream market. The task is to determine the wants of the super-premium market and the hows (attributes) to be met by their firm. Use the house of quality concept. Market resear ...

Inc is a corporation who produces markets and sells a

INC is a corporation who produces, markets, and sells a product known as "The Mist Writer" (MW). Research conducted by BLS indicates that college students have a need for a writing implement that produces a quality scrip ...

The word omnichannel is used a great deal to describe the

The word "omnichannel" is used a great deal to describe the consumer options today in an ever changing marketing environment. 1. Give an example of how "omnichannel" plays a role in your experiences as a consumer. 2. 2 P ...

Pick an organization public or private and then choose a

Pick an organization (public or private) and then choose a particular type of COI that is associated with this type of organization. Locate and describe any laws that are designed to discourage or prevent this type of CO ...

Skyline preparatory high for girls is an elite prep school

Skyline Preparatory High for Girls is an elite prep school with 47 faculty and staff members on the payroll. Jamie Davis, a two-year English instructor, becomes pregnant. She is not married. She is a slim woman who is no ...

A customer service in the healthcare industry is an idea

a. Customer service in the healthcare industry is an idea whose time has come—and it deserves serious attention. In fact, the focus on the customer/patient should be the most important thing in healthcare—and it can be a ...

A manufacturing company has a pool of 50 labor hours a

A manufacturing company has a pool of 50 labor hours. A customer has requested two products, Product A and Product B, and has requested 15 and 20 of each respectively. It requires 2 hours of labor to produce Product A an ...

What is employee engagement disengagement and actively

What is employee engagement, disengagement, and actively disengaged? Why are these concepts important? As Leaders in CIS, what hope do you have and what can you do to combat disengagement?

Please answer with short essayexplain mis infrastructure

Please answer with short essay Explain MIS infrastructure and some ways it ensures continuous business operations. (Ch 5 - D/R, Scalability) Discuss advantages and disadvantages of Cloud Computing, and why it is such an ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert