Mountain Bikes - Lecture notes 8 PDF

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 PDF
Total Downloads 68
Total Views 122

Summary

Notes crucial to coursework...


Description

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...


Similar Free PDFs