Q1

profilegysgtclarke
BooksRUsRawDataRES351Students3.xls
Home>Business & Finance homework help>Accounting homework help>Q1

Books R Us Sales Data

In the example below, total sales are forecasted using service sales. Sales Revenue by week
You can use the packet info to develop a set of forecasts of sales data or used a moving average of total services sales to forecast total sales.
For more information about this ficticious company and it's industry, First Quarter Second Quarter Third Quarter Fourth Quarter
Visit www.inkwaterpress.com, www.xlibris.com or www.firstbooks.com. Get a feel for this industry & examine the sales data Week Total Services Books Week Total Services Books Week Total Services Books Total Services Books
for “Books R Us”. Jan 5 - 9 7,932 6,985 947 Apr 5 - 9 7,811 6,956 556 7.5-7.9 9,216 8,209 1,017 Oct 4 - Oct 8 39,498 37,583 1,915
Jan 12 - 16 16,781 14,934 1,848 Apr 12 - 16 10,897 11,279 -69 7.12-7.16 11,217 7,925 3,292 Oct 11 - 15 13,956 12,383 1,573
Note that we have four sets of data. Bookselling Services Sales Revenue by week Jan 19 - 23 3,260 1,868 1,071 Apr 19 - 23 25,352 25,631 106 7.19-7.23 20,689 20,132 557 Oct 18 - 22 18,745 16,537 2,208
For each sample, how can I measure: Set up book signings Jan 26 - 30 3,401 1,227 2,141 Apr 26 - 30 10,190 11,555 1,310 7.26-7.30 26,042 23,862 2,180 Oct 25 - 29 24,863 24,057 806
Set up Radio / TV interviews Total Book Total Other Feb 2 - 6 1,412 760 580 May 3 - 7 16,058 15,340 717 Aug. 2 - 6 14,337 10,581 3,756 Nov. 1 - 5 13,564 12,082 1,483
The Mean Send e-mails to book stores Date Total Services Books Charges Feb 9 - 13 1,399 48 1,200 5.10 - 5.14 45,746 45,692 456 Aug 9 - 13 25,952 22,350 3,602 Nov. 8 - 12 15,193 14,646 547
Coefficient of Variation Send mass mailings to bookstores Jan 5 - 9 7932.04 6984.90 947.14 0 Feb 16 - 20 303 16 261.2 5.17 - 5.21 20,103 18,995 1,137 Aug 13-20 18,343 14,329 3,929 Nov. 15 - 19 25,946 21,819 2,527
The Standard Deviation Contact Film Makers Jan 12 - 16 16781.18 14933.55 1847.58 0.00 Feb 23 - 27 6,332 5255.5 1050.72 5.24-5.28 38,372 37,140 1,238 Aug 23-27 23,034 19,877 3,157 Nov. 22-26 10,612 9,004 1,608
The degree of skewness Print Books Jan 19 - 23, 04 3259.77 1868.45 1071.48 0.00 Mar 1 - 5 1,930 1,418 513 5.31-6.04 8,752 8,014 738 Aug 30 - Sept 3 10,573 8,483 2,104 Nov. 29-12/3 31,053 28,586 2,386
Line up book reviews Jan 26 - 30, 04 3400.51 1227.35 2141.44 319.84 Mar 8 - 12 9,329 556 8,773 6.7-6.11 14,845 13,414 1,370 Sept 6 - 10 14,976 12,305 2,671 Dec 6 - 10 20,910 20,237 673
How can I use these measures and compare Feb 2 - 6, 04 1411.65 760.00 579.68 31.72 Mar 15 - 19 20,876 18,178 1,198 6.14-6.18 9,191 8,129 1,062 Sept 13 - 17 18,616 16,960 1,657 Dec 13-17 14,231 13,051 1,180
to the overall total average (which you must first calculate) via: Feb 9 - 13, 04 1398.97 48.00 1199.80 71.97 Mar 22 - 26 20,144 19,507 638 6.21-6.25 11,166 8,878 2,288 Sept 20 - 24 22,217 19,379 2,839 Dec 20 - 24 4,575 4,056 519
A ratio analysis Feb 16 - 20, 04 302.90 16.00 261.2 151.17 Mar 29 - Apr 1 14,736 13,755 981 6.28-7.2 28,844 26,776 2,419 Sept 27 - Oct 01 28,503 26,340 2,211 Dec 27 - 31 18,756 17,783 973
The calculation of an index Feb 23 - 27, 04 6332.29 5255.5 1050.72 25.70 AVERAGE AVERAGE AVERAGE AVERAGE
A comparison of short term vs. long term trends Mar 1 - 5, 04 1930.27 1417.70 512.57 26.07 Standard Deviation Standard Deviation Standard Deviation Standard Deviation
Mar 8 - 12, 04 9328.66 555.80 8772.86 0 Coefficient of Var
Sample 1 Mar 15 - 19, 04 20876.30 18177.90 1198.40 0
Sales Revenue by week Mar 22 - 26, 04 20144.12 19506.53 637.59 1500.00 Ave. Weekly Sales
Mar 29 - Apr 1, 04 14735.99 13755.35 980.64 0
Total Other Total Total Books Apr 5 - 9, 04 7811.45 6955.70 555.75 0 Total Services Books Week Total
Date Total Charges Services Sales Apr 12 - 16, 04 10897.21 11279.45 -68.96 300.00 Quarter 1 0.00 0.00 0.00 Jan 5 - 9 7,932
Jan 19 - 23, 04 3259.77 319.84 1868.45 1071.48 Apr 19 - 23, 04 25352.02 25631.14 106.47 -313.28 Quarter 2 0.00 0.00 0.00 Jan 12 - 16 16,781
Jan 26 - 30, 04 3400.51 31.72 1227.35 2141.44 Apr 26 - 30, 04 10189.79 11555.33 1310.37 -385.59 Quarter 3 0.00 0.00 0.00 Jan 19 - 23 3,260
Feb 2 - 6, 04 1411.65 71.97 760.00 579.68 May 3 - 7, 04 16057.54 15340.28 717.26 -2675.91 Quarter 4 0.00 0.00 0.00 Jan 26 - 30 3,401
Feb 9 - 13, 04 1398.97 151.17 48.00 1199.80 5.10 - 5.14 45746.03 45692.45 456.39 0 Feb 2 - 6 1,412
Feb 16 - 20, 04 302.90 25.70 16.00 261.2 5.17 - 5.21 20103.36 18994.93 1137.38 -402.81 Feb 9 - 13 1,399
Feb 23 - 27, 04 6332.29 26.07 5255.5 1050.72 5.24-5.28 38372.29 37140.25 1237.54 -28.95 Services Feb 16 - 20 303 Total Reviewers 1646 8.13%
Mar 1 - 5, 04 1930.27 0 1417.70 512.57 5.31-6.04 8751.70 8013.50 738.20 -5.50 Quarter 1 6,604.29 Feb 23 - 27 6,332 Total Non-reviewes 6,828.00 33.74%
Mar 8 - 12, 04 9328.66 555.80 8772.86 6.7-6.11 14844.62 13414.41 1370.44 0.00 Total Reviewers 430.60 Mar 1 - 5 1,930 Total ca Publishing Services 11645.5 57.54%
Mar 15 - 19, 04 20876.30 1500.00 18177.90 1198.40 6.14-6.18 9190.94 8129.30 1061.64 59.77 Total Publishing 5,216.73 Mar 8 - 12 9,329 Frieght 117.75 0.58%
Mar 22 - 26, 04 20144.12 19506.53 637.59 6.21-6.25 11165.78 8877.90 2287.88 0.00 Total Other Serivces 950.36 Mar 15 - 19 20,876 Total Service 20237.25 1
Mar 29 - Apr 1, 04 14735.99 13755.35 980.64 6.28-7.2 29547.15 26776.46 2419.04 0.00 Misc 6.60 Mar 22 - 26 20,144 TOTAL 20910.41 1
Apr 5 - 9, 04 7811.45 300.00 6955.70 555.75 7.5-7.9 9215.86 8209.21 1016.94 351.65 Quarter 2 18292.39 Mar 29 - Apr 1 14,736
Apr 12 - 16, 04 10897.21 -313.28 11279.45 -68.96 7.12-7.16 11216.78 7925.25 3291.53 -10.29 Total Reviewers 1487.16 Apr 5 - 9 7,811
Apr 19 - 23, 04 25352.02 -385.59 25631.14 106.47 7.19-7.23 20688.91 20132.09 556.82 0.00 Total Publishing 10525.39 Apr 12 - 16 10,897
Apr 26 - 30, 04 10189.79 -2675.91 11555.33 1310.37 7.26-7.30 26042.36 23862.15 2180.21 0.00 Total Other Serivces 6171.82 Apr 19 - 23 25,352 Total Reviewers 2543 19.49%
May 3 - 7, 04 16057.54 15340.28 717.26 Aug. 2 - 6 14336.76 10580.50 3756.26 0.00 Misc 106.10 Apr 26 - 30 10,190 Total Non-reviewes 3209 24.59%
9589.34 Aug 9 - 13 25951.86 22349.55 3602.31 0.00 Quarter 3 16210.03 May 3 - 7 16,058 Total ca Publishing Services 7178 55.0%
Sample 2 7868.5703896646 Aug 13-20 18342.99 14328.85 3928.80 0.00 Total Reviewers 3159.33 5.10 - 5.14 45,746 Frieght 120.75 0.93%
Aug 23-27 23033.93 19876.60 3157.33 85.34 Total Publishing 8915.52 5.17 - 5.21 20,103 Total Service 13050.75 1
Sales Revenue by week Aug 30 - Sept 3 10573.23 8482.50 2104.00 0.00 Total Other Serivces 3986.05 5.24-5.28 38,372 TOTAL 14230.96 1
Sept 6 - 10 14976.30 12305.45 2670.85 -13.27 Misc 150.75 5.31-6.04 8,752
Total Other Total Total Books Sept 13 - 17 18616.10 16959.50 1656.60 0.00 Quarter 4 17832.61 6.7-6.11 14,845 Total Reviewers 399.00 2.25%
Date Total Charges Services Sales Sept 20 - 24 22217.21 19378.50 2838.71 0.00 Total Reviewers 401.23 6.14-6.18 9,191 Total Non-reviewes 6,923.00 39.05%
5.10 - 5.14 45746.03 -402.81 45692.45 456.39 Sept 27 - Oct 01 28502.94 26340.25 2210.54 0.00 Total Publishing 10342.91 6.21-6.25 11,166 Total ca Publishing Services 10,407.00 58.7%
5.17 - 5.21 20103.36 -28.95 18994.93 1137.38 Oct 4 - Oct 8 39497.64 37582.55 1915.09 -47.88 Total Other Serivces 6954.72 6.28-7.2 28,844 Frieght 17,729.00
5.24-5.28 38372.29 -5.50 37140.25 1237.54 Oct 11 - 15 13956.06 12383.11 1572.95 0.00 Misc 133.74 7.5-7.9 9,216 Total Service 17783
5.31-6.04 8751.70 0.00 8013.50 738.20 Oct 18 - 22 18745.25 16537.25 2208.00 0.00 7.12-7.16 11,217
6.7-6.11 14844.62 59.77 13414.41 1370.44 Oct 25 - 29 24862.70 24057.05 805.65 0.00 7.19-7.23 20,689
6.14-6.18 9190.94 0.00 8129.30 1061.64 Nov. 1 - 5 13564.34 12081.65 1482.69 0.00 7.26-7.30 26,042
6.21-6.25 11165.78 8877.90 2287.88 0.00 Nov. 8 - 12 15192.94 14646.10 546.84 0.00 Aug. 2 - 6 14,337
6.28-7.2 29547.15 351.65 26776.46 2419.04 Nov. 15 - 19 25946.12 21819.45 2526.67 0.00 Aug 9 - 13 25,952
7.5-7.9 9215.86 -10.29 8209.21 1016.94 Nov. 22-26 10611.55 9003.78 1607.77 1600.00 Aug 13-20 18,343
7.12-7.16 11216.78 0.00 7925.25 3291.53 Nov. 29-12/3 31053.16 28586.00 2386.16 0.00 Aug 23-27 23,034
7.19-7.23 20688.91 0.00 20132.09 556.82 Dec 6 - 10 20910.41 20237.25 673.16 81.00 Aug 30 - Sept 3 10,573
7.26-7.30 26042.36 0.00 23862.15 2180.21 Dec 13-17 14230.96 13050.75 1180.21 0.00 Sept 6 - 10 14,976
20407.15 Dec 20 - 24 4574.82 4056.00 518.82 0.00 Sept 13 - 17 18,616
Sample 3 12313.9882662146 Dec 27 - 31 18756.04 17783.00 973.04 0.00 Sept 20 - 24 22,217
Sales Revenue by week Sept 27 - Oct 01 28,503
Oct 4 - Oct 8 39,498
Total Other Total Total Books Oct 11 - 15 13,956
Date Total Charges Services Sales Oct 18 - 22 18,745
Aug. 2 - 6 14336.76 0.00 10580.50 3756.26 Oct 25 - 29 24,863
Aug 9 - 13 25951.86 0.00 22349.55 3602.31 Nov. 1 - 5 13,564
Aug 13-20 18342.99 85.34 14328.85 3928.80 Nov. 8 - 12 15,193
Aug 23-27 23033.93 0.00 19876.60 3157.33 Nov. 15 - 19 25,946
Aug 30 - Sept 3 10573.23 -13.27 8482.50 2104.00 Nov. 22-26 10,612
Sept 6 - 10 14976.30 0.00 12305.45 2670.85 Nov. 29-12/3 31,053
Sept 13 - 17 18616.10 0.00 16959.50 1656.60 Dec 6 - 10 20,910
Sept 20 - 24 22217.21 0.00 19378.50 2838.71 Dec 13-17 14,231
Sept 27 - Oct 01 28502.94 -47.88 26340.25 2210.54 Dec 20 - 24 4,575
Oct 4 - Oct 8 39497.64 0.00 37582.55 1915.09 Dec 27 - 31 18,756 Pop standard dev
Oct 11 - 15 13956.06 0.00 12383.11 1572.95 16,361 9889.4654693024
Oct 18 - 22 18745.25 0.00 16537.25 2208.00
Oct 25 - 29 24862.70 0.00 24057.05 805.65
Nov. 1 - 5 13564.34 0.00 12081.65 1482.69
Nov. 8 - 12 15192.94 0.00 14646.10 546.84
20158.02
Sample 4 7458.1619342433
Total Other Total Total Books
Date Total Charges Services Sales
Nov. 15 - 19 25946.12 1600 21819.45 2526.67
Nov. 22-26 10611.55 0 9003.78 1607.77
Nov. 29-12/3 31053.16 81 28586 2386.16
Dec 6 - 10 20910.41 0 20237.25 673.16
Dec 13-17 14230.96 0 13050.75 1180.21
Dec 20 - 24 4574.82 0 4056 518.82
Dec 27 - 31 18756.04 0 17783 973.04
Mean 18011.87 16362.3185714286 1409.4042857143
Stand Dev 9051.68 8294.4977091793 797.8954805164

Books R Us Sales Data
Total 7932.04 16781.18 3259.77 3400.51 1411.65 1398.97 302.90 6332.29
Weeks
Thousands $$
Books R Us Total Sales Trends
Total
Services
Books
Average Weekly Sales BRUS