Case study: USAPITAS LTD
Background information
USAPITAS is a food and beverage supplier. USAPITAS purchases various different speciality beverages and foods from around the world. Currently the firm deals with up to 29 different suppliers from 12 countries. USAPITAS purchases up to 70 different products from these suppliers, and sell to 24 different firms in 10 different countries.
The firm has been trading since 1956 when it started selling bulk teas and coffees to the retail trade. The firm is a private limited company.
USAPITAS is currently undergoing some structural changes and Mr Campbell, the Sales Director, is seeking to achieve efficiency gains in the area of sales within the organisation. Mr Campbell wishes to increase the customer base of USAPITAS. Initially this will involve reviewing current countries that the firm is trading in, but eventually should lead to expansion into other countries. Mr Campbell wants to see improvements in communications between USAPITAS and all of its stakeholders including customers, suppliers, staff and shareholders. He would also like to introduce more products into the firm’s range of supplies. Mr Campbell sees ICT as a useful tool in his expansion plans. He wishes to make better use of current ICT facilities at USAPITAS, and he also wishes to harness the use of the internet to better effect for USAPITAS. The firm has recently lost its IT manager and you have been promoted into his post.
Mr Campbell has asked you to look at the existing IT facilities in use at USAPITAS. He is unhappy with the information being provided to him and his staff. He would like you, as the new IT manager, to provide better data from existing data sources, and make better use of the internet in various areas within the firm.
In part 1 of this task you will be expected to provide data from an existing database, which contains some sales information. The data contained within the database is accurate but poorly presented. Your task will be to use the database provided to produce some queries and reports, which should be available for staff to use with the minimum level of IT expertise. In carrying out this task you should note that current sales staff have varying degrees of IT skills.
In part 2 of this task you will be asked to use software to support analysis of the financial performance of USAPITAS. You will be provided with current data which should be used for test purposes. Again, as above, you must take account of the fact that staff using your solutions may not be very familiar with IT.
In part 3 of this task you will be asked to produce a newsletter for staff which will increase their awareness of the internet and its benefits for USAPITAS. This newsletter will also contain staff development and training information.
參考答案:个案研究: USAPITAS 公司
背景数据
USAPITAS 是食物和饮料供应者。 USAPITAS 从在全世界购买各种不同的不同特制饮料和食物。 现在和来自 12个国家的达到 29个不同的供应者的坚定交易。USAPITAS 购买达到来自这些供应者的 70种不同的产品, 而且卖到在 10个不同的国家中的 24个不同的公司。
当它开始卖对零售业的大量茶和咖啡的时候，公司已经自从 1956 以后进行贸易。 公司是一个私人的有限公司。
USAPITAS 现在正在遭受一些结构的变化和坎贝尔先生,售卖指导者, 正在寻求在组织里面在售卖的区域中达成效率增益。 坎贝尔先生愿增加 USAPITAS 的客户基础。 最初这将会包括检讨现在的国家，公司正在进行贸易在, 但是最后应该导致扩充进其他的国家。 坎贝尔先生想要见到在 USAPITAS 和包括客户，供应者，职员和股东的它所有的保管赌注的人之间的沟通进步。 他也会喜欢引导较多的产品进入公司的补给范围。 坎贝尔先生视 ICT 为他的扩充计划的一个有用的工具。 他愿比较好的利用在 USAPITAS 的现在 ICT 设备，而且他也愿为 USAPITAS 束以马具对比较好的效果英特网的使用。 公司最近已经遗失它的资讯科技经理，而且你已经进入他的职位之内被促进。
坎贝尔先生已经要求你在 USAPITAS 在使用中审查现有的资讯科技设备。 他对对他和他的职员被提供的数据感到不快乐。 他想要你,如新的资讯科技经理, 在公司里面提供来自现有的数据来源的较好数据, 而且在各种不同的区域中比较好的利用英特网。
在这一件工作的部份 1 中你将会被期望提供来自一个现有的数据库的数据,这包含一些售卖数据。 在数据库里面被包含的数据是正确的但是身体不舒服的呈现。 你的工作将会是使用被提供生产一些疑问和报告的数据库,这应该可用来使用最小程度的资讯科技专长的职员。在实行这一件工作方面你应该注意现在的售卖设置职员有改变资讯科技技术的程度。
在这一件工作的部份 2 中你将会被要求使用软件支援 USAPITAS 的财政表现的分析。 你将会具有应该作为测试目的的现在数据。 再一次，如上方，你一定考虑使用你的解决职员不可能对资讯科技感到很熟悉的事实。
在这一件工作的部份 3 中你将会被要求为将会为 USAPITAS 增加对英特网和它的利益他们的注意职员生产一个时事通讯。 这一个时事通讯也将会包含职员发展和训练数据。
