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

  Caregivers to long-term caregiving

What is a typical response of caregivers to long-term caregiving?

  Define three ways technology influences student independence

Describes three examples of how digital and assistive technologies can be used to support diverse learners. Discusses three ways technology influences student independence.

  What new equipment and software are necessary

Outline a change management strategy: What new equipment and software are necessary? What training and support will the staff need?

  Performance maturity level

E-link; a software company started its operation 10 years ago. Theybasically doing business in web based software systems. Over theperiod of time company has developed a very sophisticated system ofquality control.

  Discuss the pros and cons of mandatory sentences

Discuss the pros and cons of mandatory sentences. Do mandatory sentences remove discretion from the sentencing judge and vest discretion in the prosecutor, who may elect to charge a defendant with a lesser offense to avoid imposition of a mandator..

  Modernization theory claims

Modernization theory claims that

  Which of those strategies do you think is most effective

Which of those strategies do you think is most effective? Can you picture any of them having potential drawbacks

  An explanation of the desired outcome or goal

An explanation of the desired outcome or goal

  Description of the cultures-including the religion-language

A description of the cultures, including the religion, language, and general philosophies and beliefs. A description of the relationship between the cultures and the arts. At least one image each of early Chinese art and early Japanese art that demon..

  Who gains and who loses from a tariff

Who gains and who loses from a tariff. How do the effects of tariffs differ from the effects of quotas. If you were a small country, what would you rather utilize.

  Determine why change is so difficult for organizations

Determine why change is so difficult for organizations. Propose ways that human resource (HR) specialists can assist in making change easier.

  Doctrine of employment at-will

Stating what the ex-employee must demonstrate to prevail and give at least three examples of the public policy exception that have been recognized by some of the states.

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