Marketing Budgeting Parameters

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 2

MARKETING BUDGETING

PARAMETERS

Current price 40.00


Unit cost 25.00
Seasonal factor
Sales Parameters 35.00
3,000.00
Overhead 0.15
Sales expense
Advertisement budget 40,000.00

DECISIONS
Advertisement expenditure 10,000.00

OUTPUT
Profit

CALCULATIONS
Quarter Q1
Seasonal factor 0.90

Unit sold 3,591.55


Revenue 143,662.10
Cost of goods 89,788.81
Gross margin 53,873.29

Sales Expenses 8,000.00


Advertising 10,000.00
Overhead 21,549.32
Total fixed cost 39,549.32

Profit 14,323.97
Profit margin 0.10
Q1 Q2 Q3 Q4

0.90 1.10 0.80 1.20

8,000.00 8,000.00 9,000.00 9,000.00

Total
10,000.00 10,000.00 10,000.00 40,000.00

Q2 Q3 Q4 Total
1.10 0.80 1.20

4,389.68 3,192.49 4,788.74 15,962.46


175,587.02 127,699.65 191,549.47 638,498.24
109,741.88 79,812.28 119,718.42 399,061.40
65,845.13 47,887.37 71,831.05 239,436.84

8,000.00 9,000.00 9,000.00 34,000.00


10,000.00 10,000.00 10,000.00 40,000.00
26,338.05 19,154.95 28,732.42 95,774.74
44,338.05 38,154.95 47,732.42 169,774.74

21,507.08 9,732.42 24,098.63 69,662.10


0.12 0.08 0.13

You might also like