Reference no: EM133379010

Question 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? (If necessary, do a Google search to answer this question.)

Question What was the Sales and Revenue for E-Bikes in all years? Which years had no sales or revenue?

Question Which customer sold the most E-Bikes in 2020 and what was the Total Sales Quantity by all customers for that year?

Question What year had the highest Sales Quantity?

Question What year had the highest Net Sales and what year had the lowest Net Sales? Is this consistent with the question 4 response for the year with the highest Sales Quantity. What would be one possible explanation for an inconsistency?

Question In the year with the lowest Net Sales, which Material Desc had the lowest Net Sales? Which Material Desc had the highest Net Sales?

Question Which material had the lowest Net Sales overall?

Question In the year that had the highest Net Sales, what division and customer had the highest Net Sales?

Question In the year with the lowest Net Sales, what division and customer had the highest Net Sales?

Question What customer provided the highest Net Sales for Accessories (AS Division) in all years?

Question In 2019, for Bicycles (BI Division), what is the total Net Sales for the top three customers?

Question What is the average Net Sales per customer?

Question What was the average Net Sales per customer each year?

Question What was the average Net Sales per customer per year per division?

Question Can you determine from this table whether GBI gained or lost a customer based on Net Sales? Explain your answer.

Question What was the average Net Sales per customer for each of the years? Which year has the highest average Net Sales per customer? How much was that amount?

Question Briefly describe any differences in the historical (year by year) Net Sales trends for the US and Germany (DE).

Question Is there seasonality in Net Sales? If so, what month has the highest Net Sales? Is the seasonality similar in both Germany and US?

Question Do any products show a significant change in Net Sales over time? Provide one example and are the changes the same for both Germany and US?

Question Do any of the AS Division materials not display significant seasonality? Explain your answer.

Question What customer has the highest percentage contribution to Total Sales? What has been the trend of that customer's percentage contribution over the years?

Question What year had the highest overall gross margin? What was the gross margin during that year?

Question What was the gross margin (as a percentage of sales) for Germany for the year with the highest gross margin? Comment on the trend.

Question What was the gross margin (as a percentage of sales) for US during the same year?

Question 25: Develop a 2021 forecast trendline chart (with formula and R2 value) for Tailwind E-Bikes annual sales quantity. Which trendline option would you select to forecast 2021 E-Bike sales? Comment on any concerns with using this forecast approach for 2021 planning.

Question 26: Develop a 2021 forecast chart for Tailwind E-Bikes monthly sales quantity using an Excel Forecast Sheet and a 95% confidence level. Comment on the differences between the monthly forecast and the annual trendline forecasts.

Question 27: Which method (Annual Trendline or Monthly Forecast Sheet) and what 2021 forecast quantity would you recommend to the team? What is your rationale?

Question 28: Is there another timeseries forecasting approach other than Annual Trendline or Monthly Forecast Sheet you would consider for Tailwind E-Bike? What is your rationale?