Sales 2 - 3,702 December 1,533 2,013 444 3,990 Total 17,232...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
NewGeneration Monitors Case Problem Tutorial 3 Author: Luke Tomaselli Box 1694 Seat 17 Date: 3/12/2006 Purpose: To report and analyze annual sales figures from three NewGeneration monitors
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Filename: a2ebf81e61a02a63282f1ef4ef59fd8128b3a0b6.xls 05/07/2009 Page 2 of 3 Prepared by: Luke Tomaselli NewGeneration Monitors Sales Data 1/1/2006 - 12/31/2006 Monthly Sales Data Month VX100 VX300 FlatScreen Total January 1,410 1,860 435 3,705 February 1,284 1,704 390 3,378 March 1,443 1,875 435 3,753 April 1,425 1,842 423 3,690 May 1,509 1,998 450 3,957 June 1,473 1,923 453 3,849 July 1,533 1,863 465 3,861 August 1,452 1,914 441 3,807 September 1,368 1,794 420 3,582 October 1,389 1,836 429 3,654 November 1,413 1,866 423
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3,702 December 1,533 2,013 444 3,990 Total 17,232 22,488 5,208 44,928 Filename: a2ebf81e61a02a63282f1ef4ef59fd8128b3a0b6.xls 05/07/2009 Page 3 of 3 Prepared by: Luke Tomaselli NewGeneration Monitors Sales Data 1/1/2006 - 12/31/2006 Analysis of 2006 Sales Monitor Units Sold Total Revenue VX100 $199.99 $165.20 $34.79 17,232 $3,446,227.68 $599,501.28 20.03% VX300 $299.99 $234.75 $65.24 22,488 $6,746,175.12 $1,467,117.12 49.03% FlatScreen $899.99 $722.23 $177.76 5,208 $4,687,147.92 $925,774.08 30.94% Total 44,928 $14,879,550.72 $2,992,392.48 Price per Unit Cost per Unit Gross Profit per Unit Gross Profit from Sales % of Gross Profit from Sales...
View Full Document

Page1 / 3

Sales 2 - 3,702 December 1,533 2,013 444 3,990 Total 17,232...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online