Used Cars Spreadsheet



Used Cars Spreadsheet, Chart and Letter

A used car dealer wants to use a spreadsheet to keep track of the value of the inventory. The spreadsheet should include the year and model of each car for sale and the price they paid for it. The dealer typically sells their cars at a 15% markup. Include a column for the markup price. Sort the data by year.

1972 Corvette, price paid $17,000

2000 Porsche, price paid $31,000

1957 Chevy Bel Aire, price paid $2,500

1978 Triumph, price paid $9,120

1983 Rolls Royce, price paid $68,920

1958 Cadillac, price paid $17,790

2003 Jaguar, price paid $44,650

1985 DeLorean, price paid $29,000

1999 Ferarri, price paid $32,340

1955 Studebaker, price paid $1,900

1980 Aston-Martin, price paid $56,700

1958 Thunderbird, price paid $28,000

1967 Mustang, price paid $22,460

Add labels and formulas to calculate the following in your spreadsheet:

• Total of the prices paid for all of the inventory

• The profit for each car.

• Change the markup to 12.5% for any car that was produced before 1970; all other cars remain at the 15% markup.

• The 1972 Corvette has been sold delete its row from the spreadsheet.

• One new car was added to the inventory 2004 Jeep, price paid $32,000 (make sure profit in calculated for it!)

• Create a bar chart, showing each car’s profit. Use approp-riate chart title, x and y axis titles and x axis labels noting model of each car.

• Write a letter to the sales people, mentioning an extra bonus commission of $1,000 (over the regular 2% commission) to anyone selling the car that has the biggest profit, include the chart and a picture of the car. Use business letter format. Include your name in the closing. The address of the car dealership is 1725 Middle Country Rd., Selden, NY 11784.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download