Sign Up Now
Get instant access to over 1 million+ study documents
OR
Already registered? click here to login
By creating your account, you agree to our terms of service, privacy policy and student honor code.
Supplier Database: MS Access
If your database contained around 1000 suppliers (using the same fields contained in this exercise and no other), what other types of reports beside contact information could you create with the data?
Well, apart from a contacts report, the data fields used in this exercise can conveniently be used to generate both a supplier-sales report and supplier revenue report. The YTD order figure represents the supplier's sales level. For instance, we could take the YTD order to be a measure of the number of orders placed for the company's products by customers from, say, three years in the past. If we are comparing 1000 producers dealing in the supply of, in our case, a particular mouse model from a specific manufacturer, then we can compare suppliers based on their level of sales and consequently, size -- higher YTD order figures can rightly be taken to indicate higher online sales levels, higher sales revenues, and consequently, larger sizes.
Question Two
How would these reports assist you in preparing your solution to your case study?
The contacts report prepared in this exercise informs the assessor's decision by showing the suitability, in terms of proximity to the company, of each of the potential suppliers. The further away the supplier is, the higher the costs that will be incurred in transportation costs; therefore, it makes sense to pick a supplier who is located within reasonable reach. The sales-size and sales-revenue reports, similarly, could help the assessor identify those suppliers that are likely to offer lower prices. The larger the sales volumes (as measured by the YTD order index), the larger the supplier's revenue base, and the greater their ability to offer low prices through scale economies. In this regard, suppliers with higher YTD indices are judged more attractive than those with lower indices. It was on this basis that Amazon and Wal-Mart were selected as the preferred distributors in this exercise.
With optimistic concurrency control, the database checks resources to determine if any conflicts have occurred only when attempting to change data. If a conflict occurs, the application must read the data and attempt the change again. Pessimistic concurrency, on the other hand, control locks resources as they are required, for the duration of a transaction. Unless deadlocks occur, a transaction is assured of successful completion 5.5 Audit Tracking Although auditing does
The third alternative offers the initial benefits of the first alternative. It also allows for focusing on core competencies and maintaining a smaller organization to promote personal corporate culture of the second alternative. However, this option will have a disruption as the organization changes to an autonomous entity that may be counter-productive. The fourth alternative of no entry has the benefit of not subjecting TAG to the risk of a new
AMR Research (2005) believes that companies must begin developing and redeploying current order management architectures with the focus on delivering more flexibility rather than a strategy that delivers far less. The move toward customer-driven fulfillment processes requires the ability to build and adapt channel-specific, product-specific, and customer-specific order flows quickly without an army of developers creating custom code. However, the days of big bang, rip-and-replace implementations are over, and any
During this penultimate period of violence under Rojas, the violence that wracked Colombia assumed a number of different characteristics that included an economic quality as well as a political one with numerous assassinations taking place. These were literally contract killings there were sponsored by opposition forms. There were also horrendous genocidal acts that were carried out by gangs combined with authentic revolutionary fighting in some regions of the country. The fourth
Their clients ranged from automobile sales companies to banks. However, most were larger corporations in Thailand in globally. When the interviewee was asked about cost, they provided me with literature about their services and products. They had standard pricing schemes based on the number of end users, the type of application that system would be used for. They offered a number of different packages for their customers, but they could
Figure 2: ECM is the foundation of solid knowledge management Source: Establishing a True Source of Product Content for Competitive Advantage, AMR Research (Murphy (2003)) Retaining the knowledge to overcome "knowledge walkouts" From the basis of an ECM architecture or framework, organizations can begin to successively learn and accumulate knowledge from its employees. The true intelligent enterprise is one with the capacity to learn from the collective experience of successive generations of workers and