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. Consult the Shapiro Library APA Style Guide for more information on citations.

Share This Post

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

Related Questions

Negotiation Flow Chart This flow chart assignment measures your mastery of ULOs 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 2.10, 2.11, 3.1, 3.2, 3.3, 4.1, 4.2, and 4.3. Requirem

Negotiation Flow Chart This flow chart assignment measures your mastery of ULOs 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 2.10, 2.11, 3.1, 3.2, 3.3, 4.1, 4.2, and 4.3. Requirement: Develop a flow chart for a selected negotiation that has either succeeded or failed (business, international,

This assignment measures your mastery of ULOs 3.4, 4.2, 5.3, and 5.6. For this journal assignment, choose a real or fictional company or other organization of interest to you. In our scenario, t

This assignment measures your mastery of ULOs 3.4, 4.2, 5.3, and 5.6. For this journal assignment, choose a real or fictional company or other organization of interest to you. In our scenario, the organization is conducting a search for a new chief executive officer (CEO). As a board member of

Explain the importance of teamwork in an organization. In your explanation, address the two types of self-directed work teams and the three generic team types and how an organization’s context of cult

Explain the importance of teamwork in an organization. In your explanation, address the two types of self-directed work teams and the three generic team types and how an organization’s context of culture, structure, and systems supports teamwork. Your response should be at least 250 words in length.

This journal entry measures your mastery of ULOs 2.14. Journal: Course Reflection In this course you have developed the communication and management skills essential for successfully resolving conf

This journal entry measures your mastery of ULOs 2.14. Journal: Course Reflection In this course you have developed the communication and management skills essential for successfully resolving conflict situations in labor and management practices. Part 1: Describe the three most important insights you gained from the course. Part 2: Share

Mind Map of The Colorado River – The Sharing of Water Crisis: Multiparty Negotiations This mind map assignment measures your mastery of ULOs 2.7, 2.8, and 2.9. What is a Mind Map? A mind map is

Mind Map of The Colorado River – The Sharing of Water Crisis: Multiparty Negotiations This mind map assignment measures your mastery of ULOs 2.7, 2.8, and 2.9. What is a Mind Map? A mind map is a visual technique used to organize information and processes. It begins with a central

This assignment measures your mastery of ULOs 1.2, 3.3, 4.1, 5.4, and 5.5. For this assignment, you will read an article and answer a series of questions concerning the ethics and moral responsibil

This assignment measures your mastery of ULOs 1.2, 3.3, 4.1, 5.4, and 5.5. For this assignment, you will read an article and answer a series of questions concerning the ethics and moral responsibilities involved with a controversial marketing strategy. Begin by researching the CSU Online Library to find an article

Mind Map of The Colorado River – The Sharing of Water Crisis: Multiparty Negotiations This mind map assignment measures your mastery of ULOs 2.7, 2.8, and 2.9. What is a Mind Map? A mind map is

In preparation, follow the guidelines established below: Find an article (that is less than five years old) that pertains to the important issues leaders or consultants will face when working with

In preparation, follow the guidelines established below: Find an article (that is less than five years old) that pertains to the important issues leaders or consultants will face when working with various types of teams, and discuss what methods are best to use for developing better teams for the future.

Create a PowerPoint presentation with speaker notes to educate others regarding the development of an operational budget and a capital budget. Be sure to address the following: Provide the process for

Create a PowerPoint presentation with speaker notes to educate others regarding the development of an operational budget and a capital budget. Be sure to address the following: Provide the process for developing an operational budget. Provide the process for developing a capital budget. Differentiate between the operational and capital budgets.

How are problems between teams recognized? What steps would you take to rectify any identified problems? Explain in detail.

Consider the application of Kantian universal principles in the context of the Apple/Foxconn scenario described in Chapter 6. How might cultural differences impact the interpretation and practice of R

Consider the application of Kantian universal principles in the context of the Apple/Foxconn scenario described in Chapter 6. How might cultural differences impact the interpretation and practice of Respect for Persons in a global business setting? Would you agree with the claim that Apple and Foxconn are operating both legally

How are problems between teams recognized? What steps would you take to rectify any identified problems? Explain in detail. In your responses to other students, indicate whether you agree or disagree

How are problems between teams recognized? What steps would you take to rectify any identified problems? Explain in detail. In your responses to other students, indicate whether you agree or disagree with their steps, and offer suggestions for improvement.

Consider the application of Kantian universal principles in the context of the Apple/Foxconn scenario described in Chapter 6. How might cultural differences impact the interpretation and practice of R

Assume that you are the negotiation leader for your three-member team. You have been assigned to complete negotiations with three other nations and build a solid coalition for a new high-tech, state-o

Assume that you are the negotiation leader for your three-member team. You have been assigned to complete negotiations with three other nations and build a solid coalition for a new high-tech, state-of-the-art logistical natural resource pipeline (supporting electronic vehicle battery manufacturing) that will be constructed through the coalition members‘ regions.

Due: After completion of Lesson 7 Credit Weight: 25% of your final grade Summary: Case study essay (1000–1200 words; word-processed and double-spaced) _________________________________________________

Due: After completion of Lesson 7 Credit Weight: 25% of your final grade Summary: Case study essay (1000–1200 words; word-processed and double-spaced) _________________________________________________________________________ Case Study: Reed Hastings — Netflix Adapted from Lussier, R. N., & Achua, C. F. (2016). Leadership: Theory, application, and skill development (6th ed.). Cengage Learning. In

Assignment 3 Due: After completion of Lesson 10 Credit Weight: 25% of your final grade Summary: Case study essay (1000–1200 words; word-processed and double-spaced) ___________________________________

Assignment 3 Due: After completion of Lesson 10 Credit Weight: 25% of your final grade Summary: Case study essay (1000–1200 words; word-processed and double-spaced) _________________________________________________________________________ Case Study: Mary Barra — CEO of General Motors Adapted from Lussier, R. N., & Achua, C. F. (2016). Leadership: Theory, application, and skill development

Due: After completion of Lesson 4 Credit Weight: 25% of your final grade Summary: Case study essay (1000–1200 words; word-processed and double-spaced) _________________________________________________

Due: After completion of Lesson 4 Credit Weight: 25% of your final grade Summary: Case study essay (1000–1200 words; word-processed and double-spaced) _________________________________________________________________________ Case Study: Foxconn Technology Group Adapted from Lussier, R. N., & Achua, C. F. (2016). Leadership: Theory, application, and skill development (6th ed.). Cengage Learning. Have you