I have 3 assisgnments that I need done by Saturday on finance

profilecarfito
Module2Assignment5.xlsx
Home>Business & Finance homework help>Accounting homework help>I have 3 assisgnments that I need done by Saturday on finance

Questions

Type your name here, Last Name First
Forecasting Advanced Intermediate Exercises
30.1. Businesses in the city of Techville are required to remit their sales tax collections every month to the city tax department. To ensure that business owners are in compliance, the city assesses a penalty on businesses that are out of compliance with this regulation at the beginning of each quarter. The exercise spreadsheet includes the revenue data for the collection of sales tax receipts from businesses.
a. Prepare a graph of the revenue collection from July 2006 to June 2013. Does there appear to be seasonality in the data?
b. Prepare an overlay graph of the revenue collection to validate your assumption.
c. Go through the appropriate steps to deseasonalize the data in preparation for the next budget cycle forecasting. Upon reaching the step of having deseasonalized data for July 2006 to June 2013, prepare a chart similar to Figure 30.20 showing the original data with the deseasonalized data.
30.2. Valley County is developing a forecast for its sales tax revenue. The data they believe will increase the accuracy of the forecast include the number of single-family home permits, the average monthly rent for an apartment in a multifamily facility, and the employment levels in the county. This problem requires using a non-restricted spreadsheet. Data are provided separately
a. Using the data provided and the regression functionality in Excel, develop a model (formula) for predicting sales tax revenues.
b. Calculate the Durbin Watson statistic. Are the residuals correlated with each other, and why?
c. Reverse the log of the predicted value (sales tax).
d. Provide the predictive formula derived from these calculations.
e. Calculate the predicted change in sales tax revenue next year using differences.
x
Type your name here, Last Name First
Please enter your name on the first page

Put Graphs Here

Put Results Exercise 29.1c below 1a and 1c below, 1b to the right
Exercise 1
Put data for graph 1b here
Fiscal Year Month MonthYear Revenue Deseasonlized FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 FY 2013
FY 2007 July Jul-06 486 Graph for Exercise 1a July
FY 2007 Aug Aug-06 118,228 Aug
FY 2007 Sept Sep-06 738,995 Sept
FY 2007 Oct Oct-06 40,469 Oct
FY 2007 Nov Nov-06 194,269 Nov
FY 2007 Dec Dec-06 522,234 Dec
FY 2007 Jan Jan-07 7,241 Jan
FY 2007 Feb Feb-07 163,667 Feb
FY 2007 Mar Mar-07 543,571 Mar
FY 2007 Apr Apr-07 7,700 Apr
FY 2007 May May-07 72,777 May
FY 2007 Jun Jun-07 654,310 Jun
FY 2008 July Jul-07 600
FY 2008 Aug Aug-07 132,025 Put Graph for Exercise 1a Here
FY 2008 Sept Sep-07 694,925 Graph for Exercise 1b
FY 2008 Oct Oct-07 14,590
FY 2008 Nov Nov-07 2,951
FY 2008 Dec Dec-07 760,545
FY 2008 Jan Jan-08 3,492
FY 2008 Feb Feb-08 102,809
FY 2008 Mar Mar-08 670,206 Put Graph for Exercise 1b Here
FY 2008 Apr Apr-08 7,467
FY 2008 May May-08 46,430
FY 2008 Jun Jun-08 768,589
FY 2009 July Jul-08 198
FY 2009 Aug Aug-08 176,875
FY 2009 Sept Sep-08 614,337
FY 2009 Oct Oct-08 8,079 Graph for Exercise 1c
FY 2009 Nov Nov-08 171,477
FY 2009 Dec Dec-08 652,988
FY 2009 Jan Jan-09 2,814
FY 2009 Feb Feb-09 147,537
FY 2009 Mar Mar-09 664,756
FY 2009 Apr Apr-09 4,541
FY 2009 May May-09 109,509
FY 2009 Jun Jun-09 712,203
FY 2010 July Jul-09 4,835
FY 2010 Aug Aug-09 200,091
FY 2010 Sept Sep-09 663,140
FY 2010 Oct Oct-09 7,705
FY 2010 Nov Nov-09 5,790 Put Graph for Exercise 1c Here
FY 2010 Dec Dec-09 885,442
FY 2010 Jan Jan-10 965
FY 2010 Feb Feb-10 105,881
FY 2010 Mar Mar-10 880,198
FY 2010 Apr Apr-10 12,602
FY 2010 May May-10 177,362
FY 2010 Jun Jun-10 546,337
FY 2011 July Jul-10 1,805
FY 2011 Aug Aug-10 118,645
FY 2011 Sept Sep-10 696,400
FY 2011 Oct Oct-10 5,908
FY 2011 Nov Nov-10 205,746
FY 2011 Dec Dec-10 547,898
FY 2011 Jan Jan-11 7,926
FY 2011 Feb Feb-11 136,651
FY 2011 Mar Mar-11 724,465
FY 2011 Apr Apr-11 7,200
FY 2011 May May-11 173,590
FY 2011 Jun Jun-11 691,634
FY 2012 July Jul-11 5,842
FY 2012 Aug Aug-11 228,060
FY 2012 Sept Sep-11 554,226
FY 2012 Oct Oct-11 8,118
FY 2012 Nov Nov-11 4,763
FY 2012 Dec Dec-11 829,057
FY 2012 Jan Jan-12 3,105
FY 2012 Feb Feb-12 290,004
FY 2012 Mar Mar-12 596,768
FY 2012 Apr Apr-12 4,935
FY 2012 May May-12 88,855
FY 2012 Jun Jun-12 743,767
FY 2013 July Jul-12 2,682
FY 2013 Aug Aug-12 160,706
FY 2013 Sept Sep-12 544,784
FY 2013 Oct Oct-12 10,584
FY 2013 Nov Nov-12 281,208
FY 2013 Dec Dec-12 624,579
FY 2013 Jan Jan-13 936
FY 2013 Feb Feb-13 141,268
FY 2013 Mar Mar-13 322,932
FY 2013 Apr Apr-13 5,195
FY 2013 May May-13 181,479
FY 2013 Jun Jun-13 929,887

Exercise 30.1c

To show the cell checking, put a check here: x Grade Graph 1 Percent Correct 0%
Grade Graph 2
Grade Graph 3
Fiscal Year Month MonthYear Revenue 12Month Average 2 Month Average Seasonal Ratio Average Seasonals Normalized Seasonals Damped Seasonals De-Seasonalized Check Grade
0 0 0
computed ratio Factor 0 0
verify 0
FY 2007 July Jul-06 486 0 0
FY 2007 Aug Aug-06 118,228 0 0
FY 2007 Sept Sep-06 738,995 0 0
FY 2007 Oct Oct-06 40,469 0 0
FY 2007 Nov Nov-06 194,269 0 0
FY 2007 Dec Dec-06 522,234 0 0
FY 2007 Jan Jan-07 7,241 0 0 0 0 0 0 0
FY 2007 Feb Feb-07 163,667 0 0 0 0 0 0 0
FY 2007 Mar Mar-07 543,571 0 0 0 0 0 0 0
FY 2007 Apr Apr-07 7,700 0 0 0 0 0 0 0
FY 2007 May May-07 72,777 0 0 0 0 0 0 0
FY 2007 Jun Jun-07 654,310 0 0 0 0 0 0 0
FY 2008 July Jul-07 600 0 0 0 0 0 0 0
FY 2008 Aug Aug-07 132,025 0 0 0 0 0 0 0
FY 2008 Sept Sep-07 694,925 0 0 0 0 0 0 0
FY 2008 Oct Oct-07 14,590 0 0 0 0 0 0 0
FY 2008 Nov Nov-07 2,951 0 0 0 0 0 0 0
FY 2008 Dec Dec-07 760,545 0 0 0 0 0 0 0
FY 2008 Jan Jan-08 3,492 0 0 0 0 0
FY 2008 Feb Feb-08 102,809 0 0 0 0 0
FY 2008 Mar Mar-08 670,206 0 0 0 0 0
FY 2008 Apr Apr-08 7,467 0 0 0 0 0
FY 2008 May May-08 46,430 0 0 0 0 0
FY 2008 Jun Jun-08 768,589 0 0 0 0 0
FY 2009 July Jul-08 198 0 0 0 0 0
FY 2009 Aug Aug-08 176,875 0 0 0 0 0
FY 2009 Sept Sep-08 614,337 0 0 0 0 0
FY 2009 Oct Oct-08 8,079 0 0 0 0 0
FY 2009 Nov Nov-08 171,477 0 0 0 0 0
FY 2009 Dec Dec-08 652,988 0 0 0 0 0
FY 2009 Jan Jan-09 2,814 0 0 0 0 0
FY 2009 Feb Feb-09 147,537 0 0 0 0 0
FY 2009 Mar Mar-09 664,756 0 0 0 0 0
FY 2009 Apr Apr-09 4,541 0 0 0 0 0
FY 2009 May May-09 109,509 0 0 0 0 0
FY 2009 Jun Jun-09 712,203 0 0 0 0 0
FY 2010 July Jul-09 4,835 0 0 0 0 0
FY 2010 Aug Aug-09 200,091 0 0 0 0 0
FY 2010 Sept Sep-09 663,140 0 0 0 0 0
FY 2010 Oct Oct-09 7,705 0 0 0 0 0
FY 2010 Nov Nov-09 5,790 0 0 0 0 0
FY 2010 Dec Dec-09 885,442 0 0 0 0 0
FY 2010 Jan Jan-10 965 0 0 0 0 0
FY 2010 Feb Feb-10 105,881 0 0 0 0 0
FY 2010 Mar Mar-10 880,198 0 0 0 0 0
FY 2010 Apr Apr-10 12,602 0 0 0 0 0
FY 2010 May May-10 177,362 0 0 0 0 0
FY 2010 Jun Jun-10 546,337 0 0 0 0 0
FY 2011 July Jul-10 1,805 0 0 0 0 0
FY 2011 Aug Aug-10 118,645 0 0 0 0 0
FY 2011 Sept Sep-10 696,400 0 0 0 0 0
FY 2011 Oct Oct-10 5,908 0 0 0 0 0
FY 2011 Nov Nov-10 205,746 0 0 0 0 0
FY 2011 Dec Dec-10 547,898 0 0 0 0 0
FY 2011 Jan Jan-11 7,926 0 0 0 0 0
FY 2011 Feb Feb-11 136,651 0 0 0 0 0
FY 2011 Mar Mar-11 724,465 0 0 0 0 0
FY 2011 Apr Apr-11 7,200 0 0 0 0 0
FY 2011 May May-11 173,590 0 0 0 0 0
FY 2011 Jun Jun-11 691,634 0 0 0 0 0
FY 2012 July Jul-11 5,842 0 0 0 0 0
FY 2012 Aug Aug-11 228,060 0 0 0 0 0
FY 2012 Sept Sep-11 554,226 0 0 0 0 0
FY 2012 Oct Oct-11 8,118 0 0 0 0 0
FY 2012 Nov Nov-11 4,763 0 0 0 0 0
FY 2012 Dec Dec-11 829,057 0 0 0 0 0
FY 2012 Jan Jan-12 3,105 0 0 0 0 0
FY 2012 Feb Feb-12 290,004 0 0 0 0 0
FY 2012 Mar Mar-12 596,768 0 0 0 0 0
FY 2012 Apr Apr-12 4,935 0 0 0 0 0
FY 2012 May May-12 88,855 0 0 0 0 0
FY 2012 Jun Jun-12 743,767 0 0 0 0 0
FY 2013 July Jul-12 2,682 0 0 0 0 0
FY 2013 Aug Aug-12 160,706 0 0 0 0 0
FY 2013 Sept Sep-12 544,784 0 0 0 0 0
FY 2013 Oct Oct-12 10,584 0 0 0 0 0
FY 2013 Nov Nov-12 281,208 0 0 0 0 0
FY 2013 Dec Dec-12 624,579 0 0 0 0 0
FY 2013 Jan Jan-13 936 0 0 0
FY 2013 Feb Feb-13 141,268 0 0
FY 2013 Mar Mar-13 322,932 0 0
FY 2013 Apr Apr-13 5,195 0 0
FY 2013 May May-13 181,479 0 0 0
FY 2013 Jun Jun-13 929,887 0 0 415

Answer 1a

Exercise 1
Fiscal Year Month MonthYear Revenue
FY 2007 July Jul-06 486
FY 2007 Aug Aug-06 118,228
FY 2007 Sept Sep-06 738,995
FY 2007 Oct Oct-06 40,469
FY 2007 Nov Nov-06 194,269
FY 2007 Dec Dec-06 522,234
FY 2007 Jan Jan-07 7,241
FY 2007 Feb Feb-07 163,667
FY 2007 Mar Mar-07 543,571
FY 2007 Apr Apr-07 7,700
FY 2007 May May-07 72,777
FY 2007 Jun Jun-07 654,310
FY 2008 July Jul-07 600
FY 2008 Aug Aug-07 132,025
FY 2008 Sept Sep-07 694,925
FY 2008 Oct Oct-07 14,590
FY 2008 Nov Nov-07 2,951
FY 2008 Dec Dec-07 760,545
FY 2008 Jan Jan-08 3,492
FY 2008 Feb Feb-08 102,809
FY 2008 Mar Mar-08 670,206
FY 2008 Apr Apr-08 7,467
FY 2008 May May-08 46,430
FY 2008 Jun Jun-08 768,589
FY 2009 July Jul-08 198
FY 2009 Aug Aug-08 176,875
FY 2009 Sept Sep-08 614,337
FY 2009 Oct Oct-08 8,079
FY 2009 Nov Nov-08 171,477
FY 2009 Dec Dec-08 652,988
FY 2009 Jan Jan-09 2,814
FY 2009 Feb Feb-09 147,537
FY 2009 Mar Mar-09 664,756
FY 2009 Apr Apr-09 4,541
FY 2009 May May-09 109,509
FY 2009 Jun Jun-09 712,203
FY 2010 July Jul-09 4,835
FY 2010 Aug Aug-09 200,091
FY 2010 Sept Sep-09 663,140
FY 2010 Oct Oct-09 7,705
FY 2010 Nov Nov-09 5,790
FY 2010 Dec Dec-09 885,442
FY 2010 Jan Jan-10 965
FY 2010 Feb Feb-10 105,881
FY 2010 Mar Mar-10 880,198
FY 2010 Apr Apr-10 12,602
FY 2010 May May-10 177,362
FY 2010 Jun Jun-10 546,337
FY 2011 July Jul-10 1,805
FY 2011 Aug Aug-10 118,645
FY 2011 Sept Sep-10 696,400
FY 2011 Oct Oct-10 5,908
FY 2011 Nov Nov-10 205,746
FY 2011 Dec Dec-10 547,898
FY 2011 Jan Jan-11 7,926
FY 2011 Feb Feb-11 136,651
FY 2011 Mar Mar-11 724,465
FY 2011 Apr Apr-11 7,200
FY 2011 May May-11 173,590
FY 2011 Jun Jun-11 691,634
FY 2012 July Jul-11 5,842
FY 2012 Aug Aug-11 228,060
FY 2012 Sept Sep-11 554,226
FY 2012 Oct Oct-11 8,118
FY 2012 Nov Nov-11 4,763
FY 2012 Dec Dec-11 829,057
FY 2012 Jan Jan-12 3,105
FY 2012 Feb Feb-12 290,004
FY 2012 Mar Mar-12 596,768
FY 2012 Apr Apr-12 4,935
FY 2012 May May-12 88,855
FY 2012 Jun Jun-12 743,767
FY 2013 July Jul-12 2,682
FY 2013 Aug Aug-12 160,706
FY 2013 Sept Sep-12 544,784
FY 2013 Oct Oct-12 10,584
FY 2013 Nov Nov-12 281,208
FY 2013 Dec Dec-12 624,579
FY 2013 Jan Jan-13 936
FY 2013 Feb Feb-13 141,268
FY 2013 Mar Mar-13 322,932
FY 2013 Apr Apr-13 5,195
FY 2013 May May-13 181,479
FY 2013 Jun Jun-13 929,887

Answer 1b

FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 FY 2013
July 486 600 198 4,835 1,805 5,842 2,682
Aug 118,228 132,025 176,875 200,091 118,645 228,060 160,706
Sept 738,995 694,925 614,337 663,140 696,400 554,226 544,784
Oct 40,469 14,590 8,079 7,705 5,908 8,118 10,584
Nov 194,269 2,951 171,477 5,790 205,746 4,763 281,208
Dec 522,234 760,545 652,988 885,442 547,898 829,057 624,579
Jan 7,241 3,492 2,814 965 7,926 3,105 936
Feb 163,667 102,809 147,537 105,881 136,651 290,004 141,268
Mar 543,571 670,206 664,756 880,198 724,465 596,768 322,932
Apr 7,700 7,467 4,541 12,602 7,200 4,935 5,195
May 72,777 46,430 109,509 177,362 173,590 88,855 181,479
Jun 654,310 768,589 712,203 546,337 691,634 743,767 929,887

Answer 1c

Fiscal Year Month MonthYear Revenue 12Month Average 2 Month Average Seasonal Ratio Average Seasonals Normalized Seasonals Damped Seasonals De-Seasonalized
12.0525257217 12 12
0.9956419324 0.99
12
FY 2007 July Jul-06 486 0.019379517 25,085
FY 2007 Aug Aug-06 118,228 0.6178279844 191,361
FY 2007 Sept Sep-06 738,995 2.2939002477 322,157
FY 2007 Oct Oct-06 40,469 0.0438611512 922,664
FY 2007 Nov Nov-06 194,269 0.4347613411 446,840
FY 2007 Dec Dec-06 522,234 2.584633189 202,053
FY 2007 Jan Jan-07 7,241 255,329 255,334 0.02836026 0.0158066932 0.0157378066 0.0255804285 283,081
FY 2007 Feb Feb-07 163,667 255,338 255,913 0.6395396743 0.5772801084 0.5747642826 0.5790166398 282,663
FY 2007 Mar Mar-07 543,571 256,488 254,652 2.1345651413 2.4834323186 2.4726093527 2.4578832592 221,154
FY 2007 Apr Apr-07 7,700 252,816 251,737 0.0305876778 0.0272510811 0.027132319 0.0368609958 208,895
FY 2007 May May-07 72,777 250,659 242,687 0.2998781931 0.4068686199 0.405095459 0.4110445044 177,053
FY 2007 Jun Jun-07 654,310 234,716 244,646 2.6745222053 2.5213424656 2.5103542848 2.4952507419 262,222
FY 2008 July Jul-07 600 254,575 254,419 0.0023587869 0.0095157297 0.0094742596 0.019379517 30,967
FY 2008 Aug Aug-07 132,025 254,263 251,727 0.5244752484 0.6166550855 0.613967661 0.6178279844 213,691
FY 2008 Sept Sep-07 694,925 249,191 254,468 2.730898688 2.3170678857 2.3069699472 2.2939002477 302,945
FY 2008 Oct Oct-07 14,590 259,744 259,734 0.0561717789 0.0343528953 0.0342031831 0.0438611512 332,635
FY 2008 Nov Nov-07 2,951 259,725 258,627 0.0114108021 0.4309298812 0.4290518597 0.4347613411 6,788
FY 2008 Dec Dec-07 760,545 257,529 262,291 2.8996274293 2.6120229575 2.6006395849 2.584633189 294,257
FY 2008 Jan Jan-08 3,492 267,052 267,036 0.0130755975 0.0255804285 136,497
FY 2008 Feb Feb-08 102,809 267,019 268,888 0.3823476668 0.5790166398 177,557
FY 2008 Mar Mar-08 670,206 270,756 267,399 2.5063924232 2.4578832592 272,676
FY 2008 Apr Apr-08 7,467 264,041 263,769 0.0283087793 0.0368609958 202,572
FY 2008 May May-08 46,430 263,498 270,520 0.1716338261 0.4110445044 112,957
FY 2008 Jun Jun-08 768,589 277,542 273,060 2.8147208633 2.4952507419 308,021
FY 2009 July Jul-08 198 268,579 268,551 0.0007369932 0.019379517 10,213
FY 2009 Aug Aug-08 176,875 268,522 270,386 0.654157161 0.6178279844 286,285
FY 2009 Sept Sep-08 614,337 272,250 272,023 2.2584033171 2.2939002477 267,813
FY 2009 Oct Oct-08 8,079 271,796 271,674 0.0297378778 0.0438611512 184,195
FY 2009 Nov Nov-08 171,477 271,552 274,180 0.6254177223 0.4347613411 394,417
FY 2009 Dec Dec-08 652,988 276,808 274,459 2.3791835713 2.584633189 252,643
FY 2009 Jan Jan-09 2,814 272,110 272,303 0.0103346713 0.0255804285 110,012
FY 2009 Feb Feb-09 147,537 272,496 273,463 0.539512816 0.5790166398 254,806
FY 2009 Mar Mar-09 664,756 274,431 276,464 2.4044931399 2.4578832592 270,459
FY 2009 Apr Apr-09 4,541 278,498 278,482 0.0163054702 0.0368609958 123,187
FY 2009 May May-09 109,509 278,466 271,563 0.4032566072 0.4110445044 266,418
FY 2009 Jun Jun-09 712,203 264,659 274,345 2.5960157303 2.4952507419 285,424
FY 2010 July Jul-09 4,835 284,030 283,953 0.0170277677 0.019379517 249,495
FY 2010 Aug Aug-09 200,091 283,876 282,141 0.7091884483 0.6178279844 323,862
FY 2010 Sept Sep-09 663,140 280,405 289,382 2.2915758517 2.2939002477 289,088
FY 2010 Oct Oct-09 7,705 298,358 298,694 0.0257956411 0.0438611512 175,668
FY 2010 Nov Nov-09 5,790 299,030 301,857 0.0191813472 0.4347613411 13,318
FY 2010 Dec Dec-09 885,442 304,685 297,773 2.9735427514 2.584633189 342,579
FY 2010 Jan Jan-10 965 290,862 290,736 0.0033191616 0.0255804285 37,724
FY 2010 Feb Feb-10 105,881 290,610 287,216 0.368645579 0.5790166398 182,863
FY 2010 Mar Mar-10 880,198 283,823 285,208 3.0861575043 2.4578832592 358,112
FY 2010 Apr Apr-10 12,602 286,594 286,519 0.0439819019 0.0368609958 341,870
FY 2010 May May-10 177,362 286,445 294,776 0.6016835144 0.4110445044 431,491
FY 2010 Jun Jun-10 546,337 303,108 289,043 1.890156481 2.4952507419 218,951
FY 2011 July Jul-10 1,805 274,979 275,269 0.0065584232 0.019379517 93,157
FY 2011 Aug Aug-10 118,645 275,559 276,841 0.4285667934 0.6178279844 192,035
FY 2011 Sept Sep-10 696,400 278,123 271,634 2.5637421578 2.2939002477 303,588
FY 2011 Oct Oct-10 5,908 265,145 264,920 0.0222998099 0.0438611512 134,690
FY 2011 Nov Nov-10 205,746 264,695 264,538 0.7777573491 0.4347613411 473,240
FY 2011 Dec Dec-10 547,898 264,381 270,435 2.025987299 2.584633189 211,983
FY 2011 Jan Jan-11 7,926 276,489 276,657 0.0286477011 0.0255804285 309,830
FY 2011 Feb Feb-11 136,651 276,825 281,384 0.4856369691 0.5790166398 236,005
FY 2011 Mar Mar-11 724,465 285,943 280,019 2.5871947748 2.4578832592 294,751
FY 2011 Apr Apr-11 7,200 274,095 274,187 0.0262610445 0.0368609958 195,341
FY 2011 May May-11 173,590 274,280 265,905 0.6528264378 0.4110445044 422,314
FY 2011 Jun Jun-11 691,634 257,531 269,246 2.5687814113 2.4952507419 277,180
FY 2012 July Jul-11 5,842 280,961 280,760 0.0208078022 0.019379517 301,452
FY 2012 Aug Aug-11 228,060 280,559 286,949 0.7947755513 0.6178279844 369,132
FY 2012 Sept Sep-11 554,226 293,339 288,018 1.9242757331 2.2939002477 241,609
FY 2012 Oct Oct-11 8,118 282,697 282,603 0.0287258205 0.0438611512 185,084
FY 2012 Nov Nov-11 4,763 282,509 278,978 0.0170730385 0.4347613411 10,955
FY 2012 Dec Dec-11 829,057 275,447 277,619 2.9863072458 2.584633189 320,764
FY 2012 Jan Jan-12 3,105 279,792 279,660 0.0111027676 0.0255804285 121,382
FY 2012 Feb Feb-12 290,004 279,528 276,722 1.047997945 0.5790166398 500,856
FY 2012 Mar Mar-12 596,768 273,916 273,522 2.1817909279 2.4578832592 242,798
FY 2012 Apr Apr-12 4,935 273,129 273,231 0.0180616126 0.0368609958 133,881
FY 2012 May May-12 88,855 273,334 284,853 0.3119331409 0.4110445044 216,169
FY 2012 Jun Jun-12 743,767 296,371 287,851 2.5838581027 2.4952507419 298,073
FY 2013 July Jul-12 2,682 279,331 279,241 0.0096046053 0.019379517 138,394
FY 2013 Aug Aug-12 160,706 279,151 272,953 0.5887673107 0.6178279844 260,114
FY 2013 Sept Sep-12 544,784 266,756 255,346 2.1335115663 2.2939002477 237,492
FY 2013 Oct Oct-12 10,584 243,936 243,947 0.0433864436 0.0438611512 241,307
FY 2013 Nov Nov-12 281,208 243,958 247,817 1.1347390282 0.4347613411 646,810
FY 2013 Dec Dec-12 624,579 251,677 259,432 2.4074894481 2.584633189 241,651
FY 2013 Jan Jan-13 936 267,187 0.0255804285 36,590
FY 2013 Feb Feb-13 141,268 0.5790166398 243,979
FY 2013 Mar Mar-13 322,932 2.4578832592 131,386
FY 2013 Apr Apr-13 5,195 0.0368609958 140,935
FY 2013 May May-13 181,479 0.4110445044 441,507
FY 2013 Jun Jun-13 929,887 2.4952507419 372,663

Grade Worksheet

2.5 Total Points Available Item Grade Weight x A mark here makes the numbers in the grade calculation visible.
0.25 Base Points (for trying this exercise)
0.45 Manual Points
1.8 Points to be graded
0.0% Percent all sheets
0 Graded Points
0 Graph 1 0.15 0
0 Graph 2 0.15 0
0 Graph 3 0.15 0
0.25 Initial Grade 0.45
0.1 Minimum Earned Points
0.35 Threshold
0 Grade Grade Table
A 100%
B 90%
C 80%
D 70%
F 0%