Excel spreadsheet/application required

Closed - This job posting has been filled and work has been completed.

Job Description

Hi,

I need assistance to create a spreadsheet or other application which does the following:

1. Takes input from a user around the amount of phone handsets a customer requires
2. Takes a custom Bill of Material and based on the size of the customer provided in step 1 suggests the correct bill of materials required. The custom bill of materials are for <30 handsets or >30 handsets
3. Creates a labour estimate for the amount of work required to configure the system (based on some simple metrics to be provided)
4. Calculates a per user, per month cost for the system
5. Has the ability to future add other aspects like data or phone services

It's a pretty simple project for someone great with Excel, I'd suggest it'll take 4-6 hours.