The Marketing Costs Grid shown below refers to the Marketing Costs datafiles which are found as both Excel spreadsheets and Access database tables.

Whereas the data provided in the datafiles enable the reader to produce factor specific conclusions, as well as both graphic representations and programmatically generated forecasting models, the reader can further use this data to produce checklists and programming matrices based on one’s own evaluation of the factors. To this end the document matrix below, and/or the (‘MARKETINGCOSTS.xls’ in the ‘../xls’ folder), can be used by the reader. Alternatively, this grid (‘MARKETINGCOSTS.htm’ in the ‘../HTM’ folder) can be opened in Word, completed, and then copied and pasted into an Excel spreadsheet (preserving all the relevant cells) after completion. For further information on the fields within the Grid and on the manipulation of the data please refer to the definition file .

SECTORS

01

02

03

04

05

06

07

08

09

10

11

12

13

14

15

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

COST

TOTAL

for

COST

SALES COSTS:

1

SALES PERSONNEL VARIABLE & COMMISSION COSTS

2

SALES EXPENSES AND COSTS

3

SALES MATERIALS COSTS

4

TOTAL SALES COSTS

DISTRIBUTION + HANDLING COSTS:

5

DISTRIBUTION FIXED COSTS

6

DISTRIBUTION VARIABLE COSTS

7

WAREHOUSING FIXED COSTS

8

WAREHOUSING VARIABLE COSTS

9

PHYSICAL HANDLING FIXED COSTS

10

PHYSICAL HANDLING VARIABLE COSTS

11

PHYSICAL PROCESS FIXED COSTS

12

PHYSICAL PROCESS VARIABLE COSTS

13

TOTAL DISTRIBUTION & HANDLING COSTS

ADVERTISING COSTS:

14

MAILING & CORRESPONDENCE COSTS

15

MEDIA ADVERTISING COSTS

16

ADVERTISING MATERIALS & PRINT COSTS

17

POS & DISPLAY COSTS

18

EXHIBITION & EVENTS COSTS

19

TOTAL ADVERTISING COSTS

AFTER-SALES COSTS:

20

PRODUCT RETURNS & REJECTION COSTS

21

PRODUCT INSTALLATION & RE-INSTALLATION

22

PRODUCT BREAKDOWN & POST INSTALLATION

23

PRODUCT SYSTEMS & CONFIGURATION COSTS

24

PRODUCT SERVICE & MAINTENANCE COSTS

25

CUSTOMER PROBLEM SOLVING & COMPLAINTS

26

TOTAL AFTER-SALES COSTS

TOTAL MARKETING COSTS:

27

TOTAL MARKETING COSTS

TOTALS for SEGMENTS:

SECTOR TOTALS: