If a company has total revenues of $100,000, sales discounts of $3,000, sales returns of $4,000, and sales allowances of $2,000,
1 answer:
You might be interested in
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:
