Question: How do I solve question B & C in excel ? please show me how to solve so i can do it for the next

How do I solve question B & C in excel ? please show me how to solve so i can do it for the next two. thank you.

B: in colum c (starting in the appropriate cell) write a formula using a built in excel function to forecast demand through October using an MA (3) model.

C: in colum d (starting in the appropriate cell) write a formula using a built in excel function to forecast demand through October using an MA (5) model.

month orders delivered

jan 120

feb 90

mar. 100

april 75

may 110

june 50

july 75

aug 130

sep 110

oct 90

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!

please answer 1 & 2 using EXCEL. PLEASE SHOW ALL FORMULAS USED IN CELLS. thank you! nts Beverage Shootout' Coca-Cola vs. Pepsi Financial Statement Analysis First, you need to export financial...

Solve the following linear programming question using Excel. ( 2 0 Pts ) . A company is involved in the production of two items ( x and Y ) . The resources need to produce x and Y are twofold, namely...

SOLVE A,B, AND C. USE EXCEL PLEASE! 19. Dunn Manufacturing is considering the following two alternatives. The cost information for the two proposals for replacing an equipment are provided are in...

PLEASE ANSWER PART B, C, AND D! PLEASE SHOW THE FORMULA SHEET, NOT JUST THE EXCEL WITH THE NUMBERS. THANK YOU Webmasters.com has developed a powerful new server that would be used for corporations'...

1. ABC's most recent free cash flow (FCF 0 ) is $100 million. The free cash flow is expected to grow at a rate of 30 percent in next year and 20 percent in the second year. After two years, it is...

1. ABC's most recent free cash flow (FCF0) is $100 million. The free cash flow is expected to grow at a rate of 30 percent in next year and 20 percent in the second year. After two years, it is...

Info: Info & Questions 1 A, B, C, and D: Please show ALL WORK and equations used to solve problems! (explain as much as you can please, preferably showing equations on excel!) CASE LO8-22, L08-4Q,...

Solve for part D only. Also, please show your work/formulas in excel and thank you. Expected Monthly Return Expected Monthly Return PG Microsoft BAC Exxon 0.010848 0.014854 0.011589 0.012043 Variance...

please solve question b using the same method of question a and provide steps thank you A code C runs T seconds to stin rewelte for an input of size 5 . How to find the odter of rentime for the sods...

There are 9 million disabled people (12.3% of the population) in Turkey (DIE, 2005). How can you achieve equity principle for disabled people in public administration?

Describe the major reasons that helped the CIO of Los Angeles to decide to use Google Apps rather than upgrade the city's existing Microsoft system.

2 What are the main differences between digital currency and cryptocurrency?

help Activity-based costing systems can mitigate product cost distortions because A) ABC relies solely on unit-level cost drivers. B) the calculations used in ABC are more complicated calculations...