need excel project done please and thank you Net Sales Front Range Action Sports Annual Net Sales Quarter

need excel project done please and thank you

Net Sales

Front Range Action Sports
Annual Net Sales
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Percent of Total Sales Trend
Colorado $ 48,123,789 $ 42,468,256 $ 45,159,681 $ 49,452,695 $ 185,204,421
New Mexico 25,783,516 21,985,365 19,987,269 22,252,487 90,011,637
Oregon 35,658,498 34,689,526 37,986,369 39,456,899 147,791,292
California 58,123,789 64,468,256 65,159,681 68,452,695 237,802,929
Washington 42,143,258 46,598,456 44,874,332 50,546,222 187,802,929
Total Sales $ 209,832,850 $ 210,309,859 $ 211,786,868 $ 213,233,878 $ 874,231,959

Quarterly Net Sales by State

Quarter 1 Colorado New Mexico Oregon California Washington 48123789 25783516 35658498 58123789 42143258 Quarter 2 Colorado New Mexico Oregon California Washington 42468256 21985365 34689526 64468256 46598456 Quarter 3 Colorado New Mexico Oregon California Washington 45159681 19987269 37986369 65159681 44874332 Quarter 4 Colorado New Mexico Oregon California Washington 49452695 22252487 39456899 68452695 50546222

Net Sales by State

Annual Net Sales by State

New Mexico Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Percent of Total Sales Trend 25783516 21985365 19987269 22252487 90011637 Oregon Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Percent of Total Sales Trend 35658498 34689526 37986369 39456899 147791292 California Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Percent of Total Sales Trend 58123789 64468256 65159681 68452695 237802929 Washington Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Percent of Total Sales Trend 42143258 46598456 44874332 50546222 187802929 Total Sales Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Percent of Total Sales Trend 209832850 210309859 211786868 213233878 874231959

Seattle Inventory

Seattle Facility: Inventory Status of Apparel
As of December 31
Total Items in Stock 271
Average Price
Median Price
Lowest Price
Highest Price
Ski Products
Ski Quantity in Stock
Quantity in Stock Item # Item Name Retail Price Category Sport Stock Level
32 115689 Deluxe Biking Shorts 69.52 Pants Biking
78 114568 Vented Explorer 34.78 Hats Hiking
28 456897 Wicked Heavy Socks 9.35 Socks and Gloves Skiing
58 465899 Gripper Gloves 25.55 Socks and Gloves Skiing
57 465888 Airflow Hat 2.99 Hats Hiking
18 165332 Mini Crew Socks 6.45 Socks and Gloves Fitness

Denver Inventory

Denver Facility: Inventory Status of Apparel
As of December 31
Total Items in Stock 265
Average Price $ 9.68
Median Price $ 6.45
Lowest Price $ 2.99
Highest Price $ 18.98
Number of Biking Products 1
Biking Quantity in Stock 58
Quantity in Stock Item # Item Name Retail Price Category Sport Stock Level
58 965888 Cotton Visor 2.99 Hats Biking OK
35 658752 Bandana 4.99 Hats Hiking Order
18 765332 Mini Crew Socks 6.45 Socks and Gloves Fitness Order
58 729567 Striped Crew Socks 14.99 Socks and Gloves Fitness OK
96 796689 Sun Runner Cap 18.98 Hats Fitness OK

&F

Inventory Summary

Apparel Inventory Summary
As of December 31
Seattle Denver
Total Items in Stock
Average Price
Median Price
Lowest Price
Highest Price

Annual Expenses

Direct Expenses by Quarter
Summary
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Annual Total % of Total
Sales Expense $ 4,458,578 $ 4,678,712 $ 4,887,953 $ 5,325,215
Administrative Expense 1,311,774 1,587,963 1,689,563 1,856,878
Rent Expense 1,317,470 1,317,470 1,317,470 1,317,470
Interest Expense 129,713 138,963 115,786 128,963
Advertising Expense 964,872 1,184,532 1,278,741 1,581,372
Totals by Quarter
Expenses 5-Year Forecast
Forecasted Increase 3.5%
Year 2019 2020 2021 2022 2023
Projected Expenses

Sales Reps

Alexander, Rebekah
Alvarez, Eliza
Bradley, Christine
Caputo, Stephanie
DiAntonio, Avelina
Furfy, Jana
Hernandez, Anna

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Using the information found in the discussion preparation, determine two

  Using the information found in the discussion preparation, determine two work-life challenges that may be faced within any organization by military personnel such as reserve and National Guard members; people who speak with accents or have English fluency concerns; or gays and lesbians. Examine at least two employment laws that

Visit an agency or government site in your area that

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

You have created a policy brief presentation that has theoretically caught the attention of a lawmaker. He/she would like more information about this. Write a formal paper, including title page, table Nursing Assignment Help

You have created a policy brief presentation that has theoretically caught the attention of a lawmaker. He/she would like more information about this. Write a formal paper, including title page, table of contents, executive summary, topic headings, in-text citations, and references about your selected health issue. Using the outline that

1. Review the two articles about bank failures and bank

1. Review the two articles about bank failures and bank diversification that are found below this. Economic history assures us that the health of the banking industry is directly related to the health of the economy. Moreover, recessions, when combined with banking crisis, will result in longer and deeper recessions

Julian of Norwich, Revelations of Divine Love. Use your understanding

Julian of Norwich, Revelations of Divine Love. Use your understanding of a “hermeneutic circle” to interpret Julian of Norwich’s vision in her Revelations of Divine Love (W1.P2.3). What are some of its meanings? Use what you have learned in the Required Readings, Supplemental Learning Material and your own experiences and reasoning to

Assignment 8 – Summative – Legal Plan (PO4, PO5, CO6, ILO.SK1, BIS2,

For your final summative assignment, you complete the legal section of a business plan. Include the following: 1.    A defense for the form of business entity for the company you’ve chosen, the number of owners, and other factors. 2.    An explanation of liability with federal, state, and local taxes and

The Marrow Thieves by Cherie Dimaline

Read and analyze The Marrow Thieves by Cherie Dimaline 1. Building on the readings and the in-class discussions we have had about the class material, this assignment asks you to write an essay with an introduction, conclusion, and multiple body paragraphs. In your introduction, give a brief summary of the

How do you think this virus would affect chocolate sales? At the same

QUESTION 4 In the year 2007, the outbreak of a new disease affecting cattle had a devastating impact on the farm’s dairy industry in New Zealand. Known as ‘whooping cow disease’, fear of the virus quickly spread throughout the world causing people to avoid consumption of cattle and cattle related

PLEASE FOLLOW THE INSTRUCTION &RUBRIC DETAILS, ZERO PLAGIARISM, FIVE REFERENCES

 PLEASE FOLLOW THE INSTRUCTION &RUBRIC DETAILS, ZERO PLAGIARISM, FIVE REFERENCES LESS THAN FIVE YEARS, SEE TEMPLATE ATTACHED Subjective: What details did the patient provide regarding their personal and medical history? What are their symptoms of concern? How long have they been experiencing them, and what is the severity? How are their

DISEASE CARD Directions Review the Disease Card Assignment List and

    DISEASE CARD Directions  Review the Disease Card Assignment List and complete the disease card Template for Each Disease. Each Disease card must have the appropriate references utilized by the student.    1. Psychosocial 2. Down Syndrome 3. Agoraphobia 4. Attention-deficit/hyperactivity disorder (ADHD) 5. Autism spectrum disorders (autism) 6. Anxiety Disorders

150 words Describe the individual and state interests in the

150 words   Describe the individual and state interests in the refusal of life sustaining treatment. How is withholding treatment different from withdrawing treatment? Can minors decide if they want treatment withheld? What happens to an adult patient who lacks the capacity to decide for himself or herself?

THE GOAL: Your final project is to develop a personal

THE GOAL:   Your final project is to develop a personal financial plan for when you graduate college. The project has three main parts. Part 1:   (20% of grade): A narrative about yourself. This should include thoughts on your career direction, a timeline to graduate and ideas for your after college work experience. 2-3 paragraph for part

Select and identify an issue or challenge that you would

Select and identify an issue or challenge that you would like to find a solution to. Take about 15-30 minutes and begin a brainstorming exercise. You can do this as an individual or in a group setting. Consider the following What did you learn about this technique? Where were the

The written research proposal will be created based on a

  The written research proposal will be created based on a narrowly defined aspect of the topic selected in Week One. A research proposal is a detailed plan for a specific study to be conducted at a future time. It is the document which potential researchers typically submit to an

Please respond to at least two classmates’ posts with feedback

Please respond to at least two classmates’ posts with feedback about their ability to interest you in their story Leah: Like always I woke up to the screams of my alarm. It was a brisk morning of March; the Vermont air was crispy and refreshing as I made my way