Case Study-
Capacity allocation problem for
customer orders in K Company
個案研討
個案研討
個案研討
個案研討 K 公司客戶訂單產能配置問題
公司客戶訂單產能配置問題
公司客戶訂單產能配置問題
公司客戶訂單產能配置問題
Author: 黃秀娟
黃秀娟
黃秀娟
黃秀娟 (Livia Huang)
Class: 2nd year of IMBA
Student ID: M9802167
Course: Business Case Study
Instructor: Dr. Yvonne Han
Department: International MBA
Academic Year: Semester 2, 2010-2011
Case Study- Capacity allocation problem for customer orders in K Company
I.
ABSTRACT
Nowadays, the environment of integrated-circuit (IC) high-tech industries is highly competitive. How to make quick responses and effective decisions is crucial to maintaining company’s competitive advantages. Due to the highly expensive equipment and low profits in IC testing industry, most IC testing companies have no intension to purchase more test machines and expand testing capacity. Hence, how to provide a satisfactory capacity allocation plan using limited testing machines to meet customer orders demand is a challenging task. In order to make a capacity allocation plan timely and quickly, it is necessary to provide a set of formulas for measuring the required test machines given a batch of customer orders and analyze profitability and priority of different customers because test machines are limited and demand is changeable, as well as each customer order requires specific test machines and cycle times. For most IC testing companies, it is imperative to give a reply of available to promise for customer orders in order to manage better customer relationship and keep long-term cooperation.
In this case study, five criteria, including completion rate of customer order, contribution rate of total revenue, price of customer order, customer loyalty, and customer potential, for evaluating the profitability and priority of customers are proposed. Then Analytical Hierarchy Process (AHP) is used to analyze and rank priority for each customer.
Next, an order capacity allocation system is developed based on a set of formulas for measuring the required test machines given a batch of customer
Case Study- Capacity allocation problem for customer orders in K Company
orders and the obtained priority of customers along with the idea of available to promise (ATP) for IC testing industry. The development of this system also considers the limited conditions of capacity, such as test machine types, quantity, and product types, and customer orders available. The developed order capacity allocation system can comply with customer demand to provide available-to-promise information for sales and operations cooperation in addition to the quick response to customer demand.
The contributions of this case study are as follows:
(1) Apply AHP methodology to prioritize customers using the proposed criteria;
(2) Develop an order capacity allocation system to provide available-to-promise information.
Keywords: Analytical hierarchy process, Available to promise, Capacity measure,
IC testing.
-Case Study- Capacity allocation problem for customer orders in K Company
(1)
Case Study- Capacity allocation problem for customer orders in K Company
II.
Table of Contents
I. ABSTRACT ... 2
II. Table of Contents ... 5
III. Company Profile ... 6
IV. IC Testing Service... 8
Service in K Company ... 8
What is IC Testing Service? ... 8
V. Customer orders (Capacity) allocation problems ... 10
Customer order processing flow ... 10
Issue 1 - Sales can’t promise customer orders immediately ... 11
Issue 2 - Capacity allocation unfair ... 12
Issue 3 - Plunder / Rob capacity problem ... 13
VI. Suggestions / Solutions ... 14
Step 1: Rank priority for each customer ... 14
Step 2: Develop an order capacity allocation system... 16
VII. Conclusion ... 21
VIII. Suggestions / Solutions by Group Discussion ... 22
Group 1 ... 22
Group 2 ... 22
Case Study- Capacity allocation problem for customer orders in K Company
III.
Company Profile
Company Founded May 1, 1987
Paid-In Capital NT$ 12.8 Billion
Factories Hsin-Chu (HQ) / Chu-Nan (Factories) Sales Offices U.S.A / Japan / Singapore (S.E.A.&EU) Total Floor Space 3,277,945 Square ft (Dec. 31,2008) Total Clean Room Space 1,444,982 Square ft (Dec. 31,2008) Employees Numbers 4,500
IPO Listed in TSE May 9 , 2001
K Company was founded in 1987 and has grown to become the World
leader in developing and delivering test solutions. K Company is worth over 750 million USD off net asset and has 4 state-of-the-art facilities with over 4,500 employees located in Taiwan. To provide an immediate support to its customers, K Company also has regional offices throughout the world, covering USA, Japan,
Europe, China and Singapore.
K Company is one of the world's largest testing houses. According to the most recent data from independent sources, K Company has been ranked in the top 3 of the world's leading suppliers in testing service.
The services currently available at K Company offer are: Testing Development Engineering , Wafer Probing , Pre-assembly and Final Test. K Company provides a broad range of testing platforms and the knowledge based
Case Study- Capacity allocation problem for customer orders in K Company
engineering resources that meets the needs of many of the leading semiconductor manufacturers, IDM and IC Design Houses. More than 1,000 dedicated engineers working with the most advanced automated test equipment provide unparallel support and diversified applications. The services are available covers the full range of applications such as RF, Mixed-signal, Digital, Memory, LCD driver, CIS/CCD and SOC.
With a strong focus on IC Testing, K Company ensures that it leads the way in the highly competitive testing industry. K Company will be capable of achieving this goal by providing customers with cost-effective services and solutions using the very latest technology, experienced engineering teams and ensuring consistently high quality.
Case Study- Capacity allocation problem for customer orders in K Company
IV.
IC Testing Service
Service in K Company
At K company's Final Test it perform 100% electrical testing as per customers parameters / test program with dedicated changeover kits for a wide range of IC package.
Capability at Final Test includes small packages to high pin count and covers the following form factors: PDIP, PLCC, full SOIC range – SOP, TSOP, TSSOP, MSOP, QFP, LQFP, TQFP, QFN , BGA , LGA , CSP , SIP and certain types of modules..
Operating temperature at final test can range from -55 ° C to 150 ° C and performed in class 100 for CCD/CIS and class 10K for all packages.
What is IC Testing Service?
Case Study- Capacity allocation problem for customer orders in K Company
After packaged each piece of IC in order to double confirm and check its electrical function, it needs to do IC testing (Final testing), such as function、 speed 、power consumption、 thermal energy scatter and so on attributes.
Basically, it follows each customer specification and test program to overall test / exam its products. The Purpose is to examine IC quality if conform to customer specification and then according to the testing result to classify each IC into different grade, (ex: grade A、grade B、grade C….and downgrade). After final testing, customer can setup IC selling price according as different IC grade. Therefore, IC testing is the essential manufacture process and indispensable.
Case Study- Capacity allocation problem for customer orders in K Company
V.
Customer orders (Capacity) allocation problems
Customer order processing flow
At K Company, every month sales have to discuss with their customer to inquire the next month orders before 25th every month. K company internal calls
“forecast”. After each sale provides the forecast to TPM (the Total Productive management department) and then TPM will exchange all customer orders into capacity according to different type of testers. On beginning of each month, K Company will held a production and marketing meeting to discuss capacity allocation for each customer order. In this meeting, production managers、 production planners、sales managers、account sales and TPM all will attend the meeting to have a conclusion. After the meeting, each sales will know how many
Case Study- Capacity allocation problem for customer orders in K Company
capacity is be allocated for each customer. Therefore sales have to inform and reply his/her customer for how many orders that K Company will take.
Issue 1 - Sales can’t promise customer orders immediately
In this customer order processing flow, it has 3 problems. First problem is that when customer inquire or replace orders to K Company, sales can’t reply customer for capacity immediately. Because each month, Sales inquire / discuss with their customers for next month forecast before 25th and provide forecast to
TPM. K Company internal has to wait for TPM to exchange the customer orders into capacity. TPM have to according to each type tester’s characteristics and IC testing time to figure out each customer’s forecast into capacity(tester quantity), and then discuss the capacity allocation in the production & marketing meeting. It takes about 1 week or even longer.
Below table shows all customer orders’ capacity demand monthly. In house sets mean each type tester that K Company has. For red number in customer order demand, it means the in house tester quantity (capacity) less than customer orders demand. Therefore, in production & marketing meeting will discuss how to allocate customer orders.
Tester J7 KS KW PK PKll T35 T36 T65 T71 T77 T81 T82 T85 T88 V2 TOTAL In house Sets 1 21 3 11.5 22 12 3.5 26 14 3 25 3 5 4 13 153.00 Customer order demand (sets) 0.43 30 0.43 0.51 12 1.49 1.49 26.8 7.07 1.17 15.5 2.22 7.06 1.16 6.97 94.15
Case Study- Capacity allocation problem for customer orders in K Company
Issue 2 - Capacity allocation unfair
Another problem happens in production & marketing meeting. In the meeting, if capacity of some testers are over booking (as above table), it need to decide which customer can get the capacity. Normally, production & Sales divisions all have right to discuss how to allocate overbooking issue. But the problem is TPM division always subjective to decide the capacity allocation by his/her cognition. Even sales director can’t oppose to say NO.
For example, all of customer orders demand 30 sets of KS tester, but in house, it only has 21 sets. But TPM will allocate the capacity by cognition as below drawing.
Case Study- Capacity allocation problem for customer orders in K Company
Issue 3 - Plunder / Rob capacity problem
Some customers don’t follow the rule to booking capacity, 1 or 2 customers often don’t provide the forecast so that sales can’t book the capacity for them.
For example, when customer E wants capacity in the middle of month, they always call executive director of Company K directly to request the capacity. And then an executive director gives an order to Company K internal to make capacity for customer E. (As below drawing shows)
Case Study- Capacity allocation problem for customer orders in K Company
VI.
Suggestions / Solutions
Step 1: Rank priority for each customer
Firstly, list down all customers and then use Analytical Hierarchy Process (AHP) to analyze and rank priority for each customer.
Second, apply AHP methodology to prioritize customers by using 5 proposed criteria. And the 5 proposed criteria are including: completion rate of customer order, contribution rate of total revenue, price of customer order, customer relationship, and potential customers, for evaluating the profitability and priority of customers are proposed.
Case Study- Capacity allocation problem for customer orders in K Company
After the evaluating by AHP methodology, it can know the priority of customers. It shows as following:
Customer Synthetic Synthetic Synthetic Synthetic Weight WeightWeight Weight Customer Customer Customer Customer priority priority priority priority S 0.178 1111 U 0.152 2222 M 0.117 3333 I 0.106 4444 T 0.093 5555 F 0.090 6666 O 0.087 7777 A 0.076 8888 C 0.074 9999 J 0.028 1010 1010
Case Study- Capacity allocation problem for customer orders in K Company
Step 2: Develop an order capacity allocation system
Use Access software to develop an customer orders capacity allocation system and it must some limited rule, such as each tester type quantity in house、the limited conditions of capacity and customer priority to be the rule of exchange and allocate customer orders. And the structure of a customer orders capacity allocation system as following:
Case Study- Capacity allocation problem for customer orders in K Company
The main page of a customer orders capacity allocation system
Case Study- Capacity allocation problem for customer orders in K Company
Case Study- Capacity allocation problem for customer orders in K Company
Case Study- Capacity allocation problem for customer orders in K Company
VII.
Conclusion
The developed order capacity allocation system can comply with customer demand to provide available-to-promise information for sales and operations cooperation in addition to the quick response to customer demand.
Through an order capacity allocation system, it can make a capacity allocation plan timely、quickly and fair.
Reply the available to promise for customer orders that can manage better
Case Study- Capacity allocation problem for customer orders in K Company
VIII.
Suggestions / Solutions by Group Discussion
Beside the suggestions in above chapters, for these issues, we also discussed in class and had 3 groups to provide recommendations and solutions for these problems. Which as following:
Group 1
For problem 1, it can setup software to calculate customer orders into capacity automatic.
For problem 2 & 3, it can use 80/20 principle to sift the most important customers, because only 20% customers occupy the majority of revenue for the company. Therefore, when allocating the capacity, these 20% customers have priority to get the capacity.
If customer who is not in these 20%, it can’t get the capacity without booking or providing the forecast on time.
Group 2
If neglect the reality, for these 3 issues, we can follow the Pareto principle (also known as the 80-20 rule) which group 2 mentioned to handle.
Whatever to sort customers into: VIP / good relationship / general / unclear condition or bad reputation, for limited orders, or sales all be responsible for coordinating. These can be the methods to handle or process the capacity allocation and then to get the maximum profit.
Case Study- Capacity allocation problem for customer orders in K Company
But today the problems in practice are:
(1) In hot season, tester’s capacity is full and production planner is also allocating the capacity to maximum.
(2) The test demand which not be fulfilled in the market can’t support the testing house to increase testers/capacity.
(3) Customers can’t find second source (second vendor)
Therefore, in this cycle, production planners / division is seeking the capacity allocation in hot season, not the revenue.
Because the company revenue is hard to increase, sales division can’t follow the general sales promotion strategy to coordinate the business between customers and production line. And it results in sales can’t get the profit for K company. So, when sales get orders, all needs to follow production planners’ rule – “production full run” to be prerequisite to get company profit in hot season. And for “capacity allocate unfair” issue is also have to be put after “capacity full run”, that is because the production planner’s power is bigger than sales division and customers. And this is hard to change in semiconductor industry.
However, for Plunder / Rob capacity problem, it may affect the full-run production. This needs to consider, but if company top managers request production to dispatch/reschedule to meet production full run. That also is hard to change in this industry.
Case Study- Capacity allocation problem for customer orders in K Company
Group 3
For issue 1 & 2, it can follow first in and first out rule to allocate the capacity. Therefore, the capacity allocation will be fair for all customers.
For Issue 3: Plunder / Rob capacity problem: Sales persons do forecast for those companies who have the bad record not providing forecast to K Company. Sales representatives check the orders with their customers. If there is any volume increase or decrease, even cancel the orders. Contact with customers weekly, not monthly base. In peak season, the capacity is tight, check with customers every day.
Sales department keeps record; they should have some flexibility allow them set the testing priority for their customers. After all, sales department know more about their customers not the other departments.