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
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.
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.
The staff involved in the development, configuration, and testing of the system should read this document.
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 |
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.
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.
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.
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 |
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.
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. |
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. |
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.
Theaters
This database already exists and will require Read Only access by
the Print & Soundtrack System.
|
|
Films
This database already exists and will require Read Only access by
the Print & Soundtrack System.
|
|
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. | |
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. |
|
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. |
|
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. |
|
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. | |
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. | |
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. |
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.
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.
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.
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
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
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
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 its 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.
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)