Title | Mountain Bikes - Lecture notes 8 |
---|---|
Author | Jordan Allison |
Course | Principles of Information Management |
Institution | University of the West of Scotland |
Pages | 7 |
File Size | 114.6 KB |
File Type | |
Total Downloads | 68 |
Total Views | 122 |
Notes crucial to coursework...
Greig Brown PIM
Goliath Moron Apple Amber Scotty Totals
Jan 4 6 0 1 1
Feb 4 7 6 0 0
Mar 3 4 4 0 1
12
17
12
Price 250 395 195 495 695
No. Sold >50 >100 >50 >25 >50
Bonus £25.00 £39.50 £19.50 £49.50 £69.50
Jan £4,560.00
Feb £4,935.00
Mar £3,805.00
Total Income Before Tax £15,500.00 £33,970.00 £12,480.00 £8,910.00 £22,935.00
Gross Income
Total Income After Tax
£93,795.00
£93,939.50
Reference Table Goliath Moron Apple Amber Scotty Total Sales Bonus Goliath Moron Apple Amber Scotty
Bike Type Goliath Moron Apple Amber Scotty Total
£25.00 £0.00 £19.50 £0.00 £0.00
£65,757.65
Apr 0 6 3 0 2
May 4 7 0 1 3
Jun 3 4 0 0 2
Jul 5 6 5 1 0
Aug 6 6 4 0 0
Sep 6 7 9 1 1
Oct 7 8 6 3 0
Nov 8 10 12 5 8
Dec 12 15 15 6 15
11
15
9
17
16
24
24
43
63
Jun Jul Sep Apr May Aug Oct Nov Dec £4,345.00 £6,345.00 £3,720.00 £5,090.00 £4,650.00 £7,210.00 £7,565.00 £16,325.00 £25,245.00
Jun 9
Jul 17
Total 26
Bonus £100.00
Total of Each Bike 62 86 64 18 33 263
Monthly Sa £30,000.00
£25,000.00
£20,000.00
£15,000.00
£10,000.00
£5,000.00
£0.00 Jan
Feb
Mar
Apr
May
Jun
les
Jul
Aug
Sep
Oct
Nov
Dec
Yearly Sales £100,000.00
£90,000.00
£80,000.00
£70,000.00
£60,000.00
£50,000.00
£40,000.00
£30,000.00
£20,000.00
£10,000.00
£0.00 Goliath
Moron
Apple
Amber
s
Column B
Scotty
Total...