+ Reply to Thread
Results 1 to 2 of 2

Help on how to do inventory simulation on excel

  1. #1
    Registered User
    Join Date
    09-27-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Help on how to do inventory simulation on excel

    I need help on how to do inventory simulation on excel. Can someone please just guide me on how to go about doing the problem? I don't know how to do 30 year simulations on excel. I've heard that you have to press F8 to do it but I don't know how to go about it. Here's the question I need help on:

    A company stocks and ships to their retailers a product each week. The Product costs $150 per unit and is sold to the retailers for $230 per unit. Units not sold during one week are held over and sold the next week at a cost of $15 per unit, charged on beginning inventory. The company also charges itself $12 per unit for any lost sales. The fixed cost for the operations is $2,000 per week. The company wants to maximize profits.

    The demand for the product follows a uniform distribution with a minimum of 150 units and a maximum of 200 units. The company is considering three possible order levels. These are 170, 175, or 180 units per week. Beginning inventory is zero.

    Do 30 one(1) year simulations of each of the three stock levels and use the results to determine which of the three order amounts should be selected.

  2. #2
    Registered User
    Join Date
    09-27-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Help on how to do inventory simulation on excel

    Anything? Please?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1