Answer:
Check the explanation
Explanation:
The above question is based on a non-linear programming model, to answer this question, there will be a need to determine the optimal order quantities of the three different Ferns with diverse values of annual demand, item cost as well as order cost objective of the non-linear programming model is to minimize the overall annual cost.
Step 1: Setup a spreadsheet on Excel, as shown in the first and second attached images below:
Note: The values of quantities of the three items is kept as 1 to for the calculations of total cost.
The Solver dialogue box will appear. Enter the decision variables, objective function and the constraints, as shown in the third attached image below:
