Explore BrainMass

Explore BrainMass

    Business Statistics in Excel for Annual Demand

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

    Problem:Business Statistics. Please use Excel. Answer questions 3 and 4. The answer for questions 1 and 2 have been provided to answer 3 and 4..

    1.)
    Annual demand 15000 Uncontrollable input
    Unit cost $80.00 Parameter
    Carrying cost rate 18% Parameter
    Order cost $220.00 Parameter
    Order quantity 677.0031866 Decision variable

    2.)
    Annual ordering cost = Annual Demand*Order cost/Order quantity
    Annual holding cost = Carrying cost rate*Unit cost*Order quantity/2
    Total annual cost = Annual ordering cost + annual holding cost

    © BrainMass Inc. brainmass.com June 4, 2020, 1:32 am ad1c9bdddf
    https://brainmass.com/business/business-management/business-statistics-excel-annual-demand-405601

    Attachments

    Solution Summary

    The expert examines business statistics in Excel for annual demand for uncontrollable input.

    $2.19

    ADVERTISEMENT