個案總覽

In the process of business development, many enterprises have to deal with issues from all dimensions of operations management including inventory management, distribution management, and network design. Sichuan Telecom, a branch of China Telecom Co. Ltd, which was a Fortune Global 500 company, had achieved its highest market share in its broadband business and maintained strong growth momentum in this segment. However, there was a serious inventory management problem concerning ADSL modems, a component that most broadband users required. The problem was that Sichuan Telecom's ADSL modem inventory was either too high or insufficient. To reduce inventory costs and improve the service level, the procurement manager conducted a comprehensive analysis of the company's sales and demand forecasting, procurement and suppliers, distribution management, warehouse management, and inventory management. This case follows the procurement manager in analyzing the company's existing operational management system for ADSL modems in order to discover the cause of the inventory problem and develop an effective plan to improve operations management.

In May 2008, the business manager at Western Day Care Centre (WDCC) was considering expanding the company's services at its Emery Street location. WDCC was currently running at full capacity with a continuously growing waiting list and demand for day care services was increasing. The business manager was evaluating the financial feasibility of renovating the first-floor gymnasium and converting it into a classroom. Incorporating the care requirements and regulations under Ontario's Day Nurseries Act, she wanted to know the total cost of the renovation, as well as the amount of new revenue that would be generated and the payback period. Financial modeling in a spreadsheet, cost-benefit analysis (differential analysis), and determining the decision variables are all techniques used to determine the feasibility of the renovation.

Instructor spreadsheet for product 8B09E06.