Excel Case Study 2

Excel Case Study 2 - 16,880 19,295 13,555 J a n u r y F e b M c h A p il Rodney's Video Rentals Semi-Annual Sales Report Total Average Highest

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
September 10, 2007 Rodney's Video Rentals Semi-Annual Sales Report Total Average Highest Lowest Video Rentals 12,300 15,000 13,995 15,266 16,792 16,094 89,447 14,908 16,792 12,300 Video Sales 495 700 980 1,180 1,358 1,127 5,840 973 1,358 495 Investment Interest 325 335 350 375 412 402 2,199 367 412 325 DVD Player Sales 400 525 605 495 544 675 3,244 541 675 400 Snack Sales 200 150 225 315 346 258 1,494 249 346 150 Net Sales 13,720 16,710 16,155 17,631 19,452 18,556 102,224 17,037 19,452 13,720 J a n u r y F e b M c h A p il
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
September 10, 2007 Rodney's Video Rentals Semi-Annual Sales Report Total Average Highest Lowest Video Rentals 12,275 14,990 13,950 15,200 16,760 16,050 89,225 14,871 16,760 12,275 Video Sales 450 650 990 1,150 1,300 1,100 5,640 940 1,300 450 Investment Interest 300 300 300 350 375 350 1,975 329 375 300 DVD Player Sales 380 500 590 500 530 640 3,140 523 640 380 Snack Sales 150 100 200 300 330 220 1,300 217 330 100 Net Sales 13,555 16,540 16,030 17,500 19,295 18,360 101,280
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 16,880 19,295 13,555 J a n u r y F e b M c h A p il September 10, 2007 Rodney's Video Rentals Semi-Annual Sales Report Total Average Highest Lowest Video Rentals $25 $10 $45 $66 $32 $44 $222 $37 $66 $10 Video Sales $45 $50 ($10) $30 $58 $27 $200 $33 $58 ($10) Investment Interest $25 $35 $50 $25 $37 $52 $224 $37 $52 $25 DVD Player Sales $20 $25 $15 ($5) $14 $35 $104 $17 $35 ($5) Snack Sales $50 $50 $25 $15 $16 $38 $194 $32 $50 $15 Net Sales $165 $170 $125 $131 $157 $196 $944 $157 $196 $125 Bonus Rate 10% Bonus $16.50 $17.00 $12.50 $13.10 $15.70 $19.60 $94.40 Performance Above Above Above Above Above Above Above J a n u r y F e b M c h A p il 1 2 3 4 5 6 ($20) ($10) $0 $10 $20 $30 $40 $50 $60 $70 $80 Sales By Month Video Rentals Video Sales Investment Interest DVD Player Sales Snack Sales Month Actual-Forecast...
View Full Document

This note was uploaded on 04/04/2012 for the course IT 103 taught by Professor Sangjara during the Fall '08 term at George Mason.

Page1 / 3

Excel Case Study 2 - 16,880 19,295 13,555 J a n u r y F e b M c h A p il Rodney's Video Rentals Semi-Annual Sales Report Total Average Highest

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online