2-2 Report-Financial Justification

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

580

Subject

Business

Date

Jul 1, 2024

Type

docx

Pages

2

Uploaded by BrigadierWaterNightingale42

Financial Justification 2-2 Report: Financial Justification Ameka S. Cheatham Innovation & Strategy for High-Performance Organizations MBA-580 Southern New Hampshire University April 22, 2024 1
Financial Justification To facilitate a comparative assessment of the financial benefits of Options A and B, we created a series of visualizations in an Excel spreadsheet: A 3D stacked column chart comparing the sales forecasts for the two options, with traditional and connected sales shown separately. This chart allowed us to evaluate and compare the projected sales performance over time. I also constructed a similar 3D stacked column chart to compare the gross margin forecasts, again separating traditional and connected sales. This helped us assess and compare the expected profitability of each option. Lastly, I calculated and graphed the total gross margin less R&D and capital costs for both options on a line chart. This enabled a direct comparison of the net profitability after accounting for additional expenses. Based on our thorough analysis of these charts and data visualizations, we concluded that Option A offers the most favorable financial benefits to the company. Option A demonstrated higher projected sales, gross margin, and net profitability compared to Option B, as well as more consistent and advantageous trends over the forecasted period. Therefore, we confidently recommend that the company pursue Option A to maximize the financial benefits. 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help