Daisy had to go through kitchen manager training to run the hotdog stand, so she knows that proper storage of meat products is very important. To provide that cold storage and handling, a local restaurantcharges one cent per hotdog percalendardayand Madison, Daisy's assistant, has a calendar that shows365 days per year. The same restaurant has the food contracts with vendors, so they handle the orders, but charge$60 to process, receive, and put each order in their freezeron top of their storage costs.
Daisy holds hotdog sales throughout the year, but is very selective about her days. Sheaverages 160 sale days per year,with anaverage of 263 hotdogs sold on each day.
Daisy is very concerned about storage and ordering costs as hotdog sales are likely to increase when people discover that by sharing a hotdog with her on the library lawn they can support the kids. Daisy is thinking that something like the table on the right might allow her to figure out important metrics and see how they would change as the inputs change over time.
a) make a "hotdog" worksheet in your workbook into which Daisy can have Madison enter the number of sale days per year, the average sales per sale day, the cost per order, and the holding costs per hot dog per day andhave it compute the optimal quantity she should order. Some extra "helper" cells (like the total annual demand) are OK with Daisy, but she wants the spreadsheet to round the number of hotdogs because she doesn't know how to do that fancy math herself.
b) If Daisy orders the quantity that minimizes the sum of the order and carrying costs, compute how many orders per year will she need to make?
c) Given the above ordering quantity compute the annual carrying costs, order costs and total costs for this operation?
d) Compute the order cycle in sales days?
e)The restaurant is changing their pricing to $65 per order and .9 cents per hotdog per day. Add another column next to the current numbers, that has all the same computations and do comparison with this new pricing so that Daisy can see if her costs will be higher or lower after the change.
Daisr is very merned taut statue and endenl test as hustle: sales are likelqllI tn hireasewhen peepiedisemer that blur sharia: a hasdeliiiherenseimrwlawnmevunslmtmeds. Dalsris thinking that semething like setahileen the right rniht alllmmI her In gureaut important men-ii: and see hrt'lllirti'lesllI \"UH shame as the inputsdiarme euertime. ii treateam'wisheetinwrwamkintemmisv canhave Madissnenterthenumheraisaiedavspervearjse average salupersale damtheeastperurdenandtiieheldirl temperhntdnlperdaymdheitmmem \"museums alder. Semeestra 'helper' cells ike the Elm-umuhuluu E "i i tutaiamualdemandiareulwim Daisv,hutshewanuie u are mi spreadsheet to HILII'HI the number at humus because she 11 thmmmmmmmm. all\" an if Daisy orders the qumw that minimises the sum afthe nrder 14 andmmmmmwtehwmamuersperwaswill she 15 W \"1 needtemakei' 1i Dru-rm 11m Gwenieahevearderumtrwnputethemnualearmn: 1: mm 1:53.13! murdereastsam tetalcestsfurmiseperatian? 11mm m Eunputethenrdercrdein salesdavsi' 1... Therestaurantiseharlirlthek'prleingteiperu'de-i'andeemsperhutdagperdadedmtl'Ier ealumnnekttnthemrrentmunbers.lhathuallthesamecmputatimsandeammparisanwiimis newpridniseiataisyeanseeifhereestsuillhehijhererhweraiterti'lediarle. Dalsr want: somethlnl Into whtol'l MadIoon could enter the rnlntrnurn quantity and oost for each quantity break point and hauetteornputethe bestorder Immune-1mm\" that amanorderooot, prollIctlonoost, and tohl overall cost. Mods-on stunted the tollowhl. Mawot'the loom actually have decimals, but Dalsrwanted them reformatted lwtthout actuallrdurltm the values] beuule It's hard for Dalsr to oomt dtanlewtdl paws. [note: format. don"t round]. Hadlron also added a note to that It woo clear which one Baler should ehooie became, well, she's a do]. I} modify the "cum sheet to lndude the followlnl table Into whleh Madison pen enter the mlnllnurn ouanttde: and their respective price: and have other Item:- oompubed. lndudlnu 'HJ'A' where appropriate and the lliDalsllr:I'Io'lnrrme thls one'note to Daley a: shown below. moor ha Llnlh'lcethdlrn'l Etiolt Minn Fro-lion Tmlol _ \"A HM HIM MM \"A. If! Hi "all 1411 III?! 1'\" 511.111 l'-I 1M 111E] 51E?! 45'] L'Hll m \"$.51? \"mint" M1! in 55]] 515.31? Hf h} Daley\": hotdog sate: keep Imprm and euerwuallvther're runntnl EDI] honing :ale day: per lIl'ear and auer'allnl no hotdoas per dl'f. Thewholesaler I: shlpplnl nearlrr container oi hotdo to the cttr eod1b,wouldlouelno'eeduttoaall omtalner,andatsowudhenetltfron1 atttdeaduertlolmhr smordnlduswortlwnusera result,Datrrtsoered a quantttrhreallforltlmhoodolsat a time foronlvi cent: apteoeoronlvapenrweadishe'll hu'gllI Immulneadtorder. ModifytheabovetabletotndudedteleoewprtoehreatutoheIpDaidete-rrntnehowmalwhotdolo nodule Nououoonsupponyourmedomerbyulhpm udoncemororonxomondseordrphr oomefeq. 'Dordleoncfngop'JFrryouoonoomehdnoyono wormFdorselllnphoodops ordrebmry. Filed Intern! Drinks: 4. :m-mnd'umFumahamhw lltalluwheumhmtarlwlminlbuhmsmmd mnumhmmmlmseamwehnh. Hint: 111cm is I helpful widen that remindrruu haw tn W: I 2- wlue 'I'mrn I cumulative m under the standard mm\"! WWI. 1. =2 3. I... 5. Emmi! 1. l. g. m \f
