Project #92736 - Midterm Evaluation

 

 

 

Calculate  8 pts

 

 

Monthly Sales Metrics (This section I already completed)

 

1. Units/Order: Measures the average number of units per order for each month.
            Calculate as: Items/ Orders = average Units per Order

 

2. $/Order: Measures the average $ per order (same as $ per transaction in a brick n' mortar retailer).
            Calculate as: Revenue/ Orders = average $ per Order

 

3. Conversion Rate: Measure the proportion of visitors to the Ecommerce website placed orders.
            Calculate as: Orders/Monthly Visitors

 

Monthly Visitor Analysis

 

1. BUILD: Analyzes month to month increase or decrease trends as a ratio
            Calculate as: Month visitors divided by last month visitors = BUILD

 

2. TY% to LY: Analyzes % increase/decrease over the same month last year.
            Calculate as: (TY month visitors - LY month visitors)/ LY month visitors - TY% to LY

 


Monthly Sales Trends
1. BUILD: Analyzes month to month increase or decrease trends as a ratio
            Calculate as: Month revenue divided by last month revenue = BUILD

 

2. TY% to LY: Analyzes % increase/decrease over the same month last year.
            Calculate as: (TY revenue - LY revenue)/ LY revenue = % inc/dec

 

Insert Charts – 8 pts

 


Select an appropriate chart type (bar, column, pie, line etc) and layout to create a comparative chart reflecting the following data for 2012- 2013:
Chart-1: $ per order by month

 

Chart 2: Unit per order by month

 

Chart 3: Percent change in visits versus percent change in sales by month

 

Chart 4: Monthly Build for visits versus sales

 

(**NOTE: Comparative charts: Each chart will reflect information for 2012 and 2013 both)

 

Formatting

 

Format  8 PTS

 

  1. Each worksheet should have an appropriate name.

  2. Charts should be moved to individual worksheets

    1. Should be formatted with an appropriate name and axis information

  3. Provide appropriate heading for the table at the top

  4. Format Table according to formatting guidelines

    1. Save file with the appropriate file name.

    2. Rename worksheets as directed.

    3. Use two decimal places for all $ and % figures.

    4. Use embedded formulas ONLY to calculate missing values. No Manual calculations will be accepted.

    5. All answers should be accurate

    6. The table should be well formatted

      1. Tables should not bleed to the next page in print view.

      2. Consistent Font size and styles

      3. All dollar values should be formatted with appropriate sign

      4. All percentage values should be formatted with appropriate sign

      5. Use appropriate borders.

      6. All columns containing numbers should be center and middle aligned. Column labels should also be center/middle aligned.

      7. All columns containing words ONLY should be left and middle aligned.

      8. Highlight (using fill color) column labels, table labels to differentiate.

 

 

 

Questions: 6 pts

 

Review your work (excel = charts) and answer the following questions:

 

  1. Which 3 months have high website traffic? (1 pt)

  2. Which 3 months have high conversion? (1pt)

  3. Which months have high traffic but comparatively lower conversion rate? Why do you think that may be the case? (1 pt)

  4. Compare and discuss visitor analysis for 2012 and 2013. What are some of the trends that you can see in the table and in the chart? (1.5 pt)

  5. Analyze sales trends for 2012 and 2013 and discuss how these are different from visitor trends? What are some of the trends that you can see in the table and in the chart? (1.5 pt)

     

 

Subject Mathematics
Due By (Pacific Time) 11/10/2015 11:30 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy