I will order a sheet in Excel with formulas, which will provide us with the information we need based on the entered data.
The data is entered into the spreadsheet by our employees: travel time to the customer, working time, return time, order number, respectively for the following days of the month.
We need to get the following data from it:
- travel costs (based on the number of kilometers traveled and a constant value)
- labor cost for a given order (based on time and a proportional share in the cost of the day's work)
The sheet must easily provide us with data from the entire month, all costs assigned to a given order number, and for one order number, costs may be included in different cells (travel cost, labor cost) and on different days of the month.
The sheet must work properly under OpenOffice.