I'm doing a business course and am having trouble with this excel question.

[adrinakhobane123]

I'm doing a business course and am having trouble with this excel question.

I need to design a spreadsheet in Excel, that keeps track of annual expenses for the company car, but have no numerical data.

The only information given is the labels needed to be used, such as main heading, date, mileage, petrol, maintenance, registration, insurance, subtotals, averages and main totals. I have no idea on where to start and the textbook isn't really helping me, so I was hoping someone on here might be able to help or at least steer me in the right direction, thanks.

 

[Michael M]

Aren't you supplied with some sort of data to base your expenses on.
If not I'd suggest they want you to create a hypothetical set of data from possibly other references in your texbook.
But we can't help if there is no data to manipulate !

 

[sastoka]

Hi there,

Here is how I would do.

Assign a sheet for each type of cost

- Maintenance: date, duration of maintenance, invoice number, cost, and average cost per day
- Journey: date, duration, petrol, mileage, destination from and to, toll fees, and average per km and per hours
- inurance and registration : date, number of type per year, amount, before and after taxes, increase rate
- Summary : create a table that is linked to all the total, then out of that create a pivot.

in each sheet i's recommend to create one table per car so you can keep track car by car.

create date, then we'll help with the rest
Regards.

 

[adrinakhobane123]

thankyou you have all helped me heaps

 

[Fazza]

Best I think to have a single sheet for all costs in a single table (for all cars if there are multiple cars, for all companies if multiple companies). Some of those headings would be better as entries in single field - such as 'category'field with entries petrol, maintenance, registration or insurance.

With such an efficient setup reporting can be done simply without needing any formulas and utilising various Excel built-in data handling techniques. For example, a pivot table. The alternative of having multiple tables/worksheets for each category & for each car & for each company will lead to inefficiencies.