Automated network sizing and pricing system for satellite network

• US 6,216,117 B1
• Filed: 09/21/1998
• Issued: 04/10/2001
• Est. Priority Date: 09/21/1998
• Status: Expired due to Fees

• Current Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Original Assignee: Electronic Data Systems Corporation (Perspecta, Inc.)
• Inventors: Hall, Eric P.
• Primary Examiner(s): COSIMANO, EDWARD R
• Application Number:
  US09/157,640
• Time in Patent Office: 932 Days
• Field of Search: 705/1, 705/30, 705/34, 705/400, 707/503, 707/504, 707/509
• US Class Current: 705/400
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 30/0283 Price estimation or determination
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

An automated satellite network sizing and pricing workbook (15) implemented on a computer system (10) that is programmed to execute electronic spreadsheet software. The workbook (15) is comprised of a number of worksheets (15A-15J). Some of the worksheets receive data, sometimes manually from a network provider and sometimes automatically from other worksheets, and perform “hidden” calculations to provide various data used for sizing and pricing the network. Other worksheets are for reference or for generating reports of calculated values. The worksheets interact with each other, and the network provider uses them interactively and iteratively to design a network that is feasible in terms of both capacity and cost.

Claims

1. An automated method of pricing a satellite network, using a computer programmed with electronic spreadsheet software, comprising the steps of:

receiving sizing input data into a traffic sizing spreadsheet, said sizing input data representing the quantity of communications traffic on said network;

using said traffic sizing spreadsheet to calculate sizing output data for said network;

receiving cost input data into a unit costing spreadsheet, said cost input data representing the cost for each of a number of units of equipment and service associated with said network;

receiving network input data into an input spreadsheet, said network input data comprising equipment unit data, hub service data, hub equipment data, and space segment data, wherein said equipment unit data represents a desired number of units of equipment for said network, and wherein said hub service data represents characteristics of hub service for said network, and wherein hub equipment data and said space segment data are obtained at least in part from said sizing output data;

using said unit costing spreadsheet to calculate total costs per unit of said network;

using a technical infrastructure spreadsheet to calculate financial data from data retrieved from other of said spreadsheets; and

using a quote document spreadsheet to calculate customer quote data from data retrieved from other of said spreadsheets.

2. The method of claim 1, further comprising the step of using at least one of said spreadsheets to automatically retrieve satellite space segment values from a space segment spreadsheet in response to said sizing output data.

3. The method of claim 1, wherein said network is a shared network, and further comprising the step of using at least one of said worksheets to automatically calculate a shared hub usage value.

4. The method of claim 1, further comprising the step of using at least one of said spreadsheets to receive geographic data for said network and to retrieve tax rate data from a taxrate spreadsheet in response to geographic data.

5. The method of claim 1, further comprising the step of using a competitive analysis spreadsheet to receive cost data for said network from other of said spreadsheets, to receive cost data for a competing network, and to automatically calculate variance values.

6. The method of claim 1, further comprising the step of using at least one of said spreadsheets to receive margin data, and wherein said financial data comprises net data, and further comprising the step of using at least one of said spreadsheets to display said net data such that said margin data can be iteratively adjusted.

7. The method of claim 1, wherein said sizing output data represents at least a required number of inroutes and outroutes.

8. The method of claim 1, wherein said sizing output data represents at least a required number of interface modules.

9. The method of claim 1, wherein said sizing input data represents at least inroute and outroute throughput rates.

10. The method of claim 1, wherein said traffic sizing spreadsheet provides both preliminary sizing output data and advanced sizing output data.

11. A computer implemented network pricing system, comprising:

a computer system having a processor and memory, the computer system executing an electronic spreadsheet software application that provides said network pricing system;

said electronic spreadsheet software operable to provide the following spreadsheets;

a traffic sizing spreadsheet that receives sizing input data, said sizing input data representing the quantity of communications traffic on said network, and the calculates sizing output data for said network;

a unit costing spreadsheet that receives cost input data, said cost input data representing the cost for each of a number of units of equipment and service associated with said network, and that calculates total costs per unit of said network;

an input spreadsheet that receives network input data, said network input data comprising equipment unit data, hub service data, hub equipment data, and space segment data, wherein said equipment unit data represents a desired number of units of equipment for said network, and wherein said hub service data represents characteristics of hub service for said network, and wherein hub equipment data and said space segment data are obtained from said sizing output data;

a technical infrastructure spreadsheet that calculates financial data from data retrieved from other of said spreadsheets; and

a quote document spreadsheet that calculates customer quote data from data retrieved from other of said spreadsheets.

12. The system of claim 11, wherein said software further provides a space segment spreadsheet, and wherein at least one of said worksheets retrieves satellite space segment values from said space segment spreadsheet in response to said sizing output data.

13. The system of claim 11, wherein said network is a shared network and wherein at least one of said worksheets automatically calculates a shared hub usage value.

14. The system of claim 11, wherein said software further provides a taxrate spreadsheet, wherein said input spreadsheet receives geographic data for said network, and wherein at least one of said worksheets retrieves tax rate data from said taxrate spreadsheet in response to geographic data.

15. The system of claim 11, wherein said software further provides a competitive analysis spreadsheet that retrieves cost data from said unit cost spreadsheet, receives cost data for a competing network, and calculates variance values.

16. The system of claim 11, wherein at least one of said spreadsheets also receives margin data, and said financial data comprises net data, and wherein at least one of said spreadsheets retrieves said net data such that said margin data can be iteratively adjusted.

17. The system of claim 11, wherein said traffic sizing spreadsheet provides both preliminary sizing output data and advanced sizing output data.