Linear programming problem
Not what you're looking for?
You need to organize your home office, especially your paperwork. You have three general kinds of paperwork: tax files, bill files, investment files. You estimate that you have 10 tax files, 30 bill files, and 15 investment files. Each month you access each tax file three times; each bill file, two times; and each investment file, eight times. You have three places to put files, a file cabinet, your desk, or a storage box. The file cabinet can hold 30 files; the desk, 10 files; and the storage box, 25 files. When a file is accessed, the time it takes for a file to be accessed depends on the type of file and where you put it. You need to decide where to put your files. Your goal is to minimize the total time you spending each month accessing your files.
Retrieval Time (minutes)
(See attached)
Hint: The minimum retrieval time will be 660 minutes per month.
Purchase this Solution
Solution Summary
This posting contains solution to following linear programming problem using excel solver.
Solution Preview
Let Xij = No of i files stored in j storage space where i=t, b, i and j=f, d, s
For example, Xtf = No of tac files stored in file cabinate.
Decision variables
Tax Files Bill Files Investment Files
File ...
Purchase this Solution
Free BrainMass Quizzes
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Operations Management
This quiz tests a student's knowledge about Operations Management
Basics of corporate finance
These questions will test you on your knowledge of finance.