Our Services

Get 15% Discount on your First Order

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

May 25, 2024

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

Business & Finance

Share This Post

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

Related Questions

You have been asked to evaluate Company A and Company B and make your recommendation for acquiring one or both companies. Based on your initial assessment,

You have been asked to evaluate Company A and Company B and make your recommendation for acquiring one or both companies. Based on your initial assessment, you have created balanced scorecards for both companies. You are now ready to analyze the information you have gathered so far about the two

ENG 190 Module One Assignment Guidelines and RubricOverview As you begin to consider the project due in Module Seven, you will begin the first phase of

ENG 190 Module One Assignment Guidelines and RubricOverview As you begin to consider the project due in Module Seven, you will begin the first phase of research for the project. This includes selecting an article, identifying potential topics, drafting a research question, and discussing the purpose of your research. The

1-1 Discussion: Using Research (50 Points)Research is an important part of academics, but it is also used in your daily life. You use research to find a

1-1 Discussion: Using Research (50 Points)Research is an important part of academics, but it is also used in your daily life. You use research to find a restaurant, look up reviews for products you want to purchase, write essays for your courses, or try to convince someone of something you

Case 2 MGT599 Strategic Management Module 2 Strategic Advantage: Analytics and Economics Economic Implications of Organizational Strategies Case 2

Case 2 MGT599 Strategic Management Module 2 Strategic Advantage: Analytics and Economics Economic Implications of Organizational Strategies Case 2 Resources The Relationship between an Organization and its Environment (2022)Evaluating the General Environment (2022)Resource-Based View (2022) Leadership: Business Economics Insights (2022)Managing Operations: Sustainable and inclusive growth: A weekly briefing (2022) Data Analytics: Artificial intelligence and data analytics can unlock new economic

Exam Content This assignment is intended to help you use leadership skills to gather project members from cross-functional departments and skill sets and

Exam Content This assignment is intended to help you use leadership skills to gather project members from cross-functional departments and skill sets and lead them in the fulfillment and implementation of a mock project. Discover the various responsibilities of a project manager by organizing a project. See Chapter 19, sections

This assignment is intended to help you use leadership skills to gather project members from cross-functional departments and skill sets and lead them in

This assignment is intended to help you use leadership skills to gather project members from cross-functional departments and skill sets and lead them in the fulfillment and implementation of a mock project. Discover the various responsibilities of a project manager by organizing a project. See Chapter 19, sections 19.9 and

Prepare a research paper on the topic – Why is Entrepreneurship Important? Submission Instructions: The paper is to be clear and concise and students

Prepare a research paper on the topic – Why is Entrepreneurship Important? Submission Instructions: The paper is to be clear and concise and students will lose points for improper grammar, punctuation, and misspelling. The paper is to a minimum of 1000 words in length, current APA style, excluding title and

It is important to understand what information systems are and why they are essential for running and managing a business. The case studies below will

It is important to understand what information systems are and why they are essential for running and managing a business. The case studies below will provide you with an opportunity to review many of the concepts covered in this course. These case studies provide you with an opportunity to critically

Use Excel File that I provide and the formula sheet in the book to make the calculations. Be sure to use cell references. (50 pts) Write one sentence (in

Use Excel File that I provide and the formula sheet in the book to make the calculations. Be sure to use cell references. (50 pts) Write one sentence (in the Excel File) next to each ratio you calculated in Question 1 describing what that number means in words. (50 pts) For example,

The case studies below provide you with an opportunity to critically analyze events that are taking place in real-life businesses. This helps to develop

The case studies below provide you with an opportunity to critically analyze events that are taking place in real-life businesses. This helps to develop your critical thinking and research skills as you research each of these scenarios. For this assignment, you will review four case studies from your eTextbook, one

o measure the financial performance of any company, it is important to analyze its four key financial statements: balance sheets, income statements, cash

o measure the financial performance of any company, it is important to analyze its four key financial statements: balance sheets, income statements, cash flow statements, and shareholders’ equity statements. In this assignment, you will: Visually present the balance sheet to depict what each company owns and what it owes over

SLP1 MGT599 Strategic Management Assignment Overview Advocating Business Ethics It’s time to analyze what constitutes proactive and continually evolving

SLP1 MGT599 Strategic Management Assignment Overview Advocating Business Ethics It’s time to analyze what constitutes proactive and continually evolving ethical/sustainable behavior for organizations from a multidisciplinary perspective. The resources below address ethics in the news from MBA disciplines. We can now expand that to the concept of sustainability. Use quality

Case 1 MGT599 Strategic Management Tends in Ethics, Sustainability, and Leadership Career Growth: Management and Leadership Reimagined Case 1

Case 1 MGT599 Strategic Management Tends in Ethics, Sustainability, and Leadership Career Growth: Management and Leadership Reimagined Case 1 Resources Creating Organizational Control Systems (2022)Vision, Mission, and Goals (2022)The Basic Building Blocks of Organizational Structure (2022)Understanding the Strategic Management Process (2022)Data Analysis: 4 Ways HR Analytics Help Small Businesses Make Data-Driven Decisions (2022) Economics: Employability, the Labor Force,

n your role as controller of a division of TransGlobal Airlines, you are responsible for assessing the possible acquisition of the two identified small

n your role as controller of a division of TransGlobal Airlines, you are responsible for assessing the possible acquisition of the two identified small airlines in the Caribbean specializing in chartered flights for luxury vacations using light aircraft (60 passengers or less). One of the important steps in this acquisition

Summative Assessment: Recruiting and Retention Decisions As a leader in business and industry, you will find yourself contributing to human resource

Summative Assessment: Recruiting and Retention Decisions As a leader in business and industry, you will find yourself contributing to human resource decisions in your organization. Recruitment, retention, and employee diversity are often intertwined. In this case, you have been asked by your employer to assess the current state of recruitment

HEADING Examination of key financial metrics of the company: EPS, dividends, ROA, ROE, and market environment. Making smart investment decisions within the

HEADING Examination of key financial metrics of the company: EPS, dividends, ROA, ROE, and market environment. Making smart investment decisions within the business and financial world requires an analysis of a company’s financial information. Take, for example, a company that sustains $1.34 of dividend payments, $3.82 of EPS, 17% ROA,

ou are a former Navy officer and fighter pilot who is now the controller of a division of TransGlobal Airlines, which utilizes a fleet of corporate jets

ou are a former Navy officer and fighter pilot who is now the controller of a division of TransGlobal Airlines, which utilizes a fleet of corporate jets for charter at several airports in the southeast part of the United States. Your division’s private charter clients include several Fortune 500 companies

Background: As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at

Background: As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at least 80% of the accounts receivable balance outstanding at December 31, 2016, has been resolved (e.g., collected, written off or returned). As of May 31, 2017,