Explore BrainMass

Explore BrainMass

    Maximizing profit on the sale of widgets

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

    You can sell widgets for $50/Y, where Y is the number of widgets you sell. In other words, the more widgets you sell, the lower the price. It costs $1.5Y to make Y widgets. Using Excel, how many widgets do you make to maximize your profits?

    © BrainMass Inc. brainmass.com June 3, 2020, 4:45 pm ad1c9bdddf
    https://brainmass.com/business/accounting/maximizing-profit-sale-widgets-2844

    Solution Preview

    Please see the attached excel spreadsheet.

    This problem, ...

    Solution Summary

    In Excel, the solution is demonstrated and solved.

    $2.19

    ADVERTISEMENT