Scenario
Black Cherry Comics (BCC) is a UK publisher that translates and repackages popular Japanese 'Manga' comics. In the last five years, its sales in the teenage and young professional market have increased phenomenally as this Japanese art form becomes more popular. The Owner of BCC is currently investigating the possibility of expanding their operations to include foreign language editions (e.g. French, German) for export to the EU.
As part of this process they need a fresh analysis of the sales data for all 10 of their currently published titles. The information and statistics provided should convince their bank of the company's buoyancy and improving sales, and be supporting evidence for a business loan to help finance the European expansion.
You have recently been employed in BCC's small IT department to create a spreadsheet model which will analyse the collected data and produce suitable reports and graphs as part of a management information system (MIS).
By using the BCC Sales Data provided create a working spreadsheet model.
Assignment 1 (Duration: 5 hours; Hand in: End of 1st Week) P1, D1
Assignment 2 (Duration: 20 hours; Hand in: End of 5th Week) P2, P3, P4, M1, M2
Assignment 3 (Duration: 10 hours; Hand in: End of 7th week) P5, P6, M3
Assignment 4 (Duration: 20 hours; Hand in: End of 11th Week) P7, P8, P9, M4, D2
As part of this process they need a fresh analysis of the sales data for all 10 of their currently published titles. The information and statistics provided should convince their bank of the company's buoyancy and improving sales, and be supporting evidence for a business loan to help finance the European expansion.
You have recently been employed in BCC's small IT department to create a spreadsheet model which will analyse the collected data and produce suitable reports and graphs as part of a management information system (MIS).
By using the BCC Sales Data provided create a working spreadsheet model.
Assignment 1 (Duration: 5 hours; Hand in: End of 1st Week) P1, D1
Assignment 2 (Duration: 20 hours; Hand in: End of 5th Week) P2, P3, P4, M1, M2
Assignment 3 (Duration: 10 hours; Hand in: End of 7th week) P5, P6, M3
Assignment 4 (Duration: 20 hours; Hand in: End of 11th Week) P7, P8, P9, M4, D2