University Book Store Computer Purchase Program
iii) University Book Store Student Computer Purchase Program
1. Background.
The Busy Biker is a bike shop located close to Tokyo University and owned by Nomura Hideki. He began the shop 20 years ago and sell new and second hand bicycle after fixing it too. The Business grew and demand continued to increase. Nomura must determine how many bicycles he need to have in stock at every beginning of semester. Below here is the data that help Nomura to forecast and to know how accurate will it be in assisting him in his business.
2. The Busy Biker Shop Data
|Year |Bikes Sold |
|1 |225 |
|2 |313 |
|3 |475 |
|4 |408 |
|5 |792 |
|6 |806 |
|7 |899 |
|8 |953 |
|9 |1,069 |
|10 |986 |
|11 |1,098 |
|12 |1,256 |
|13 |1,178 |
|14 |1,607 |
| |12,065 |
From the data’s above, Nomura will setup an analysis using the:
• 2, 3 and 4 month Average Methods
• Weighted Average Methods (0.5 & 0.5, 0.5, 0.4 & 0.1 and 0.5, 0.3 & 0.2),
• Alpha 0.5, 0.6 & 0.7 Methods.
• Regression/Linear Trend Methods.
Justification of using above methods is:
• Try and error method due to uncertainty in economics and demand in the future, the best result for each methods will be compared each other to produce the most reliable result.
• There’s no indication that more student will be accept (next year intake) by Tokyo University next year, so the demand are based only on historical data.
• No guarantee on price increased for next year
1. Background.
The Busy Biker is a bike shop located close to Tokyo University and owned by Nomura Hideki. He began the shop 20 years ago and sell new and second hand bicycle after fixing it too. The Business grew and demand continued to increase. Nomura must determine how many bicycles he need to have in stock at every beginning of semester. Below here is the data that help Nomura to forecast and to know how accurate will it be in assisting him in his business.
2. The Busy Biker Shop Data
|Year |Bikes Sold |
|1 |225 |
|2 |313 |
|3 |475 |
|4 |408 |
|5 |792 |
|6 |806 |
|7 |899 |
|8 |953 |
|9 |1,069 |
|10 |986 |
|11 |1,098 |
|12 |1,256 |
|13 |1,178 |
|14 |1,607 |
| |12,065 |
From the data’s above, Nomura will setup an analysis using the:
• 2, 3 and 4 month Average Methods
• Weighted Average Methods (0.5 & 0.5, 0.5, 0.4 & 0.1 and 0.5, 0.3 & 0.2),
• Alpha 0.5, 0.6 & 0.7 Methods.
• Regression/Linear Trend Methods.
Justification of using above methods is:
• Try and error method due to uncertainty in economics and demand in the future, the best result for each methods will be compared each other to produce the most reliable result.
• There’s no indication that more student will be accept (next year intake) by Tokyo University next year, so the demand are based only on historical data.
• No guarantee on price increased for next year