Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Expected 2012 Percentage average sales difference in 2012 per customer 2012 actual average per industry average sales sales per 2012 comparable, per customer to customer

image text in transcribed
Expected 2012 Percentage average sales difference in 2012 per customer 2012 actual average per industry average sales sales per 2012 comparable, per customer to customer average adjusted for expected above Tick mark Tick mark Store sales per company average sales scope? Yes location Notes customer specific events per customer or No 18 hour 9.52 $ 9.42 1.14% No 18 hour 10.15 $ 9.45 A 7.38% #NAME? E 18 hour 9.50 $ 9.50 -0.09% #NAME? UAWNH 18 hour 9.50 $ 9.32 1.86% #NAME? 24 hour 3.62 $ 9.38 -8.10% #NAME? E 24 hour 9.59 $ 9.73 -1.50% #NAME? 24 hour 9.94 $ 9.56 4.02% #NAME? 24 hour 9.41 $ 9.12 3.17% #NAME? 9 24 hour 9.43 $ 9.62 -2.05% #NAME? 10 24 hour 8.75 $ 9.36 -6.54% #NAME? E 11 24 hour 9.21 $ 9.33 -1.36% #NAME? 12 24 hour 9.96 $ 9.35 6.62% #NAME? E 13 24 hour 9.94 $ 9.55 4.07% #NAME? 14 24 hour 9.51 $ 9.65 -1.45% #NAME? 15 24 hour 10.05 $ 9.45 B 6.32% #NAME? E 16 24 hour 9.50 $ 9.63 1.34% #NAME? 17 24 hour 9.48 $ 9.83 -3.57% #NAME? 18 24 hour 9.60 $ 9.67 0.68% #NAME? 19 24 hour 9.69 $ 9.50 D 1.90% #NAME? 20 24 hour 9.39 $ 9.50 D -1.23% #NAME? Total 9.54 $ 9.50 0.50% #NAME? Tick marks Results If the results indicated an item is above scope in terms of the percentage difference, from expectations , a "Yes" is indicated for further follow -up. Overall results are carried to the summary tab. A Calculated using the 2012 expected sales divided by the expected customer count B Calculated using only months that store was open (excluding months closed for fire) C Calculation D Calculated using average of 24 hour stores and adjusted for months open during the year E We should investigate further into the issue

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Local Disaster Resilience Administrative And Political Perspectives

Authors: Ellen Russell, Ashley D Ross

1st Edition

1135910618, 9781135910617

More Books

Students also viewed these Economics questions

Question

=+E5-16 Bank reconciliation Objs 4, 5

Answered: 1 week ago

Question

Describe the contributions of Keller and Marion Breland.

Answered: 1 week ago