To analyze the data we decided to group it by Customer Segment to begin. We used the total profits, order count and profit/order equations to see what the data could tell us through the Customer Segment. What we found was that the Corporate segment created the largest total profits with $599,746 and the lowest was the Consumer segment with $287,960. The largest order count to no surprise went to the Corporate segment again with 3076, but instead of the Consumer being the lowest order count, in this analysis portion the segment with the smallest order count was Small Business with 1642. Following the trend, the Corporate segment had the greatest profit/order with $195 and Home Office had the lowest profit/order with $157. Overall, Corporate segments were the most profitable and successful in the superstore sales.

Marketing Specialist for Hi-Tec Sports (Tigard, OR)

Hi-Tec is a sports company that manufactures outdoor clothing and footwear. They are looking for a marketing specialist who will be responsible for all activities relating to consumer marketing. Just a few of the requirements they have are a bachelor degree from a University or college, 2-3 years of marketing experience, knowledge of footwear and apparel, Microsoft Office skills, and someone who embodies a “team player” attitude.

We began by looking up reviews on what people have said a job at Hi Tec is like. Overall they received positive reviews from people who posted on indeed.com. There were 3 posts and a few of the things said were “productive and fun work place”, “colleagues are always smiling” and occasionally they would have team building exercises. On the stars rating, the lowest was a 3/5 on job security/ advancement but all other categories received at least a 4/5. One review suggested they could improve on management.
On glassdoor.com there was one review posted which gave the company a 2/5 but said it was a “family company with a flexible outlook” but had “poor process control and management”.

Next we did extensive research on sites such as Amazon.com and Ebay on Hi Tec products. Their most popular product seems to be hiking shoes, which are very highly rated (above four stars). We then looked into their most popular hiking shoe. The Waimea Falls Outdoor Sandal had 265 reviews with an average rating of 4.2/5 stars. People who have worn the shoe thoroughly enjoy the fit , and comfortableness of the shoe. They also seem to be a fan of how their feet respond to such a comfortable shoe. However, the wearers of the shoe admit it isn’t the most fashionable outdoor shoe around. Considering this is a woman’s shoe we believe the company should put more consideration into the fashionable side of this popular product.

After looking at Hi Tec’s website it seemed very evident that Hi Tec Sports is a company that focuses very much on the quality and technology of its products. They seem to be a very product driven company and after seeing the reviews on Amazon and Ebay, they are reaching their goal of producing and selling well liked and purchased outdoor gear.

This assignment took a lot of trial and error. Learning to write code is never easy. Changing the colors of the boxes was easy to figure out and also changing the font type. However it was difficult to figure how to change the font size, which we had to ask help for. Eventually we figured it all out and made it so the boxes fit perfectly into the layout we chose for our blog page.

 

Above we have a blueprint of visiting a movie theater. A few things that customers could be inconvenienced by would be not enough parking spaces, sold out showtimes, and a dirty theater room. Although there is not much that employees could do about parking and sold out shows, it is in the employees hands to make sure the movie theater is presentable and clean. Also, something could happen with technology and mechanics during the film which could lessen the customers experience. Things that could be a challenge for employees would be dealing with difficult customers which is something all businesses see and also making sure that everything runs smoothly mechanically.

 

West Side Portland, OR

High income residents of Portland tend to reside in the hills on the West side of the Columbia.  Residents often have to drive to the base of the hill to reach any sort of service or store.

 

4 star hotels help us narrows our search that this is the right area to put the spa.

Traffic conditions during rush hour between 4:00-7:00pm

Competitions around the area

 

The area with zip code between 97202 and 97209, there are 42,525 people living in that area.  Comparing this to the area with zip code 97212 and 97219 there are 39,472 people living there.  This therefore tells us that the area in the west side of Portland is the right area to locate our spa.

 

After finding this information, we thought this was compelling evidence to prove that this is the best area in Portland to start up the new spa. This gives detailed information about the particular area along with demographics and numbers.