List all steps and assumptions - Show the model, its solution, and your interpretation of the output. Provide guidance with the formulas in Excel spreadsheet, as well as in the Excel solver (constraints and formulas for results). Snapshots of it will work.
Currently, State University can store 200 files on hard disk, 100 files in computer memory, and 300 files on tape. Users want to store 300 word-processing files, 100 packagedprogram files, and 100 data files. Each month a typical word-processing file is accessed eight times; a typical packaged-program file, four times; and a typical data file, two times.
When a file is accessed, the time it takes for the file to be retrieved depends on the type of file and on the storage medium (see Table below). If the goal is to minimize the total time per month that users spend accessing their files, formulate and solve a model that can be used to determine where files should be stored.
|
Storage Medium
|
Time (Minutes)
|
|
Word Processing
|
Packaged Program
|
Data
|
|
Hard disk
|
5
|
4
|
4
|
|
Memory
|
2
|
1
|
1
|
|
Tape
|
10
|
8
|
6
|