I have a small trucking business, I need to develop an EXCEL model where I plugin the numbers and I get results. There are Fixed & Variable costs in our business. Fixed Costs per trip remain unchanged, where as the Variable Costs vary per trip.
There are 2 types of Business Models in Trucking (in each cases the fixed and variable costs differ), so I will require 2 types of excel templates to plug and get the results.
I need a working model where I plug in some variables like No. of trips, Destination, Maintenance etc and the result I expect is
1. The Truck Break-Even for that MONTH
2. The No. of Trips it took to Break-Even
3. Profit / Loss for that MONTH
4. The system must enable data entry for unlimited No. of trucks and generate automatically the Grand Total Profit / Loss generated
5. I should be able to add / delete any variable
6. Suggested Solutions Have to Highly Scaleable
7. I need truck-wise profit / loss for any period like Month, Quarter, Yearly etc. The system must save all data entered to generate the required reports for period entered.
I will need visibility of all formulas used in each cell. Any kind of Charts / Graphs that can be added will be welcome.
I believe an accounting background would help, applicants with ACCOUNTING background will be preferred.
This is an urgent requirement, so only those with ability to complete the task in 3 days or so need apply please.
When you Apply please mention the code TRUCKING , so that I know you have read my brief.
20 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
I have a financial and accounting background and good understanding of financial analysis .I can deliver according to requirements and within the specifications.
I will set up an Executive summary page linked to data sheets that run the numbers, with filters to isolate datasets. I have [login to view URL] Supply Chain Management, was Director of Operations for 200 stores.