Print & Soundtrack System

Functional Specification

 

IMAX Corporation

January 20, 1999

 

 

 

 

 

 

 

Contact:                                 Glenda Savage

                                                Film Analyst

                                                IMAX Corporation

 

 

Prepared by:                         Dante Dionne II

                                                D.P. Specialists

                                                a Metro Information Services Company

 

 

 

Signed for on behalf of

IMAX

 

Signed:  __________________________________

Name:  ___________________________________

Title:  ____________________________________

Date:  ____________________________________

DPS

 

Signed:  _________________________________

Name:  __________________________________

Title:  ___________________________________

Date:  ___________________________________

 


 

Confidentiality Notification

 

This document contains confidential information of D.P. Specialists  (DPS).

 

In consideration of receipt of this document, the recipient agrees to maintain such information in confidence and to not reproduce this document in whole or in part by any means, including electronic regeneration, without the written consent of an executive of DPS or otherwise disclose this information to any person or organization outside the group directly responsible for the evaluation of its contents.  There is no obligation to maintain the confidentiality of any information which was known prior to the receipt of such information from DPS or which is already publicly available.


 

 1. ProjectOverview                                                                                                  4

1.1      Overview                                                                                                             4

1.2      Purpose of Document                                                                                   4

1.3      Intended Audience                                                                                         4

1.4      Contacts, Roles and Responsibilities                                                 4

1.5      Scope                                                                                                                      5

2.   System Overview                                                                                                   6

2.1      Existing Workflow                                                                                         6

2.2      Proposed Workflow                                                                                      6

2.3      Security                                                                                                                6

2.4      On-line Help                                                                                                        7

2.5      Functional Areas                                                                                            7

2.6      Reports                                                                                                                 8

2.7      System Configuration                                                                                  8

2.8      Databases                                                                                                            8

3.   Sample Webpages                                                                                                 10

3.1      System Login                                                                                                     10

3.2      Print & Soundtrack Home Page                                                             11

3.3      Film Master                                                                                                      12

4.   Proposed Work Flow and Database Table Structure                   15

4.1      Work Flows                                                                                                       15

4.2      IMAX Order Workflow                                                                                16

4.3      IMAX Order Workflow Continued                                                        17

4.4      DKP/70MM Order Workflow                                                                      18

4.5      DKP/70MM Return Order Workflow                                                     19

4.6      Print Table                                                                                                        20

4.7      Soundtrack Table                                                                                         21

4.8      Reel Table                                                                                                          22

4.9      Order                                                                                                                     23

4.9      Order  Detail Table                                                                                       24

4.10    Print Evaluation Table                                                                               25

5.   Conclusions                                                                                                           27

6.   Estimate                                                                                                                  29
 

1.     Project Overview

1.1     Overview

The objective of this document is to define the Functional Specification for the web based  Print & Soundtrack  Tracking System for IMAX Corporation.

 

In the course of developing the Functional Specification, DPS has been given the following documents to review:

 

q       Memo, Describing an Overview of the System Requirements

q       70 MM New Reel or Print Order and Work Process Document

q       70 MM Used Print Order and Work Process Document

q       AS IS – Print and Soundtrack Delivery (Draft)

q       AS IS – Print and Soundtrack Delivery: Ridefilm and Trailers (Draft)

q       AS IS – Print and Soundtrack Delivery: Ridefilm (Draft)

q       Print & Soundtrack Database Information Requirements

q       Documents gathered during on-site interviews.

1.2     Purpose of Document

This document details the features and functionality to be provided for the IMAX Print & Soundtrack System. It defines the system configuration and identifies its components.

1.3     Intended Audience

The staff involved in the development, configuration, and testing of the system should read this document.

1.4     Contacts, Roles and Responsibilities

 

Client Staff

Title

Phone Number

Role and Responsibilities

Glenda Savage

Film Analyst

(905) 403-6348

Project Manager

DP Specialists Staff

 

 

 

Dante Dionne II

Sr. Consultant

(310) 416-9846

Project Manager

 

 

1.5     Scope

IMAX Corporation desires to develop a Print & Soundtrack Database to track print/trailer/ridefilms and soundtrack location, inventory level, and characteristic. The Print & Soundtrack Database System is expected to perform the following high level functions:

 

System Components – Phase One

q       Use of Application Level Security Model using a combination of User Name and Password along with Workstation identification.

q       Print Database including maintenance and viewing of Print/Trailer/Ridefilm History information.

q       Soundtrack Database including maintenance and viewing of Soundtrack History information.

q       Ordering and Tracking of New and Used Prints/Trailers/Ridefilms and Soundtracks.

q       Quick update module for data entry of Prints/Trailers/Ridefilms and Soundtracks as they are returned.

q       Print Rejuvenation Evaluations.

q       Print Transfers between Theaters.

q       Print Retirement/Destruction.

q       Database View and Reporting.

 

System Components – Phase Two

q       Integration with Accounting Systems at IMAX in Sheridan Park and at DKP/70MM.

 

q       Integration with Other Internal Systems currently unidentified.

 

q       Remote access by users off-site.

 

q       Integration with DKP/70MM shipping.

 

2.     System Overview

2.1     Existing Workflow

The Current system is a manual one utilizing as series of Excel Spreadsheets to track the Print or Soundtrack at all stages of the process.  The person in charge of that area of operation independently maintains each Spreadsheet. 

 

2.2     Proposed Workflow

This system will allow specified IMAX and  DKP/70MM personnel to create one database and application that can be accessed by all members via the World Wide Web. This system will automate the complete Print & Soundtrack Tracking process, including ordering, shipping, notification of involved parties via email and/or data views specific to the users needs and the ability to update Print & Soundtrack status.

 

Print & Soundtrack System will allow users to search the Print & Soundtrack database information in any number of ways by Name, Status, etc.

 

The system will allow a user to check availability of a Print or Soundtrack, take and order and route the order information to shipping and accounting.. After completing the order, it will be submitted via e-mail to all involved parties. Shipping and accounting at both IMAX and DKP/70MM will be provided with views of the orders that require their involvement.  Once they have processed their information they will be able to change the status of the order reflecting completion on their specific tasks.

 

Upon the return of a Print or Soundtrack the return will logged into the system and notice will be sent to the appropriate parties.  Upon Approval of a Print Evaluation Request the evaluation process will begin.  A special  series of  screens will be provided to track the evaluation that will be added to the Print or Soundtracks History.

 

2.3     Security

A number of security levels have been identified within the system.

 

q       System Administrator (specific IMAX and/or DKP/70MM staff member, Full Access)

q       Local Administrator (selected supervisors, Full Access accept to Users)

q       Ordering (staff members taking orders, Add/Update/Cancel Orders)

q       Shipper (staff members in shipping, Update Order Status and Print Check-in/out)

q       Editor (Full Access Add/Update accept for Users)

q       Viewer (Full Access View Only)

 

Access to Function

System Administrator

Local Administrator

Ordering

Shipper

Editor

Viewer

Assign all levels to users.

Y

N

N

N

N

N

Create new users and assign Security Level.

Y

Y

N

N

N

N

Place Orders

Y

Y

Y

N

Y

N

Update Availability of Inventory.

Y

Y

N

Y

Y

N

View  All

Y

Y

N

N

Y

Y

2.4     On-line Help

Module sensitive help will be available on-line. Clicking the “Help” link from any screen will display module sensitive help. Each screen will define any special field requirements or other instructions that may assist the user.

 

A printed copy of the On-line Help System will be provided to act as User Documentation.

 

2.5     Functional Areas

 

1.

User Login

Enables a user to log into Print & Soundtrack System.

2.

Order Entry

Allows operators to Search the Print & Soundtrack Database for Availability, place orders and notify appropriate parties of the order.

3.

Order Processing

Allows recipients of orders to process the ordering of new prints and trailers and/or the shipping of new prints and trailers or used prints, trailers and soundtracks.  The order processor will be able to view the order seeing all information regarding the Print, Soundtrack(s) and Trailer required.

4.

Shipping

This function allows the shipping department to view a list of orders for Prints and Soundtracks to be shipped.  Once a Print is shipped the operator can click and icon to confirm shipping which will generate email back to Ordering and to both IMAX and DKP/70MM A/R if and invoice is required.  Also included in this section will be the ability to check prints in when they are returned and  notify appropriate parties of the need for Approval of a screening/evaluation.

5.

A/R IMAX

Allows the operator to view a list of shipped prints, which require invoicing.  Once invoices have been sent the operator can simply click and icon to confirm invoicing.

5.

A/R DKP/70MM

Allows the operator to view a list of shipped prints, which require invoicing, new prints which have been processed and screenings that have been done.  DKP/70MM will also be able to modify Print Status for Prints to be destroyed.

6.

Evaluations

This area will allow the operator to complete a Print Evaluation form and submit their findings to the appropriate parties for approval.

7.

Reports

See section 2.6

8.

Film/Print/Soundtrack Master

This area will allow the operators to Add/Modify/Delete Film/Print and Reel information in a easy to use drill down fashion.

9.

Theater (Supplemental Table)

This area will allow the operators to Add/Modify/Delete Supplemental Theater Information that currently is not available in the existing Theater table.

10.

Security Level Master

Allows System Administrators to Add/Modify/Delete Security Levels.

11.

User Master

Allows System Administrators to Add/Modify/Delete Users of the Print & Soundtrack System.

 

2.6     Reports

1.

TBD

Other Views will be available by Report

2.

Prints & Soundtracks Shipped

Allows viewing of Prints and Soundtracks that have been shipped.

3.

Print  & Soundtrack History by Theater

Allows viewing of a Theaters Order History.

4.

New Prints in Inventory

Allows viewing of New Prints that are now in Inventory.

5.

Inventory by Film

Allows viewing Prints and their status by Film.

 

2.7     System Configuration

The server will be an Intel based PC running Microsoft Windows NT Server 4.0, Microsoft Internet Information Server 4.0 and Microsoft SQL Server 6.5 or 7.0 as the database server. Client workstations will be capable of running Microsoft Internet Explorer 4.0 or greater.  Screen will be design to support 800x600 resolution in order to have enough room to present data views with out vertical scrolling.

 

 

1.1     Databases

There are several databases, which will be accessed from the Print & Soundtrack System.  Below is a list of the databases and there usage.
Text Box: Theaters
Theaters – This database already exists and will require Read Only access by the Print & Soundtrack System.

 

Text Box: Films
Films – This database already exists and will require Read Only access by the Print & Soundtrack System.

 

Text Box: Supplemental Theaters 
Supplemental Theaters - This table is New and will be created for the Print & Soundtrack System.  This Table will contain the additional information on Theater Sound System Capabilities and Shipping Addresses.  This data will be compiled from existing Excel Spreadsheets now maintained manually.  This table will be built in compliance with the existing DKP Shipping Database to ensure future compatibility.
Text Box: Prints
 
Prints - This table is New and will be created for the Print & Soundtrack System.  Prints will be given a system generated unique ID and will be Joined to the Film Table by a unique Film ID.  This table will contain information specific to the Print.
 
Text Box: Soundtracks
Soundtracks - This table is New and will be created for the Print & Soundtrack System. Soundtracks will be Joined to the Film Table by a unique Soundtrack ID.  This table will contain information specific to each Soundtrack.
 
Text Box: Reels
Reels - This table is New and will be created for the Print & Soundtrack System.  Reels will be Joined to the Print Table by a unique Print ID.  This table will contain information specific to each Reel, which makes up the Print.
 
Text Box: Orders
Orders - This table is New and will be created for the Print & Soundtrack System.  General Order information will be stored in this table such as Theater, Film, License Date, etc.  Once and order is fulfilled it will be flagged as Historical and viewable through Print History. Orders will be linked back to the Print by the Print ID.
Text Box: Order Details
Order Detail - This table is New and will be created for the Print & Soundtrack System.  Ordered Items (Print, Soundtracks, Trailers, etc) will be added to this table Once and order is fulfilled it will be flagged as Historical and viewable through Print History.  Orders will be linked back to the Print by the Print ID.
Text Box: Print Evaluation
Print Evaluation - This table is New and will be created for the Print & Soundtrack System.  Prints which are returned to DKP and approved for screening will have a Print Evaluation performed once this is complete IMAX will be notified of the work required to bring the Print up to the Minimum Quality Standard and decide upon whether to rejuvenate the Print.  Print Evaluations will also be viewable through Print History.

1.     Sample Web Pages

1.1     System Login

When Users Navigate to the appropriate URL (Internet Address) within their browser they will be presented with a User Login and Password Dialog.

  

 

Users must successfully enter a valid User Name and Password to gain access to the Print & Soundtrack System.  After three failed login attempts the Users IP Address and other information is Logged in a Security Log File and a Designated System Administrator is Emailed.


1.1     Print & Soundtrack System Home Page

Once a user has successfully Logged In they will be presented with a menu of options.  The options available will depend on their Security Level.

 

 

The following section illustrates a sample of screens used to drill down the Film/Print/Reel Menu Option.


 

1.1     Film Master

The Film Master Menu Option allows operators to Add/Modify/Delete Film, Print and Reel Information.

 

 

Selecting a Film from the List (ie 1234) will display the detailed Film Information.

 


 

Selecting the “Prints” Button will display a list of all the Prints created for this particular Film.

 

 

 

Selecting a Print ID will display the detailed information on that particular Print.

 

 

 

1.     Proposed Work Flow and Database Table Structure

 

1.1     Work Flows

 

There are several different Order Processing Flows that need to be Automated.  The following will act as a guide to understanding these different scenarios.

 

·         In-Stock New or Used Print/Soundtrack Order:

1.        MPLA is received for a print.

2.        Operator searches Print Inventory for Print and finds one available.

3.        Operator selects the print and adds it to the Order.

4.        Operator searches Soundtrack Inventory for Soundtrack and finds one available.

5.        Operator selects the Soundtrack and adds it to the Order.

6.        Optional addition of another Soundtrack.

7.        Operator Searches Print Inventory for Trailer and finds one available.

8.        Operator selects and adds the Trailer to the Order

9.        Order is Completed and Submitted and flagged as “Ordered”.

10.     Order is received by DKP and flagged “Committed”.

11.     Shipping is notified of the Order.

12.     Trailer is Shipped and flagged as “Shipped”.

13.     Print and Soundtrack are shipped to meet Licensing Start Date.  Each item in an order will have a Ship Date associated with it.

 

·         Out-of-Stock New Print/Soundtrack Order:

1.        MPLA is received for a print.

2.        Operator searches Print Inventory for Print and finds none.

3.        Operator forecasts possible future requirements for this print in order to take advantage of quantity discounts.

4.        Operator generates P.O. for the required Print and adds it to the order.

5.        Operator searches Soundtrack Inventory for Soundtrack and finds one available.

6.        Operator selects the Soundtrack and adds it to the Order.

7.        Optional addition of another Soundtrack.

8.        Operator Searches Print Inventory for Trailer and finds one available.

9.        Operator selects and adds the Trailer to the Order.

10.     Order is Completed and Submitted and flagged as “Ordered”.

11.     Order is received by DKP and flagged “Received”.

12.     Shipping is notified of the Order.

13.     Trailer is Shipped and flagged as “Shipped”.

14.     DKP flags the Print order as “In Production”  (DKP Generates an internal Requisition) and orders Print from CFI.

15.     Print is received from the lab and Screened.

16.     Once all the reels are screened the Print Order is flagged as “Committed”. (DKP Generates an internal Release Tracking Sheet)

17.     DKP A/R is notified of the costs involved with the new print (IMAX is invoiced).

18.     Print and Soundtrack are shipped to meet Licensing Start Date.


 

·         Out-of-Stock Used Print/Soundtrack Order:

1.        MPLA is received for a print.

2.        Operator searches Print Inventory for Used Print and finds only Prints requiring Rejuvenation.

3.        Operator evaluates the required repairs and determines whether or not to have the work done.

4.        Operator generates W.O. for the required work on the Print and adds it to the order.

5.        Operator searches Soundtrack Inventory for Soundtrack and finds one available.

6.        Operator selects the Soundtrack and adds it to the Order.

7.        Optional addition of another Soundtrack.

8.        Operator Searches Print Inventory for Trailer and finds one available.

9.        Operator selects and adds the Trailer to the Order.

10.     Order is Completed and Submitted and flagged as “Ordered”.

11.     Order is received by DKP and flagged “Received”.

12.     Shipping is notified of the Order.

13.     Trailer is Shipped.

14.     Work is started to Rejuvenate and Print Order is flagged “Rejuvenating”.

15.     Once all the reels are screened the Print Order is flagged as “Committed”.

16.     DKP A/R is notified of the costs involved with the new print (IMAX is invoiced).

17.     Print and Soundtrack are shipped to meet Licensing Start Date.

 

·         Out-of-Stock Used Print/Soundtrack Order:

1.        MPLA is received for a print.

2.        Operator searches Print Inventory for Used Print and finds only Prints requiring Rejuvenation.

3.        Operator evaluates the required repairs and determines whether or not to have the work done.

4.        Operator generates W.O. for the required work on the Print and adds it to the order.

5.        Operator searches Soundtrack Inventory for Soundtrack and finds one available.

6.        Operator selects the Soundtrack and adds it to the Order.

7.        Optional addition of another Soundtrack.

8.        Operator Searches Print Inventory for Trailer and finds one available.

9.        Operator selects and adds the Trailer to the Order.

10.     Order is Completed and Submitted and flagged as “Ordered”.

11.     Order is received by DKP and flagged “Received”.

12.     Shipping is notified of the Order.

13.     Trailer is Shipped.

14.     Work is started to Rejuvenate and Print Order is flagged “Rejuvenating”.

15.     Once all the reels are screened the Print Order is flagged as “Committed”.

16.     DKP A/R is notified of the costs involved with the new print (IMAX is invoiced).

17.     Print and Soundtrack are shipped to meet Licensing Start Date.

 

·         Return Used Print/Soundtrack:

1.        DKP receives print/soundtrack/trailer/ridefilm.

2.        Shipper searches for Inventory items returned.

3.        Shipper uses quick check-in to flag items as returned.

4.        Prints are updated as “Needs Screening”.

5.        IMAX is informed of Print requiring  Screening Approval.

6.        If Screening Approval is given Prints are screened and evaluated.  Otherwise is goes in inventory as “needing Screening”.

7.        Evaluations are entered and IMAX is notified of findings.

8.        Print Status is changed to “Needs Work”.

9.        Print is now available to the Order Entry System.

 

 1.1     IMAX Order Work Flow

1.2     IMAX Order Work Flow Continued

 

1.1     DKP/70MM  Order Work Flow

 

1.2     DKP/70MM Return Order Work Flow Continued

 

 

 

1.1     Print Table

 

Field Name

Data Type

Size

Description

Counter

Auto

 

Primary Key

FilmCounter

Integer

 

Foreign Key to Film

PrintID

Char

20

ID assigned by DKP

QualityRating

Integer

 

 

PrintCost

Currency

 

 

Format

Char

1

(2)D, (3)D

MediaType

Char

1

 (I)max*, (D)ome*

PrintType

Char

1

(Feature), (T)railer, (R)ide, (7)0mm, (3)5mm, I(N), I(P)

PrintEye

Char

1

(L)eft Eye, (R)ight Eye

Promotion+

Char

1

(N)ow Playing, (C)oming soon, (G)eneric,

(2)D Promotion, (3)D Promotion

SetSize

Integer

 

Number of reels in a print set

Status

Char

1

(A)vailable, (C)ommitted, (S)hipped,

(D)amaged, (R)etired, In Re(p)air, (L)eased

PrintUsed

Char

1

(N)ew, (U)sed

NumPasses

Integer

 

0 for new Prints

PhotoGarded

Char

1

(Y)es, (N)o

ScreeningCode

Char

20

Alphanumeric

RatingCode

???

 

 

PONumber

Char

20

P.O. Number which generated the Print.

DateInService

Date

 

Date Print went into Service

Customer

Char

1

(I)MAX, (M)cGillvery, (S)ony

Logo

Char

1

(Y)es or (N)o

Comments

Text

16K

Unique characteristics of the Print

 

 

 

 

 

 

 

 

 

 

 

 

 

* = Applies to Feature Films Only

+ = Applies to Trailers Only

 

1.2     SoundTrack Table

 

Field Name

Data Type

Size

Description

Counter

Auto

 

Primary Key

FilmCounter

Integer

 

Foreign Key to Film

SoundTrackID

Char

20

ID assigned by DKP

Cost

Currency

 

 

MediaType

Char

1

(C)D Rom, CD Audi(O), (A)nalog, (D)VD, (L)D, D-8(8), Ca(P)tioning, D(R)S, 1/(2) inch, (3)5mm

Language

Char

20

 

FilmType

Char

1

(F)eature, (T)Trailer

Specification

Char

1

(N)on-PSE, PSE-(S)ingle Channel, PSE-(M)ulti Channel, (O)ther

Status

Text

1

(A)vailable, (C)ommitted, (S)hipped,

(D)estroyed, A(R)chived

SpecNotes

Text

16K

Notes on Specification if other is selected

Comments

Text

16K

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1.3     Reel Table

Field Name

Data Type

Size

Description

Counter

Auto

 

Primary Key

PrintCounter

Integer

 

Foreign Key to Print

QualityRating

Integer

 

 

ReelNumber

Integer

 

e.g. 1 of 15

Status

Text

20

 

ReelEye

Char

1

(L)eft Eye, (R)ight Eye

ReelAge

Char

1

(N)ew, (U)sed

NumPasses

Integer

 

0 for new reels

PhotoGarded

Char

1

(Y)es, (N)o

ScreeningCode

Char

20

Alphanumeric

RatingCode

Integer

 

 

PONumber

Char

20

P.O. Number which generated the Reel.

DateInService

Date

 

Date Reel went into Service

ReelCost

Currency

 

 

Stock

Char

1

(T)riathelon, (K)odak

Customer

Char

1

(I)MAX, (M)cGillvery, (S)ony

Comments

Text

16K

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1.4     Orders Table

 

Field Name

Data Type

Size

Description

Counter

Auto

 

Primary Index

OrderNumber

Integer

 

 

OrderDate

Date

 

 

AccountCode

Char

?????

 

TheaterID

Integer

?????

Foreign Key to Theater Table

TheaterName

Char

30

Name of Theater

DateRequired

Date

 

 

DueDate

Date

 

 

OrderStatus

Char

1

(O)rdered, (R)eceived,  (C)ommited, (S)hipped, (I)n Prodiction, etc.

AuthorizedBy

Char

50

 

AuthorizationDate

Date

 

 

SpecialInstructions

Text

16K

i.e Ship assembled/head out.

Comments

Text

16K

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1.5     Order Detail Table

 

Field Name

Data Type

Size

Description

Counter

Auto

 

Primary Index

OrderNumberCounter

Integer

 

Join to Order Table

PrintCounter

Integer

 

Foreign Key to Print or Trailer Table (if Print or Trailer Order)

SoundTrackCounter

Integer

 

Foreign Key to Soundtrack Table (if Soundtrack Order)

DateRequired

Date

 

 

DueDate

Date

 

 

ShippingMethod

Char

1

(U)PS, (F)edEx, (E)lite, (T)heater

ShippingDate

Date

 

 

ShippingCost

Currency

 

 

ShipFrom

Char

1

(I)nventory - DKP, (V)endor - Sonics, (T)heater

InvoiceRequired

Char

1

(Y)es, (N)o

ActionTaken

Char

1

(P)O for New and Repairs

OrderStatus

Char

1

(O)rdered, (R)eceived,  (C)ommited, (S)hipped, (I)n Prodiction, etc.

Assembled

Char

1

(Y)es, (N)o

PhotoGarded

Char

1

(Y)es, (N)o

PONumber

Char

20

P.O. Number which generated the Order Item.

AuthorizedBy

Char

50

 

AuthorizationDate

Date

 

 

FedExCode

Char

20

 

DKPInvoiceNumber

Char

20

 

SpecialInstructions

Text

16K

i.e Ship assembled/head out.

Comments

Text

16K

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1.6     Print Evaluation Table

 

Field Name

Data Type

Size

Description

Counter

Auto

 

Primary Key

PrintCounter

Integer

 

Foreign Key to Print

EvaluationDate

Date

 

 

Version

Char

????

Should this go into the Print Table???

CurrentRating

 

 

 

ScreeningCode

Char

20

Alphanumeric

ReturnedFrom

 

 

 

ReturnDate

 

 

 

UnusualCondiditon

Text

16K

 

PhotoGarding

Char

1

(Y)es, (N)o

SonicCleaning

Char

1

(Y)es, (N)o

PTRCleaning

Char

1

(Y)es, (N)o

Destroy

Char

1

(Y)es, (N)o

Process5

Char

1

(Y)es, (N)o

EstPostRepairRating

Integer

 

 

EstRepairCost

Currency

 

 

EstRepairTime

Integer

 

Days

ActPostRepairRating

Integer

 

 

ActRepairCost

Currency

 

 

ActRepairTime

Integer

 

Days

PGAuthorized

Char

1

(Y)es, (N)o

SCAuthorized

Char

1

(Y)es, (N)o

PTRCAuthorized

Char

1

(Y)es, (N)o

AuthDestroy

Char

1

(Y)es, (N)o

P5Authorized

Char

1

(Y)es, (N)o

AuthorizedBy

Char

20

 

AuthorizationDate

Date

 

 

AuthorizationPONum

Char

20

 

AuthSpecialInst

Text

16K

 

RepairsCompletedOn

Date

 

 

NewScreeningCode

Char

20

Alphanumeric

NewRatingCode

Integer

 

 

NewStatusAssignedBy

Char

20

 

NewStatusDate

Date

 

 

DKApprovalBy

Char

20

 

DKApprovalDate

Date

 

 

Comments

Text

16K

i.e. Perfs torn at theater

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2.     Conclusions

 

During the interviews of both IMAX and DKP/70MM users it was concluded that the Order Process is more complex than originally specified in the RFP of November 23, 1998.  The process of filling an order requires the coordination of several components a Print, possibly multiple Soundtracks for the Print and possibly multiple Trailers with multiple Trailer Soundtracks.  These components may come from Used inventory or may be ordered New from one of several vendors.  Depending on the time frame all the components may come together at DKP/70MM for shipping or they may be shipped directly to the theater from the vendor producing the copy.

 

At a minimum the Print & Soundtrack System must include the flexibility to handle these situations and route correspondence and/or Data Views to the appropriate parties.
 

Phase 1:

The following is a list of the items, which need to be handled in Phase 1 of the project list by Functional Area.

 

Order Entry:

·         Orders for New Committed Prints w/P.O. number

·         Orders for New Inventoried Prints w/P.O. number (future commitments)

·         Orders for New Soundtracks w/P.O. number

·         Orders for New Trailers w/P.O. number

·         Orders for New Trailer Soundtracks w/P.O. number

·         Orders for Used Prints with/without Work Required w/W.O. number

·         Orders for Used Soundtracks

·         Orders for Used Trailers

·         Orders for Used Trailer Soundtracks

·         Order that include Prints/Soundtracks/Trailers being transferred between Theaters.  Each order item will have a Ship From location which will identify where we anticipate the item be shipped from.

 

An Order can consist of any combination of the items listed above.

 

Order Tracking:

·         View of Order showings it’s components and their individual Status

·         View of New Orders

·         View of Order to be Shipped by Date

·         View of Order History

 

All Views will allow for Searching by TBD criteria.

 

Order Check Points:

There have been several check points identified where simple updating of the order or its items will eliminate some manual spreadsheet updates and help more accurately track the order.

·         When the Order is entered items will be accordingly

·         When Orders are received at DKP items will be confirmed and items to be shipped out immediately (trailers) will be flagged for shipping.

·         When items are shipped the shipper will modify the status of the item to shipped

·         When New items ordered arrive the shipping will modify the order to reflect the delivery

·         New items which are shipped directly to the Theater will be updated by the person contacted of the confirmation of the shipment

·         When the work is completed on Used prints with W.O. numbers the item will be flagged as Work Complete

·         When all items on an order have been accounted for and shipped the order will be flagged as complete

 

Print Evaluation:

·         Print Evaluations will be entered from the Screening reports at DKP/70MM that will be routed back to IMAX via email and views.  These reports will act as a decision point in determining whether to rejuvenate a Used Print to be sent out to a Theater or make new Prints.

·         Print evaluations will be able to be attached to Order Items as a reference to the work performed along with a W.O. number.

 

Master File Maintenance:

·         Print File Maintenance Updated directly from Orders with ability to view Print Rejuvenation History and Order History.

·         Soundtrack File Maintenance Updated directly from Orders with ability to view Order History.

·         Reel File Maintenance may not be within the scope of Phase 1.

 

Reporting:

·         Exact reports will be determined later.

 

Phase 2:

At IMAX – Further automation and integration with the P.O. system and accounting systems could be accomplished and the Inventory Tracking of Cases and Platters.  It may also be possible to develop the business rules necessary to do some forecasting of future inventory requirements.

At DKP/70MM - It was found through the interview process that the Screening logs are the central piece of information, which drives business and the billing process at DKP/70MM.  In Phase 2 automation of the screening logs with integration into the accounting system would eliminate a great deal of manual input and avoid the possibility of human error.  It would also allow for more timely billing of goods and services.

1.     Estimate

 

Based on using our In-House Standards (ASP/VB Script, IIS 4.0, NT 4.0 and MS SQL) and reuse of similar modules we have developed in the past, this project is expected to be completed within the elapsed time of three (3) months. The initial projected effort for this project is: 

DPS:

 

Consultants                                                                      Rate                                Hours (est.)                   Total Cost (est.)

 

q      Project Manager/Architect                                     $125/hr                           320 hrs.                          $40,000

                                     

q      Developer(s)                                                             $90/hr                             820 hrs.                          $73,800

 

 

Total Costs (est.)                                                                                                                                             $113,800

 

Development Time Estimates by Function:                                                                                                 Hours

Implementation of Security Model.                                                                                                                   40           

Maintenance Prints/Trailers/Ridefilms/Soundtracks.                                                                                    120         

Print Order Processing.                                                                                                                                       260

                Bulk Orders to Inventory

Rejuvenation Approvals

                Out of Stock Ordering

Quick Entry Processing of Returned Prints/New Prints                                                                                40

Print Rejuvenation Evaluations                                                                                                                         40

Database Views and Reporting                                                                                                                         80

Database Architecture and Spreadsheet Conversions                                                                                  80

Server Configuration and Integration                                                                                                               80

Documentation                                                                                                                                                     40

System Testing                                                                                                                                                    40

 

IMAX Corporation:

 

q      Project Sponsor (part-time)

 

q      Business Contact(s) (part-time)

 

q      Technical Contact(s) (part-time)