need excel project done please and thank youNet SalesFront Range Action SportsAnnual Net Sales Quarter

need excel project done please and thank you

Net Sales

Front Range Action Sports
Annual Net Sales
Quarter 1Quarter 2Quarter 3Quarter 4TotalPercent of Total SalesTrend
Colorado$ 48,123,789$ 42,468,256$ 45,159,681$ 49,452,695$ 185,204,421
New Mexico25,783,51621,985,36519,987,26922,252,48790,011,637
Oregon35,658,49834,689,52637,986,36939,456,899147,791,292
California58,123,78964,468,25665,159,68168,452,695237,802,929
Washington42,143,25846,598,45644,874,33250,546,222187,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 Stock271
Average Price
Median Price
Lowest Price
Highest Price
Ski Products
Ski Quantity in Stock
Quantity in StockItem #Item NameRetail PriceCategorySportStock Level
32115689Deluxe Biking Shorts69.52PantsBiking
78114568Vented Explorer34.78HatsHiking
28456897Wicked Heavy Socks9.35Socks and GlovesSkiing
58465899Gripper Gloves25.55Socks and GlovesSkiing
57465888Airflow Hat2.99HatsHiking
18165332Mini Crew Socks6.45Socks and GlovesFitness

Denver Inventory

Denver Facility: Inventory Status of Apparel
As of December 31
Total Items in Stock265
Average Price$ 9.68
Median Price$ 6.45
Lowest Price$ 2.99
Highest Price$ 18.98
Number of Biking Products1
Biking Quantity in Stock58
Quantity in StockItem #Item NameRetail PriceCategorySportStock Level
58965888Cotton Visor2.99HatsBikingOK
35658752Bandana4.99HatsHikingOrder
18765332Mini Crew Socks6.45Socks and GlovesFitnessOrder
58729567Striped Crew Socks14.99Socks and GlovesFitnessOK
96796689Sun Runner Cap18.98HatsFitnessOK

&F

Inventory Summary

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

Annual Expenses

Direct Expenses by Quarter
Summary
Quarter 1Quarter 2Quarter 3Quarter 4Annual Total% of Total
Sales Expense$ 4,458,578$ 4,678,712$ 4,887,953$ 5,325,215
Administrative Expense1,311,7741,587,9631,689,5631,856,878
Rent Expense1,317,4701,317,4701,317,4701,317,470
Interest Expense129,713138,963115,786128,963
Advertising Expense964,8721,184,5321,278,7411,581,372
Totals by Quarter
Expenses 5-Year Forecast
Forecasted Increase3.5%
Year20192020202120222023
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

Operational Excellence Week 2 Assignmentinformation

Operational Excellence Week 2 Assignment information Systems for Business and Beyond Questions · Chapter 2 – study questions 1-10, Exercise 2      Information Technology and Organizational Learning Questions ·. The above submission should be one page in length and adhere to APA formatting standards. **Remember the page length does

Pg. 01Project I ProjectDeadline: Sunday 12/5/2024 @ 23:59[Total

Pg. 01 Project I Project Deadline: Sunday 12/5/2024 @ 23:59 [Total Mark is 14] Introduction to Database IT244 College of Computing and Informatics Project Instructions · You can work on this project as a group (minimum 2 and maximum 3 students). Each group member must submit the project individually with