Explore BrainMass

Explore BrainMass

    Non linear Optimization

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Ordering fuel. Three liquid fuels are stored in tanks for use in a blending process. Each fuel is characterized by a demand rate, a fixed replenishment cost, and a unit cost. Inventory carrying costs are assessed at the rate of 12 percent per year.

    In order to save money on insurance rates, the operating policy is to limit the average value of stock on hand to no more than $7,500.

    Fuel Demand Fixed Cost Unit Cost
    1 1,000/year $100 $50
    2 250/year $75 $100
    3 500/year $50 $20

    a. What are the optimal order quantities for the three items when they are ordered jointly, assuming that the fixed ordering costs are incurred for each item? What is the average annual cost for the three items combined?

    b. Suppose the items are managed separately, but the overall limit on stock value still holds. What are the order quantities for the individual items? What is the average annual cost for the three items combined?

    c. Suppose the stock limit in the base case is relaxed. If the limit is raised by $500, what is the impact on the optimal average annual costs?

    © BrainMass Inc. brainmass.com March 4, 2021, 8:02 pm ad1c9bdddf


    Solution Preview

    Please see the attached Excel file for a detailed response to your ...

    Solution Summary

    An attached Excel file contains formulas and explanations for finding optimal solutions to the given problems.