Scribd
Upload
11 views2 pages

Forecast TMC

The document provides a monthly overview of starting inventory, shipments, production, and ending inventory for the years 2013 and 2014. It includes specific figures for each month, along with mean error (ME) and mean absolute percentage error (MAPE) calculations. Additionally, it presents a summary of the data with mean squared error (MSE) values.

Uploaded by

fuchiball bol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views2 pages

Forecast TMC

The document provides a monthly overview of starting inventory, shipments, production, and ending inventory for the years 2013 and 2014. It includes specific figures for each month, along with mean error (ME) and mean absolute percentage error (MAPE) calculations. Additionally, it presents a summary of the data with mean squared error (MSE) values.

Uploaded by

fuchiball bol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Month/ Year January February March April May June

2013
Starting 120,816.00 125,871 120,415 132,696 125,386 124,197
Shipped 26,203 33,738 18,977 40,057 33,429 18,070
Production 31,258 28,281 31,258 32,747 32,240 29,770
Ending 125,871 120,415 132,696 125,386 124,197 135,897

2014
Starting 125,767 131,395 126,075 139,201 132,010 130,192
Shipped 27,135 34,962 19,637 41,514 34,581 18,685
Production 32,763 29,642 32,763 34,323 32,763 32,763
Ending 131,395 126,075 139,201 132,010 130,192 144,269
ME MAPE
1,012 3.17%
January 26,203
February 33,738
March 18,977
April 40,057
May 33,429
June 18,070
July 47,283
August 1,852
September 42,170
October 30,419
November 32,223
December 22,894
January 27,135 26,203 932 0.034346785
February 34,962 33,738 1,224 0.035009439
March 19,637 18,977 660 0.033610022
April 41,514 40,057 1,457 0.035096594
May 34,581 33,429 1,152 0.033313091
June 18,685 18,070 615 0.032914102
July 48,953 47,283 1,670 0.034114355
August 1,838 1,852 (14) 0.007616975
September 43,675 42,170 1,505 0.034459073
October 31,457 30,419 1,038 0.032997425
November 33,346 32,223 1,123 0.033677203
December 23,677 22,894 783 0.033070068
27,135
July August September October November December

135,897 121,361 141,836 129,436 131,764 127,822


47,283 1,852 42,170 30,419 32,223 22,894
32,747 22,327 29,770 32,747 28,281 20,839
121,361 141,836 129,436 131,764 127,822 125,767

144,269 129,639 149,643 138,731 141,597 136,333


48,953 1,838 43,675 31,457 33,346 23,677
34,323 21,842 32,763 34,323 28,082 23,402
129,639 149,643 138,731 141,597 136,333 136,058
MSE
1,219,697

868,624
1,498,176
435,600
2,122,849
1,327,104
378,225
2,788,900
196
2,265,025
1,077,444
1,261,129
613,089

You might also like