464591 Convert Excel-based model to SQL or MySQL

In Progress

The project is to convert the attached Excel model to one that utilizes a relational data base. We would like to have an object-based application that allows us to build the models (like the one attached), which are customized to each client, in a simpler fashion.

In essence, a sales projection is input(C3), monthly sales forecasts are input (F4,T4,M4 etc) and then related expense percentages added (D22, D23 etc) and it creates a monthly forecast. When Actuals are input (H8,H9,H10 etc), it compares the actual to forecast on a dollar and percentage basis (columns J,K etc). The user can immediately tell if the amount or the percentage for each line item is above or below forecast based on color (red and green). YTD totals are included at the end.

One addition to the attached model we would like to add is the ability to forecast an expense by month (eg, D22 applies a cost for the entire year that is amortized monthly). The desire would be to forecast (for example) Auto Insurance at 1.2% of revenue in January and 1.2% for June only.

Further, the current model is given to clients and they manage the model themselves. The ability to export to HTML or XML and charge a subscription for access would be a welcome addition.

The attached is an example of a single branch. The application needs to allow for branches to be added, which then requires a Consolidated view.

Further, data is collected from a client as an export from Quickbooks. We also have a template that massages and redirects this data for input into the attached model, so once this assignment is done, the template will need to be completed.

Skills: Anything Goes, Excel, MySQL, SQL, Templates, XML

See more: month of january, models of fashion, k&k insurance, june is the month for, january is the month of, january is month, for the month of june, for the month of january, cost of sales template, build it green, application template excel, project object model, model view view model, xml excel, subscription based, sql based, SQL Access, sales excel, mysql to sql, model fashion, insurance application, forecast, Fashion model, export from excel, excel us

About the Employer:
( 0 reviews ) Austin,

Project ID: #2210487

Awarded to:


Please read PB for more details

$2740 USD in 90 days
(19 Reviews)