Copy of Sales Forecast Week2 -2 of MBA 580

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

580

Subject

Business

Date

Feb 20, 2024

Type

xlsx

Pages

17

Uploaded by Tia2698

Report
Year 0 1 2 3 4 5 6 7 8 9 Your Company 187.1 192.9001 198.88 205.04528 211.40169 217.95514 224.71175 231.67781 238.85982 246.26448 BMW 126.1 130.7657 135.60403 140.62138 145.82437 151.21987 156.81501 162.61716 168.634 174.87346 Toyota 275.4 286.1406 297.30008 308.89479 320.94168 333.45841 346.46329 359.97536 374.01439 388.60096 VW 282.9 295.0647 307.75248 320.98584 334.78823 349.18412 364.19904 379.8596 396.19356 413.22989 1 2 3 4 5 6 7 8 9 10 11 0 50 100 150 200 250 300 350 400 450 500 Sales Growth of the Whole Market
1 2 3 4 5 6 7 8 9 10 11 12 0 50 100 150 200 250 300 350 Option A Traditional and Connected Sales Sales Forecast Data Numbers Shown in Billion Sales Traditional Sales Connected
10 253.89868 181.34377 403.75639 430.99877
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year 0 1 2 3 4 5 6 7 8 9 Your Company 3.8 4.1876 4.6147352 5.0854382 5.6041529 6.1757765 6.8057057 7.4998877 8.2648762 9.1078936 BMW 1.6 2.008 2.52004 3.1626502 3.969126 4.9812531 6.2514727 7.8455982 9.8462258 12.357013 Toyota 4.8 5.9904 7.4760192 9.330072 11.64393 14.531624 18.135467 22.633063 28.246063 35.251086 VW 8.4 10.3488 12.749722 15.707657 19.351833 23.841459 29.372677 36.187138 44.582554 54.925707 1 2 3 4 5 6 7 8 9 10 11 0 10 20 30 40 50 60 70 80 Sales Growth Connected Vehicle Market Chart Title Chart Title
1 2 3 4 5 6 7 8 9 10 11 0 2 4 6 8 10 12 Chart Title Chart Title 1 2 3 4 5 6 7 8 9 10 11 12 0 2 4 6 8 10 12 Your Company
10 10.036899 15.508052 43.993356 67.668471
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year 0 1 2 3 4 5 6 7 8 9 Sales Traditional 183.3 190.8153 198.63873 206.78292 215.26101 224.08672 233.27427 242.83852 252.7949 263.15949 Sales Connected 3.8 4.1876 4.6147352 5.768419 7.2105238 9.0131547 11.266443 14.083054 17.603818 22.004772 Total Sales 187.1 195.0029 203.25346 212.55133 222.47154 233.09987 244.54071 256.92157 270.39871 285.16426 Gross Margin Traditional 27.495 28.622295 29.795809 31.017437 32.289152 33.613007 34.991141 36.425778 37.919234 39.473923 Gross Margin Connected 0.798 0.879396 0.9690944 1.211368 1.51421 1.8927625 2.3659531 2.9574414 3.6968017 4.6210022 Total Gross Margin 28.293 29.501691 30.764903 32.228805 33.803362 35.50577 37.357094 39.383219 41.616036 44.094925 R&D Option A 4.1 4.133 1.16699 1.2019997 1.2380597 1.2752015 1.3134575 1.3528613 1.3934471 1.4352505 R&D option B 1.1 1.133 1.16699 1.2019997 1.2380597 1.2752015 1.3134575 1.3528613 1.3934471 1.4352505 Notes: Your company grows connected cars at 10.2%/year for 2 years, then grows connected cars at 25%/year. Your company grows traditional cars at industry growth rate of 4.1 %/year. Margin for connected cars: 21%. Margin for traditional cars: 15%. Numbers shown in billions. There are two additional R&D costs for this option in year 0 and year 1.
1 2 3 4 5 6 7 8 9 10 11 12 0 5 10 15 20 25 30 35 40 45 50 Option A Traditional and Connected Sales Gross Margin Forecast Data Numbers Shown in Billions Gross Margin Traditional Gross Margin Connected
10 273.94903 27.505965 301.45499 41.092354 5.7762527 46.868607 1.478308 1.478308
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year 0 1 2 3 4 5 Sales Traditional 183.3 190.8153 198.63873 206.78292 215.26101 224.08672 Sales Connected 3.8 4.1876 4.6147352 5.0854382 5.6041529 6.1757765 Total Sales 187.1 195.0029 203.25346 211.86835 220.86517 230.26249 Gross Margin Traditional 27.495 28.622295 29.795809 31.017437 32.289152 33.613007 Gross Margin Connected 0.798 0.879396 0.9690944 1.067942 1.1768721 1.2969131 Total Gross Margin 28.293 29.501691 30.764903 32.085379 33.466024 34.90992 R&D and Capital Costs 1.1 1.133 1.16699 1.2019997 1.2380597 1.2752015 Notes: Your company grows connected cars at 10.2%/year. Your company grows traditional cars at industry growth rate of 4.1 %/y Margin for connected cars: 21%. Margin for traditional cars: 15%. R&D and Capital Costs grow at a rate of 3%. 150 200 250 300 Option A Traditional Sales Forecast Data Numbers Shown in B
1 2 3 4 5 0 50 100 Sales Traditional 1 2 3 4 5 6 0 50 100 150 200 250 300 Option B Traditional a Sales Forecast Data Numbers Shown in Bill Sales Traditional 10 15 20 25 30 35 40 45 50 Option A Traditional and Conn Gross Margin Forecast Data Numbers Shown in Billions
1 2 3 4 5 6 0 5 10 15 20 25 30 35 40 45 50 Option B Traditional and Connecte Gross Margin Forecast Data Numbers Shown in Billions Gross Margin Traditional Gross M 1 2 3 4 5 6 7 8 0 5 10 Gross Margin Traditional Gross Margi 1 2 3 4 5 6 0 10 20 30 40 50 60 Gross Margin Les Capital Cost Innov Total Gross Margin Row 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Total Gross Margin Option A 28.293 29.501691 30.764903 32.228805 33.803362 35.50577 Total Gross Margin Option B 28.293 29.501691 30.764903 32.085379 33.466024 34.90992 1 2 3 4 5 6 0 5 10 15 20 25 30 35 40 45 50 Gross Margin Less R& Capital Cost Innovati Total Gross Margin Row 17 1 2 3 4 5 6 7 8 0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 Chart Title R&D Option A R&D
6 7 8 9 10 233.27427 242.83852 252.7949 263.15949 273.94903 6.8057057 7.4998877 8.2648762 9.1078936 10.036899 240.07998 250.3384 261.05977 272.26738 283.98592 34.991141 36.425778 37.919234 39.473923 41.092354 1.4291982 1.5749764 1.735624 1.9126577 2.1077487 36.420339 38.000754 39.654858 41.386581 43.200103 1.3134575 1.3528613 1.3934471 1.4352505 1.478308 year. l and Connected Sales Billions
6 7 8 9 10 11 l Sales Connected 6 7 8 9 10 11 and Connected Sales lion Sales Connected nected Sales
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
7 8 9 10 11 ed Sales Margin Connected 8 9 10 11 12 in Connected 7 8 9 10 11 ss R&D and vation A 17 R&D Option A
37.357094 39.383219 41.616036 44.094925 46.868607 36.420339 38.000754 39.654858 41.386581 43.200103 7 8 9 10 11 &D and tion Option B 7 R&D and Capital Costs 9 10 11 R&D Option A R&D option B option B

Related Documents

Assignment 2 - Updated version.docx
MBA-FPX5006_AdlerMichelle_Assessment1-1.docx
MBA-FPX5006_AdlerMichelle_Assessment2-2.docx
midterm winter 2024.pdf
BUS 302L.docx
IMG_0967.png
Assignment 5.docx
Assignment 1.docx
MAPA5385 Assignment 6.docx
MAPA5385 Assignment 5.docx
NP_WD19_EOM2-1_EmmaCasia_Report_1.docx
CMUS372_ Discussion 1.docx
Recommended textbooks for you
Text book image
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Text book image
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Text book image
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
Text book image
Introduction to Business
Business
ISBN:9781947172548
Author:OpenStax
Publisher:OpenStax College
Text book image
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Text book image
Bcom
Business
ISBN:9780357026595
Author:LEHMAN, Carol M.
Publisher:Cengage Learning,
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Text book image
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Text book image
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
Text book image
Introduction to Business
Business
ISBN:9781947172548
Author:OpenStax
Publisher:OpenStax College
Text book image
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Text book image
Bcom
Business
ISBN:9780357026595
Author:LEHMAN, Carol M.
Publisher:Cengage Learning,
SEE MORE TEXTBOOKS