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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- template generic vehicle checklist
- used cars spreadsheet
- inspection and testing form nfpa
- archives inventory template
- answers to chapters 1 2 3 4 5 6 7 8 9 end of chapter
- great plains inventory control fact sheet
- inventory sheet
- sample account for decedent s estate
- business plan template
- generic inventory package veterans affairs
Related searches
- cheap used cars with financing
- used cars financing
- buying used cars with cash
- finance used cars near me
- used cars with no credit check
- used cars bad credit no down payment
- used cars for sale with no credit
- used cars no down payment
- financing used cars tips
- cargurus used cars private owner
- used cars dealers financing companies
- used cars with financing available