Đã Đóng

Estimating + Quotation-Invoicing system for small shop

I have a relatively simple project that entails two sections. It is a specialized estimating system that will allow the workers of a sheet metal fabrication shop to enter dimensions of specific types of sheet metal enclosures and ducts, and then have the program calculate amounts of sheet metal required, cost per unit dependent upon the gauge/thickness/type of the metal, and add in a factor for labour, and the option to add in a couple other variable factors per type of shape.

(Imagine a series of duct shapes... a "Y"-shaped vent, a curved right-angle bend, a reducing channel... all fairly standard shapes in the HVAC industry. However, a contractor will bring in specific dimensions, usually in inches, of how large the openings will be, how wide, tall and deep a component will be, etc. THERE is where the dimensions need to be entered into a subprogram for each type of shape, then the factors calculated to come up with a final cost.) See the attached PDF document for additional data that will clarify what the shop currently runs with, and what is required.

The above mentioned part is relatively easy, actually, and I would do it myself in Excel, except the resultant quote results (and this is the second part of the project) must be stored in a format that can be brought over into a quotation/invoicing structure that can be stored like any typical sales/estimating/quoting system.

The girl at the front of the shop must be able to bring up the data in its quoted form, confirm with the customer all the details, then save that as a customer order and later, an invoice that will be stored.

Typical post-processing, in terms of end-of-month sales reporting, lookups, etc., must be possible from such a system.

Either side of this type of processing is not terribly difficult; however, I have been unable to find a commercial package that will do such a task relatively economically... the ones who CAN do the estimating part are massive, expensive programs with long learning curves, offering so many features that the needed estimation part is less than a tenth of all that is offered; hence, much of the remaining application is never used and wasted.

Companies with estimating/quoting/records-retrieval systems are a dime-a-dozen, but cannot do the variable-shape-dimensioning type of quoting required.

Try to think of the finished product as a typical, relatively simple, quoting/invoicing/AR/AP, the kind that an experienced ACCESS programmer probably already has lots of boilerplate code for. The only difference is that the product costs come in through the estimating section from the shop floor, and I would supply all the formulas for that to work, most likely in Excel format, so the existing, working formulas can be transferred wholesale into your developed product.

I would have done the project myself, but two limiting factors apply:

1) My MS-Access knowledge is rusty... somewhere over 10 years old. I am, however, very experienced in Excel and a range of other applications.

2) I have several other projects on the go, some technical, some programming and some investment, that prevent me from applying the proper amount of time required to do this in a timely manner.

I would hope a programming task such as this could be accomplished in less than a week or two, with follow-up adjustments as required. If it would take more than 3 or 4 weeks to complete the main body of programming, this may not be feasible. Please advise accordingly.

I await your response. Please respond with any clarifications you require. Thank you for your consideration.

W. Halyn

Kỹ năng: Microsoft Access

Xem thêm: invoicing system access, access invoicing system, quotation system access, kind programmer need, programming used, learning series, system find workers, sales quotation format, programming variable types, programming excel 2013, programmer shop, programmer find customer, programmer excel add programming, programmer contractor, processing find programmer, order processing companies, need data structure programmer, microsoft programmer, microsoft excel programmer, microsoft excel formulas, microsoft access programming, metal sales, labour work, need sales girl

Về Bên Thuê:
( 0 nhận xét ) Muskoka, Canada

Mã Dự Án: #4549273

17 freelancer đang chào giá trung bình $1125 cho công việc này

illuminesoft

Can you give your existing Dos based application of calculations for analysis. I will appreciate if you let me know which other features of your existing software are to be used in New MS Access database application.

$1172 CAD trong 14 ngày
(239 Đánh Giá)
7.4
Prashantskin

Res.Buyer I have gone through your interesting project. I will develop everything in access. Please see PMB for details Thanks for your time Regards Prashant

$1250 CAD trong 10 ngày
(458 Đánh Giá)
6.9
kulhanekd

I have 15 years exp building access databases. I would like to be the person to builds yours. I can start today. Thanks Donna

$1111 CAD trong 7 ngày
(32 Đánh Giá)
5.8
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards winnet21

$900 CAD trong 14 ngày
(10 Đánh Giá)
4.7
MarlinSoftware

Hi, I have 12 years experience developing MS Access applications and feel confident that I could do this project for you. I would give this project priority in order to complete within the deadline. Please view my port Thêm

$1200 CAD trong 14 ngày
(11 Đánh Giá)
4.7
VBAWhizz

I have 20 years of Access and VBA experience - please see your PMB for further details of my proposal.

$1500 CAD trong 14 ngày
(6 Đánh Giá)
4.6
MentisSoftware

I have 20 years experience with Microsoft Access development and I am very interested in working with you. Please see your PM for more information.

$1250 CAD trong 14 ngày
(3 Đánh Giá)
3.8
SajjadHussain14

Hi, Plz check PM

$1111 CAD trong 15 ngày
(2 Đánh Giá)
3.2
bhavinjani

hi please check pm

$1250 CAD trong 10 ngày
(1 Đánh Giá)
1.0
paris2785

VB, VBA and Databases expert for over a decade. Msc in Information Systems.

$750 CAD trong 7 ngày
(0 Đánh Giá)
0.0
cuiontech

We can do this for you. But I would want to know if you would prefer it to be a web based application and done in PhP and my SQL instead of MS - Access. Please let me know if you would be interested in discussing this Thêm

$1578 CAD trong 30 ngày
(0 Đánh Giá)
0.0
Tablassus

Greetings Mr. Halyn. I have checked your requirements and I am ready to start. Please check my samples of past works along with some presentation of my work. Thanks also for your well detailed project. Best regards Fi Thêm

$833 CAD trong 10 ngày
(0 Đánh Giá)
0.0
Frankhardy

Hi, I can start with the design and development right away. I will follow up with a 3 month free post-launch support that could be ongoing as per your requirements. Payments can be made in milestones after satisfa Thêm

$1150 CAD trong 28 ngày
(0 Đánh Giá)
0.0
adrianschmidt

I'm willing to work on this project - it sounds interesting

$1211 CAD trong 11 ngày
(0 Đánh Giá)
0.0
Pharoa

I want to thank you for the opportunity to bid on your project. I will bring over 19 years of experience developing business and invoicing applications with Ms Access and Visual Basic to bear on your project should Thêm

$833 CAD trong 15 ngày
(0 Đánh Giá)
2.8
rmknakal

This would probably take less than a week.

$777 CAD trong 6 ngày
(0 Đánh Giá)
0.0
anilhadiyal

I am interested in your project

$1250 CAD trong 15 ngày
(0 Đánh Giá)
0.0