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.

The strength of the economy depends on the balance pf production and consumption of goods and consumption of goods and services

Marco works in the marketing department of a luxury fashion brand. he is making a presentation on the success of a recent marketing campaign that included a fashion show. which slide elements can he use to include photographs and footage of the fashion show in his presentation? marco can use the: table images audio option to include photographs and the: flowcharts images video option to include footage of the fashion show.

Zachary company produces commercial gardening equipment. since production is highly automated, the company allocates its overhead costs to product lines using activity-based costing. the costs and cost drivers associated with the four overhead activity cost pools follow: activities unit level batch level product level facility level cost $ 64,800 $ 27,730 $ 15,000 $ 154,000 cost driver 2,400 labor hrs. 47 setups percentage of use 11,000 units production of 780 sets of cutting shears, one of the company’s 20 products, took 240 labor hours and 7 setups and consumed 15 percent of the product-sustaining activities. required: (a) had the company used labor hours as a company wide allocation base, how much overhead would it have allocated to the cutting shears? (b) how much overhead is allocated to the cutting shears using activity-based costing? (c) compute the overhead cost per unit for cutting shears first using activity-based costing and then using direct labor hours for allocation if 780 units are produced. if direct product costs are $150 and the product is priced at 30 percent above cost for what price would the product sell under each allocation system? (d) assuming that activity-based costing provides a more accurate estimate of cost, indicate whether the cutting shears would be over- or underpriced if direct labor hours are used as an allocation base. explain how over-or undercosting can affect vaulker's profitability. (e) comment on the validity of using the allocated facility-level cost in the pricing decision. should other costs be considered in a cost- plus pricing decision? if so, which ones? what costs would you include if you were trying to decide whether to accept a special order?