Contents
Introduction: 2
Inventory Stock 2
Management Information System 11
Inventory Stock 12
Material Requirements Planning 16
Project Plan 19
Investment Appraisal Techniques 21
Conclusion: 22
Conference list 24
Introduction:
Gia Hoang Company Ltd is located HCMC which manufactures and sells range of personal computers in Dong Nai industries park. In 2005, the company sells their products locally and also exports its products to foreign markets especially in the South East Asia. The company has provided many services such as design, run project in IT as well as management for public and private companies in Vietnam. On the other hand, Gia Hoang also wanted to create a good reputation and the best company and building effective solution and technology applications related to IT and Services. So, they also want to plan to make further management decisions.
As a result, this report will provide forecasting techniques about sales, management information systems, inventory control, material requirements planning, project plan, and investment appraisal techniques for Gia Hoang Company. These tools would help Gia Hoang Company run and business efficiently and successfully, to complete with a fierce market.
Inventory Stock
Quarterly sales data, in thousands units, from the past 5 years are provided as follow:
Forecast for sales in 2011 through the least squares regression analysis
According to Carl Friedrich Gauss (1974), “the least squares correspond to the maximum likelihood criterion if the experimental errors have a normal distribution and can also be derived as a method of moment’s estimator.”
From data above, we have the table and scatter diagram as follow:
Years
Quarter
No. years
X
2006
Q1
96
Q2
1
92
Q3
2
54
Q4
3
90
2007
Q1
4
104
Q2
5
96
Q3
6
64
Q4
7
100
2008
Q1
8
108
Q2
9
110
Q3
10
84
Q4
11
104
2009
Q1
12
100
Q2
13
108
Q3
14
74
Q4
15
92
2010
Q1
16
110
Q2
17
100
Q3
18
72
Q4
19
100
The form y = a + bx is the equation a straight line, where x and y are related variation, a is the intercept of the line on the vertical axis, and b is the gradient of the line.
After calculating on spreadsheet, the equation of straight line is y = 0.4707x + 88.429 with the first quarter of 2006 where x = 0, the second quarter of 2006 where x = 1…to the five quarter of 2010 where x = 19
Combining with the trend line, forecast sales for 2011 as the following table:
Year
Quarter
No.
Trend
Y = S+T
2010
Quarter 1
16
93,750
