You work as a middle manager for one of the top U.S. producers of luxury and mass-market automobiles and trucks. The company from the course scenario has decided to incorporate internet of things (IoT

You work as a middle manager for one of the top U.S. producers of luxury and mass-market automobiles and trucks. The company from the course scenario has decided to incorporate internet of things (IoT) technology in its vehicles (also called connected cars). Often organizations have to choose from multiple innovative implementation options. The choice is usually determined by many factors including the financial viability of each idea. In this assignment, you will compare the financial benefits for two innovation options and create data visualizations to help determine the option with greater financial benefit. This assignment will help you make a recommendation for one of the two options in Milestone One.

Prompt

Create a series of charts in an Excel spreadsheet and a memo that compares the financial benefits of options A and B. The charts in your spreadsheet should include a comparison of financial forecasts from both innovation options (discontinuous and incremental). You should create the charts using the data in this Sales Forecast. Make sure to add titles to all your charts so you can clearly reference them in your memo. Consider the following points:

Create a chart for sales forecast data.
1. Graph sales forecast data for total sales for options A and B on a three-dimensional stacked column chart.
  - Each column should show traditional sales on the bottom and connected sales on the top.
  - Both options may appear on the same three-dimensional chart, or you can make a separate chart for each option.
Create a chart for gross margin forecast data.
1. Graph gross margin forecast data for total sales for options A and B on a three-dimensional stacked column chart.
  - Each column should show traditional sales on the bottom and connected sales on the top.
  - Both options may appear on the same three-dimensional chart, or you can make a separate chart for each option.
Create a chart for gross margin less R&D and capital costs calculations.
1. Calculate gross margin less R&D and capital costs for options A and B.
2. Graph total gross margin less R&D and capital costs forecasts to compare options A and B on a line chart.
  - Both options should appear on the same chart.
Explain any conclusions you can draw from your data visualizations.
1. Review the charts and discuss any conclusions you can make from those data visualizations.
2. Explain whether option A or option B will provide your company the most financial benefit. You should reference your data visualizations to justify your explanation and conclusions.

What to Submit

Submit an Excel document with all your charts.
Submit a ½- to 1-page Word document with 12-point Times New Roman font, double spacing, and one-inch margins. If you include references, they should be cited according to APA style

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Good evening , i need assistance with an assingment . please review below. Business administrators must evaluate how organizations operate within their historical development, industry context, and gl

Good evening , i need assistance with an assingment . please review below. Business administrators must evaluate how organizations operate within their historical development, industry context, and global environment. Effective administration requires analyzing organizational needs across areas such as leadership, operations, and change management. In today’s business landscape, effective administration

Good evening , need assistance with a competency assignment- Must free free of Ai detection and work Business administrators must evaluate how organizations operate within their historical developmen

Good evening , need assistance with a competency assignment- Must free free of Ai detection and work Business administrators must evaluate how organizations operate within their historical development, industry context, and global environment. Effective administration requires analyzing organizational needs across areas such as leadership, operations, and change management. In today’s

Use the Assignment on this website: https://bookshelf.vitalsource.com/home/dashboard?context=login The instructions for this assignment are also found in Chapter 16 of your required textbook. AssiUs

Use the Assignment on this website: https://bookshelf.vitalsource.com/home/dashboard?context=login The instructions for this assignment are also found in Chapter 16 of your required textbook. AssiUsegnment 2 Financial Analysis Project Phase II Completion requirements Assignment 2 Overview Now that you’ve set your workbook up and have completed the SurgiFlex calculations in Phase I,

PROJECT 1 IS IN THE ATTACHMENT Competency In this second part of the four-part project series, you will demonstrate your mastery of the following competency: Analyze quantitative and qualitati

***PROJECT 1 IS IN THE ATTACHMENT*** Competency In this second part of the four-part project series, you will demonstrate your mastery of the following competency: Analyze quantitative and qualitative data to solve problems and make decisions that impact organizations and their stakeholders

Good evening, I need assistance completing this assignment (MUST BE FREE OF AI DETECTION ). Competency 1 Assessment Instructions You’re a business consultant, and your new task is to teach a group o

Good evening, I need assistance completing this assignment (MUST BE FREE OF AI DETECTION ). Competency 1 Assessment Instructions You’re a business consultant, and your new task is to teach a group of interns how economic events impact economic activity and economic concentration. You’ve decided to present the information in

Good evening, I need assistance with completing this assignment. (must be free of AI detection) Competency 1 Assessment Instructions Southwest Airlines is facing tough competition and needs to update

Good evening, I need assistance with completing this assignment. (must be free of AI detection) Competency 1 Assessment Instructions Southwest Airlines is facing tough competition and needs to update how it handles HR—things like hiring, training, and keeping workers happy—to stay on top. They’ve decided to hire you as an

Touchstone 4: Organization Analysis & Strategic Recommendations SCENARIO: Select an organization you are familiar with or have worked for (currently or in the past). You are tasked with analyzin

Touchstone 4: Organization Analysis & Strategic Recommendations SCENARIO: Select an organization you are familiar with or have worked for (currently or in the past). You are tasked with analyzing the organization both internally and externally using some of the tools and frameworks you have learned in this course. You are also

Touchstone 2: Did Jim and Laura Buy a Car? SCENARIO: Jim and Laura Buyer visit the local car dealership because they are interested in buying a new car. The car they currently have is aging and is

Touchstone 2: Did Jim and Laura Buy a Car? SCENARIO: Jim and Laura Buyer visit the local car dealership because they are interested in buying a new car. The car they currently have is aging and is starting to have mechanical problems. Jim and Laura would share the new car, and

Week 8 – Assignment: Improve (Use the I in the A-S-I Framework) Instructions Assignment Directions: Focusing on the Improve pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict the

Week 8 – Assignment: Improve (Use the I in the A-S-I Framework) Instructions Assignment Directions: Focusing on the Improve pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict the operational efficiencies to be gained by your improvements. These may include customer satisfaction, transport / delivery time, energy usage, and carbon

Looking for someone to do my assignment below free of AI and plagiarism. Assignment Directions: Part #2 of 4: Focusing on the Avoid/Reduce pillar of the Avoid-Shift-Improve (A-S-I) Framework, descri

Looking for someone to do my assignment below free of AI and plagiarism. Assignment Directions: Part #2 of 4: Focusing on the Avoid/Reduce pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict the need to improve the efficiency of the transport system as a whole. This is a big picture

Provide background information on your company (A. O. Smith Corporation; NYSE: AOS). Create a value proposition for the company and discuss the key value proposition components as they relate to your

Provide background information on your company (A. O. Smith Corporation; NYSE: AOS). Create a value proposition for the company and discuss the key value proposition components as they relate to your company. Explain how the company creates value and for whom. Explain the company’s value capture strategy. Discuss Porter’s Five

Looking for someone to do my assignment below that is AI and plagiarism free: Assignment Directions: Part #1 of 4: Using course readings and resources including the United States Pocket Guide to Trans

Looking for someone to do my assignment below that is AI and plagiarism free: Assignment Directions: Part #1 of 4: Using course readings and resources including the United States Pocket Guide to Transportation [webpage], Transportation Statistics Annual Report [webpage] (TSAR), and Transportation Geography of the United Sates [webpage], identify a major transportation need and

Looking for someone to do my assignment below that is AI and Plagerism free Near the end of our text, in Ch. 14, there will be content on how we can learn from risk management leaders. These are wel

Looking for someone to do my assignment below that is AI and Plagerism free Near the end of our text, in Ch. 14, there will be content on how we can learn from risk management leaders. These are well thought of profitable companies. Please look at one of these companies and

InstructionsAssignment Directions: Focusing on the Shift/Maintain pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict approaches to improve transportation efficiency. This is a lo

InstructionsAssignment Directions: Focusing on the Shift/Maintain pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict approaches to improve transportation efficiency. This is a logical view. Use data and depictions as appropriate. Submit a paper in Microsoft Word format with your recommendations for the transportation system. Include a title page, 3-5

This paper is to be a summary of what you have learned in my class, whether it is from reading a newspaper, from my lectures, and/or from the textbook (three things that do not rot your brain or waste

This paper is to be a summary of what you have learned in my class, whether it is from reading a newspaper, from my lectures, and/or from the textbook (three things that do not rot your brain or waste your time, which is the opposite of social media). I expect

Looking for someone to do my assignment below that’s free of plagiarism and AI Chapter 2 provided information on the “as is” environment of SCRM during the past decade. Provide a report, incorporati

Looking for someone to do my assignment below that’s free of plagiarism and AI Chapter 2 provided information on the “as is” environment of SCRM during the past decade. Provide a report, incorporating up to three themes that are shared in the development of SCRM as a discipline in the

Week 4 – Assignment: Avoid/Reduce (Use the A in the A-S-I Framework) Instructions Assignment Directions: Part #2 of 4: Focusing on the Avoid/Reduce pillar of the Avoid-Shift-Improve (A-S-I) Framework,

Week 4 – Assignment: Avoid/Reduce (Use the A in the A-S-I Framework) Instructions Assignment Directions: Part #2 of 4: Focusing on the Avoid/Reduce pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict the need to improve the efficiency of the transport system as a whole. This is a big picture

NURS 8143 Healthcare Financing in Adv Nursing CHOOSE 1 OF THE FOLLOWING SCENARIOS AND CREATE A BUDGET. This assignment should be submitted as a word document with a reference page and IS WORTH 100 POI

NURS 8143 Healthcare Financing in Adv Nursing CHOOSE 1 OF THE FOLLOWING SCENARIOS AND CREATE A BUDGET. This assignment should be submitted as