EssyQuality提供：英国硕士作业代写，商业学exam代考、论文代写，商业学网课代修、exam代考、、exam代考、英国大学代写，ps语法使用指南，申请书代写，个人陈述指南、留学文书代写，申请之SP代写、留学生申请书代写，留学生代考、留学生exam代考、留学生代考、留学生exam代考、留学生作业代写、留学生论文作业代写，Exam代考。。。
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
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
