2 questions need to complete using excel formulas and finish with a pivot table. Please create a Pivot table on another tab to show total sales quantity, total sales extended cost and total sales

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

2 questions from raw data given..need to complete using excel formulas and finish with a pivot table

 

 

1)  Please calculate all areas highlighted in yellow and keep your formula in the answer

a) Dollars sold by month

b) Total units and dollars sold by month

c) Total units and dollars sold for the season

d) End of season sales by line as a percent to the total

e) Total units on hand at the end of the season

SALES BY MONTH EOS

FEB MAR APR MAY JUN JUN SALES OH

LINE RRP U OH U $ U $ U $ U $ U $ U $ U $ % to TTL U

PARFUM $150.00 43 4 2 10 7 4 8

PLAY RTW $85.00 643 75 35 87 80 66 83

PLAY CONVERSE $150.00 1254 57 34 64 57 43 86

WALLET $138.00 134 2 5 3 2 5 2

TOTAL 2074

2) Using the above sales table, please calculate the below areas highlgihted in yellow and keep your formula in the answer

a) average units sold per month by Line

b) months cover by Line

LINE AVG U SLD / MON MONTHS COVER

PARFUM

PLAY RTW

PLAY CONVERSE

WALLET

3) Based on the below assumptions and your months cover, would you suggest that this store purchases ATS for any line? If so, which line(s)?

Assumptions:

The above sales are for 1 store

The next seasonal ordering period for all Lines is October

ANSWER:

 

Please answer the questions below by using the "DATA" tab

Q A

1) Provide figures for the below:

a. Gross Total Sales (EXT OP$) for SS14, please keep your formula in the answer

b. Total Quantity Sold for AW14, please keep your formula in the answer

c. Total Received Quantity for Mens throughout seasons by using "SUMIF" function, please keep your formula in the answer

d. What is the sell-through for SS14 and AW14 seasons

2) How did the brand's performance change between SS14 and AW14? Give quantitative examples to support.

3) What category of clothing was the most popular throughout seasons?

4) Please create a Pivot table on another tab to show total sales quantity, total sales extended cost and total sales extended retail (EXT OP$) by Department (D Name) and Category (C Name).

 

 

Attachments:

Expert's Answer

1254 Times Downloaded

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of