Abstract

This project is up to create a spreadsheet for purchasing and reporting old car inventory for a car dealership.

Introduction

Create a spreadsheet excel for purchasing and reporting old car inventory for a car dealership. The spreadsheet includes all information related to purchasing cars, selling cars, taxes, salaries of employees, profit for the company in the past 1 year sales and finally calculating the loss and profit incurred in the year 2019 vs 2020.

Details of all items used

I used excel to create the spreadsheet, website, and Github.

Problem statement

To look for the amount of selling cars 2019 and 2020.

Methodology

I added all information about the cars.

Then the cost of each one.

After that I put a formula to know the variable cost which it was (=G3*H3+F3), then a spired down to have the other result for each model of car.

To know the sold car price I did something similar as the last step, but putting a different this formula (=F3+I13).

Finally, to know profit or loss amount was (=J3-F3).

After to have all amounts I calculated the total of each one variable cost, sold car price, and profit or loss using (=SUM) and selecting all cells. (=SUM(F3:F7)).

In this sheet, I did the profit 2020. Putting the dame models of cars but with a different cost.

Formula =G3*H3+FE

As I did in the last sheet to calculate Sold of car and profit or loss.

Total purchasing cars 2019 and 2020.

I went to the third sheet where is all information about employees. Having highest =MAX(B3:B8), Lowest =MIN(B3:B8), and Average =AVERAGE(B3:B9).

Gross Pay =C2*D2

State taxes =0.04*E2

TAX =(F2+G2)/E2

Net Pay =(E2-F2-G2).

Final chart with all data updated.

Future work

To resolve the problems and avoid them in a future project.

Results

Result s about selling cars 2019 and 2020.

Conclusion#

To know the value of each car by putting some formulas in excel.

References

Github Excel Cars models wedside