Purposes Of Spreadsheet
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.
BCC are 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 that will
accurately perform the following functions.