Compute gross revenue according to given data

Reference no: EM131438504

Question: Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database. First, she would like you to edit the worksheets Dealer Satisfaction and End-User Satisfaction to display the total number of responses to each level of the survey scale across all regions for each year. Second, she wants a count of the number of failures in the worksheet Mower Test. Next, Elizabeth has provided you with prices for PLE products for the past 5 years:

Year Mower Price ($) Tractor Price ($)

2010	150	3,250
2011	175	3,400
2012	180	3,600
2013	185	3,700
2014	190	3,800

Create a new worksheet in the database to compute gross revenues by month and region, as well as worldwide totals, for each product using the data in Mower Unit Sales and Tractor Unit Sales. Finally, she wants to know the market share for each product and region based on the PLE and industry sales data in the database. Create and save these calculations in a new worksheet. Summarize all your findings in a report to Ms. Burke.

Reference no: EM131438504

Questions Cloud

Significant issues or transactions : Wirte a paragraph to analyse on financial position (balance sheet) of Starbucks company (300 words) and a paragraph on some recent significant issues or transactions have arisen in respect of Starbuck since the date of the last set of financial s..

Newly elected federal-level senator : You work for a newly elected federal-level senator who asked you to prepare a briefing on why socialized medicine has not been the government healthcare system in the United States. Key points that need to be in your briefing follow: the U.S. Constit..

Social security benefits by increasing the payroll tax : Imagine that congress decided to fund an increase in Social Security benefits by increasing the payroll tax on employers. Would this prevent employees from being affected by the higher tax? Why or why not?

Describe the effect of each transaction on assets : Describe the effect of each transaction on assets, liabilities, and stockholders' equity. For example, the first answer is (1) Increase in assets and increase in stockholders' equity.

Compute gross revenue according to given data : Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database. First, she would like you to edit the worksheets Dealer Satisfaction and End-User Satisfaction to display the total number of res..

Marketing branding and positioning from the text : After reading the advantages and disadvantages of marketing branding and positioning from the text, consider the notion that a truly effective brand is one that succinctly captures the product offering in a way that answers a question in the cust..

Behavioral tracking : Behavioral Tracking. A questionable area to consider when evaluating social media ethics is the role of behavioral targeting. Imagine advertisers tracking where you shop and browse from “click-through” behaviors and time spent on various websites.

Hr in small business : What selection methods did Bob Dolan use for hiring salespeople? Did he go about using these methods in the best order? What, if anything, would you change about the order of the methods used? What were the advantages to Kinaxis of using personali..

The information you would share with your leadership team : HR was often seen as a non-revenue-generating part of the business, or simply overhead. That misconception has changed dramatically due to technology. While HR is still not revenue generating, it adds a great deal of value to the business. Describe t..

User Account

All Pages