Excel application test

# Excel application test - Total Cost \$55,629.10 Total Profit...

This preview shows pages 1–2. Sign up to view the full content.

Item Number Total Profit FT56 44 \$26.58 \$32.75 \$1,169.52 \$1,441.00 \$271.48 FY78 62.00 14.59 16.90 904.58 1,047.80 143.22 GMI45 71.00 203.69 221.50 14,461.99 15,726.50 1,264.51 F40 30.00 16.95 21.25 508.50 637.50 129.00 GM52 612.00 34.57 41.00 21,156.84 25,092.00 3,935.16 F89 212.00 33.79 38.21 7,163.48 8,100.52 937.04 GM57 81.00 66.58 72.49 5,392.98 5,871.69 478.71 F56 109.00 44.69 52.99 4,871.21 5,775.91 904.70 Total Sales \$63,692.92

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Total Cost \$55,629.10 Total Profit \$8,063.82 % of Profit 14.5% Highest Profit \$3,935.16 Lowest Profit \$129.00 CA120 1/9/2007 Ms. Gail Youth A uto S upply Quantity Sold Initial Item Cost Item Sale Price Total Initial Cost Total Gross Sales FT56 4% FY78 5% GMI45 6% F40 2% GM52 50% F89 17% GM57 7% F56 9% Sales Profits...
View Full Document

## This test prep was uploaded on 04/13/2008 for the course CA CA120 taught by Professor N/a during the Fall '06 term at Montgomery CC.

### Page1 / 2

Excel application test - Total Cost \$55,629.10 Total Profit...

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

View Full Document
Ask a homework question - tutors are online