Annual Net Sales and Inventory Status for Action Sports
School
CUNY Queensborough Community College**We aren't endorsed by this school
Course
CIS 101
Subject
Economics
Date
Dec 11, 2024
Pages
11
Uploaded by AgentWolf2046
2373ecc399a81dcbae934573972167296210ec74.xlsxColorado21%New Mexico10%Oregon17%California30%Washington21%Annual Net Sales by State
2373ecc399a81dcbae934573972167296210ec74.xlsxFront Range Action SportsAnnual Net SalesQuarter 1Quarter 2Quarter 3Quarter 4TotalColorado$ 48,123,789 $ 42,468,256 $ 45,159,681 $ 49,452,695 $ 185,204,421 New Mexico25,783,516 21,985,365 19,987,269 22,252,487 90,008,637 Oregon35,658,498 34,689,526 37,986,369 39,456,899 147,791,292 California58,123,789 64,468,256 65,159,681 68,452,695 256,204,421 Washington42,143,258 46,598,456 44,874,332 50,546,222 184,162,268 Total Sales$ 209,832,850 $ 210,209,859 $ 213,167,332 $ 230,160,998 $ 863,371,039 ColoradoNew MexicoOregonCaliforniaWa$- $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 Quarterly Net Sales by StateQuarter 1Quarter 2Quarter 3Quarter 4
2373ecc399a81dcbae934573972167296210ec74.xlsxTrend21%10%17%30%21%Percent of Total Salesashington
2373ecc399a81dcbae934573972167296210ec74.xlsxSeattle Facility: Inventory Status of ApparAs of December 31Total Items in Stock271 Average Price24.773333Median Price17.45Lowest Price2.99Highest Price69.52Ski Products 2 Ski Quantity in Stock 86 Quantity in StockItem #Item NameRetail PriceCategory78114568 Vented Explorer 34.78 Hats32115689 Deluxe Biking Shorts69.52 Pants18165332 Mini Crew Socks6.45 Socks and Gloves28456897 Wicked Heavy Socks9.35 Socks and Gloves57465888 Airflow Hat2.99 Hats58465899 Gripper Gloves25.55 Socks and Gloves
2373ecc399a81dcbae934573972167296210ec74.xlsxrelSportStock LevelHikingOKBikingOrderFitnessOrderSkiingOrderHikingOKSkiingOK
2373ecc399a81dcbae934573972167296210ec74.xlsxDenver Facility: Inventory Status of AppareAs of December 31Total Items in Stock265 Average Price$ 9.68 Median Price$ 6.45 Lowest Price$ 2.99 Highest Price$ 18.98 Number of Biking Products 1Biking Quantity in Stock 58Quantity in StockItem #Item NameRetail PriceCategory58965888 Cotton Visor2.99 Hats35658752 Bandana4.99 Hats18765332 Mini Crew Socks6.45 Socks and Gloves58729567 Striped Crew Socks14.99 Socks and Gloves96796689 Sun Runner Cap18.98 Hats
2373ecc399a81dcbae934573972167296210ec74.xlsxelSportStock LevelBikingOKHikingOrderFitnessOrderFitnessOKFitnessOK
2373ecc399a81dcbae934573972167296210ec74.xlsxApparel Inventory SummaryAs of December 31SeattleDenverTotal Items in Stock271 265 Average Price$ 24.77 $ 9.68 Median Price$ 17.45 $ 6.45 Lowest Price$ 2.99 $ 2.99 Highest Price$ 69.52 $ 18.98
2373ecc399a81dcbae934573972167296210ec74.xlsxDirect Expenses by QuarterSummaryQuarter 1Quarter 2Quarter 3Quarter 4Annual TotalSales Expense$ 4,458,578 $ 4,678,712 $ 4,887,953 $ 5,325,215 $ 19,350,458 Administrative Expens1,311,774 1,587,963 1,689,563 1,856,878 $ 6,446,178 Rent Expense1,317,470 1,317,470 1,317,470 1,317,470 $ 5,269,880 Interest Expense129,713 138,963 115,786 128,963 $ 513,425 Advertising Expense964,872 1,184,532 1,278,741 1,581,372 $ 5,009,517 Totals by Quarter$ 8,182,407 $ 8,907,640 $ 9,289,513 $ 10,209,898 $ 36,589,458 Expenses 5-Year ForecastForecasted Increase3.5%Year20192020202120222023Projected Expenses$ 36,589,458 $ 37,870,089 $ 39,195,542 $ 40,567,386 $ 41,987,245 Quarter 1Quarter 2Quarter 3Quarter 4$8,000,000 $9,000,000 $10,000,000 $11,000,000 Direct Expenses
2373ecc399a81dcbae934573972167296210ec74.xlsx% of Total53%18%14%1%14%
2373ecc399a81dcbae934573972167296210ec74.xlsxSales RepsAlexanderRebekahAlvarezElizaBradleyChristineCaputoStephanieDiAntonioAvelinaFurfyJanaHernandezAnna