搜索
数据产品名称求和项:Sum(数量)求和项:库存量求和项:单价AliceMutton89039AniseedSyrup291310BostonCrabMeat5512318.4CamembertPierrot1721934CarnarvonTigers534262.5Chai1443918Chang2131719Chartreuseverte226918ChefAnton'sCajunSeasoning265322ChefAnton'sGumboMix100021.35C魌edeBlaye2517263.5EscargotsdeBourgogne406213.25FiloMix14387Fl鴗emysost1972621.5Geitost551122.5GnocchidinonnaAlice252138GorgonzolaTelino35012.5Grandma'sBoysenberrySpread2112025Guaran?Fant醩tica148204.5Gudbrandsdalsost662636GulaMalacca272719.45Gumb鋜Gummib鋜chen811531.23Gustaf'sKn鋍kebr鰀2510421Ikura253131InlagdSill6911219IpohCoffee961746Jack'sNewEnglandClamChowder122859.65Konbu207246Lakkalik鲻ri585718LaughingLumberjackLager205214LouisianaFieryHotPepperSauce217621.05LouisianaHotSpicedOkra1417ManjimupDriedApples982053MascarponeFabioli36932Maxilaku621020MozzarelladiGiovanni351434.8Nord-OstMatjeshering191025.89NorthwoodsCranberrySauce32640NuNuCaNu?Nougat-Creme157614OriginalFrankfurtergr黱eSo遝883213OutbackLager491515Pavlova492917.45PerthPasties105032.8P鈚?chinois12211524QuesoCabrales202221QuesoManchegoLaPastora468638RacletteCourdavault3047955RavioliAngelo483619.5Rh鰊br鋟Klosterbier41257.75R鰏sleSauerkraut982645.6R鰀Kaviar210115R鴊edesild2059.5SasquatchAle15511114ScottishLongbreads99612.5SingaporeanHokkienFriedMee722614SirRodney'sMarmalade164081SirRodney'sScones38310Siropd'閞able2411328.5Spegesild619512SteeleyeStout1172018Tarteausucre331749.3TeatimeChocolateBiscuits137259.2Th黵ingerRostbratwurst720123.79Tofu213523.25Tourti鑢e30217.45Tunnbr鰀12619UncleBob'sOrganicDriedPears1401530Valkoinensuklaa226516.25Vegie-spread422443.9WimmersguteSemmelkn鰀el1772233.2512345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455ABCDEFGHIJKLMNOP月销售量增长率15%15inD7:需补充短缺产品品种47补充短缺产品所需资金99983.5inD3:产品名称96.5销售量96.6需要量库存量短缺数量售出单价购入单价4799983.5RacletteCourdavault304349.679270.65552.255%4688493.9Chang213244.9517227.951918.0510%4694228.7Konbu207238.0524214.0565.715%4799983.5Fl鴗emysost197226.5526200.5521.520.42520%47105738.3WimmersguteSemmelkn鰀el177203.5522181.5533.2531.587525%48111500.4CamembertPierrot172197.819178.83432.330%48117292.0Guaran?Fant醩tica148170.220150.24.54.275UncleBob'sOrganicDriedPears140161151463028.5TeatimeChocolateBiscuits137157.5525132.559.28.7415%80000Chai144165.639126.61817.115%120000PerthPasties105120.750120.7532.831.16SteeleyeStout117134.5520114.551817.1ChefAnton'sGumboMix100115011521.3520.2825ScottishLongbreads99113.856107.8512.511.875AliceMutton89102.350102.353937.05IpohCoffee96110.41793.44643.7ManjimupDriedApples98112.72092.75350.35R鰏sleSauerkraut98112.72686.745.643.32Th黵ingerRostbratwurst7282.8082.8123.79117.601Gumb鋜Gummib鋜chen8193.151578.1531.2329.6685SasquatchAle155178.2511167.251413.3OriginalFrankfurtergr黱eSo遝88101.23269.21312.35Maxilaku6271.31061.32019Jack'sNewEnglandClamChowder122140.38555.39.659.1675SingaporeanHokkienFriedMee7282.82656.81413.3Gudbrandsdalsost6675.92649.93634.2OutbackLager4956.351541.351514.25SirRodney'sScones3843.7340.7109.5GorgonzolaTelino3540.25040.2512.511.875MascarponeFabioli3641.4932.43230.4NorthwoodsCranberrySauce3236.8630.84038P鈚?chinois122140.311525.32422.8Pavlova4956.352927.3517.4516.5775MozzarelladiGiovanni3540.251426.2534.833.06Vegie-spread4248.32424.343.941.705Tarteausucre3337.951720.9549.346.835AniseedSyrup2933.351320.35109.5CarnarvonTigers5360.954218.9562.559.375RavioliAngelo4855.23619.219.518.525R鴊edesild20235189.59.025Tourti鑢e3034.52113.57.457.0775C魌edeBlaye2528.751711.75263.5250.325Nord-OstMatjeshering1921.851011.8525.8924.5955Lakkalik鲻ri5866.7579.71817.1GnocchidinonnaAlice2528.75217.753836.1GulaMalacca2731.05274.0519.4518.4775QuesoCabrales20232212119.95BostonCrabMeat5563.25123018.417.48Chartreuseverte2225.36901817.1565758596061626364656667686970717273747576ABCDEFGHIJKLMNOPChefAnton'sCajunSeasoning2629.95302220.9EscargotsdeBourgogne404662013.2512.5875FiloMix1416.138076.65Geitost5563.2511202.52.375Grandma'sBoysenberrySpread2124.1512002523.75Gustaf'sKn鋍kebr鰀2528.7510402119.95Ikura2528.753103129.45InlagdSill6979.3511201918.05LaughingLumberjackLager20235201413.3LouisianaFieryHotPepperSauce2124.1576021.0519.9975LouisianaHotSpicedOkra11.15401716.15NuNuCaNu?Nougat-Creme1517.257601413.3QuesoManchegoLaPastora4652.98603836.1Rh鰊br鋟Klosterbier44.612507.757.3625R鰀Kaviar22.310101514.25SirRodney'sMarmalade1618.44008176.95Siropd'閞able2427.6113028.527.075Spegesild6170.159501211.4Tofu2124.1535023.2522.0875Tunnbr鰀1213.861098.55Valkoinensuklaa2225.365016.2515.437512345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455QRSTUVW=C7*(1+$D$2)inF7:=MAX(D7-E7,0)inH7:=G7*95%=COUNTIF(F7:F76,0)inD4:{=SUM(F7:F76*G7:G76)}99983.580000900001000001100001200005%10%15%20%25%30%月销量增长率95年6月补充短缺库存量所需资金随预计月销量增长率的变化月销量增长率15%