Matching Items (21)
Filtering by
- All Subjects: Analytics
- Creators: Department of Information Systems
Description
Sagebrush Coffee is a small business in Chandler, Arizona that purchases green beans, roasts them in small batches for quality, and ships fresh, gourmet roasted coffee beans across the nation. Deciding which coffee beans to buy and roast is one of the most crucial business decisions Sagebrush and other gourmet coffee roasters face. Further complicating this decision is the fact that coffee is a crop, and like all crops, has a specific growing season and the exact same product cannot usually be ordered from year to year, even if it proves to be successful. The goal of this research is to use data analytics and visualization to help Sagebrush make better purchasing decisions by identifying consumer purchasing trends and providing a recommendation for their portfolio mix. In the end, I found that Latin American coffees are popular with both returning and first-time customers, but a specific country of origin does not appear to be associated with the top coffee producing countries. Additionally, December is a critical month for Sagebrush and Sagebrush should make sure to target the states with the most sales: California, Pennsylvania, and New York. Arizona has growth potential as it is not one of the top three locations, despite the presence of a physical store. Also included in the following report is a portfolio recommendation suggesting how many of each product based on region, processing type, and roast level to carry in inventory.
ContributorsBlue, Jessica Morgan (Author) / Kellso, James (Thesis director) / Davila, Eddie (Committee member) / Department of Information Systems (Contributor) / Economics Program in CLAS (Contributor) / Department of Supply Chain Management (Contributor) / Morrison School of Agribusiness (Contributor) / Barrett, The Honors College (Contributor)
Created2018-05
Description
This project analyzes the tweets from the 2016 US Presidential Candidates' personal Twitter accounts. The goal is to define distinct patterns and differences between candidates and parties use of social media as a platform. The data spans the period of September 2015 to March 2016, which was during the primary races for the Republicans and Democrats. The overall purpose of this project is to contribute to finding new ways of driving value from social media, in particular Twitter.
ContributorsMortimer, Schuyler Kenneth (Author) / Simon, Alan (Thesis director) / Mousavi, Seyedreza (Committee member) / Department of Information Systems (Contributor) / Department of Supply Chain Management (Contributor) / Barrett, The Honors College (Contributor)
Created2016-05
Description
This report details a prioritization value model that was created for the use of Arizona State University and ASU LightWorks in determining and implementing appropriate sustainability projects for removing greenhouse gas emissions. A thorough review regarding the current project selection process, and an extensive analysis into the desired state of the process was conducted for this paper. The newly developed prioritization model includes multiple attributes that rank and prioritize projects based upon the highest value as determined by criteria set forth by the university. Encompassed within this report are the steps in creating the decision model, as well as the benefits and additional uses of the model for the end user. From the analysis and model created, the end user has the ability to choose carbon neutral projects that better align with the vision of the New American University.
ContributorsAmoroso, Nicholas (Co-author) / Lee, Betty (Co-author) / Brooks, Dan (Thesis director) / Johnson, Travis (Committee member) / Barrett, The Honors College (Contributor) / Department of Finance (Contributor) / Department of Information Systems (Contributor)
Created2015-05
Description
The main goal of this study was to understand the awareness of small business owners regarding occupational fraud, meaning fraud committed from within an organization. A survey/questionnaire was used to gather insight into the knowledge and perceptions of small business owners, while also obtaining information about the history of fraud and the internal controls within their business. Twenty-four owners of businesses with less than 100 employees participated in the study. The results suggest that small business owners overestimate their knowledge regarding internal controls and occupational fraud, while also underestimating the risk of fraud within their own business. In fact, 92% of participants were not at all familiar with the popular Internal Control \u2014 Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission. The results also show that small business owners tend to overestimate the protection provided by their currently implemented controls in regard to their risk of fraud. Overall, through continued knowledge of internal controls and occupational fraud, business owners can better protect their businesses from the risk of occupational fraud by increasing their awareness of fraud.
ContributorsDennis, Lauren Nicole (Author) / Orpurt, Steven (Thesis director) / Munshi, Perseus (Committee member) / Barrett, The Honors College (Contributor) / Department of Information Systems (Contributor) / School of Accountancy (Contributor)
Created2014-05
Description
Monocular is a user engagement application that offers a website owner the opportunity to track user behavior and use the data to better understand the site's strengths and weaknesses in terms of user satisfaction and motivation. This data allows the customer to make improvements to a website, resulting in a better user experience and potential for an improved bottom line.
ContributorsHooke, Wade (Co-author) / Ortiz-Monasterio, Diego (Co-author) / Clark, Joseph (Thesis director) / Prince, Linda (Committee member) / Barrett, The Honors College (Contributor) / Department of Information Systems (Contributor) / Department of Supply Chain Management (Contributor) / W. P. Carey School of Business (Contributor)
Created2014-05
Description
The purpose of this project is to provide our client with a tool to mitigate Company X's franchise-wide inventory control problem. The problem stems from the franchises' initial strategy to buy all inventory as customers brought them in without a quantitative way for buyers to evaluate the store's inventory needs. The Excel solution created by our team serves to provide that evaluation for buyers using deseasonalized linear regression to forecast inventory needs for clothing of different sizes and seasons by month. When looking at the provided sales data from 2014-2016, there was a clear seasonal trend, so the appropriate forecasting model was determined by testing 3 models: Triple Exponential Smoothing model, Deseasonalized Simple Linear Regression, and Multiple Linear Regression.The model calculates monthly optimal inventory levels (current period plus future 2 periods of inventory). All of the models were evaluated using the lowest mean absolute error (meaning best fit with the data), and the model with best fit was Deseasonalized Simple Linear Regression, which was then used to build the Excel tool. Buyers can use the Excel tool built with this forecasting model to evaluate whether or not to buy a given item of any size or season. To do this, the model uses the previous year's sales data to forecast optimal inventory level and compares it to the stores' current inventory level. If the current level is less than the optimal level, the cell housing current value will turn green (buy). If the currently level is greater than or equal to optimal level or less than optimal inventory level*1.05, current value will turn yellow (buy only if good quality). If the current level is greater than optimal level*1.05 current level will be red (don't buy). We recommend both stores implement a way of keeping track of how many clothing items held in each bin to keep more accurate inventory count. In addition, the model's utility will be of limited use until both stores' inventories are at a level where they can afford to buy. Therefore, it is in the client's best interest to liquidate stale inventor into store credit or cash In the future, the team would also like to develop a pricing model to better meet the needs of the client's two locations.
ContributorsUribes-Yanez, Diego (Co-author) / Liu, Jessica (Co-author) / Taylor, Todd (Thesis director) / Gentile, Erica (Committee member) / Department of Economics (Contributor) / Department of Information Systems (Contributor) / Department of Marketing (Contributor) / School of International Letters and Cultures (Contributor) / School of Life Sciences (Contributor) / Department of Supply Chain Management (Contributor) / Barrett, The Honors College (Contributor)
Created2017-05
Description
Within this paper I summarize the key features, and results, of research conducted to support the development, design, and implementation of an internal control system at a startup small business. These efforts were conducted for an Honors Thesis/Creative Project for Barrett, the Honors College at Arizona State University. The research revolved around deciding which financial policies, procedures, and safeguards could be useful in creating an internal control system for small businesses. In addition to academic research, I developed an “Internal Control Questionnaire” for use as a ‘jumping off point’ in conversations about a business’ existing accounting system. This questionnaire is applicable across many industries, covering the major topics which every small business/startup should consider.
The questionnaire was then used in conjunction with two interviews of small business owners. The interviews covered both the overall financial status of their business and their business’ pre-existing accounting system. The feedback received during these interviews was subsequently used to provide the business owners with eleven recommendations ranging from the implementation of new policies to verification of existing internal controls.
Finally, I summarize my findings, both academic and real-world, conveying that many small business owners do not implement formal internal control systems. I also discuss why the business owners, in this specific circumstance, did not yet implement the aforementioned eleven suggestions.
The questionnaire was then used in conjunction with two interviews of small business owners. The interviews covered both the overall financial status of their business and their business’ pre-existing accounting system. The feedback received during these interviews was subsequently used to provide the business owners with eleven recommendations ranging from the implementation of new policies to verification of existing internal controls.
Finally, I summarize my findings, both academic and real-world, conveying that many small business owners do not implement formal internal control systems. I also discuss why the business owners, in this specific circumstance, did not yet implement the aforementioned eleven suggestions.
ContributorsDuncan, Spencer James (Author) / Garverick, Michael (Thesis director) / Casas Arce, Pablo (Committee member) / School of Accountancy (Contributor) / School of International Letters and Cultures (Contributor) / Barrett, The Honors College (Contributor)
Created2019-05
Description
With growing levels of income inequality in the United States, it remains as important as ever to ensure indispensable public services are readily available to all members of society. This paper investigates four forms of public services (schools, libraries, fire stations, and police stations), first by researching the background of these services and their relation to poverty, and then by conducting geospatial and regression analysis. The author uses Esri's ArcGIS Pro software to quantify the proximity to public services from urban American neighborhoods (census tracts in the cities of Phoenix and Chicago). Afterwards, the measures indicating proximity are compared to the socioeconomic statuses of neighborhoods using regression analysis. The results indicate that pure proximity to these four services is not necessarily correlated to socioeconomic status. While the paper does uncover some correlations, such as a relationship between school quality and socioeconomic status, the majority of the findings negate the author's hypothesis and show that, in Phoenix and Chicago, there is not much discrepancy between neighborhoods and the extent to which they are able to access vital government-funded services.
ContributorsNorbury, Adam Charles (Author) / Simon, Alan (Thesis director) / Simon, Phil (Committee member) / Department of Information Systems (Contributor) / Department of English (Contributor) / Department of Economics (Contributor) / Barrett, The Honors College (Contributor)
Created2018-05
Description
Our research encompassed the prospect draft in baseball and looked at what type of player teams drafted to maximize value. We wanted to know which position returned the best value to the team that drafted them, and which level is safer to draft players from, college or high school. We decided to look at draft data from 2006-2010 for the first ten rounds of players selected. Because there is only a monetary cap on players drafted in the first ten rounds we restricted our data to these players. Once we set up the parameters we compiled a spreadsheet of these players with both their signing bonuses and their wins above replacement (WAR). This allowed us to see how much a team was spending per win at the major league level. After the data was compiled we made pivot tables and graphs to visually represent our data and better understand the numbers. We found that the worst position that MLB teams could draft would be high school second baseman. They returned the lowest WAR of any player that we looked at. In general though high school players were more costly to sign and had lower WARs than their college counterparts making them, on average, a worse pick value wise. The best position you could pick was college shortstops. They had the trifecta of the best signability of all players, along with one of the highest WARs and lowest signing bonuses. These were three of the main factors that you want with your draft pick and they ranked near the top in all three categories. This research can help give guidelines to Major League teams as they go to select players in the draft. While there are always going to be exceptions to trends, by following the enclosed research teams can minimize risk in the draft.
ContributorsValentine, Robert (Co-author) / Johnson, Ben (Co-author) / Eaton, John (Thesis director) / Goegan, Brian (Committee member) / Department of Finance (Contributor) / Department of Economics (Contributor) / Department of Information Systems (Contributor) / School of Accountancy (Contributor) / Barrett, The Honors College (Contributor)
Created2017-05
Description
The National Basketball Association is the world's most recognized professional basketball league. Athletes such as Kobe Bryant and Lebron James have transcended from being high school standouts to global icons, but their careers might not have panned out the same way if they weren't allowed to declare for the draft immediately upon graduating high school. In 2005, the NBA and the NBA Players Association agreed to implement an age limit for athletes declaring for the NBA Draft. Although this was supposed to reduce the quantity of younger players declaring for the draft, the rule has been ineffective as the average age of lottery picks, also known as the first 14 picks of the draft, has decreased since the rule's implementation. Adam Silver, the current commissioner of the NBA, has been vocal about potentially raising the minimum draft-eligible age once more because of NBA team executives calling recent draft picks unfit for the NBA. The purpose of this research is to examine if lottery picks are indeed "NBA ready" upon being drafted, and if there is a correlation between the age at which they are drafted, the pick at which they were selected, the length of their career, and their career success. Various statistical analysis techniques are utilized, such as the calculation of R-squared values and correlation coefficients, and the usage of t-tests and multiple regressions. Box score statistics such as minutes per game, points per game, rebounds, and assists as well as advanced metrics such as player efficiency rating, win shares, box plus/minus, and value over replacement player were the focal point of this study. Players drafted with lottery selections from the 1985-2016 drafts had their career statistics compiled and examined for this analysis in order to adequately conduct the regressions. The results indicate that although lottery picks are having a decreasing immediate impact upon being drafted, the younger an athlete is drafted, the more long-term success they can expect to achieve in the NBA.
ContributorsKender, Mitchell Edward (Author) / McIntosh, Daniel (Thesis director) / Eaton, John (Committee member) / Department of Information Systems (Contributor) / Department of Marketing (Contributor) / Barrett, The Honors College (Contributor)
Created2018-05