Newspaper Ad Manifest

An advertising manifest is a form used by publications, such as newspapers, showing which ads are scheduled to be run in a particular issue. The software I am requesting bids on will be a web-enabled database application tracking advertisers and the ads that they run. There will be different reports to be generated for printing. This system has to be able to handle multiple publications per ad entry. Some ads will run only once; some will run a set number of times; some will run until cancelled.


Publication: A newspaper or special edition for which advertising must be tracked separately; “Daily Bugle?? or “Home and Garden Show Tab??

Customer: An advertiser

Insertion Order: The transaction by which an advertisement is scheduled. Elements of an insertion order include customer, size of ad, first date of insertion, and what publication(s) it is for.

Columns: The horizontal measure of an advertisement. In a six-column newspaper, an ad that is three columns wide goes halfway across the page.

Depth: The vertical measure of an advertisement. Measured in inches.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

*Data Structures*

I envision the application using four tables, as laid out below. This is by no means an inflexible list; you're free to change this as necessary to meet the bid requirements.


* Name

* Inches per page

* Pub day of week (whether the publication comes out on Wednesday, Thursday, Friday, etc)


* Company

* Contact Person

* Phone


* Customer (links to Customer table)

* Columns

* Depth

* First date of insertion

* Times to insert (0 for until cancelled?)

* Price of ad

* Comments (needs to be a pretty good sized free-text entry field, 4k would be plenty of space)

* Publications (that it is scheduled to run in, can be multiple)

* Salesperson (that sold the ad, links to Sales table. Can be null)

* Commission (numeric field)


* Salesperson

* Rate (a decimal value between 0 and 1)


When the sales agent keys in the insertion order, they will provide the following information:

* Customer

* Columns across

* Inches deep

* First date of insertion (pull down menu)

* Number of times ad will run

* Choose which publications it will run in

* Cost of the ad

* Which ad salesperson sold the ad

* Amount of commission (the default should be the cost of the ad times the commission rate, but the user has an opportunity to change the default)

* Comments

There should also be input screens for the customer, publication and sales tables.


The main report is the Advertising Manifest. The inputs for the report should be the publication and the publication date. This report should list all ads scheduled for that publication, in descending order of size. The information needed is the customer name, columns, depth, and size (the product of columns and depth).

There should be information at the bottom of each page (like a footer) that includes the publication name, pub date, and how many pages of advertising there are throughout the entire publication. To arrive at this, add up the size of all ads in the publication.

For example, if there are 1007 column inches of advertising in the publication, then the program would report 12.59 pages of advertising.

Other useful reports would be commission reports (give a date range and it lists all ads per salesperson, commission on each ad and total commission per salesperson) and advertiser reports (give a date range and it generates a list of each advertiser and the total column inches they ran during that time).

All reports should be formatted to print on [url removed, login to view] paper.


It is a good idea to put in some security, since it is web based. But there is not a need for individual user security here; convenience and speed have a higher premium. Ideally, there will be a username/password that will be stored in a cookie so that the user doesn’t have to key it in every time.

If requested, I will provide an account on the server on which the software will ultimately run, accessible via ftp and ssh.

## Platform

All bids must be for a web-enabled application that can be hosted on a Unix server. The database backend should be mysql. The coder is free to choose how to implement this in a web environment (such as PHP, Javascript, etc), as long as any server side software required to run it is free or included in the bid price, and it can be run successfully from any reasonably up-to-date web browser such as Internet Explorer, Netscape Navigator, or Opera. Platform independence for the user is critical (it will be used by both Windows and Macintosh users), so no bids that involve client-side application installations will be considered.

Habilidades: Javascript, PHP

Veja mais: working from home data input, work from home order entry, work from home agent, work at home for free data entry, work at home agent, what is numeric data entry, what is data structures in c, what is data structures, what is data entry 10 key, what is a good data entry speed, what is a data structures, what is a 10 key data entry, what are data structures in c, what are data structures, web based ssh client, web based ssh, vertical menu web, useful data structures, used structures, total application software company, set data structures, security company sales, sales commission structures, sales agent requirements, sales agent company

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #3064306

Concedido a:


See private message.

$89.25 USD em 45 dias
(12 Comentários)

16 freelancers are bidding on average $250 for this job


See private message.

$250.75 USD in 45 dias
(168 Comentários)

See private message.

$297.5 USD in 45 dias
(62 Comentários)

See private message.

$89.25 USD in 45 dias
(41 Comentários)

See private message.

$127.5 USD in 45 dias
(45 Comentários)

See private message.

$425 USD in 45 dias
(13 Comentários)

See private message.

$552.5 USD in 45 dias
(9 Comentários)

See private message.

$255 USD in 45 dias
(34 Comentários)

See private message.

$446.25 USD in 45 dias
(5 Comentários)

See private message.

$136 USD in 45 dias
(10 Comentários)

See private message.

$313.65 USD in 45 dias
(5 Comentários)

See private message.

$85 USD in 45 dias
(7 Comentários)

See private message.

$85 USD in 45 dias
(2 Comentários)

See private message.

$127.5 USD in 45 dias
(0 Comentários)

See private message.

$416.5 USD in 45 dias
(0 Comentários)

See private message.

$297.5 USD in 45 dias
(0 Comentários)