目的：保护该数据模板的公式部分不被修改，同时隐藏公式LEONARDODIVINCICORPORATION2000BUDGETPLANNERBUDGETPLANNERPleaseenteryourbudgetbysettingthevaluesintheunshadedareas.Theblueareasarecalculated.Assumptions:Region123456789101112VersionTacticalExpenditures:ThisYearJanFebMarAprMayJunJulAugSepOctNovDecAdvertising175,10114,51515,57017,60212,03314,60314,11916,79315,90810,89813,36313,65516,043Telemarketing225,43024,33222,36318,55817,58522,20317,08717,17116,54415,73220,10817,24316,504NextYearJanFebMarAprMayJunJulAugSepOctNovDecAdvertising215,20020,80016,90017,20018,40015,80018,00018,20017,20018,10019,50019,90015,200Telemarketing277,60021,80024,60025,80020,60023,70019,60025,30023,50023,20024,60022,90022,000Seasonality100%5%6%8%8%9%11%7%5%8%9%10%14%UnitSalesProjections:Markups:ProductEst.ComptnOursThisYearNextYearJanFebMarAprMayJunJulAugSepOctNovDecDesktop17%16%8,103000000000000Laptop17%13%12,79300000000000012in.ColorMonitor22%22%2,61800000000000014in.ColorMonitor22%21%3,956000000000000101KeyKeyboard24%25%851000000000000LaserPrinter30%27%4,785000000000000RevenueCalculation:CostCostProductThisYearNextYearPriceNextYearJanFebMarAprMayJunJulAugSepOctNovDecDesktop1,217.991,3001519.95-------------Laptop1,572.011,6001819.95-------------12in.ColorMonitor124.45160209.95-------------14in.ColorMonitor165.36200249.95-------------101KeyKeyboard13.261629.95-------------LaserPrinter121.53120159.95-------------AllProducts-------------CostofGoodsSoldProductNextYearJanFebMarAprMayJunJulAugSepOctNovDecDesktop-------------Laptop-------------12in.ColorMonitor-------------14in.ColorMonitor-------------101KeyKeyboard-------------LaserPrinter-------------AllProducts-------------VariableCostsPercentofRevenue1998DesktopThisYearNextYearNextYearJanFebMarAprMayJunJulAugSepOctNovDecRevenueWarehousing3%2.90%-------------#NAME?Shipping2%1.90%-------------OrderProcStaff2%2.10%-------------VariableBenefits0.0032270370.003150000000000000LaptopWarehousing-------------Shipping-------------OrderProcStaff-------------VariableBenefits00000000