I am creating an automobile finance system for retail bike dealer. The system contains features using which inventory, purchase, sales and party (customers, suppliers, manufacturers, financers) details can be maintained.
Here inventory indicates to vehicles only which can be two wheeler, three wheeler and four wheeler. A lot of information is used to store with inventory, among these the following are crutial :-
1. car value, 2. down payment, 3. no. of EMI(s) and 4. EMI value.
(here EMI means Equal Monthly Installment)
when purchases are made inventory gets increase by qty and on sales it decreases as it normally should.
all these are working great and the system is also doing fine. the system is almost ready but I've stucked in a point where i need to generate a report based on vehicle wise profitability. i am using crystal report for reporting services.
the payment procedure in this system is as follows :-
1. customer buys the vehicle of his/her choice paying a lumpsum amount as down payment. the actual value of the vehicle, no. of emi(s) and emi value have been stored in inv. master and these all are getting stored when the sales invoice is created.
2. after this,customer pays only emi month by month to clear the rest of amount. details of emis such as no. of emi (which the customer is currently paying), its value, due date , payment date, latefine (if customer pays the emi after due date is crossed) and net amount (actual emi value+latefine) are generated by the system.
this procedure continues till the full amount for the vehicle is recovered from the relevant customer.
now i am on need to create a report which can show vehicle wise profit/loss the dealer is making by selling each vehicle.
my question is, how can i generate the profitability....can anybody give me idea based on the above scenario to compute profit/loss vehicle wise.....if there is any kind of formula for creating the profitability, that will be much better....plz send if there is any resources regarding this are available....if possible plz send the link to my email :- [email removed]
plz help in this....its very urgent....
any help will be appreciated...
thnks in advance...