For this final assignment I’d like you to call upon your knowledge of forecasting to help project your firm’s revenue stream for the upcoming year. In the Microsoft Excel that is attached to this assignment, you will find the past four years of quarterly revenue data for your nonprofit. Your revenue comes from two major sources: individual donations and donations from corporations. I’d like you to use the past four years’ worth of data to forecast the individual donations and donations for corporations for the next fiscal year (year 5 quarters 1-4).   Once you have forecasted both individual revenue streams you can simply add them together to get your overall revenue forecast for the next fiscal year. Please discuss what forecasting method you chose and how you made your decision. You can do this in your excel document or write up a separate paragraph or two in a Microsoft Word document.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

For this final assignment I’d like you to call upon your knowledge of forecasting to help project your firm’s revenue stream for the upcoming year. In the Microsoft Excel that is attached to this assignment, you will find the past four years of quarterly revenue data for your nonprofit. Your revenue comes from two major sources: individual donations and donations from corporations. I’d like you to use the past four years’ worth of data to forecast the individual donations and donations for corporations for the next fiscal year (year 5 quarters 1-4).

 

Once you have forecasted both individual revenue streams you can simply add them together to get your overall revenue forecast for the next fiscal year. Please discuss what forecasting method you chose and how you made your decision. You can do this in your excel document or write up a separate paragraph or two in a Microsoft Word document. 

A
C
D
E
F
Time
Year
Quarter
Individual Donations
Donations from Local Businesses
Total Revenue
1
1
1
17600
40000
57600
2
1
18800
24000
42800
1
3
20800
48000
68800
4
1
4
22000
80000
102000
5
2
19200
44000
63200
2
2
19200
30000
49200
7
2
21200
44000
65200
8.
2
4
22400
88000
110400
9
3
1
20400
48000
68400
10
20800
32000
52800
11
3
22000
52000
74000
12
4
23200
72000
95200
13
4
1
21600
48000
69600
14
4
22000
40000
62000
15
4
23600
56000
79600
16
4
4
24400
84000
108400
17
5
1
18
19
5
3
20
4
Transcribed Image Text:A C D E F Time Year Quarter Individual Donations Donations from Local Businesses Total Revenue 1 1 1 17600 40000 57600 2 1 18800 24000 42800 1 3 20800 48000 68800 4 1 4 22000 80000 102000 5 2 19200 44000 63200 2 2 19200 30000 49200 7 2 21200 44000 65200 8. 2 4 22400 88000 110400 9 3 1 20400 48000 68400 10 20800 32000 52800 11 3 22000 52000 74000 12 4 23200 72000 95200 13 4 1 21600 48000 69600 14 4 22000 40000 62000 15 4 23600 56000 79600 16 4 4 24400 84000 108400 17 5 1 18 19 5 3 20 4
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.