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

Period Period #Prior Period Prior Period #Prior Period Yea

January1December15PY

February2January1CY

March3February2CY

1Q44Q16PY

April5March3CY

May6April5CY

June7May6CY

2Q81Q4CY

July9June7CY

August10July9CY

September11August10CY

3Q122Q8CY

October13September11CY

November14October13CY

December15November14CY

4Q163Q12CY

Full Year17Full Year17PY

Sales

August CY

101111

September Prior Period Prior Year Plan

10Total Sales28,200276002340023400 Product #11Product #12,900285025002,500 Product #22Product #22,800275024002,400 Product #33Product #32,700265023002,300 Product #44Product #42,600255022002,200 Product #55Product #52,500245021002,100 Product #66Product #62,400235020002,000 Product #77Product #72,300225019001,900 Product #88Product #82,200215018001,800 Other9Other7,8007,6006,2006,200 Total Sales10Total Sales28,200276002340023,400

Cost

September Prior Period Prior Year Plan

8Total Cost of Goods2,450245024002400 Salary1Salary510510500500 Benefits2Benefits500500490490 Travel3Travel490490480480 Contractor co4Contractor cost480480470470 Other5Other470470460460 Cost Categor6Cost Category 30000-Other7Other(0)(2,450)(2,400)(2,400) Total Cost of Goods

8Total Cost of Goods2,450245024002,400

Expense

September Prior Period Prior Year Plan

8Total Expense7,140714065406540 Salary expen1Salary expenses 650650600600

Payroll Taxes2Payroll Taxes640640590590 Advertising3Advertising630630580580 Maintanence4Maintanence620620570570 Accounting/F5Accounting/Finance610610560560 Travel6Travel600600550550 Other7Other3,3903,3903,0903,090 Total Expense

8Total Expense7,140714065406,540 Rank Sales$Rank Cost

1Product #12,9001Salary

2Product #22,8002Benefits

3Product #32,7003Travel

4Product #42,6004Contractor cost

5Product #52,5005Other

6Product #62,40030Cost Category 6

7Product #72,30029Cost Category 7

8Product #82,20028Cost Category 8

9Product #92,10027Cost Category 9

10Product #102,00026Cost Category 1

11Product #111,90025Cost Category 1

12Product #121,80024Cost Category 1

30Sales Category 13023Cost Category 1

29Sales Category 14022Cost Category 1

28Sales Category 15021Cost Category 1

27Sales Category 16020Cost Category 1

26Sales Category 17019Cost Category 1

25Sales Category 18018Cost Category 1

24Sales Category 19017Cost Category 1

23Sales Category 20016Cost Category 2

22Sales Category 21015Cost Category 2

21Sales Category 22014Cost Category 2

20Sales Category 23013Cost Category 2

19Sales Category 24012Cost Category 2

18Sales Category 25011Cost Category 2

17Sales Category 26010Cost Category 2

16Sales Category 2709Cost Category 2

15Sales Category 2808Cost Category 2

14Sales Category 2907Cost Category 2

13Sales Category 3006Cost Category 3 Total Sales28,200Total Cost of Go

Revenue Cost Expense Profit

Jan3120 Feb5221 Mar7322 Apr9423 May11524 Jun13625 Jul15726

Prior Period Year

Sales28.2

Cost of Goods 2.5

Expense7.1

Profit18.6

Profit

Jan Feb Mar Apr May Jun Jul

14,46015,06015,66015,93516,53517,13517,410 September Prior Period Prior Year Plan

18,610180101446014460

34578911 Jan Feb Mar Apr May Jun Jul

23,40024,00024,60025,20025,80026,40027,000 34578911 Jan Feb Mar Apr May Jun Jul

2,4002,4002,4002,4252,4252,4252,450 34578911 Jan Feb Mar Apr May Jun Jul

6,5406,5406,5406,8406,8406,8407,140

$Rank Expense$

5101Salary expenses650

5002Payroll Taxes640

4903Advertising630

4804Maintanence620

4705Accounting/Fina610 06Travel600

07Depreciation590

08Rent/Lease580

09Delivery Expens570

010Utilities/Telepho560

011Insurance550

012Property Taxes540

030Interest0

029Office Expenses0

028Amortization0

027Vehicle Expense0

026Contractor Labo0

025Bad Debts0

024Expense Catego0

023Expense Catego0

022Expense Catego0

021Expense Catego0

020Expense Catego0

019Expense Catego0

018Expense Catego0

017Expense Catego0

016Expense Catego0

015Expense Catego0

014Expense Catego0

013Expense Catego0 2,450Total Expense7,140

Aug Sep Oct Nov Dec 18,01018,61018,88519,48520,085 1213151617 Aug Sep Oct Nov Dec 27,60028,20028,80029,40030,000

1213151617 Aug Sep Oct Nov Dec 2,4502,4502,4752,4752,475 1213151617 Aug Sep Oct Nov Dec 7,1407,1407,4407,4407,440