You are now a business analyst for Global Bike Inc. (GBI). You have been assigned to assist the strategic planning team with profitability analysis and forecasting. Your IT team has pulled transactional data from 2016 through 2020 for you to analyze. All dollar amounts have been converted to USD. The data are stored in an Excel file called Global Bike Sales.xlsx. Although you are free to do your own analysis, at the very least, you need to answer the questions in the following section so that you can report back to the team.

Question 1: What was the overall Revenue and Net Sales for all years? Which year had the highest Revenue and Net Sales and what was the Net Sales during that year? Why do you believe the Revenue and Net Sales values are different?

Answer rating: 100% (QA)

To answer Question 1 you would need to perform the following steps 1 Open the Excel file Global Bike ... View the full answer