11 Gatorpops

Information about 11 Gatorpops

Published on December 17, 2007

Author: Lassie

Source: authorstream.com

Content

Gator Pop Operations:  Gator Pop Operations Dr. Everette S. Gardner, Jr. 1. Introduction:  1. Introduction The alert student will recall that Alligator Sushi was originally developed at Wildflour Restaurant’s flagship location in Missouri City. This product is composed of thin slices of fresh alligator marinated in corn liquor. The processing cycle is relatively simple. Fresh alligators are received daily from a supplier in Hope, Arkansas. On arrival, the alligators are released in a pit in Wildflour’s bar. Accompanied by cheers from bar patrons, Danny Darwin and John Cangelosi descend into the pit, wrestle the alligators into submission, and tie them up. Next, the executive chef, Jose Lima, enters the pit to slay and slice the beasts. Jose tosses the sushi into vats of 150-proof corn liquor. Bartenders fish out slices from the vats as needed. Matt Galante, Wildflour CEO, decided to develop a new version of Alligator Sushi as a supermarket and liquor-store product. The sushi will be frozen and marketed as an adult popsicle under the trade name “Gator Pops.” You have been engaged as an operations management consultant to Matt. Slide3:  2. Simple exponential smoothing and seasonal adjustment Your first task is to forecast national quarterly sales of Gator Pops. The table below shows the results of seasonal adjustment for the first two years of actual sales (in millions of pops). Actual Moving Sum of # of Avg. Seas. Adj. Year Qtr t Data Avg. Ratio ratios ratios ratio Index Data 1998 1 1 280 0.0 0.00 0.82 1 0.821 0.820 341.4 2 2 290 0.0 0.00 0.89 1 0.891 0.889 326.1 3 3 400 330.0 1.21 2.45 2 1.225 1.223 327.0 4 4 350 327.5 1.07 1.07 1 1.069 1.067 327.9 1999 1 5 270 328.8 0.82 Sum 4.005 4.000 329.2 2 6 295 331.3 0.89 331.7 3 7 410 331.3 1.24 335.2 4 8 350 0.0 0.00 327.9 Apply simple exponential smoothing with a weight of 0.50 to the last year of seasonally-adjusted data. Start with a forecast of 329.2 for the first quarter of 1999. A. What are the MAD and MSE values for 1999? B. What are the seasonally-adjusted forecasts for each quarter in the year 2000? C. Reverse the seasonal adjustment in the forecasts. What are the final forecasts for each quarter in the year 2000? Slide4:  3. Trend-adjusted smoothing Sales in Arcola, Texas (in thousands of pops) for the first three months after product introduction in that market were: Month Arcola sales September 100 October 120 November 130 There is not enough data to estimate seasonality in that market. Apply trend-adjusted smoothing with the following weights: level = .3, trend = .1, and trend modifier = .9. A. What is the forecast for December? B. What is the forecast for January? C. What is the forecast for April? Slide5:  4. EOQ and safety stocks After several years of Gator Pop production, Matt Galante realized that he needed a better inventory management system for the major Gator Pop components: Gators, wrappers, and popsicle sticks. Matt ordered every item once per week. He was concerned about the reordering workload and wanted to explore alternative ordering rules. Matt asks you to develop an EOQ-based inventory management system for Gator Pop components. As a test case, Matt provides annual demand forecasts in dollars for the Brice’s Crossroads, Mississippi, sales region: Item Annual demand $ Gators $10,000 Wrappers 900 Sticks 64 You may assume that demand is very stable and there is no need for safety stock. The demand values above are forecasts for the next year from simple exponential smoothing. You may ignore corn liquor demand because it is produced on site in bulk quantities from very inexpensive components—fermentation time is only about two hours so any shortages can be remedied quickly. Answer the following questions: A. What is Matt’s total inventory investment and re-ordering workload for these items under current policy (ordering every item once per week)? Assume that the work year includes 50 weeks, that is Matt orders every item 50 times per year. B. Suppose that you implement the EOQ model with K = 1. Compute inventory investment and re-ordering workload. What are the investment and workload savings from the EOQ model? Slide6:  4. EOQ and safety stocks (cont.) Matt becomes unhappy with the EOQ using K = 1 for Gators. He feels that the ordering rate is still too high. Furthermore, demand has become variable and he is concerned about possible stockouts. The demand forecast for next year is still $10,000, although the standard deviation of forecast errors for monthly forecasts has increased from near zero to $120. Answer the following questions: C. Compute the EOQ and reordering workload for Gators using K = 5. D. Compute the reorder point and safety stock. Leadtime is 1 month and Matt wants a 10% probability of running out of stock during one leadtime. E. What are the minimum and maximum inventory investment values for the new EOQ and safety stock policy for Gators? Slide7:  5. MRP Matt asks you to experiment with MRP techniques for managing Gator Pop sticks. Here are gross requirements for the next 6 weeks, in thousands of sticks: Week 1 2 3 4 5 6 Gross requirements 20 5 10 20 5 70 Currently, there are 25,000 sticks on hand, with 5,000 sticks allocated to a special order (for “Road Party 77” to celebrate the completion of the last section of the Sam Houston Tollway—never mind that less than half of the exits on the Tollway are complete). There is a scheduled receipt of 15,000 sticks due in week 1. Matt asks you to order lot-for-lot, with a 2-week leadtime, and maintain a safety stock of 5,000 sticks. Answer the following questions: A. What are the net requirements for the 6-week period? B. When should planned orders be received and released? Slide8:  6. Project management Here are the activities in rolling out a new Gator Pop promotion: Task Description Time Immediate Predecessors A Get Matt to approve budget 2 weeks B Select advertising theme 2 A C Produce flyers 12 A D Buy radio time 3 B E Schedule magazine ads 3 B F Train salespeople 1 B G Prepare radio copy 4 D H Prepare magazine copy 6 E I Distribute flyers 2 C,F J Run special in supermarkets 3 G,H,I Draw this project in activities on arrows format. Then answer the following questions: A. What is the earliest that this project can be finished? B. Which activities are critical? C. Which activities have the most slack? Slide9:  7. Waiting-line analysis Matt asks you to analyze the idea of selling Gator Pops from a refrigerated cart on the club level at Enron Field. This idea came from Yogi Berra, who was coaxed out of retirement to assist the Astros in food service. Yogi estimates that customers will arrive at the cart at the rate or 170 per hour throughout a ball game. Yogi plans to run the cart himself and thinks he can serve about 3 customers per minute. Matt’s instructions were as follows: “This may be a super idea, but I want to know how long the waiting line is likely to be. If there are too many people in line, the club level could get congested. I think about 20 people in line is all we can stand. Also, how long will it take for people to wait in line and get served? If the fans think they will miss a half-inning, they won’t bother to get in line. Here’s something else to worry about: How do we know that Yogi can handle this thing himself? What would happen if we had two or even three cart attendants? Get back to me when you can answer my questions.” What is your response to Matt? Slide10:  8. Dimensional analysis There are two alternative sources of alligators that offer the quality necessary to make Gator Pops. Shania’s Gators (Wildflour’s current supplier) has a 5-day leadtime and sells its Gators for $38.50 per pound. Monica’s Gators is both cheaper ($35.00 per pound) and quicker (4-day leadtime). However, Monica’s records show that she is in stock only 80% of the time, while Shania is in stock 95% of the time. Matt asks you to pick a supplier using dimensionless analysis. He feels that leadtime should receive a weight of 2, with price weighted at 4. The in-stock percentage is most important and should receive a weight of 5.

Related presentations


Other presentations created by Lassie

Presentation Accenture
12. 03. 2008
0 views

Presentation Accenture

Taxation
19. 10. 2007
0 views

Taxation

population
21. 10. 2007
0 views

population

19 sethusamudram ppt
30. 09. 2007
0 views

19 sethusamudram ppt

sample seminar
02. 05. 2008
0 views

sample seminar

Oral Radiology
02. 05. 2008
0 views

Oral Radiology

Rainfall
07. 04. 2008
0 views

Rainfall

Andrew
19. 02. 2008
0 views

Andrew

campaigns and elections
07. 01. 2008
0 views

campaigns and elections

Emergency Planning
03. 10. 2007
0 views

Emergency Planning

stjerna 060307
09. 10. 2007
0 views

stjerna 060307

ElectiveWkshpGoalSet
10. 10. 2007
0 views

ElectiveWkshpGoalSet

p5animals
12. 10. 2007
0 views

p5animals

RT
12. 10. 2007
0 views

RT

pinarsut
13. 10. 2007
0 views

pinarsut

Lecture19 Ch19 111405
15. 10. 2007
0 views

Lecture19 Ch19 111405

Poster APS summary
16. 10. 2007
0 views

Poster APS summary

david ingleby
17. 10. 2007
0 views

david ingleby

Ole Lund
23. 10. 2007
0 views

Ole Lund

acmmm02
24. 10. 2007
0 views

acmmm02

rebecca
11. 12. 2007
0 views

rebecca

HHH Scandale
17. 10. 2007
0 views

HHH Scandale

1 WMO
19. 10. 2007
0 views

1 WMO

Great Britain
02. 11. 2007
0 views

Great Britain

ENYA
02. 11. 2007
0 views

ENYA

5AlpaShah
06. 11. 2007
0 views

5AlpaShah

Rectoria Panama 2006
25. 10. 2007
0 views

Rectoria Panama 2006

L10a 4345 Sp02
07. 11. 2007
0 views

L10a 4345 Sp02

Shahriar
15. 11. 2007
0 views

Shahriar

lakshmi wireless
15. 11. 2007
0 views

lakshmi wireless

CONTEMPORARY DANCE LESSONS
23. 11. 2007
0 views

CONTEMPORARY DANCE LESSONS

price iso 15926 as owl
07. 11. 2007
0 views

price iso 15926 as owl

acute 060718 neuroemergencies
23. 10. 2007
0 views

acute 060718 neuroemergencies

The Olmec
21. 11. 2007
0 views

The Olmec

wetlands inventory
03. 01. 2008
0 views

wetlands inventory

plainChairdesign
04. 01. 2008
0 views

plainChairdesign

Polymorphic Robotics at ISI
07. 01. 2008
0 views

Polymorphic Robotics at ISI

t Campout with Foodborne Illness
07. 01. 2008
0 views

t Campout with Foodborne Illness

poly web cast
15. 10. 2007
0 views

poly web cast

MTAC 11 06v1 03georgewright
06. 11. 2007
0 views

MTAC 11 06v1 03georgewright

awmapres041905
31. 10. 2007
0 views

awmapres041905

Insecta
23. 10. 2007
0 views

Insecta

ficci wo pictures
29. 12. 2007
0 views

ficci wo pictures

Modelos de control Ley 24156
22. 10. 2007
0 views

Modelos de control Ley 24156

severe wx
07. 10. 2007
0 views

severe wx

Egypt presentation salem 2nd
21. 10. 2007
0 views

Egypt presentation salem 2nd

nursinghome
29. 11. 2007
0 views

nursinghome

IMechE 19th May
15. 10. 2007
0 views

IMechE 19th May

EGEE Summer School 2007
17. 10. 2007
0 views

EGEE Summer School 2007

Carolyn
31. 12. 2007
0 views

Carolyn

4 Systematic chemistry web cec
16. 02. 2008
0 views

4 Systematic chemistry web cec

hsearch
20. 11. 2007
0 views

hsearch

kimkidu
24. 02. 2008
0 views

kimkidu

IntroMiscConcl
27. 02. 2008
0 views

IntroMiscConcl

dutchhistoryfordummi es
27. 02. 2008
0 views

dutchhistoryfordummi es

hansen2
29. 10. 2007
0 views

hansen2

sciencenews
29. 09. 2007
0 views

sciencenews

Running a vegetarian campaign
04. 03. 2008
0 views

Running a vegetarian campaign

D3 NomuraResearch
25. 03. 2008
0 views

D3 NomuraResearch

presentationkpimchan ThaiAirways
30. 03. 2008
0 views

presentationkpimchan ThaiAirways

ch19 Kreitner 2004 6e OB
08. 04. 2008
0 views

ch19 Kreitner 2004 6e OB

indiapres110606
14. 04. 2008
0 views

indiapres110606

MMM CEO
18. 04. 2008
0 views

MMM CEO

ch26 hedgingrisk
16. 04. 2008
0 views

ch26 hedgingrisk

myCH14
07. 05. 2008
0 views

myCH14

CROSSGRID VO SEC KD
08. 05. 2008
0 views

CROSSGRID VO SEC KD

Prescribed Fire at UNF
02. 01. 2008
0 views

Prescribed Fire at UNF

md apr quality82604 mtan
30. 04. 2008
0 views

md apr quality82604 mtan

bowles
01. 05. 2008
0 views

bowles

PSRS partI
02. 05. 2008
0 views

PSRS partI

pres1
02. 05. 2008
0 views

pres1

Waittimes presentation e
02. 05. 2008
0 views

Waittimes presentation e

ae8 eman over
26. 02. 2008
0 views

ae8 eman over

CH 9
04. 01. 2008
0 views

CH 9

Horton ALA Moving Mountains
29. 02. 2008
0 views

Horton ALA Moving Mountains

remsim
01. 11. 2007
0 views

remsim

CERLS
16. 10. 2007
0 views

CERLS

forum creativite5
23. 10. 2007
0 views

forum creativite5

Ceanothus
14. 12. 2007
0 views

Ceanothus

Pollard
24. 10. 2007
0 views

Pollard

Typology 7mfamelev
02. 11. 2007
0 views

Typology 7mfamelev

ST3
24. 10. 2007
0 views

ST3

UNITROL Service Nov2006 Aend A
19. 10. 2007
0 views

UNITROL Service Nov2006 Aend A

energetech
17. 04. 2008
0 views

energetech

Presentaton
23. 10. 2007
0 views

Presentaton

LTCOPhistoryandresp
03. 10. 2007
0 views

LTCOPhistoryandresp

schmerge experimental results
21. 11. 2007
0 views

schmerge experimental results

martemiyanov
27. 09. 2007
0 views

martemiyanov

Lecture9 JF
16. 10. 2007
0 views

Lecture9 JF

helen meeks
02. 10. 2007
0 views

helen meeks

Mol gen 9910
16. 10. 2007
0 views

Mol gen 9910