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.

Which of the following statements regarding the learning curve and economies of scale is accurate? answers: just as diseconomies of scale are presumed to exist if a firm gets too large, there is a corresponding increase in costs in the learning-curve model as the cumulative volume of production grows.where diseconomies of scale are presumed to exist if a firm gets too large, there is no corresponding increase in costs in the learning-curve model as the cumulative volume of production grows.where diseconomies of scale are presumed to exist if a firm gets too small, there is no corresponding increase in costs in the learning-curve model as the cumulative volume of production grows.just as diseconomies of scale are presumed to exist if a firm gets too small, there is a corresponding increase in costs in the learning-curve model as the cumulative volume of production grows.

The assumptions of the production order quantity model are met in a situation where annual demand is 3650 units, setup cost is $50, holding cost is $12 per unit per year, the daily demand rate is 10 and the daily production rate is 100. the production order quantity for this problem is approximately:

David burdick is the ceo of acme bubblegum, a successful public company. as one of the cofounders of the company, burdick has enjoyed speaking and writing about the success of acme bubblegum for several years. typically, he speaks at conferences or directly to the press, but recently, he has been blogging about his firm anonymously. specifically, he defended a recent advertising campaign that was unpopular among consumers and pointedly attacked one of acme bubblegum’s competitors. burdick deeply enjoys his anonymous blogging and believes that none of his readers actually know that he works for acme bubblegum.should burdick be allowed to praise his company’s performance anonymously online? should he be allowed to attack his competitors without disclosing his relationship with the company? how would you feel if the ceo of a company at which you shopped was secretly writing criticisms of his or her competition? how would you feel if you knew a writer for your favorite blog was actually closely involved in a company that the blog discussed? 1. define the ethical issue? 2. who are the primary stakeholders? 3. what are the possible alternatives? 4. how could you evaluate the ethical implications of the alternative actions (use appropriate decision rules)? 5. what action would you recommend and why?