excel work due Saturday 12 noon
Arun1990
Hurst_GO_XL_Grader_Vol1_CAP_v21.xlsxNet Sales
| Front Range Action Sports | |||||||
| Annual Net Sales 2018 | |||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | Percent of Total Sales | Trend | |
| Texas | $ 17,133,779 | $ 13,567,356 | $ 15,159,671 | $ 19,553,695 | |||
| New Mexico | 15,773,516 | 11,975,365 | 19,977,369 | 13,353,577 | |||
| Oregon | 15,657,597 | 15,679,536 | 17,976,369 | 19,556,799 | |||
| California | 17,133,779 | 15,567,356 | 15,159,671 | 17,553,695 | |||
| Washington | 13,153,357 | 16,597,556 | 15,775,333 | 10,556,333 | |||
| Total Sales |
Portland Inventory
| Portland Facility: Inventory Status of Apparel | ||||||
| As of December 31, 2018 | ||||||
| Total Items in Stock | 384 | |||||
| Average Price | ||||||
| Median Price | ||||||
| Lowest Price | ||||||
| Highest Price | ||||||
| Hiking Products | ||||||
| Hiking Quantity in Stock | ||||||
| Quantity in Stock | Item # | Item Name | Retail Price | Category | Sport | Stock Level |
| 65 | 115689 | Wide Brim Explorer | 28.99 | Pants | Hiking | |
| 48 | 114568 | Cotton Deluxe Explorer | 25.55 | Hats | Hiking | |
| 72 | 456897 | Dri Release Heavy Socks | 12.65 | Socks and Gloves | Fitness | |
| 33 | 465899 | Gripper Gloves | 13.55 | Socks and Gloves | Skiing | |
| 81 | 465888 | Airflow Hat | 22.18 | Hats | Hiking | |
| 85 | 165332 | Sport Deluxe Crew Socks | 6.45 | Socks and Gloves | Fitness |
Austin Inventory
| Austin Facility: Inventory Status of Apparel | ||||||
| As of December 31, 2018 | ||||||
| Total Items in Stock | 261 | |||||
| Average Price | $ 9.68 | |||||
| Median Price | $ 6.45 | |||||
| Lowest Price | $ 2.99 | |||||
| Highest Price | $ 18.98 | |||||
| Number of Hiking Products | 3 | |||||
| Hiking Quantity in Stock | 203 | |||||
| Quantity in Stock | Item # | Item Name | Retail Price | Category | Sport | Stock Level |
| 84 | 965888 | Cotton Visor | 2.99 | Hats | Hiking | OK |
| 76 | 658752 | Bandana | 4.99 | Hats | Hiking | OK |
| 42 | 765332 | Mini Crew Socks | 6.45 | Socks and Gloves | Fitness | Order |
| 16 | 729567 | Striped Crew Socks | 14.99 | Socks and Gloves | Fitness | Order |
| 43 | 796689 | Sun Explorer Cap | 18.98 | Hats | Hiking | Order |
&F
Inventory Summary
| Apparel Inventory Summary | ||
| As of December 31, 2018 | ||
| Portland | Austin | |
| Total Items in Stock | ||
| Average Price | ||
| Median Price | ||
| Lowest Price | ||
| Highest Price |
Annual Expenses
| Direct Expenses by Quarter | ||||||
| Summary, December 2018 | ||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Annual Total | % of Total | |
| Sales Expense | $ 3,358,578 | $ 3,678,712 | $ 3,887,953 | $ 5,325,215 | ||
| Administrative Expense | 911,773 | 1,287,963 | 1,389,489 | 1,556,834 | ||
| Rent Expense | 1,245,800 | 1,245,800 | 1,245,800 | 1,245,800 | ||
| Interest Expense | 129,713 | 138,963 | 115,786 | 128,963 | ||
| Advertising Expense | 863,435 | 1,058,493 | 978,759 | 1,241,367 | ||
| Totals by Quarter | ||||||
| Expenses 5-Year Forecast | ||||||
| Forecasted Increase | 3.5% | |||||
| Year | 2018 | 2019 | 2020 | 2021 | 2022 | |
| Projected Expenses |
Sales Reps
| Amaro, Jenna |
| Asai, Lynn |
| Burke, Camden |
| Chavez, Alfred |
| Dennison, Malia |
| Nguyn, Phoung |
| Patel, Ami |
