do test only use techniqes found in files
roberto pulpowill probably not use all files
7 months ago
170
files (14)LPprojectselectionandtransportationaug271.xlsx
LPprojectselectionandtransportationaug27.xlsx
transportationsept10.xlsx
LPbasicwordproblemaug20.xlsx
- Decisiontheory1QUAN4630sept24.xlsx
- LPbasicaug13.xlsx
- Utilityoct8.xlsx
- SKM_C300i25100117370.pdf
- CuttingLPrevisedaug20.xlsx
- ClassificationwithDiscriminantAnalysisOct29.xlsx
- ForecastingQUAN4630nov12.xlsx
- CollegesandUniversitiesClusterAnalysisWorksheetNov5.xlsx
- QUAN4630takehomeFA25.xlsx
- RegressionQUAN4640oct15.xlsx
LPprojectselectionandtransportationaug271.xlsx
project selection
| Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available | |||||
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | |||||
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 | ||||
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 | ||||
| Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | ||||||
| 1 | 0 | 1 | 0 | 1 | ||||||
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | total expected $ return | $ 530,000.00 | <= | Available | |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | total cash spent | $ 140,000.00 | $ 150,000.00 | ||
| No. of employees | 5 | 3 | 2 | 5 | 3 | total number of empl | 10 | 12 | ||
We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset. Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).
transportation
| DISTRIBUTION | CENTER | ||||
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |
Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix. Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.
LPprojectselectionandtransportationaug27.xlsx
project selection
| Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available | |||||
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | |||||
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 | ||||
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 | ||||
| Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | ||||||
| 1 | 0 | 1 | 0 | 1 | ||||||
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | total expected $ return | $ 530,000.00 | <= | Available | |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | total cash spent | $ 140,000.00 | $ 150,000.00 | ||
| No. of employees | 5 | 3 | 2 | 5 | 3 | total number of empl | 10 | 12 | ||
We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset. Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).
transportation
| DISTRIBUTION | CENTER | ||||
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |
Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix. Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.
transportationsept10.xlsx
project selection
| Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available | |
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 |
We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset. Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).
transportation
| DISTRIBUTION | CENTER | ||||
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 | |
| DISTRIBUTION | CENTER | ||||
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | |
| Marietta | 0 | 350 | 0 | 850 | integers |
| Minneapolis | 150 | 0 | 500 | 150 | |
| min total ship cost | $ 28,171.00 | ||||
| constraints | total shipped | <= | capacity | ||
| Marietta shipping | 1200 | 1200 | |||
| Minn shipping | 800 | 800 | |||
| total received | >= | demand | |||
| Cleveland receiving | 150 | 150 | |||
| Baltimore receiving | 350 | 350 | |||
| Chicago receiving | 500 | 500 | |||
| Phoenix receiving | 1000 | 1000 |
Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix. Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.
LPbasicwordproblemaug20.xlsx
Basic LP
Maximize 5A -3B +10C subject to: A + B + 3C <= 20 B >= 2 3A - 2B <= 15 A,B,C >= 0
Sheds
| type A | type B | type C | |||||||||||
| 2 | 0 | 49 | |||||||||||
| profit | 80 | 84 | 85 | max | $ 4,325.00 | ||||||||
| mach time | 2 | 3 | 4 | 200 | <= | 200 | |||||||
| craft time | 5 | 5 | 3 | 157 | <= | 160 |
A small firm builds three types of garden sheds. Type A requires 2 hours of machine time and 5 hours of craftsman time. Type B requires 3 hours of machine time and 5 hours of craftsman time. Type C requires 4 hours of machine time and 3 hours of craftsman time. Each day there are 200 hours of machine time available and 160 hours of craftsman time. The profit on each type A shed is $80, on each type B shed is $84, and on each type C shed is 85 . How many sheds of each type should we make to maximize the profit?
- as discussed
- jks
- Teacher Training
- For a-plus writer only
- Traditional PaperAnt
- In a 1-2 page paper, introduce Tootsie Roll Industries Inc., report on the external auditor's report and then complete the blue cells on tab one of the excel sheet. Introduction: Should engage investors providing them with information pertinent to an in
- Nutritional Assessment
- Report about Art History
- Do this Essay for me
- Integration of E-commerce and ERP Systems with other ICT (information and communication technologies) to create value for customers and shareholders.
