Author Archives: kateyj@uoregon.edu

Spreadsheets Workshop

In looking at various charts of a sample company with inventory, shipping, type of product, etc. we deducted some information about the companies sales.  When looking at all of the data it was a bit overwhelming, over 8000 lines of data! In order to better grasp what the information was telling us about sales we singled out certain aspects of the products being sold in order to see how sales were effected in these various segments.

The first variable we looked at was the product container.  We wanted to see if there were more larger product containers being sold for profit or smaller product containers.  After analyzing the data we found that the most overall profitable container size is the Small Box with a total of $926,994.  This is probably due to the fact that people are most likely buying small products from the office supply store in person.  In terms of making the most profit per order on average, the Jumbo Drum was at the top.

Screen Shot 2015-11-18 at 4.59.48 PM

Another variable we looked at closer was the product sub-category in order to see what products were selling and which were not bringing in profits for the company. It appears that the company is making the most on copiers, fax machines, and other large office machinery.  This makes sense as these orders will likely have a higher price tag and thus the company will make more per unit sold. The company is losing money on bookcases, tables, and scissors, rulers, and trimmers.  All of these profit numbers are in the negative. If you were this company you would want to look into these products that were struggling and see what could be done to boost profits whether that is advertising, sales, limiting product orders, etc.

Screen Shot 2015-11-18 at 5.00.00 PM

A third variable that we looked at was the shipping mode and how that impacted sales. The company is making the most/order on those items being shipped via delivery trucks.  This is likely due to the fact that this is the most cost effective option for consumers and also highly available option for the company.  The regular air shipping while having a remarkably high total profits of $1,104,693, the profit per order was less than that of the delivery truck.  We believe this is because it is harder for the company to coordinate air shipping and people are less likely to ship a commodity good a long distance.  If someone needs office supplies, they are likely to go to the closest office supply store and pick up the goods.

Screen Shot 2015-11-18 at 5.00.07 PM

The final variable that we looked at was the customer segment.  Not surprisingly, corporate and small businesses are where the company makes the most profit per order.  This makes sense because these are entities that will have a constant need for office goods.  These groups are also likely to order more copiers, and larger machines which were the products that were most profitable.

Screen Shot 2015-11-18 at 4.59.26 PM

Service Blueprint: Dutch Bros.

Dutch Bros. Service Blueprint

The main pain point for Dutch Bros. Coffee is in the overly drawn out employee-customer interaction.  While Dutch Bros, prides itself on great customer service, it can be a slow process to receive an order.  Cars tend to line up out of the parking lot and this can lead to unhappy customers.  It is strictly drive-thru, which limits customers from having a place to sit and get settled while waiting for their drink to be made. One solution we came up with is for employees to take orders earlier in the process which would allow for faster turn around in getting drinks.  This would follow In N Out Burger’s style of taking orders. This solution still follows Dutch Bros value on positive customer interaction.

Another solution would be to increase the size of the kiosks.  This would allow for more employees to be making beverages and for more equipment to speed up the drink making process.

The idea of having a drive-thru ordering machine like McDonald’s or Starbuck’s is too impersonal and distances customers from employees.  This doesn’t adhere to Dutch Bros. values.

Hello!

Today Grant, John, and I set up our blog website.  We customized it with the theme, Aaron, and each chose a different icon for our header highlights. For our background picture we chose an image of Lillis and then changed the website title font to a yellow color to match the “O” on the building.  In order to further customize, we activated Custom CSS and learned how to write some code that changes font size, color, etc. Looking forward to the term!