Adms 2200-marketing Plan-budget (2)
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Adms 2200-marketing Plan-budget (2) as PDF for free.
More details
- Words: 1,355
- Pages: 8
Budget - FY 2010, 2011, 2012 All data in US funds North American Market Budgeted SP1 Units Sales FY 2010, 2011, 2012
Fiscal Year
Jan
Feb
2010 2011 2012
20 20.0 30.0
Mar
Apr
20.0 20.0 30.0
20.0 20.0 40.0
May 20.0 25.0 40.0
Jun 20.0 25.0 40.0
Jul 20.0 30.0 75.0
25.0 30.0 75.0
North American Budgeted Units Sales SP1 80 Units in Thousands
70 60 50 Row 11 Row 12 Row 13
40 30 20 10
ec D
ov N
ct O
Se p
g Au
Ju l
Ju n
ay M
r Ap
ar M
b Fe
Ja n
0
Monthly Units Sales
Budgeted Average price of SP1
$60,000
Budgeted Selling Price and margin analysis per vehicle -FY 2010 and 2011 Target direct materials/car $30,000 Target direct labour/car $11,000 Target Manufacturing Overhead $4,000 Total COGS/car $45,000 Gross Margin/car $15,000 Gross Margin/car % 25% Target Selling and Admin $3,000 Target Net Profit/Car % 20% Target Net Profit/Car 12000 Selling Price $60,000
Budgeted Average price of SP1
Budgeted Selling Price and ma Target direct materials/car Target direct labour/car Target Manufacturing Overhead Total COGS/car Gross Margin/car Gross Margin/car % Target Selling and Admin Target Net Profit/Car % Target Net Profit/Car Selling Price
P&L Analysis Budget - Twelve Months ending Dec 31, 2010 North American Market ( in thousands) Jan Sales -SP1 COGS Target Direct Materials Target Direct Labour Target Manufacturing overhead Total COGS Gross margin Gross margin % Selling and Admin Costs Warranty costs R&D Marketing Distribution costs Other selling and admin Total Selling and Admin Net Profit -SP1 Net Profit -SP1 %
Feb
Mar
Apr
May
Jun
Jul
$1,200
$1,200
$1,200
$1,200
$1,200
$1,200
$1,500
600 $220
600 $220
600 $220
600 $220
600 $220
600 $220
750 $275
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
$100 $1,125 $375 25%
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
2 20 20 12.5 21
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$75.0 300.0 20%
NOTES TO 2010 BUDGET Based on research during FY 2010 we expect: * warranty costs to run at 0.1% of 2010 sales * distribution costs to run at 0.5K per vehicle * Company will provide 240K for R&D costs to find new, more efficient technologies and ways of building solar vehicles * Company will aslo provide 240K to promote new SP1
P&L Analysis Budget - Twelve Months ending Dec 31, 2011 North American Market ( in thousands) Jan Sales -SP1 COGS
$1,200.0
Feb $1,200.0
Mar $1,200.0
Apr $1,500.0
May $1,500.0
Jun $1,800.0
Jul $1,800.0
Target Direct Materials Target Direct Labour Target Manufacturing overhead Total COGS Gross margin Gross margin % Selling and Admin Costs Warranty costs R&D Marketing Distribution costs Other selling and admin Total Selling and Admin Net Profit -SP1 Net Profit -SP1 %
$600.0 $220.0
$600.0 $220.0
$600.0 $220.0
$750.0 $275.0
$750.0 $275.0
$900.0 $330.0
$900.0 $330.0
$80.0 $900.0 $300 25%
$80.0 $900.0 $300 25%
$80.0 $900.0 $300 25%
$100.0 $1,125.0 $375 25%
$100.0 $1,125.0 $375 25%
$120.0 $1,350.0 $450 25%
$120.0 $1,350.0 $450 25%
3.0 20.0 20.0 10.0 7.0
3.0 20.0 20.0 10.0 7.0
3.0 20.0 20.0 10.0 7.0
3.3 20.0 20.0 12.5 19.2
3.3 20.0 20.0 12.5 19.2
3.6 20.0 20.0 15.0 31.4
4.1 20.0 20.0 15.0 31.0
$60.0 $240.0 20%
$60.0 $240.0 20%
$60.0 $240.0 20%
$75.0 $300.0 20%
$75.0 $300.0 20%
$90.0 $360.0 20%
$90.0 $360.0 20%
NOTES TO 2011 BUDGET Based on research during FY 2011 we expect: * warranty costs to run at 0.1% of 2011 sales and 0.15% of 2010 sales * distribution costs to run at 0.5K per vehicle * Company will provide 240K for R&D costs to find new, more efficient technologies and ways of building solar vehicles * Company will aslo provide 240K to promote new SP1
P&L Analysis Budget - Twelve Months ending Dec 31, 2012 North American Market ( in thousands) Jan Sales -SP1 COGS Target Direct Materials Target Direct Labour Target Manufacturing overhead Total COGS Gross margin Gross margin % Selling and Admin Costs Warranty costs R&D Marketing Distribution costs
Feb
Mar
Apr
May
Jun
Jul
$1,800.0
$1,800.0
$2,400.0
$2,400.0
$2,400.0
$4,500.0
$4,500.0
720 300
720 300
960 400
960 400
960 400
1800 750
1800 750
120 $1,140.0 $660.0 37%
120 $1,140.0 $660.0 37%
160 $1,520.0 $880.0 37%
160 $1,520.0 $880.0 37%
160 $1,520.0 $880.0 37%
300 $2,850.0 $1,650.0 37%
300 $2,850.0 $1,650.0 37%
$6.00 0 30 15
$6.00 0 30 15
$6.60 0 30 20
$7.05 0 30 20
$7.05 10 30 20
$9.60 40 30 37.5
$10.20 40 30 37.5
Other selling and admin Total Selling and Admin Net Profit -SP1 Net Profit -SP1 %
9
9
23.4
22.95
12.95
32.9
32.3
60 $600.0 33%
60 $600.0 33%
80 $800.0 33%
80 $800.0 33%
80 $800.0 33%
150 $1,500.0 33%
150 $1,500.0 33%
NOTES TO 2012 BUDGET In 2012 we expect to lower our COGS and increase Gross margin to 37% and net margin to 33%
Based on research during FY 2012 we expect: * warranty costs to run at 0.1% of 2012 sales plu 0.15% of 2011 sales plus 0.2% of 2010 sales * distribution costs to run at 0.5K per vehicle * Company will provide 180K for R&D costs to find new, more efficient technologies and ways of building solar vehicles * Company will also provide 360K to promote SP1 in order to double the units sales in comaprison to FY2011
Aug
Sep 25.0 30.0 70.0
Oct 20.0 25.0 50.0
SP1
Nov 20.0 25.0 50.0
Dec 20.0 25.0 50.0
Totals 20.0 25.0 50.0
Based on the research we expect higher sales during summer months
ec D
ov
Row 11 Row 12 Row 13
N
250.0 300.0 600.0
Budgeted Average price of SP1
$60,000
Budgeted Selling Price and margin analysis per vehicle -FY 2012 Target direct materials/car 24000 Target direct labour/car 10000 Target Manufacturing Overhead 4000 Total COGS/car 38000 Gross Margin/car $22,000 Gross Margin/car % 37% Target Selling and Admin 2000 Target Net Profit/Car % 33% Target Net Profit/Car 20000 Selling Price $60,000
Aug
Sep
Oct
Nov
Dec
FY 2010
$1,500
$1,200
$1,200
$1,200
$1,200
$15,000
750 $275
600 $220
600 $220
600 $220
600 $220
7500 2750
$100 $1,125 $375 25%
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
1000 $11,250 $3,750 25%
2 20 20 12.5 21
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
15 240 240 125 130
$75.0 300.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
750 3000.0 20%
ys of building solar vehicles
Aug $1,800.0
Sep $1,500.0
Oct $1,500.0
Nov $1,500.0
Dec $1,500.0
FY 2011 $18,000.0
$900.0 $330.0
$750.0 $275.0
$750.0 $275.0
$750.0 $275.0
$750.0 $275.0
$9,000.0 $3,300.0
$120.0 $1,350.0 $450 25%
$100.0 $1,125.0 $375 25%
$100.0 $1,125.0 $375 25%
$100.0 $1,125.0 $375 25%
$100.0 $1,125.0 $375 25%
$1,200.0 $13,500.0 $4,500 25%
4.1 20.0 20.0 15.0 31.0
3.3 20.0 20.0 12.5 19.2
3.3 20.0 20.0 12.5 19.2
3.3 20.0 20.0 12.5 19.2
3.3 20.0 20.0 12.5 19.2
40.5 240.0 240.0 150.0 229.5
$90.0 $360.0 20%
$75.0 $300.0 20%
$75.0 $300.0 20%
$75.0 $300.0 20%
$75.0 $300.0 20%
$900.0 $3,600.0 20%
ys of building solar vehicles
Aug
Sep
Oct
Nov
Dec
FY 2011
$4,200.0
$3,000.0
$3,000.0
$3,000.0
$3,000.0
$36,000.0
1680 700
1200 500
1200 500
1200 500
1200 500
$14,400.0 $6,000.0
280 $2,660.0 $1,540.0 37%
200 $1,900.0 $1,100.0 37%
200 $1,900.0 $1,100.0 37%
200 $1,900.0 $1,100.0 37%
200 $1,900.0 $1,100.0 37%
$2,400.0 $22,800.0 $13,200.0 37%
$9.90 30 30 35
$7.65 20 30 25
$7.65 20 30 25
$7.65 10 30 25
$7.65 10 30 25
$93.0 $180.0 $360.0 $300.0
35.1
17.35
17.35
27.35
27.35
$267.0
140 $1,400.0 33%
100 $1,000.0 33%
100 $1,000.0 33%
100 $1,000.0 33%
100 $1,000.0 33%
$1,200.0 $12,000.0 33%
ys of building solar vehicles aprison to FY2011
Fiscal Year
Jan
Feb
2010 2011 2012
20 20.0 30.0
Mar
Apr
20.0 20.0 30.0
20.0 20.0 40.0
May 20.0 25.0 40.0
Jun 20.0 25.0 40.0
Jul 20.0 30.0 75.0
25.0 30.0 75.0
North American Budgeted Units Sales SP1 80 Units in Thousands
70 60 50 Row 11 Row 12 Row 13
40 30 20 10
ec D
ov N
ct O
Se p
g Au
Ju l
Ju n
ay M
r Ap
ar M
b Fe
Ja n
0
Monthly Units Sales
Budgeted Average price of SP1
$60,000
Budgeted Selling Price and margin analysis per vehicle -FY 2010 and 2011 Target direct materials/car $30,000 Target direct labour/car $11,000 Target Manufacturing Overhead $4,000 Total COGS/car $45,000 Gross Margin/car $15,000 Gross Margin/car % 25% Target Selling and Admin $3,000 Target Net Profit/Car % 20% Target Net Profit/Car 12000 Selling Price $60,000
Budgeted Average price of SP1
Budgeted Selling Price and ma Target direct materials/car Target direct labour/car Target Manufacturing Overhead Total COGS/car Gross Margin/car Gross Margin/car % Target Selling and Admin Target Net Profit/Car % Target Net Profit/Car Selling Price
P&L Analysis Budget - Twelve Months ending Dec 31, 2010 North American Market ( in thousands) Jan Sales -SP1 COGS Target Direct Materials Target Direct Labour Target Manufacturing overhead Total COGS Gross margin Gross margin % Selling and Admin Costs Warranty costs R&D Marketing Distribution costs Other selling and admin Total Selling and Admin Net Profit -SP1 Net Profit -SP1 %
Feb
Mar
Apr
May
Jun
Jul
$1,200
$1,200
$1,200
$1,200
$1,200
$1,200
$1,500
600 $220
600 $220
600 $220
600 $220
600 $220
600 $220
750 $275
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
$100 $1,125 $375 25%
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
2 20 20 12.5 21
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$75.0 300.0 20%
NOTES TO 2010 BUDGET Based on research during FY 2010 we expect: * warranty costs to run at 0.1% of 2010 sales * distribution costs to run at 0.5K per vehicle * Company will provide 240K for R&D costs to find new, more efficient technologies and ways of building solar vehicles * Company will aslo provide 240K to promote new SP1
P&L Analysis Budget - Twelve Months ending Dec 31, 2011 North American Market ( in thousands) Jan Sales -SP1 COGS
$1,200.0
Feb $1,200.0
Mar $1,200.0
Apr $1,500.0
May $1,500.0
Jun $1,800.0
Jul $1,800.0
Target Direct Materials Target Direct Labour Target Manufacturing overhead Total COGS Gross margin Gross margin % Selling and Admin Costs Warranty costs R&D Marketing Distribution costs Other selling and admin Total Selling and Admin Net Profit -SP1 Net Profit -SP1 %
$600.0 $220.0
$600.0 $220.0
$600.0 $220.0
$750.0 $275.0
$750.0 $275.0
$900.0 $330.0
$900.0 $330.0
$80.0 $900.0 $300 25%
$80.0 $900.0 $300 25%
$80.0 $900.0 $300 25%
$100.0 $1,125.0 $375 25%
$100.0 $1,125.0 $375 25%
$120.0 $1,350.0 $450 25%
$120.0 $1,350.0 $450 25%
3.0 20.0 20.0 10.0 7.0
3.0 20.0 20.0 10.0 7.0
3.0 20.0 20.0 10.0 7.0
3.3 20.0 20.0 12.5 19.2
3.3 20.0 20.0 12.5 19.2
3.6 20.0 20.0 15.0 31.4
4.1 20.0 20.0 15.0 31.0
$60.0 $240.0 20%
$60.0 $240.0 20%
$60.0 $240.0 20%
$75.0 $300.0 20%
$75.0 $300.0 20%
$90.0 $360.0 20%
$90.0 $360.0 20%
NOTES TO 2011 BUDGET Based on research during FY 2011 we expect: * warranty costs to run at 0.1% of 2011 sales and 0.15% of 2010 sales * distribution costs to run at 0.5K per vehicle * Company will provide 240K for R&D costs to find new, more efficient technologies and ways of building solar vehicles * Company will aslo provide 240K to promote new SP1
P&L Analysis Budget - Twelve Months ending Dec 31, 2012 North American Market ( in thousands) Jan Sales -SP1 COGS Target Direct Materials Target Direct Labour Target Manufacturing overhead Total COGS Gross margin Gross margin % Selling and Admin Costs Warranty costs R&D Marketing Distribution costs
Feb
Mar
Apr
May
Jun
Jul
$1,800.0
$1,800.0
$2,400.0
$2,400.0
$2,400.0
$4,500.0
$4,500.0
720 300
720 300
960 400
960 400
960 400
1800 750
1800 750
120 $1,140.0 $660.0 37%
120 $1,140.0 $660.0 37%
160 $1,520.0 $880.0 37%
160 $1,520.0 $880.0 37%
160 $1,520.0 $880.0 37%
300 $2,850.0 $1,650.0 37%
300 $2,850.0 $1,650.0 37%
$6.00 0 30 15
$6.00 0 30 15
$6.60 0 30 20
$7.05 0 30 20
$7.05 10 30 20
$9.60 40 30 37.5
$10.20 40 30 37.5
Other selling and admin Total Selling and Admin Net Profit -SP1 Net Profit -SP1 %
9
9
23.4
22.95
12.95
32.9
32.3
60 $600.0 33%
60 $600.0 33%
80 $800.0 33%
80 $800.0 33%
80 $800.0 33%
150 $1,500.0 33%
150 $1,500.0 33%
NOTES TO 2012 BUDGET In 2012 we expect to lower our COGS and increase Gross margin to 37% and net margin to 33%
Based on research during FY 2012 we expect: * warranty costs to run at 0.1% of 2012 sales plu 0.15% of 2011 sales plus 0.2% of 2010 sales * distribution costs to run at 0.5K per vehicle * Company will provide 180K for R&D costs to find new, more efficient technologies and ways of building solar vehicles * Company will also provide 360K to promote SP1 in order to double the units sales in comaprison to FY2011
Aug
Sep 25.0 30.0 70.0
Oct 20.0 25.0 50.0
SP1
Nov 20.0 25.0 50.0
Dec 20.0 25.0 50.0
Totals 20.0 25.0 50.0
Based on the research we expect higher sales during summer months
ec D
ov
Row 11 Row 12 Row 13
N
250.0 300.0 600.0
Budgeted Average price of SP1
$60,000
Budgeted Selling Price and margin analysis per vehicle -FY 2012 Target direct materials/car 24000 Target direct labour/car 10000 Target Manufacturing Overhead 4000 Total COGS/car 38000 Gross Margin/car $22,000 Gross Margin/car % 37% Target Selling and Admin 2000 Target Net Profit/Car % 33% Target Net Profit/Car 20000 Selling Price $60,000
Aug
Sep
Oct
Nov
Dec
FY 2010
$1,500
$1,200
$1,200
$1,200
$1,200
$15,000
750 $275
600 $220
600 $220
600 $220
600 $220
7500 2750
$100 $1,125 $375 25%
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
$80 $900 $300 25%
1000 $11,250 $3,750 25%
2 20 20 12.5 21
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
1 20 20 10 9
15 240 240 125 130
$75.0 300.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
$60.0 240.0 20%
750 3000.0 20%
ys of building solar vehicles
Aug $1,800.0
Sep $1,500.0
Oct $1,500.0
Nov $1,500.0
Dec $1,500.0
FY 2011 $18,000.0
$900.0 $330.0
$750.0 $275.0
$750.0 $275.0
$750.0 $275.0
$750.0 $275.0
$9,000.0 $3,300.0
$120.0 $1,350.0 $450 25%
$100.0 $1,125.0 $375 25%
$100.0 $1,125.0 $375 25%
$100.0 $1,125.0 $375 25%
$100.0 $1,125.0 $375 25%
$1,200.0 $13,500.0 $4,500 25%
4.1 20.0 20.0 15.0 31.0
3.3 20.0 20.0 12.5 19.2
3.3 20.0 20.0 12.5 19.2
3.3 20.0 20.0 12.5 19.2
3.3 20.0 20.0 12.5 19.2
40.5 240.0 240.0 150.0 229.5
$90.0 $360.0 20%
$75.0 $300.0 20%
$75.0 $300.0 20%
$75.0 $300.0 20%
$75.0 $300.0 20%
$900.0 $3,600.0 20%
ys of building solar vehicles
Aug
Sep
Oct
Nov
Dec
FY 2011
$4,200.0
$3,000.0
$3,000.0
$3,000.0
$3,000.0
$36,000.0
1680 700
1200 500
1200 500
1200 500
1200 500
$14,400.0 $6,000.0
280 $2,660.0 $1,540.0 37%
200 $1,900.0 $1,100.0 37%
200 $1,900.0 $1,100.0 37%
200 $1,900.0 $1,100.0 37%
200 $1,900.0 $1,100.0 37%
$2,400.0 $22,800.0 $13,200.0 37%
$9.90 30 30 35
$7.65 20 30 25
$7.65 20 30 25
$7.65 10 30 25
$7.65 10 30 25
$93.0 $180.0 $360.0 $300.0
35.1
17.35
17.35
27.35
27.35
$267.0
140 $1,400.0 33%
100 $1,000.0 33%
100 $1,000.0 33%
100 $1,000.0 33%
100 $1,000.0 33%
$1,200.0 $12,000.0 33%
ys of building solar vehicles aprison to FY2011
Related Documents
Adms 2200-marketing Plan-budget (2)
April 2020 0
Seniorstudio 2(2)(2)
June 2020 80
Seniorstudio 2(2)(2)
June 2020 86
Seniorstudio 2(2)(2)
June 2020 77
2-2
November 2019 81