教育学论文 旅游管理 社会学论文 广告学论文 MBA论文 会计学论文 媒体学 物流学论文 国际商务管理 金融学论文 计算机网络
返回首页

英国硕士相关作业 Business Information Systems

英国硕士论文写作需求 商务信息系统 Business Information Systems 

Trimester 1, 2010 (Individual)
Due:

All students are required to submit their Excel 2007 assignments PRIOR to that deadline. As part of this assignment you are required to satisfactorily complete two hurdle quizzes to be undertaken on MIBT portal by 28th March 2010 and 1 May 2010 respectively.

Marks: 100 marks (Accounts 30% towards total assessment in the unit)

Background
Mr James Frost is the Chief Executive Officer (CEO) of the “Blue Cut Fashion” clothing store. The store is located in the Melbourne Central shopping mall. Blue Cut (for short) specialises in blue cotton products. While the range of styles is limited, the Blue Cut clothes are popular with teenagers and young adults.

While James is quite happy with the store’s operation, his Sales Manager - Ms Jane Fry - suggests they could do a much better job in the future. She believes that the Blue Cut management should collect the necessary data related to various aspects of its business. Then the data collected in Excel 2007 needs to be analysed and visualised to make a number of observations which could provide evidence of the business success and its shortcomings. Finally, a number of recommendations 英国硕士论文on how to improve the Blue Cut performance should be reported to the Blue Cut management. The following areas of improvement should be considered:
• acquiring the best selling stock;
• improving the sales strategy; and,
• better management of the store deliveries and suppliers.

Jane suggests that observations to be made should help answer a number of important questions (Take the time to consider why you think these questions are of particular interest to Jane and James):

Questions Difficulty
What transport company delivered the highest / lowest number of products to BCF? Sample
1. How many products of each style were on hand at COB on 1 Oct 2009? Easy
Note that we are interested in all products of all product categories of a specific category style.
2. What was the $ value of all products in stock in each colour category on 1 Oct 2009? Medium
We are interested in the value for insurance purposes, i.e. its replacement cost.
3. On what seven dates did BCF sell   the highest number of products? Medium
Note that we want to know the exact dates not just their 'numbers'.
4. What product size and colour combination brings the highest / lowest profit to the store? Hardest
Consider only those size and price combinations that are represented among the BCF products.
Calculate totals for each colour and each size as well.
5. What were the estimated stock levels of products in each price range on the COB of 12 Nov 2009? Hardest
Price is Low when < $30, Medium when ≥ $30 and < $50 and High otherwise.
6. What day of the week (on average) is busiest for the store staff? Hardest



------分隔线----------------------------
UK Thesis Base Contacts

24小时在线客服

QQ:77276002

Email:77276002@qq.com

推荐内容