supply chain management
sri999
3 years ago
40
files (1)Prob5.3.xlsx
Prob5.3.xlsx
Sheet1
| trans $ | US | Euorpe | Japan | SA | India | Fixed | Capacity | Vc $/unit | |||
| US | 600 | 1300 | 2000 | 1200 | 1700 | 0 | 185 | 92.5 | 10000 | 10000 | 1 |
| Euorpe | 1300 | 600 | 1400 | 1400 | 1300 | 0 | 475 | 237.5 | 7530 | 15000 | 0.502 |
| Japan | 2000 | 1400 | 300 | 2100 | 900 | 0 | 50 | 25 | 16740 | 1800000 | 0.0093 |
| SA | 1200 | 1400 | 2100 | 800 | 2100 | 0 | 200 | 100 | 7306 | 13000 | 0.562 |
| India | 2200 | 1300 | 1000 | 2300 | 800 | 0 | 80 | 40 | 9200 | 400000 | 0.023 |
| 270 | 200 | 120 | 190 | 100 | |||||||
| US | Euorpe | Japan | SA | India | 1=open | Shipping | Fixed $ | Units shipped | VC $ | ||
| US | 100 | 0 | 0 | 0 | 0 | 1 | 60000 | 0 | 100.00 | 1000000.00 | |
| Euorpe | 160 | 200 | 95 | 0 | 20 | 1 | 487000 | 0 | 475.00 | 3576750.00 | |
| Japan | 0 | 0 | 25 | 0 | 0.0 | 1 | 7500.0 | 0 | 25.00 | 418500.00 | |
| SA | 10 | 0 | 0 | 190 | 0 | 1 | 164000 | 0 | 200.00 | 1461200.00 | |
| India | 0 | 0 | 0 | 0.0 | 80 | 1 | 64000.0 | 0 | 80.00 | 736000.00 | |
| Excess capacity | Total | 782500 | 0 | 7192450.00 | |||||||
| US | 85 | Grand Total | 7974950.00 | ||||||||
| Euorpe | 0 | ||||||||||
| Japan | 25.0 | ||||||||||
| SA | 0 | ||||||||||
| India | 0.0 | ||||||||||
| US | Euorpe | Japan | SA | India | |||||||
| Unmet Demand | 0 | 0 | 0 | 0 | 0 |
other Questions(10)
- Need a statistic tutor
- I wanna one page paper about Market Profile â This is your analysis of the market. Use graphs and possibly tables...
- Short Story Essay
- Cost of Goods Manufactured and Cost of Goods Sold
- Multiple Questions Answers
- Biology
- Due in 18 hours... please include accurate calculations and read instructions throughly - original work!
- How the American Drug Culture impact on individual family and the community (Ken Man only)
- Managerial Economics help
- International Business Law
