ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

Excel 2 lab test a

•
•
D
deborah canning

This document summarizes sales data for 9 items sold by JKT Auto Supply, including the initial cost, sale price, total initial cost, gross sales, and profit for each item. The totals at the bottom show the company's total sales were $45,427.54, total costs were $40,746.90, and total profit was $4,680.64, which is an 11.5% profit margin. The highest individual item profit was $2,051.92 and the lowest was $34.96.

1 of 1
Download to read offline
Item Number Quantity Sold Initial Item Cost Item Sale Price Total Initial Item Cost Total Gross Sales Total Item Profit CHCAM79 45 35.86$ 37.65$ 1,613.70$ 1,694.25$ 80.55$ CHLUM93 26 22.49 25.19 584.74 654.94 70.20 LX96 52 225.49 264.95 11,725.48 13,777.40 2,051.92 CHCAV95 76 18.19 18.65 1,382.44 1,417.40 34.96 LX99 214 54.67 62.35 11,699.38 13,342.90 1,643.52 CH85 121 34.99 36.39 4,233.79 4,403.19 169.40 LX98 62 58.69 66.02 3,638.78 4,093.24 454.46 CHV72 91 64.49 66.42 5,868.59 6,044.22 175.63 Total Sales 45,427.54$ Total Cost 40,746.90$ Total Profit 4,680.64$ % of Profit 11.5% Highest Profit 2,051.92$ Lowest Profit 34.96$ JKT Auto Supply Profit on Items Sold

More Related Content

Excel 2 lab test a

  • 1. Item Number Quantity Sold Initial Item Cost Item Sale Price Total Initial Item Cost Total Gross Sales Total Item Profit CHCAM79 45 35.86$ 37.65$ 1,613.70$ 1,694.25$ 80.55$ CHLUM93 26 22.49 25.19 584.74 654.94 70.20 LX96 52 225.49 264.95 11,725.48 13,777.40 2,051.92 CHCAV95 76 18.19 18.65 1,382.44 1,417.40 34.96 LX99 214 54.67 62.35 11,699.38 13,342.90 1,643.52 CH85 121 34.99 36.39 4,233.79 4,403.19 169.40 LX98 62 58.69 66.02 3,638.78 4,093.24 454.46 CHV72 91 64.49 66.42 5,868.59 6,044.22 175.63 Total Sales 45,427.54$ Total Cost 40,746.90$ Total Profit 4,680.64$ % of Profit 11.5% Highest Profit 2,051.92$ Lowest Profit 34.96$ JKT Auto Supply Profit on Items Sold