PRODUCT MIX- LINEAR PROGRAMMING PROBLEM ON WHAT VARIANTS TO PLANT: 3 cassava variants: A. Lakan 1 B. Rayong 5 C. Golden Yellow BASE ASSUMPTIONS: A. Cost of Planting Material 1. Lakan 1 - $1 per kilogram 2. Rayong 5 - $0.50 per kilogram 3. Golden Yellow - $0.75 per kilogram B. FARMLAND AREA TO BE UTILIZED IN CASSAVA FARMING YEAR 1 20 HECTARES YEAR 2 50 HECTARES YEAR 3 120 HECTARES C. CROP GROWING PERIODS Lakan 1 - 10 months Rayong 5 - 4 months Golden Yellow - 7 months D. CROP YIELD-- FROM THE 100% WET WEIGHT UPON HARVEST, IT WILL GO DOWN TO BELOW DRY WEIGHT (WHICH IS THE ONE BOUGHT BY BUYERS) AFTER DRYING PROCESS: Lakan 1 - 36.4% dry weight yield Rayong 5 - 40.1% dry weight yield Golden yellow - 41% dry weight yield E. FARMLAND OUTPUT PER HECTARE FARMING (INITIAL WET WEIGHT UPON HARVEST) Lakan 1 - 25,000 kilograms per hectare Rayong 5 - 22,000 kilograms per hectare Golden Yellow - 28,000 kilograms per hectare F. BUYING PRICE PER KILOGRAM DRY WEIGHT OF CASSAVA Lakan 1-P11 per kg Rayong 5 - P6 per kg Golden Yellow - P8 per kg OBJECTIVE FUNCTION: GET THE BEST PRODUCT MIX ON THE FARMING STRATEGY ON THE 1ST YEAR 20 HECTATES, 2ND YEAR 50 HECTARES, AND 3RD YEAR 120 HECTARES WHO WILL GIVE THE MAXIMUM PROFIT. I -Make spreadsheet model for this and solve using solver in excel PRODUCT MIX- LINEAR PROGRAMMING PROBLEM ON WHAT VARIANTS TO PLANT: 3 cassava variants: A. Lakan 1 B. Rayong 5 C. Golden Yellow BASE ASSUMPTIONS: A. Cost of Planting Material 1. Lakan 1 - $1 per kilogram 2. Rayong 5 - $0.50 per kilogram 3. Golden Yellow - $0.75 per kilogram B. FARMLAND AREA TO BE UTILIZED IN CASSAVA FARMING YEAR 1 20 HECTARES YEAR 2 50 HECTARES YEAR 3 120 HECTARES C. CROP GROWING PERIODS Lakan 1 - 10 months Rayong 5 - 4 months Golden Yellow - 7 months D. CROP YIELD-- FROM THE 100% WET WEIGHT UPON HARVEST, IT WILL GO DOWN TO BELOW DRY WEIGHT (WHICH IS THE ONE BOUGHT BY BUYERS) AFTER DRYING PROCESS: Lakan 1 - 36.4% dry weight yield Rayong 5 - 40.1% dry weight yield Golden yellow - 41% dry weight yield E. FARMLAND OUTPUT PER HECTARE FARMING (INITIAL WET WEIGHT UPON HARVEST) Lakan 1 - 25,000 kilograms per hectare Rayong 5 - 22,000 kilograms per hectare Golden Yellow - 28,000 kilograms per hectare F. BUYING PRICE PER KILOGRAM DRY WEIGHT OF CASSAVA Lakan 1-P11 per kg Rayong 5 - P6 per kg Golden Yellow - P8 per kg OBJECTIVE FUNCTION: GET THE BEST PRODUCT MIX ON THE FARMING STRATEGY ON THE 1ST YEAR 20 HECTATES, 2ND YEAR 50 HECTARES, AND 3RD YEAR 120 HECTARES WHO WILL GIVE THE MAXIMUM PROFIT. I -Make spreadsheet model for this and solve using solver in excel