2-2 charts

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

580

Subject

Economics

Date

Feb 20, 2024

Type

xlsx

Pages

9

Uploaded by DeaconRose12996

Report
0 1 2 3 4 5 6 7 8 9 10 0 50 100 150 200 250 300 350 Sales Forecast Data Option A Sales Traditional Sales Connected Years Sales Forcast in Billions
0 1 2 3 4 5 6 7 8 9 1 0 5 10 15 20 25 30 35 40 45 50 Gross Margin Forcast Sales Option A Gross Margin Traditional Gross Margin Connected Years Gross Margin in Billions
10
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
0 1 2 3 4 5 6 7 8 9 10 0 50 100 150 200 250 300 Sales Forcast Option B Sales Traditional Sales Connected Years Sales forcast in Billions
0 1 2 3 4 5 6 7 8 9 1 0 5 10 15 20 25 30 35 40 45 Gross Margins Forcast Sales Option B Gross Margin Traditional Gross Margin Connected Years Gross Margins in Billions
10
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 Sales Traditional 183.3 190.8153 198.6387 206.7829 215.261 Sales Connected 3.8 4.1876 4.614735 5.768419 7.210524 Total Sales 187.1 195.0029 203.2535 212.5513 222.4715 Gross Margin Traditional 27.495 28.6223 29.79581 31.01744 32.28915 Gross Margin Connected 0.798 0.879396 0.969094 1.211368 1.51421 Total Gross Margin 28.293 29.50169 30.7649 32.22881 33.80336 R&D and Capital Costs 4.1 4.133 1.16699 1.202 1.23806 Option A: Total GM less R&D and Capital Costs 24.193 25.36869 29.59791 31.02681 32.5653 Sales Traditional 183.3 190.8153 198.6387 206.7829 215.261 Sales Connected 3.8 4.1876 4.614735 5.085438 5.604153 Total Sales 187.1 195.0029 203.2535 211.8684 220.8652 Gross Margin Traditional 27.495 28.6223 29.79581 31.01744 32.28915 Gross Margin Connected 0.798 0.879396 0.969094 1.067942 1.176872 Total Gross Margin 28.293 29.50169 30.7649 32.08538 33.46602 R&D and Capital Costs 1.1 1.133 1.16699 1.202 1.23806 Option B: Total GM less R&D and Capital Costs 27.193 28.36869 29.59791 30.88338 32.22796
5 6 7 8 9 10 224.0867 233.2743 242.8385 252.7949 263.1595 273.949 9.013155 11.26644 14.08305 17.60382 22.00477 27.50597 233.0999 244.5407 256.9216 270.3987 285.1643 301.455 33.61301 34.99114 36.42578 37.91923 39.47392 41.09235 1.892762 2.365953 2.957441 3.696802 4.621002 5.776253 35.50577 37.35709 39.38322 41.61604 44.09493 46.86861 1.275201 1.313458 1.352861 1.393447 1.435251 1.478308 34.23057 36.04364 38.03036 40.22259 42.65967 45.3903 224.0867 233.2743 242.8385 252.7949 263.1595 273.949 6.175776 6.805706 7.499888 8.264876 9.107894 10.0369 230.2625 240.08 250.3384 261.0598 272.2674 283.9859 33.61301 34.99114 36.42578 37.91923 39.47392 41.09235 1.296913 1.429198 1.574976 1.735624 1.912658 2.107749 34.90992 36.42034 38.00075 39.65486 41.38658 43.2001 1.275201 1.313458 1.352861 1.393447 1.435251 1.478308 33.63472 35.10688 36.64789 38.26141 39.95133 41.72179 0 1 2 0 5 10 15 20 25 30 35 40 45 50 Option A & B Option A: Total GM less R Total GM less R&D and Capital Costs in Billions
3 4 5 6 7 8 9 10 B: Total GM less R&D and Capital Costs R&D and Capital Costs Option B: Total GM less R&D and Capital Costs Years
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

Related Documents

14.png
Week6Live Summary.docx
Elexus Brooks- Bonus Assignment 1.docx
PS 4-24 labor--games.docx
IMG_8568.png
Three economic reasons to form a family are.docx
ECO204-Week_3_Discussion_1.docx
Econ 203 Mock Exam.pdf
Data Visualization Week 5 Notes.docx
MAT 240 Module Five Assignment.docx
ch02 C.Lites.xlsx
Econ. Lecture 2 .docx
Recommended textbooks for you
Text book image
Microeconomic Theory
Economics
ISBN:9781337517942
Author:NICHOLSON
Publisher:Cengage
Text book image
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Text book image
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Text book image
Micro Economics For Today
Economics
ISBN:9781337613064
Author:Tucker, Irvin B.
Publisher:Cengage,
Text book image
Survey Of Economics
Economics
ISBN:9781337111522
Author:Tucker, Irvin B.
Publisher:Cengage,
Text book image
Microeconomics A Contemporary Intro
Economics
ISBN:9781285635101
Author:MCEACHERN
Publisher:Cengage
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Microeconomic Theory
Economics
ISBN:9781337517942
Author:NICHOLSON
Publisher:Cengage
Text book image
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Text book image
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Text book image
Micro Economics For Today
Economics
ISBN:9781337613064
Author:Tucker, Irvin B.
Publisher:Cengage,
Text book image
Survey Of Economics
Economics
ISBN:9781337111522
Author:Tucker, Irvin B.
Publisher:Cengage,
Text book image
Microeconomics A Contemporary Intro
Economics
ISBN:9781285635101
Author:MCEACHERN
Publisher:Cengage
SEE MORE TEXTBOOKS