Innov/Strat High-Perform Org Week 2 Assignment 2

3/27/22, 2:48 PM Module Two Report Guidelines and Rubric - MBA-580-X4576 Innov/Strat High-Perform Orgs 22TW4

https://learn.snhu.edu/d2l/le/content/1022928/viewContent/17973064/View 1/3

Module Two Report Guidelines and Rubric

Overview

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).

O�en organiza�ons have to choose from mul�ple innova�ve implementa�on op�ons. 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 innova�on

op�ons and create data visualiza�ons to help determine the op�on with greater financial benefit. This assignment will help you

make a recommenda�on for one of the two op�ons in Milestone One.

Prompt

Create a series of charts in an Excel spreadsheet and a memo that compares the financial benefits of op�ons A and B. The charts in

your spreadsheet should include a comparison of financial forecasts from both innova�on op�ons (discon�nuous and incremental).

You should create the charts using the data in this Sales Forecast. Make sure to add �tles to all your charts so you can clearly

reference them in your memo. Consider the following points:

1. Create a chart for sales forecast data.

a. Graph sales forecast data for total sales for op�ons A and B on a three-dimensional stacked column chart.

Each column should show tradi�onal sales on the bo�om and connected sales on the top.

Both op�ons may appear on the same three-dimensional chart, or you can make a separate chart for each

op�on.

2. Create a chart for gross margin forecast data.

a. Graph gross margin forecast data for total sales for op�ons A and B on a three-dimensional stacked column chart.

Each column should show tradi�onal sales on the bo�om and connected sales on the top.

Both op�ons may appear on the same three-dimensional chart, or you can make a separate chart for each

op�on.

3. Create a chart for gross margin less R&D and capital costs calcula�ons.

a. Calculate gross margin less R&D and capital costs for op�ons A and B.

b. Graph total gross margin less R&D and capital costs forecasts to compare op�ons A and B on a line chart.

Both op�ons should appear on the same chart.

4. Explain any conclusions you can draw from your data visualiza�ons.

a. Review the charts and discuss any conclusions you can make from those data visualiza�ons.

b. Explain whether op�on A or op�on B will provide your company the most financial benefit. You should reference

your data visualiza�ons to jus�fy your explana�on and conclusions.

Guidelines for Submission

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

informa�on on cita�ons.

Module Two Report Assignment Rubric



MBA-580-X4576 Innov/Strat High-Perform Orgs 22… TM

3/27/22, 2:48 PM Module Two Report Guidelines and Rubric - MBA-580-X4576 Innov/Strat High-Perform Orgs 22TW4

https://learn.snhu.edu/d2l/le/content/1022928/viewContent/17973064/View 2/3

Criteria Exemplary (100%) Proficient (90%) Needs Improvement

(70%) Not Evident (0%) Value

Visualize Sales Forecast Data

Exceeds proficiency in an excep�onally clear, insigh�ul, sophis�cated, or crea�ve manner

Creates three- dimensional stacked column chart visualiza�on(s) for sales forecast data for two innova�on op�ons

Shows progress toward proficiency, but with errors or omissions; areas for improvement may include crea�ng a stacked column chart and not just a column chart

Does not a�empt criterion

15

Visualize Gross Margin Forecast

Data

Exceeds proficiency in an excep�onally clear, insigh�ul, sophis�cated, or crea�ve manner

Creates three- dimensional stacked column chart visualiza�on(s) for gross margin forecast for two innova�on op�ons

Shows progress toward proficiency, but with errors or omissions; areas for improvement may include using data for both innova�on op�ons in the stacked column chart visualiza�on(s)

Does not a�empt criterion

15

Visualize Calcula�ons

Exceeds proficiency in an excep�onally clear, insigh�ul, sophis�cated, or crea�ve manner

Creates a line chart for the specified calcula�ons

Shows progress toward proficiency, but with errors or omissions; areas for improvement may include correctly calcula�ng gross margin less R&D and capital costs that were used in line chart

Does not a�empt criterion

15

Conclusions from Data

Visualiza�ons

Exceeds proficiency in an excep�onally clear, insigh�ul, sophis�cated, or crea�ve manner

Explains any conclusions you can draw from your data visualiza�ons and iden�fica�on of innova�on op�on with the greatest financial benefit

Shows progress toward proficiency, but with errors or omissions; areas for improvement may include referencing visualiza�ons in jus�fica�ons of conclusions

Does not a�empt criterion

40

Ar�cula�on of Response

Exceeds proficiency in an excep�onally clear, insigh�ul, sophis�cated, or crea�ve manner

Clearly conveys meaning with correct grammar, sentence structure, and spelling, demonstra�ng an understanding of audience and purpose

Shows progress toward proficiency, but with errors in grammar, sentence structure, and spelling, nega�vely impac�ng readability

Submission has cri�cal errors in grammar, sentence structure, and spelling, preven�ng understanding of ideas

15

Total 100%

Module Two Report Assignment Rubric

3/27/22, 2:48 PM Module Two Report Guidelines and Rubric - MBA-580-X4576 Innov/Strat High-Perform Orgs 22TW4

https://learn.snhu.edu/d2l/le/content/1022928/viewContent/17973064/View 3/3

Reflect in ePortfolio Download Print

Open with docReader

Task: View this topic

Activity Details