Business, 10.03.2020 07:19 lataviabaker4608
Case: Performance Lawn Equipment Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database.
1. Count the number of failures in the worksheet Mower Test. (Hint: Use the Countif function)
2. 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 named ‘Gross revenues’ 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.
3. Finally, in the Industry Mower Total Sales and Industry Tractor Total Sales worksheets, add a column, at the end that displays the region that has the highest sales for each month (for each row). You are free to use any combination of excel functions we have come across.
4. List any inferences you can make from the data given in the Dealer Satisfaction and User Satisfaction worksheets.
Answers: 2
Business, 21.06.2019 19:00
Sara is a manager at a restaurant with employees from different cultural backgrounds. which action of sara could employees perceive as an act of favoritism?
Answers: 1
Business, 21.06.2019 21:20
20. sinclair company's single product has a selling price of $25 per unit. last year the company reported a profit of $20,000 and variable expenses totaling $180,000. the product has a 40% contribution margin ratio. because of competition, sinclair company will be forced in the current year to reduce its selling price by $2 per unit. how many units must be sold in the current year to earn the same profit as was earned last year? a. 15,000 units b. 12,000 units c. 16,500 units d. 12,960 units
Answers: 1
Business, 22.06.2019 00:40
Gdonald was unhappy that his company did not provide good transport facilities. he found it very strenuous to drive to work on his own, and this eventually led to job dissatisfaction. hence, he recommended ways to solve this problem. according to the evln model, this information suggests that donald's main reaction to job dissatisfaction was:
Answers: 3
Business, 22.06.2019 18:00
If you would like to ask a question you will have to spend some points
Answers: 1
Case: Performance Lawn Equipment Elizabeth Burke has asked you to do some preliminary analysis of th...
Chemistry, 06.11.2019 22:31
Mathematics, 06.11.2019 22:31
Chemistry, 06.11.2019 22:31
Computers and Technology, 06.11.2019 22:31
Physics, 06.11.2019 22:31
Mathematics, 06.11.2019 22:31