国外经典Excel表格-营业企划模板

CompanyName:CurrentYear:FinancialsOpentoDemoUsers!DashboardCreateanInvoiceOpentoDemoUsers!OpentoDemoUsers!Profit&Loss:CYPlanCreateaPurchaseOrderProfit&Loss:CYActualPYActualPayrollCalculatorOpentoDemoUsers!Profit&Loss:YTY&PlanCompareTimeSheetBalanceSheetInventoryCashFlowExpenseReportForecastSalesLoanAmortizationSchduleOpentoDemoUsers!RecordActualSalesContactListOpentoDemoUsers!RecordActualSpendingHelpCopyright©2004-2019Simpleplanning.comSoftwareLicenseAgreementSimpleplannings.comgrantsusageofthisfinancialplanningsoftwareunderthefollowingtermsandconditions:AfterthepurchasinganddownloadingofthissoftwarefromSimpleplanning.comorSimpleplanning.net,thepurchaserisgrantedalicensetousethisproduct.ThelicenseemaymakecopiesofthisproductinanamountthatdoesnotexceedthenumberoflicensesoriginallypurchasedfromSimpleplanning.comorSimpleplanning.net,orforthepurposeofcreatingabackupcopyorforuseonasecondarycomputer.Thisfileorthesoftwarecontainedinthisfileshallnotbetransferredtoanon-licenseewithoutthewrittenconsentfromSimpleplanning.com.LimitationofLiabilityABCCompanySimpleplanning.comwillnotbeheldliablefordamagesintheeventof,butnotlimitedtoinaccurateassumptions,calculationerrors,software,hardware,dataandnetworkfailureandprofit/savingslossesasaresultofusingthissoftware.PeriodPeriod#PriorPeriodPriorPeriod#PriorPeriodYearJanuary1December15PYFebruary2January1CYMarch3February2CY1Q44Q16PYApril5March3CYMay6April5CYJune7May6CY2Q81Q4CYJuly9June7CYAugust10July9CYSeptember11August10CY3Q122Q8CYOctober13September11CYNovember14October13CYDecember15November14CY4Q163Q12CYFullYear17FullYear17PYSalesAugustCY101111SeptemberPriorPeriodPriorYearPlan10TotalSales28,200276002340023400Product#11Product#12,900285025002,500Product#22Product#22,800275024002,400Product#33Product#32,700265023002,300Product#44Product#42,600255022002,200Product#55Product#52,500245021002,100Product#66Product#62,400235020002,000Product#77Product#72,300225019001,900Product#88Product#82,200215018001,800Other9Other7,8007,6006,2006,200TotalSales10TotalSales28,200276002340023,400CostSeptemberPriorPeriodPriorYearPlan8TotalCostofGoods2,450245024002400Salary1Salary510510500500Benefits2Benefits500500490490Travel3Travel490490480480Contractorcost4Contractorcost480480470470Other5Other470470460460CostCategory306CostCategory30000-Other7Other(0)(2,450)(2,400)(2,400)TotalCostofGoods8TotalCostofGoods2,450245024002,400ExpenseSeptemberPriorPeriodPriorYearPlan8TotalExpense7,140714065406540Salaryexpenses1Salaryexpenses650650600600PayrollTaxes2PayrollTaxes640640590590Advertising3Advertising630630580580Maintanence4Maintanence620620570570Accounting/Finance5Accounting/Finance610610560560Travel6Travel600600550550Other7Other3,3903,3903,0903,090TotalExpense8TotalExpense7,140714065406,540RankSales$RankCost1Product#12,9001Salary2Product#22,8002Benefits3Product#32,7003Travel4Product#42,6004Contractorcost5Product#52,5005Other6Product#62,40030CostCategory67Product#72,30029CostCategory78Product#82,20028CostCategory89Product#92,10027CostCategory910Product#102,00026CostCategory1011Product#111,90025CostCategory1112Product#121,80024CostCategory1230SalesCategory13023CostCategory1329SalesCategory14022CostCategory1428SalesCategory15021CostCategory1527SalesCategory16020CostCategory1626SalesCategory17019CostCategory1725SalesCategory18018CostCategory1824SalesCategory19017CostCategory1923SalesCategory20016CostCategory2022SalesCategory21015CostCategory2121SalesCategory22014CostCategory2220SalesCategory23013CostCategory2319SalesCategory24012CostCategory2418SalesCategory25011CostCategory2517SalesCategory26010CostCategory2616SalesCategory2709CostCategory2715SalesCategory2808CostCategory2814SalesCategory2907CostCategory2913SalesCategory3006CostCategory30TotalSales28,200TotalCostofGoodsRevenueCostExpenseProfitJan3120Feb5221Mar7322Apr9423May11524Jun13625Jul15726PriorPeriodYearSales28.2CostofGoods2.5Expense7.1Profit18.6ProfitJanFebMarAprMayJunJul14,46015,06015,66015,93516,53517,13517,410SeptemberPriorPeriodPriorYearPlan18,61018010144601446034578911JanFebMarAprMayJunJul23,40024,00024,60025,20025,80026,40027,00034578911JanFebMarAprMayJunJul2,4002,4002,4002,4252,4252,4252,45034578911JanFebMarAprMayJunJul6,5406,5406,5406,8406,8406,8407,140$RankExpense$5101Salaryexpenses6505002PayrollTaxes6404903Advertising6304804Maintanence6204705Accounting/Finance61006Travel60007Depreciation59008Rent/Lease58009DeliveryExpenses570010Utilities/Telephone560011Insurance550012PropertyTaxes540030Interest0029OfficeExpenses0028Amortization0027VehicleExpenses0026ContractorLabor0025BadDebts0024ExpenseCategory190023ExpenseCategory200022ExpenseCategory210021ExpenseCategory220020ExpenseCategory230019ExpenseCategory240018ExpenseCategory250017ExpenseCategory260016ExpenseCategory270015ExpenseCategory280014ExpenseCategory290013ExpenseCategory3002,450TotalExpense7,140AugSepOctNovDec18,01018,61018,88519,48520,0851213151617AugSepOctNovDec27,60028,20028,80029,40030,0001213151617AugSepOctNovDec2,4502,4502,4752,4752,4751213151617AugSepOctNovDec7,1407,1407,4407,4