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):
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
Trimester 1, 2010 (Individual)
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)
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