商业方向作业：business information system

 

论文题目：business information system 论文语言：英语论文 English 论文专业：commerce 学校国家：澳大利亚 是否有数据处理要求：否 论文用于：BA assignment 本科课程作业 补充要求和说明： MSC120 – Assignment Outline, Trimester 1, 2011 (Individual)  Due:  Tuesday, 10 May 2011 (11:59pm)  Late assignments will NOT be accepted.    Marks:   100 marks (This accounts for 30% of the total assessment of this unit)    Background: 背景： 詹姆斯·弗罗斯特先生是“蓝剪切时尚”服装店的行政总裁（ CEO ） 。该店位于墨尔本中央商场。蓝剪切（简称）专业在蓝色棉制品。蓝剪切衣服虽然样式的范围是有限的，深受青少年和年轻成年人。   虽然詹姆斯很高兴与商店的操作，他的销售经理 - 简·弗莱女士 - 建议在未来，他们可以做一个更好的工作。她认为蓝剪切管理应收集必要的数据，其业务涉及到各个方面。当然在Excel 2007中需要收集的数据进行分析和可视化，使一些商店的成功或它的缺点，将提供证据的观测。最后，应该报告给了一些建议，关于如何提高蓝剪切性能蓝剪切管理。应考虑以下几个方面的改进： •收购卖得最好的股票; •改善的销售策略; •商店交付和供应商更好地管理。 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. Of course the data collected in Excel 2007 needs to be analysed and visualised to make a number  of  observations  that  would  provide  evidence  of  the  store’s  success  or  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 the observations should help answer a number of important questions (Hint: Take the time to consider why you think these questions are of particular interest to Jane and James):    Questions  Difficulty 问题难度 什么样的运输公司的最高/最低价产品数量交付到BCF ？样品 1。什么是星期几一直是最繁忙的交付？最简单的，我们有兴趣知道交付和交付项目的总人数在每星期几的数量。 2。什么是库存中每种产品的总数量，性别，肤色和 在2010年10月1日的COB的大小？容易，我们想知道什么是性别方面的每种产品的库存水平。 3。在红枣七个BCF有最低销售数量和每个日期上销售多少？测试注意，我们想知道的确切日期，只是他们的“数字”的百分比值显示到小数点后两位。 4 。如果是卖股票中各产品类别分析，并指出用“是”或“否” 在盈利？挑战确定哪些产品库存牟利，那些不。 5 。产品风格和剪切组合，店里最少的毛利？具有挑战性的，只考虑那些风格和代表之间的BCF产品的切割组合。计算每个组合的利润总额。 6 。的COB每个产品catgory在2010年11月12日的库存量是什么？最难确定为每个产品在这个时候手头上股票的数量。 7。哪个供应商的位置是最有利可图的产品来源：本地， 州际或海外？硬确定哪些是最有利可图的电源位置源产品， BCF 。 8。运输公司的交货使大部分利润，可以投射 What transport company delivered the highest / lowest number of products to BCF?  Sample  1.  What day of the week has been the busiest for deliveries?  Easiest We are interested in knowing the number of deliveries and the total number of items delivered on each day of the week.  2.  What is the total quantity of each product in stock, with regard to gender, colour and  size at the COB on 1 Oct 2010? Easy We want to know what are the stock levels of each product with regard to gender.    3.  On which seven dates did BCF have the lowest number of sales and how many sales were made on each date? Testing Note that we want to know the exact dates not just their 'numbers' and the percentage values shown to two decimal places.  4.  Analyse each product category in stock and indicate with a "Yes" or "No" if it is selling  at a profit? Challenging Identify which products in stock are making a profit and those that are not.    5.  Which product Style and Cut combination, made the least gross profit for the store?  Challenging Consider  only  those  style  and  cut  combinations  that  are  represented  among  the  BCF  products. Calculate the gross profits for each combination as well.  6.  What is the stock level of each product catgory at the COB on 12 Nov 2010?  Hardest Determine the quantity of stock on hand for each product at this time.    7.  Which  supplier  location  is  the  most  profitable  to  source  products  from:  locally,  interstate, or from overseas? Hard Determine which is the most profitable supply location to source products from, for BCF.    8.  Which transport company's deliveries can be projected to make the most profit for the  store? Difficult Consider the product categories in stock that they deliver and the various profits.      Based on the advice from her Technical Manager, Franca De Lorenzo Jane estimates the level  of  difficulty  in  answering  each  of  the  questions  as  Easy,  Challenging,  Difficult  andHardest.  However,  the  level  of  difficulty  really  depends  on  the  approach  taken  to answering each question. It is also possible that to give a specific recommendation many other questions (not listed here) may also need to be answered.    Aims:  To write a brief report in Excel 2007 identifying and explaining your insights into the operation of the Blue Cut Fashion store.    Learning Objectives:  In the process of this assessment task you will:   •  learn to  plan,  schedule  and execute  project  tasks with a view  to  improve  your personal productivity;  •  understand  the  issues  related  to  the  operation  of  a  small-to-medium  sized business;  •  gain experience in seeking relevant information (such as Excel 2007 help);  •  apply evidence-based reasoning in problem-solving;  •  use the advanced functionality of Microsoft Excel 2007 to manipulate the sales and marketing data, analyse it and visualise it in tabular and chart form; and,  •  write a brief report of your business observations and recommendations.    Method:  Your project will involve three important phases, which will require you:  •  To use Microsoft Excel 2007 to assist your reasoning by combining, tabulating, reducing, cleansing, summarising and charting the available data.  •  To itemise and report the insights gained from your analysis in a textual format that can be easily understood by business professionals.  •  To clearly and directly reference all the reported insights referring to the evidence contained in the Excel 2007 charts and tables you have created.    Deliverables:  Your final report will be produced in the form of an Excel 2007 workbook. Its main purpose is to present your conclusions and recommendations to store management. You will base this advice on the summary information you have calculated and presented in the charts and tables generated from your data analysis.