Find Jobs
Hire Freelancers

Create budget analysis program(repost)

$100-500 USD

Abgeschlossen
Veröffentlicht vor etwa 14 Jahren

$100-500 USD

Bezahlt bei Lieferung
I need a program that will do what this excel mockup does but in a nicer setting like asp.net c# or the like. This is a budget analysis tool that the user can play with budget and? purchases numbers to see how they can be under budget ('what if purchases less of ...) Database is great plains. There is really one sales table the SOP10200, a customer budget table, and smaller customer and category description tables. We would like to have nice graphics as well we have existing gauge or if you can use the Telerik we have this product. ## Deliverables When the user opens the page she should be able to see a summary of the budget ??" see summary view I have a fairly simple summary by category for all the expenses in a given date range or year to date. Plan on showing the budget for 1 month, 3 months etc. You could also add ? +/- buttons next to the ToDate and Budget values, allowing the user to play with the numbers, allowing her to make category-level what-if projections. ? The detail view is the area where the user can make changes by item to the budget for what-if projections. I would add every item the user purchased in the chosen time period, ? quantity purchased, ? an average unit price and extended price for that item. This way, he can make a quick guess on how many more units needs to buy. ? Because this is a what-if tool, an average price is good enough ??" (In some ways, it is even better than showing the current price.) The user may not need to see the item number ? The user should be able to edit only the new qty and new total ? columns. ??" I expect they will only edit the units column. This is for? analysis use only. not updating the application.? Thus, by simply editing one column per row they can quickly arrive at the projected budget.? Allow the user to add items they may not have purchased previously.? In those cases, you will have to allow them to edit the average cost. ? To recap: ? Add forecast range ??" from/to dates ? - no default values You can also add a data range ??" or just show it as inferred from the data page ? ? On the summary Add two sliders ??" one for budget and one for actuals . inactivate budget slider As the user changes the slider on actuals, extrapolate forecast. ? Add a button to activate budget slider, and commit/save new oudget. When the user is done changing the budget, check that the budget total is not affected.? User should be able to move money between categories/departments but overall total should remain constant. ? Extrapolation: When the user enters a forecast range, extrapolate that data based on current purchases. Similarly, extrapolate the budget as the user manipulates the slider on the summary ? For example, if the data range is Jan-Mar 2010 and the forecast range is Jan ??" Dec 2010 then the extrapolation will be current data/3 * 12 i.e. quantity purchased to date * 12/3? this number should go to the forecast qty column in both summary and detail views. If the user changes the slider by 10 % - then forecast quantity = qty purchased to date *10/100 You should be using the same data table as the source for the summary and detail views. ? You could also add graphic elements to items that are going over-budget
Projekt-ID: 3281932

Über das Projekt

3 Vorschläge
Remote Projekt
Aktiv vor 14 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
See private message.
$297,49 USD in 14 Tagen
5,0 (68 Bewertungen)
5,5
5,5
3 Freelancer bieten im Durchschnitt $382 USD für diesen Auftrag
Avatar des Nutzers
See private message.
$425 USD in 14 Tagen
5,0 (120 Bewertungen)
5,2
5,2
Avatar des Nutzers
See private message.
$425 USD in 14 Tagen
5,0 (1 Bewertung)
1,3
1,3

Über den Kunden

Flagge von UNITED STATES
United States
4,8
39
Mitglied seit Juni 17, 2009

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.