1 / 15
文档名称:

案例09-预算模版.xls

格式:xls   页数:15
下载后只包含 1 个 XLS 格式的文档,没有任何的图纸或源代码,查看文件列表

如果您已付费下载过本站文档,您可以点这里二次下载

分享

预览

案例09-预算模版.xls

上传人:化工机械 2012/4/15 文件大小:0 KB

下载得到文件列表

案例09-预算模版.xls

文档介绍

文档介绍::RegionVersionTacticalExpenditures:ThisYearAdvertising175,101Telemarketing225,430NextYearAdvertising215,200Telemarketing277,600Seasonality100%UnitSalesProjections:Markups:ptnOursThisYearNextYearDesktop17%16%8,103Laptop17%13%12,%22%2,%21%3,956101KeyKeyboard24%25%851LaserPrinter30%27%4,785RevenueCalculation:CostCostProductThisYearNextYearPriceNextYearDesktop1,,-Laptop1,,-----AllProducts-CostofGoodsSoldProductNextYearDesktop-Laptop---101KeyKeyboard-LaserPrinter-AllProducts-VariableCostsPercentofRevenueDesktopThisYearNextYearNextYearWarehousing3%%-Shipping2%%-OrderProcStaff2%%--Shipping-OrderProcStaff--Shipping-OrderProcStaff--Shipping-OrderProcStaff-VariableBenefits0101KeyKeyboardWarehousing-Shipping-OrderProcStaff-VariableBenefits0LaserPrinterWarehousing-Shipping-OrderProcStaff-VariableBenefits0AllProductsWarehousing-Shipping-OrderProcStaff-,051Copying38,917Phones33,151OfficeSupplies29,602Banking15,142Travel37,510Insurance42,002Legal31,389OfficeStaff521,,600CopyingNotused46,200PhonesNotused43,800OfficeSuppliesNotused40,920BankingNotused18,360TravelNotused42,360InsuranceNotused48,720LegalNotused42,360OfficeStaffNotused694,680FixedBenefitsNotused78,600FixedBenefitsTotal1773000FinancialSummaryNextYearRevenue-CostofGoods-GrossMargin-Warehousing-Shipping-OrderProcStaff-Variab