Help with business analytics DUE TONIGHT (11pm EST)
refapa
DataforQuestion3.xlsxProduction Data
| Product | Production Cost/Unit | Magnet | Wire | Casing |
| A | 0.25 | 4 | 2 | 2 |
| B | 0.35 | 3 | 1 | 3 |
| C | 0.15 | 2 | 2 | 1 |
| D | 0.1 | 8 | 3 | 2 |
Demand and Price Data
| Product | NA | EU | Asia |
| Min Demand | |||
| A | 850 | 800 | 150 |
| B | 700 | 100 | 400 |
| C | 1000 | 900 | 600 |
| D | 1500 | 3500 | 2100 |
| Max Demand | |||
| A | 2450 | 2700 | 300 |
| B | 2200 | 600 | 1400 |
| C | 3300 | 2400 | 1700 |
| D | 4400 | 10500 | 6000 |
| Packaging and Shipping Cost/Unit | |||
| A | 0.2 | 0.25 | 0.35 |
| B | 0.18 | 0.22 | 0.3 |
| C | 0.18 | 0.22 | 0.3 |
| D | 0.17 | 0.2 | 0.25 |
| Unit Sales Revenue | |||
| A | 3.95 | 4.45 | 4.5 |
| B | 3.65 | 3.85 | 3.9 |
| C | 2.65 | 2.85 | 2.35 |
| D | 6.75 | 6.45 | 6.85 |
Available Raw Material Data
| Available Raw Material | |
| Magnet | 120000 |
| Wire | 50000 |
| Casing | 40000 |
