Kean.edu
General
Home
About
Educational
Kean University
MSAS5004
Intro to Programming
MSAS5104
Data Structures
MSAS5302
Decision Support Systems
MSAS5599
Web Site Design
Caldwell College
CS115
Intro to Computers
CS185
Intro to Programming
Business
Panda Imprinting
Panda Formals
DSM Internet Services
Custom Printed Boxers
Little Jammies
Tie-Dye Mania

 

CS115-09 Homework for week 9 - due November 4th

Create a financial report for Acme Products Company

You are the new director of finance for Acme Products, the company that produces the great inventions used by Wyle E. Coyote to try to catch the Road Runner. Below are some financial figures for 2001 and 2002. Use those figures to produce a report for the President of the company. You should show:

  • Total gross revenue by year
  • Total net revenue by year (Gross - Cost of goods sold) = Net
  • Percent sales increase (decrease) by month comparing the same month in 2001 to 2002
    • calculated as: difference / original value
    • (2002 value - 2001 value) / 2001 value = percent increase
  • Bar charts depicting the monthly sales trends for 2001 and 2002

This is a report for the President. Spelling, grammar, punctuation and overall look counts. Fonts should be consistent throughout the document.

Turn in:

  • The spreadsheet and any charts created.

Here is the data:

Month Gross Sales Cost of Goods Sold
Jan 2001 236723 183934
Feb 2001 269623 204959
Mar 2001 273204 214945
Apr 2001 269345 200132
May 2001 314959 249823
Jun 2001 295864 230235
Jul 2001 304785 246956
Aug 2001 325606 279202
Sep 2001 336069 284503
Oct 2001 350664 302456
Nov 2001 348970 300256
Dec 2001 378428 334055
Jan 2002 364956 312350
Feb 2002 375963 323405
Mar 2002 382378 339992
Apr 2002 390012 338821
May 2002 408432 349991
Jun 2002 402948 342341
Jul 2002 415093 350001
Aug 2002 425059 354841
Sep 2002 442020 373459
Oct 2002 451023 381295
Nov 2002 462030 391123
Dec 2002 479982 401134

Download the data









Copyright© 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008 All rights reserved.