Accounting Question

Course ProjectFollow the instructions in each tab to complete the exercise. Fill out the yellow cells.
Forecast
Projections
Pivot
Chart
Variances
25%
25%
10%
20%
20%
100%
Instructions
Compute Naïve forecast, moving average forecast, and weighted moving average forecast.
Must use formulas to compute the answers
January
February
March
April
May
June
July
August
September
October
November
December
Sales
100
130
130
140
150
160
170
190
150
130
120
Naïve Forecast
Moving Average
%
Weighted moving average
0.03
0.03
0.04
0.05
0.05
0.15
0.02
0.12
0.3
0.1
0.11
100.0%
0
Instructions
Your manager wants a 15% increase on December Year 2 sales vs December Y1 Sales. Dec Y2 sales must be 15% higher than D
Input the amount necessary to reach 15% (Dec Y2 over Dec Y1). The increase must be the same every month until Dec y2 is 1
Must use formulas to compute the answers.
SALES
Product 1
Product 2
Product 3
Y1
December
1,900
1,500
2,500
Y2
January
Y2
February
Y2
March
Y2
April
Y2
May
Y2
June
ales must be 15% higher than Dec Y1 sales.
e every month until Dec y2 is 15% higher than Dec y1.
Y2
July
Y2
August
Y2
September
Y2
October
Y2
November
Y2
December
Instructions
Make a pivot table with the data below. Put Product as row labels, Month as Column lables, and Sales as values
Month
Sales
Product
January
200 A
February
400 A
March
1200 A
April
450 A
May
500 A
June
700 A
July
350 A
August
400 A
September
900 A
October
200 A
November
1500 A
December
3000 A
January
2000 B
February
3500 B
March
4500 B
April
2000 B
May
2500 B
June
1000 B
July
3000 B
August
5000 B
September
4000 B
October
2000 B
November
1500 B
December
1000 B
January
6000 C
February
6500 C
March
7000 C
April
3000 C
May
3500 C
June
4500 C
July
4000 C
August
5000 C
September
7000 C
October
5000 C
November
5500 C
December
4000 C
les as values
Instructions
Make a chart that shows revenue and expenses by month, in bar graphs (next to each other) and the rate as a line graph.
In order to do the rate as a line graph, you have to make it a seconday axis.
Revenue
Expenses
Rate
January
5,000
4,000
1.2
February
5,500
4,400
1.3
March
6,000
4,800
1.15
April
6,500
5,200
1.5
May
7,000
5,600
1.5
June
7,500
6,000
1.3
July
8,000
6,400
1.4
er) and the rate as a line graph.
August
September
8,500
9,000
6,800
7,200
1.2
1.1
October November December
9,500
10,000
10,500
7,600
8,000
8,400
1.08
1.2
1.3
Instructions
Calculate variances and mention if the variance is favorable or unfavorable or Neither.
Provide a brief explanation as to why the variance is favorable or unfavorable
Sales
Expenses
Net Income
Salary Expense
Y1
$200,000
$100,000
$500,000
$200,000
Y2
$300,000
$100,000
$300,000
$300,000
Variance ($)
Favorable or Unfavorable
Why is it favorable or unfavorable
Course Project
Follow the instructions in each tab to complete the exercise. Fill out the yellow cells.
Forecast
Projections
Pivot
Chart
Variances
25%
25%
10%
20%
20%
100%
Instructions
Compute Naïve forecast, moving average forecast, and weighted moving average forecast.
Must use formulas to compute the answers
January
February
March
April
May
June
July
August
September
October
November
December
Sales
100
130
130
140
150
160
170
190
150
130
120
Naïve Forecast
Moving Average
%
Weighted moving average
0.03
0.03
0.04
0.05
0.05
0.15
0.02
0.12
0.3
0.1
0.11
100.0%
0
Instructions
Your manager wants a 15% increase on December Year 2 sales vs December Y1 Sales. Dec Y2 sales must be 15% higher than D
Input the amount necessary to reach 15% (Dec Y2 over Dec Y1). The increase must be the same every month until Dec y2 is 1
Must use formulas to compute the answers.
SALES
Product 1
Product 2
Product 3
Y1
December
1,900
1,500
2,500
Y2
January
Y2
February
Y2
March
Y2
April
Y2
May
Y2
June
ales must be 15% higher than Dec Y1 sales.
e every month until Dec y2 is 15% higher than Dec y1.
Y2
July
Y2
August
Y2
September
Y2
October
Y2
November
Y2
December
Instructions
Make a pivot table with the data below. Put Product as row labels, Month as Column lables, and Sales as values
Month
Sales
Product
January
200 A
February
400 A
March
1200 A
April
450 A
May
500 A
June
700 A
July
350 A
August
400 A
September
900 A
October
200 A
November
1500 A
December
3000 A
January
2000 B
February
3500 B
March
4500 B
April
2000 B
May
2500 B
June
1000 B
July
3000 B
August
5000 B
September
4000 B
October
2000 B
November
1500 B
December
1000 B
January
6000 C
February
6500 C
March
7000 C
April
3000 C
May
3500 C
June
4500 C
July
4000 C
August
5000 C
September
7000 C
October
5000 C
November
5500 C
December
4000 C
les as values
Instructions
Make a chart that shows revenue and expenses by month, in bar graphs (next to each other) and the rate as a line graph.
In order to do the rate as a line graph, you have to make it a seconday axis.
Revenue
Expenses
Rate
January
5,000
4,000
1.2
February
5,500
4,400
1.3
March
6,000
4,800
1.15
April
6,500
5,200
1.5
May
7,000
5,600
1.5
June
7,500
6,000
1.3
July
8,000
6,400
1.4
er) and the rate as a line graph.
August
September
8,500
9,000
6,800
7,200
1.2
1.1
October November December
9,500
10,000
10,500
7,600
8,000
8,400
1.08
1.2
1.3
Instructions
Calculate variances and mention if the variance is favorable or unfavorable or Neither.
Provide a brief explanation as to why the variance is favorable or unfavorable
Sales
Expenses
Net Income
Salary Expense
Y1
$200,000
$100,000
$500,000
$200,000
Y2
$300,000
$100,000
$300,000
$300,000
Variance ($)
Favorable or Unfavorable
Why is it favorable or unfavorable