$24,000. Thus, the total amount of funds that Fruit will have to allocate towards purchasing costs will not exceed the amount that was allocated towards it. This purchase order will result in 4,600 excellent chips, 3,000 good chips, and 1,400 mediocre chips. The goal for good chips will be met, while the goal for mediocre chips shall be exceeded by 400 chips. However, the goal of excellent chips shall fall short by 400 chips. Due to the fact that the budget was considered to be the most important goal, nothing should be done to attempt to meet the goal set for excellent chips. Refer to Tables 7 and 8 (below) for a tabular summary of the results: Table 7 Quantity of Quantity of Quantity of good Quantity of mediocre Supplier Lots excellent chips chips Chips Cost ($) 1 10 600 200 200 $4,000.00 2 80 4,000 2,800 1,200 3 0 0 0 0 $0.00 Total N/A 4,600 3,000 1,400 Table 8 Quantity of excellent Quantity of good Quantity of mediocre Cost chips chips chips ($) Goal 5,000 3,000 1,000 $0.00 Deviation from Goal is not met by 400 Goal is exceeded by Requirements chips Goal is met 400 chips $0.00 Sensitivity Analysis Sensitivity analysis was performed for the equation by changing the priority levels of the goals. The following four alternatives were performed using sensitivity analysis. Scenario 2
$24,000. Thus, the total amount of funds that Fruit will have to allocate towards purchasing costs will not exceed the amount that was allocated towards it. This purchase order will result in 4,600 excellent chips, 3,000 good chips, and 1,400 mediocre chips. The goal for good chips will be met, while the goal for mediocre chips shall be exceeded by 400 chips. However, the goal of excellent chips shall fall short by 400 chips. Due to the fact that the budget was considered to be the most important goal, nothing should be done to attempt to meet the goal set for excellent chips. Refer to Tables 7 and 8 (below) for a tabular summary of the results: Table 7 Supplier Quantity of Lots Quantity of excellent chips Quantity of good chips Quantity of mediocre Chips Cost ($) 1 10 600 200 200 $4,000.00 2 80 4,000 2,800 1,200 3 0 0 0 0 $0.00 Total N/A 4,600 3,000 1,400 Table 8 Quantity of excellent chips Quantity of good chips Quantity of mediocre chips Cost ($) Goal 5,000 3,000 1,000 $0.00 Deviation from Requirements Goal is not met by 400 chips Goal is met Goal is exceeded by 400 chips $0.00 Sensitivity Analysis Sensitivity analysis was performed for the equation by changing the priority levels of the goals. The following four alternatives were performed using sensitivity analysis. Scenario 2
Group9ExtraCredit.docx