Forecasting, Aggregate Planning, Eoq and Mrp

PART 1 : DATA

1. Product : Tenda Pramuka (Price Rp 300.000/ Unit)

2. Workers : 4 Person

3. Maximum working hours : 10 hours per day

4. Time estimated for produce 1 unit : 2,5 hours

5. Working days / month : 23 days = 230 hours / month

6. Maximum capacity / worker : 92 unit Tenda Pramuka per month per worker

7. Sewing cost : Rp 15.000 per unit Tenda Pramuka

8. Sewing cost overtime : Rp 25.000 per unit Tenda Pramuka

9. Subcontract (Min 50 Unit) : Rp 30.000 per unit Tenda Pramuka

10. Raw Material : D600DINIR, 1 Roll price = Rp 430.000,

1 Roll is for 6 Tenda Pramuka,

Raw material cost for 1 unit Tenda Pramuka :

Rp 430.000 / 6 = Rp 72.000

11. Inventory holding cost : Rp 5000

12. Hiring and training cost : Rp 500.000

13. Layoff cost : Rp 1.000.000

14. Safety stock : 10% of month demand

15. Beginning Inventory : 110 unit

|Month |Sales |Month |Sales |

|January |175 |July |260 |

|February |185 |August |280 |

|March |185 |September |300 |

|April |198 |October |300 |

|May |210 |November |290 |

|June |230 |December |260 |

16. Sales Data for year 2013 (Jan-Dec) : :

PART 2 : FORECASTING

Demand forecasting is the activity of estimating the quantity of a product or service that consumers will purchase. There is several method to forecast the demand. I use Linear Regression and Simple Moving Average method to forecast Tenda Pramuka 2014 sales/ demand.

Linear Regression Analysis :

[pic]

3-Month Moving Average :...