英语论文网

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 本Assignment由代写Assignment网www.51lunwen.org提供 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
Consider both sales and deliveries in your calculation; handle correctly the 'missing' days.
7. Is it more profitable to source products locally, interstate or from overseas? Difficult
Consider only the actively used suppliers.
8. What were the problems with data provided for analysis? Diffi本论文由英语论文网提供整理，提供论文代写，英语论文代写，代写论文，代写英语论文，代写留学生论文，代写英文论文，留学生论文代写相关核心关键词搜索。