Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

ListenMBA 580 Module Two Report Guidelines and RubricOverview You work as a middle manager for one of the top U.S. producers of luxury and mass-market automobiles and trucks. Your company has decided

ListenMBA 580 Module Two Report Guidelines and RubricOverview

You work as a middle manager for one of the top U.S. producers of luxury and mass-market automobiles and trucks. Your company 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 approaches and create data visualizations to help determine the approach with greater financial benefit. Carefully consider the financial data provided—one of the options is expected to deliver a greater and faster return on investment. This assignment will help you make a recommendation for your innovation approach in Milestone One.

Directions

Create a series of charts in an Excel spreadsheet and a memo that compares the financial benefits of two innovation approach options, Option A: discontinuous and Option B: incremental. The charts in your spreadsheet should include a comparison of financial forecasts from both innovation approaches. Your decision should be data-driven, emphasizing which approach aligns best with the company’s financial goals. Use your charts to support your recommendation. Be sure to add titles to all your charts so that you can reference them in your memo.

Create the charts using the data in the Sales Forecast and the Module Two Charts Excel Guide files linked in the Supporting Materials section.

Specifically, you must address the following rubric criteria:

  1. Create a chart for sales forecast data.
    1. Graph sales forecast data for total sales for options A, discontinuous, and B, incremental, on a three-dimensional stacked column chart.
      1. Each column should show traditional sales on the bottom and connected sales on the top.
      2. Both options should appear on the same three-dimensional chart, or you can make a separate chart for each option.
  2. 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.
      1. Each column should show traditional sales at the bottom and connected sales at the top.
      2. Both options may appear on the same three-dimensional chart, or you can make a separate chart for each option.
  3. 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.
      1. Both options should appear on the same chart.
  4. 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 with 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. References should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations.

Supporting MaterialsThe following resources support your work on this assignment:

Spreadsheet: Sales ForecastThis includes sales forecast data.

Document: Module Two Charts Excel GuideThis document includes directions for creating charts.

Module Two Report RubricCriteriaExemplary (100%)Proficient (90%)Needs Improvement (70%)Not Evident (0%)ValueVisualize Sales Forecast DataExceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative mannerCreates three-dimensional stacked column chart visualization(s) for sales forecast data for two innovation optionsShows progress toward proficiency, but with errors or omissions; areas for improvement may include creating a stacked column chart and not just a column chartDoes not attempt criterion15Visualize Gross Margin Forecast DataExceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative mannerCreates three-dimensional stacked column chart visualization(s) for gross margin forecast for two innovation optionsShows progress toward proficiency, but with errors or omissions; areas for improvement may include using data for both innovation options in the stacked column chart visualization(s)Does not attempt criterion15Visualize CalculationsExceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative mannerCreates a line chart for the specified calculationsShows progress toward proficiency, but with errors or omissions; areas for improvement may include correctly calculating gross margin less R&D and capital costs that were used in line chartDoes not attempt criterion15Conclusions from Data VisualizationsExceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative mannerExplains any conclusions you can draw from your data visualizations and identification of innovation option with the greatest financial benefitShows progress toward proficiency, but with errors or omissions; areas for improvement may include referencing visualizations in justifications of conclusionsDoes not attempt criterion40Clear CommunicationExceeds expectations with an intentional use of language that promotes a thorough understandingConsistently and effectively communicates in an organized way to a specific audienceShows progress toward meeting expectations, but communication is inconsistent or ineffective in a way that negatively impacts understandingShows no evidence of consistent, effective, or organized communication7.5Citations and AttributionsUses citations for ideas requiring attribution, with few or no minor errorsUses citations for ideas requiring attribution, with consistent minor errorsUses citations for ideas requiring attribution, with major errorsDoes not use citations for ideas requiring attribution7.5Total:100%ListenDictionaryTranslate

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Create a 9–10-slide PowerPoint presentation and conduct a 5–10-video recording of the delivery of the presentation, synthesizing information to make decisions that are focused on the development and j

Create a 9–10-slide PowerPoint presentation and conduct a 5–10-video recording of the delivery of the presentation, synthesizing information to make decisions that are focused on the development and justification of recommendations of evidence-based strategies on Allina Healthcare System . Collapse AllIntroduction This portfolio work project is the final piece of

Reply: The student must then post 1 reply to another student’s post. The reply must summarize thestudent’s findings and indicate areas of agreement, disagreement, and improvement. It must besupported

Reply: The student must then post 1 reply to another student’s post. The reply must summarize thestudent’s findings and indicate areas of agreement, disagreement, and improvement. It must besupported with scholarly citations in the latest APA format and corresponding list of references.The minimum word count for Integrating Faith and Learning

SPSS Questions Chapter 6 Using the ChapterSixData.sav file, do the following problems. Print your outputs after typing your interpretation on them. Please circle the key parts of the output that you d

SPSS Questions Chapter 6 Using the ChapterSixData.sav file, do the following problems. Print your outputs after typing your interpretation on them. Please circle the key parts of the output that you d SPSS QuestionsChapter 6Using the ChapterSixData.sav file, do the following problems. Print your outputs after typingyour interpretation on them.

QUANTITATIVE ANALYSIS: DESCRIPTIVE STATISTICS, ORDINAL SCALE AND DICHOTOMOUS VARIABLE ASSIGNMENT SPSS Problems Chapter 4 Using the CollegeStudentData.sav file (see Appendix A), do the following proble

QUANTITATIVE ANALYSIS: DESCRIPTIVE STATISTICS, ORDINAL SCALE AND DICHOTOMOUS VARIABLE ASSIGNMENT SPSS Problems Chapter 4 Using the CollegeStudentData.sav file (see Appendix A), do the following proble QUANTITATIVE ANALYSIS: DESCRIPTIVE STATISTICS, ORDINAL SCALE ANDDICHOTOMOUS VARIABLE ASSIGNMENTSPSS ProblemsChapter 4Using the CollegeStudentData.sav file (see Appendix A), do the following problems. Print youroutputs and circle

SPSS Questions Chapter 6 Using the ChapterSixData.sav file, do the following problems. Print your outputs after typing your interpretation on them. Please circle the key parts of the output that you d

SPSS QuestionsChapter 6Using the ChapterSixData.sav file, do the following problems. Print your outputs after typingyour interpretation on them. Please circle the key parts of the output that you discuss. Use theinformation in the appropriate “Output Interpretation” and “How to Write” sections.6.1 Compute Cohen’s kappa to assess reliability using Rater 1

Discussion Thread: Selecting and Interpreting Inferential Statistics Respond to the following short answer questions from Chapter 5 of the Morgan, Leech, Gloeckner, & Barrett textbook: D4.5.1 Comp

Discussion Thread: Selecting and Interpreting Inferential Statistics Respond to the following short answer questions from Chapter 5 of the Morgan, Leech, Gloeckner, & Barrett textbook: D4.5.1 Compare and contrast a between-groups design and a within-subjects design. D4.5.2. What information about variables, levels, and design should you keep in mind in

Module 2 – CaseHypothesis Testing: t-Tests & ANOVAsAssignment Overview Hypothesis Tests & ANOVA **Complete Module 2 SLP before Module 2 Case** One-Way ANOVA (Analysis of Variance) tests if the

Module 2 – CaseHypothesis Testing: t-Tests & ANOVAsAssignment Overview Hypothesis Tests & ANOVA **Complete Module 2 SLP before Module 2 Case** One-Way ANOVA (Analysis of Variance) tests if there are statistical differences between the means of three or more independent groups. Case 2 Resources Analysis of Variance (ANOVA)Single factor ANOVA

Module 2 – SLPHypothesis Testing: t-Tests & ANOVAsAssignment Overview Two Sample Hypothesis Tests **Complete Module 2 SLP before Module 2 Case** Comparing two samples provides insights. Are emplo

Module 2 – SLPHypothesis Testing: t-Tests & ANOVAsAssignment Overview Two Sample Hypothesis Tests **Complete Module 2 SLP before Module 2 Case**Comparing two samples provides insights. Are employees with an MBA more productive than those without? If our results support the contention, then hiring more MBAs would be good for business.

QUANTITATIVE ANALYSIS: DESCRIPTIVE STATISTICS, ORDINAL SCALE AND DICHOTOMOUS VARIABLE ASSIGNMENT SPSS Problems Chapter 4 Using the CollegeStudentData.sav file (see Appendix A), do the following proble

QUANTITATIVE ANALYSIS: DESCRIPTIVE STATISTICS, ORDINAL SCALE ANDDICHOTOMOUS VARIABLE ASSIGNMENTSPSS ProblemsChapter 4Using the CollegeStudentData.sav file (see Appendix A), do the following problems. Print youroutputs and circle the key parts of the output that you discuss.4.1.For the variables with five or more ordered levels, compute the skewness. Describe theresults. Which variables in

The student must then post 1 reply to another student’s post. The reply must summarize the student’s findings and indicate areas of agreement, disagreement, and improvement. It must be supported with

The student must then post 1 reply to another student’s post. The reply must summarize thestudent’s findings and indicate areas of agreement, disagreement, and improvement. It must besupported with scholarly citations in the latest APA format and corresponding list of references.The minimum word count for Integrating Faith and Learning discussion

DISCUSSION ASSIGNMENT INSTRUCTIONS The student will complete 8 short-answer discussions in this course and 1 long-answer Integrating Faith and Learning discussion. In the thread for each short-answer

DISCUSSION ASSIGNMENT INSTRUCTIONSThe student will complete 8 short-answer discussions in this course and 1 long-answerIntegrating Faith and Learning discussion. In the thread for each short-answer discussion thestudent will post short answers to the prompted questions. The answers must demonstratecourse-related knowledge and support their assertions with scholarly citations in the latest

BUSINESS ANALYSIS REPORT Introduction After completing the business simulation at a competent level (a score above 0.000 for the cumulative total performance at the end of Q6), you will create a writt

BUSINESS ANALYSIS REPORT Introduction After completing the business simulation at a competent level (a score above 0.000 for the cumulative total performance at the end of Q6), you will create a written report, using the attached “Business Analysis Template,” for stockholders and the board of directors to review. Analyze the

SPSS Problems Chapter 4 Using the CollegeStudentData.sav file (see Appendix A), do the following problems. Print your outputs and circle the key parts of the output that you discuss. 4.1.For the varia

SPSS ProblemsChapter 4Using the CollegeStudentData.sav file (see Appendix A), do the following problems. Print youroutputs and circle the key parts of the output that you discuss.4.1.For the variables with five or more ordered levels, compute the skewness. Describe theresults. Which variables in the dataset are approximately normally distributed/scale? Whichones are

Please follow the Instructions and NO plagiarism! All submissions should have a title page and reference page (not included in page count).Narrative component submitted in a Word document, which may i

Please follow the Instructions and NO plagiarism! All submissions should have a title page and reference page (not included in page count). Narrative component submitted in a Word document, which may include tables, graphs, and other resources as needed. Include an introductory and summary paragraph/statement. The page count should be

INVESTOR PRESENTATION: MBA ATTACHED ARE THE COMPLETED QUARTERS. DO NOT CREATE A VIDEO, JUST THE PPT SLIDES Introduction An important aspect of running a successful start-up business is acquiring fundi

INVESTOR PRESENTATION: MBA ATTACHED ARE THE COMPLETED QUARTERS. DO NOT CREATE A VIDEO, JUST THE PPT SLIDES Introduction An important aspect of running a successful start-up business is acquiring funding from potential investors based on information about the business. In this task, you will use the skills you have acquired

Write a 2–3-page paper recommending solutions to challenges and opportunities that are based on evidence-based strategies about Allina Health Collapse AllIntroduction In this assessment, you will app

Write a 2–3-page paper recommending solutions to challenges and opportunities that are based on evidence-based strategies about Allina Health  Collapse AllIntroduction In this assessment, you will apply innovative, strategic, and sustainable approaches using systems theory to consider forces and impact across the system. Now that you have conducted market data analysis, you

Create a 9–10-slide PowerPoint presentation and conduct a 5–10-video recording of the delivery of the presentation, synthesizing information to make decisions that are focused on the development and j

Create a 9–10-slide PowerPoint presentation and conduct a 5–10-video recording of the delivery of the presentation, synthesizing information to make decisions that are focused on the development and justification of recommendations of evidence-based strategies based on Allina Health Collapse AllIntroduction This portfolio work project is the final piece of your