User Account

All Pages

What is the overall revenue

Assignment Help Other Subject
Reference no: EM132286856

Scenario

You work as a report developer and analyst for Global Bike International (GBI). Your manager has supplied you with some data related to sales and has requested a number of reports. You task, with a partner, is to create the required reports to answer each of the questions below.

Question: 1. What is the overall Revenue?

Question: 2. What is the Revenue for E-Bike in 2017?

Question: 3. What is the Revenue for E-Bike in 2016?

Question: 4. What is the Sales Quantity of T-shirts to Airport Bikes in 2014?

Question: 5. What year had the highest Sales Quantity?

Question: 6. What year had the lowest Revenue?

Question: 7. In the year with the lowest Revenue, what Material had the lowest revenue?

Question: 8. Which material has the lowest revenue?

Question: 9. In the year that had the highest Net Sales, what division had the least Net Sales?

Question: 10. For the Division and Year in the previous Question, which customer had the least Net Sales?

Question: 11. In the year with the highest Revenue, what division had the highest sales revenue?

Question: 12. For the Division and Year in the previous Question, which Customer had the highest Net Sales?

Question: 13. What City provided the highest Revenue for Accessories in 2014?

Question: 14. In 2015, for Bicycles what is the total revenue for the top three customers?

Question: 15. What is the average customerRevenuein the Bikes Division in 2016?

Question: 16. What material has had the highest Quantity sold?

Question: 17. Explain the annual revenue trends for the USA and Germany? Develop an appropriate visualisation.

Question: 18. Did GBI ever gain or lose a customer? Explain

Question: 19. Which Material had the biggest drop in Revenue over a one year period? Develop an appropriate visualisation.

Question: 20. What Year and Material did the highest Revenue from a single customer occur in?

Question: 21. Is there any major change in revenue during the five years of data? What were the Materials that contributed to this change? Explain and develop an appropriate visualisation.

Question: 22. Is there seasonality in revenue during the year? If so, what month has the highest revenue? Is the seasonality similar from year to year? Why?

Question: 23. Are there any materials that show dramatic change in revenue?

Question: 24. What is the average % discount of the different deluxe touring bikes (red, silver, black)?

Question: 25. Which bike is the most profitable? Profit = Revenue-(cost of goods+discount) and what is the profit?

Question: 26. What percentage of total revenue was achieved from Chicago in 2014?

Attachment:- Reporting Assignment.rar

Verified Expert

In this assignment Microsoft Power Bi has been used.All the question has been made in the different report of one Microsoft Power Bi. in answers of each question has been given. The interpretation of the calculation has been given.The screen shot also had been attached but the student have to reattached with each screenshot showing student ID and the answer.

Reference no: EM132286856

Questions Cloud

Discuss the role of ebp in your specialty area of practice : Discuss the role of EBP in your specialty area of practice. Compare and contrast the role and implementation of EBP in your specialty with another advanced
Which strategies have been particularly effective and why : How has Amazon successfully leveraged e-commerce strategies to promote supply chain integration and boost sales and growth for the organization?
Opportunity cost of andrea four year university degree : Living expenses in either situation will cost $ 10000 per year. What is the opportunity cost of andrea's four year university degree?
The penalties imposed by the department of labor : What are some facts of the case and how did OSHA apply, and what were the penalties imposed by the Department of Labor?
What is the overall revenue : What is the average customerRevenuein the Bikes Division in 2016 - What material has had the highest Quantity sold - Did GBI ever gain or lose a customer
Draw the extensive form : a) Draw the extensive form (the tree diagram) of this game, carefully labeling each node and outcomes associated with each action.
Marketing plan for Xbox gaming console : When considering your own marketing plan for a Xbox gaming console, how would you summarize your market segmentation?
Hinder company initial success within the first year : What are two other variables that would either help or hinder a company's initial success within the first year? Why?
Why does mcdonald choose to create bundles : Why does McDonald choose to create bundles? How would they go about designing effective bundles?

Reviews

len2286856

4/18/2019 12:22:24 AM

You have been requested to use Microsoft PowerBIto analyse the data. Once you have created the required reports you will need to record the answer and insert a screen shot of the report with the answer highlighted, (in the area below). Each screen shot should include your student ID. Your manager has also asked you to interpret the data and provide an explanation for the results for certain questions. The footer must include the group member’s name and student ID. You need to create a save a separate report for each question. Name your file for assignment 1 in the form Student ID1 Student ID2.pdf. You must upload a copy ofnthe assignment to Blackboard.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd