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

In the last few units, you have developed skills to

In the last few units, you have developed skills to assist diverse clients that are experiencing unique crises across the various developmental stages of life. It is vital for human service professionals to be aware of how crises can impact individuals across the lifespan and within multicultural contexts. For this

After studying Module 2: Lecture Materials & Resources, discuss the

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.

Industrialization and the Rise of a Regulated Economy

The United States went through dramatic economic change during and after the Civil War, as industrialization spread rapidly and changed society. This transformation and some of the apparent abuses that developed (monopolistic practices, work conditions, low wages, arbitrary and oppressive expectations) led to an increased role of the government in

Deadline: 11/3/2021 4:00 pm PST Please provide 5 slides with

Deadline: 11/3/2021 4:00 pm PST Please provide 5 slides with speech notes. In 2020, we experienced the start of a global pandemic, which was stressful to billions of people in the world.  Many lost their jobs and others were impacted emotionally and/or physically. You must read the required PowerPoint slides. With

Select any company in the luxury services field, and analyse

Select any company in the luxury services field, and analyse its services marketing strategy  Promises made, how, to which segment (s), and why this/these segment(s). How do you think the promises are kept (you can refer to the concept of theService Marketing Triangle for this). Summarize the seven P approach

Each individual is asked to prepare a case analysis on

 Each individual is asked to prepare a case analysis on FORD (found in 10th Edition of our text, C277). The expected length of this Case Analysis is 3 pages, 1-inch all-around margins, single-spaced and Times New Roman 12-point font.  Please see the grading rubric at the end of the syllabus

Competency Apply the principles and practices of operations management to

CompetencyApply the principles and practices of operations management to improve performance outcomes of a healthcare organization. Student Success CriteriaView the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane. ScenarioYou are the new project

Many people say that efficiency and effectiveness metrics are interrelated

Many people say that efficiency and effectiveness metrics are interrelated and that you can’t really have one without the other or that no organization can truly be successful without both. How are efficiency and effectiveness metrics interrelated? Must you succeed in one set before addressing the other? If so, which

I have attached a copies of my draft to go

I have attached a copies of my draft to go off of. I will be needing a    narrated PowerPoint presentation that will highlight the following items.    · Your calculations for the amount of property, plant, and equipment and the annual depreciation for the project · Your calculations that

Post with a minimum of 250 words must contain at

Post with a minimum of 250 words must contain at least (2) professional references, properly cited in the current APA format. Discussion Topic Michael is a 22-year-old college student who lives off-campus. Although he has a kitchen in his apartment, he has neither the time nor the interest in making his own

Discussion Board Generally speaking, bioethics helps determine what is responsible

  Discussion Board  Generally speaking, bioethics helps determine what is responsible by considering four fundamental principles: autonomy, beneficence, nonmaleficence, and justice. The principle of autonomy is about respecting people and their free will. Beneficence and nonmaleficence are two sides of the same coin: doing what is helpful and not doing what is harmful. Justice,

Introduction: This brief section will be an overview of the

Introduction: This brief section will be an overview of the topic Requirements: This section will discuss how ESSA calls for serious consultation from teachers, principals, school board members, and others in crafting new accountability plans. How is your state handling that requirement? Evaluation & Performance: This section will discuss how

Overview Law enforcement officers use two methods to investigate possible

Overview  Law enforcement officers use two methods to investigate possible criminal activity: reasonable suspicion and probable cause. Reasonable suspicion means officers have a reasonable belief, sometimes called a hunch, that criminal activity may have occurred. They have no hard evidence to support their belief. Probable cause is more concrete. Probable cause means

Your own response to discussion 1. Consider what it would

  Your own response to discussion 1. Consider what it would take to manage a census. The following articles outline different ways to monitor and track patient census.    https://healthmanagement.org/c/hospital/news/new-approach-for-hospital-census-management https://www.umc.edu/news/News_Articles/2016/March/-Capacity-alert–plan-coordinates-best-use-of-hospital-beds.html 2. Based on what you’ve learned about managing the census, respond to the following: A hospital receives several patient

DISCUSSION: xxxxxxxxx (title of your trend) (Choose your own topic)

DISCUSSION:  xxxxxxxxx (title of your trend) (Choose your own topic) Student Leaders (Group 4):  If you are assigned a topic below, it is your responsibility to research the topic and create a 3-4 paragraph “report” on what the trend is, why it is important and, if appropriate, relate how that

Avatar Agency Director: Hello everyone! Welcome back to the AIU

Avatar Agency Director: Hello everyone! Welcome back to the AIU Criminal Justice Agency Conference. As director for the agency and because you have been selected as the top criminal justice professional in your respective field, you are going to attend the Criminal Justice Professional’s Conference on Day 3 (represented by

Assignment 2: How to Win: Strategic Options Assessment and Recommendation

 Assignment 2: How to Win: Strategic Options Assessment and Recommendation Due Week 8, Sunday, midnight of your time zone (Weight: 25%) Introduction “Strategy means making clear-cut choices about how to compete. You cannot be everything to everybody, no matter what the size of your business or how deep its pockets.”