Sunday, July 17, 2011

Littlefield Technologies Simulation Game 2 strategy

Just went through this last semester. We ended up in first place even though we made a few minor mistakes. First a few links that helped us:

http://archive.ite.journal.informs.org/Vol5No2/Miyaoka/
http://wordpress.shetgar.com/blog/?p=59
http://www.scribd.com/doc/51139499/Littlefield-Simulation-2-Report

Here is what we did:

Pre-Game Activities: The team met the Tuesday before class to examine the data and discuss strategies. It was apparent that both Stations 1 and 3 were operating at full capacity, frequently hitting 100% utilization. Station 3 seemed more strained since it had higher queues (Mean=506, STD=498) than Station 1(Mean=187, STD=175).

Since the average job lead time exceeded 2 days during days 43 through 46, inclusive, we thought it would be unprofitable to attempt to move to the $1,000 contracts. We discussed the options of altering the lot sizes, but decided that the extra setup time would only create more bottlenecks downstream.

Stage 1: As a result of our analysis, the team’s initial actions included:
1. Leave the contracts at $750.
2. Change the reorder point to 3000 (possibly risking running out of stock).
3. Change the reorder quantity to 3600 kits.
4. Purchase a second machine for Station 3 as soon as our cash balance reached $137,000 ($100K + 37K).

This strategy proved successful and after the second machine for Station 3 was purchased on Day 56 and the queue cleared, we were able to switch to the $1,000 contracts. We occasionally lost a few dollars for being a little late, but we always made more than we would have under the $750 contracts.

Stage 2: The next goal was to save enough cash to purchase a machine for Station 1 so that we could switch to the $1,250 contracts. During the cash building stage, we made the inventory order quantity as high as we could afford, which was 6,900 kits at a purchase price of $70,000. When the 6,900 kits were delivered, we switched the order quantity back to 3,600 so that we could purchase a Station 1 machine as soon as our cash balance reached $127,000 ($90K + 37K).
After 21 factory days, we were able to purchase the fourth machine for Station 1 and immediately moved to the $1,250 contracts.

The average lead time declined to under a half a day during factory days 69 through 76. There was a substantial decline in arriving orders during the same time period. The team noticed the drop in lead time and regrets not having moved to the $1,250 contracts sooner. We lost $22,750 of potential revenue for not moving on the information sooner. On the other hand, orders are random and an early move could have backfired on us.

Stage 3: During our preliminary meeting, the team discussed the possibility of purchasing a fifth machine for Station 1. We decided to wait and see if the loss of potential earnings was sufficient to justify a $90 K purchase. We knew that if we were going to buy a fifth machine we should do it as soon as possible to maximize the return on investment. We calculated the loss of potential revenue as ($1,250 – actual average revenues * jobs completed). Our initial estimates showed a potential revenue loss of $266 per day, but within a few factory days the rate of potential loss rose to $419 per day.

There is another consideration in the decision to purchase a fifth machine for Station 1. The title of the Littlefield Technologies game 2 is Customer Responsiveness. The title implies that we should be concerned about the consistency with which we deliver on our service level agreements (SLAs). The potential loss of $419 per day barely covers the $90,000 machine purchase; however we were missing our SLAs 13 out of 15 days and the percent of potential revenues lost due to missing SLAs was 3%. We decided to purchase the fifth machine on Day 94 primarily to improve our customer responsiveness.

This strategy did not perform as well as we had hoped. While our potential revenues lost declined to 1%, we were still missing our SLAs six out of seven days.

Stage 4. During Stage 4, we explored job splitting as a solution to the SLA problem. First, we split jobs into two batch of 30 kits each. This strategy worked so well that we wondered why we hadn’t explored job splitting during Stage 2 or 3. We met our SLAs 12 out of 16 days and our percent of potential revenues lost declined to 0.4%. We calculated the setup times as a proportion of a machine to be 0.007, 0.003, and 0.002 for S1, S2, and S3, respectively.

2S1 + P = 0.194458 =>   S1 + P = 0.187256  =>   S1 = 0.007202
2S2 + P = 0.082479 =>   S2 + P = 0.079424  =>   S2 = 0.003055
2S3 + P = 0.064835 =>   S3 + P = 0.062434  =>   S3 = 0.002401
Where the right hand side is calculated as Sum(%Utilization * #Machines)/#Jobs Completed

We thought that if setup time was so insignificant, maybe the other job splits would be equally good or better. Accordingly, we tried the 3-way job split for eight days, but we were not impressed with the results. On one of the days, our average revenues dropped below $1,200, which we hadn’t seen since purchasing the fifth machine for Station 1.

We thought that maybe it was because of the mismatch between machines and splits. So we tried the 5-way split thinking each job would be split equally among the five machines. This turned out to be a HUGE mistake! After only one factory day it was apparent the 5-way split was a bad thing and we switched back to the 2-way split. Even so, it took an additional four days for the system to recover from the backlogs and we lost $46,693 in potential revenues. (Morale of the story – 2 way splits are great as soon as the queue clears with the purchase of machines. Forget the other splits.)

A one-way ANOVA demonstrated that the differences between the job splits were statistically significant at the alpha=.01 level. Group 1 was no splits. Group 2 was a two-way split. Group 3 was a three-way split. Group 5 was a five-way split. Data for all groups were collected after all machine purchases explaining the small number of observations for Group 1.

We chose to stay with the 2-way split not only because it had the highest average revenues, but also because the 2-way split had the lowest variance. With the 2-way split we were meeting our service level agreements more consistently resulting in higher customer satisfaction and higher profits per job.



Stage 5. With our factory humming, our attention turned to inventory purchases. We calculated the reorder quantity using the equation:

Q* = SQRT(2DS/H) = SQRT(2 * 12 * 365 * 1,000 / 66.31) = 363 batches
Where D = annual demand = 12 * 365
S = fixed cost per order = $1,000, and
H = the handling costs = $60 x (1 + .10/365)365 = 66.31

The calculated reorder quantity was surprisingly close to the value obtained from running our numbers through the Inventory example from Chapter 7 of our text (363 vs. 382).

The text also mentioned that small variations in reorder quantity do not matter much and so people usually round to a convenient number. Thus, we set our re-order quantity to 400.
Stage 6. Previously we had been stockpiling inventory by purchasing more as soon as money was available to purchase, but we realized that we may be missing out on nontrivial interest payments. So we re-set the reorder point to 3600, which provides a four day inventory plus a safety net.

Stage 7. The Exit Strategy – We do not have control of the factory during the last 100 days of its life. We know from the instructions for the game that the demand is expected to stay consistent although orders are random. We do not feel it is wise to leave a large reorder quantity while the factory is out of our control because we might have a sudden increase in jobs during the last few days that sparks a $241,000 inventory purchase, most of which will go to waste. So before we lose control, we will buy (100 * 11.8 * 60) kits and then set the reorder quantity to 60 (or 3,600 kits). We hope this exit strategy works.

The exit strategy did work although if we had purchased another 1,200 kits in Stage 7, we could have set the reorder quantity to 0 and reorder point to 0. This would have saved use another $24,000.

11 comments:

  1. Florida Buy and Sell will help you sell your business for right amount of money, preserving the
    confidentiality of the deal.Selling a business is a complex endeavor. Many entrepreneurs postpone the sale of their business due to uncertainties and a fear of not getting what they want. As a result, when the time comes and a business must be sold anyway, it is often a fire sale, and the proceeds are seldom satisfactory. However, ready for use an already assembled car can drive you instantly. Here are opotions for Selling business, confidentiality, exit strategy and business broker.

    ReplyDelete
  2. hi how to change reorder point in littlefiled?

    ReplyDelete
  3. I want to share with you all here on how I get my loan from Mr Benjamin who help me with loan of 400,000.00 Euro to improve my business, It was easy and swift when i apply for the loan when things was getting rough with my business Mr Benjamin grant me loan without delay. here is Mr Benjamin email/whatsapp contact: +1 989-394-3740, lfdsloans@outlook.com.

    ReplyDelete
  4. Hello there. I discovered your blog by means of Google whilst looking for a related matter, your web site got here up. It looks great. I have bookmarked it in my google bookmarks to visit then.
    advanced hospital management system

    ReplyDelete
  5. How did you set your holding cost in such an equation?

    ReplyDelete
  6. I was searching for loan to sort out my bills& debts, then i saw comments about Blank ATM Credit Card that can be hacked to withdraw money from any ATM machines around you . I doubted thus but decided to give it a try by contacting (smithhackingcompanyltd@gmail.com} they responded with their guidelines on how the card works. I was assured that the card can withdraw $5,000 instant per day & was credited with$50,000,000.00 so i requested for one & paid the delivery fee to obtain the card, after 24 hours later, i was shock to see the UPS agent in my resident with a parcel{card} i signed and went back inside and confirmed the card work's after the agent left. This is no doubts because i have the card & has made used of the card. This hackers are USA based hackers set out to help people with financial freedom!! Contact these email if you wants to get rich with this Via: smithhackingcompanyltd@gmail.com or WhatsApp +1(360)6370612

    ReplyDelete
  7. Programmed ATM Cards
    Do you know that you can hack any ATM machine !!!
    We have specially programmed ATMs that can be used to withdraw money at ATMs, shops and points of sale. We sell these cards to all our customers and interested buyers all over the world, the cards have a withdrawal limit every week.
    Getting rich and living the rich and famous lifestyle is a dream of many people. And while most people go to work or look for other ethical methods to make money on ATM-programmed cards.
    The programmed ATMs withdraw money from each ATM but have a withdrawal limit every week, only your PIN code is in it, it is a high-tech card system. The PROGRAMMED ATM card works on all card-based ATMs, anywhere in the world.
    Email: atmservices44@aol.com
    Email: hacklords.investors@gmail.com

    ReplyDelete
  8. This card are real i got my card few hours ago and am just coming back from the ATM where i made my first withdraw of $4500, i am going crazy this is fucking real OSCAR WHITE sorry for being so skeptical about it at first don’t blame me the street these days got fucked up lots of scammers and now i can recommend whoever needs a blank ATM card with about $50,000,000.00 on it which you can withdraw within a month because the card has a daily limit.if you are facing any financial problem contact him asap email address is oscarwhitehackersworld@gmail.com ,whats-app +1(513)-299-8247 or text him +1(510)-210-1050 as soon as possible .

    ReplyDelete

  9. INSTEAD OF GETTING A LOAN,, I GOT SOMETHING NEW
    Get $10,050 USD every week, for six months!

    See how it works
    Do you know you can hack into any ATM machine with a hacked ATM card??
    Make up you mind before applying, straight deal...
    Order for a blank ATM card now and get millions within a week!: contact us
    via email address:: besthackersworld58@gmail.com or whats-app +1(323)-723-2568

    We have specially programmed ATM cards that can be use to hack ATM
    machines, the ATM cards can be used to withdraw at the ATM or swipe, at
    stores and POS. We sell this cards to all our customers and interested
    buyers worldwide, the card has a daily withdrawal limit of $2,500 on ATM
    and up to $50,000 spending limit in stores depending on the kind of card
    you order for:: and also if you are in need of any other cyber hack
    services, we are here for you anytime any day.
    Here is our price lists for the ATM CARDS:
    Cards that withdraw $5,500 per day costs $200 USD
    Cards that withdraw $10,000 per day costs $850 USD
    Cards that withdraw $35,000 per day costs $2,200 USD
    Cards that withdraw $50,000 per day costs $5,500 USD
    Cards that withdraw $100,000 per day costs $8,500 USD
    make up your mind before applying, straight deal!!!

    The price include shipping fees and charges, order now: contact us via
    email address::besthackersworld58@gmail.com or whats-app +1(323)-723-2568

    ReplyDelete
  10. Have you pay your necessary BILLS? Do you need money? Do you want a better way to transform your own life? My name his Elizabeth Maxwell. I am here to share with you about Mr OSCAR WHITE new system of making others rich with not less than two to three days.I was in search of a job opportunity on the internet when i come across his aid on a blogs that i was on to, talking on how he can help the needy with a programmed BLANK ATM CARD.I thought it was a scam or normal gist but i never had a choice than to contact him cause i was seriously in need of Finance for Business.I contacted him on the CARD, and not less than a minute he respond and give me the necessary information’s on how to get the card. My friends, today am a sweet happy woman with good business and a happy family. I charge you not to live by ignorance.Try and get an ATM card today through (MR OSCAR WHITE)and be among the lucky ones who are benefiting from this card. This ATM card is capable of hacking into any ATM machine anywhere in the world.It has really changed my life and now I can say I’m rich because I am a living testimony. The less money I get in a day with this card is $15,000.Every now and then money keep pumping into my account. Although is illegal, there is no risk of being caught, as it is programmed so that it can not trace you, but also has a technique that makes it impossible for the CCTV to detect you.. I urge you to contact him on the BLANK ATM CARD. For details on how to get yours today, email hackers oscarwhitehackersworld@gmail.com ,whats-app +1(209)-643-1515

    ReplyDelete