Limagrain Seed Company has grown rapidly over the last decade and is trying to forecast the firm’s inventory requirements for the next 5 years. Historical sales and inventories for the last 10 years are found below, along with project sales for the next 5 years.

a. Use the percent of sales method for forecasting Limagrain’s inventories for the next 5 years if the percent of sales is equal to the average of the percent of sales for the last 10 years.

b. The following graph includes a plot of the historical relationship between inventories and sales along with a line representing the percent of sales forecast. Analyze the forecast line compared to the plot of inventory and sales to see if you see any problems with the percent of sales forecast. Discuss.

Transcribed Image Text:

YEAR SALES INVENTORIES 2009 $5,250,000 $1,580,942 2010 6,230,000 1,754,251 2011 6,930,000 1,845,355 2012 5,750,000 1,545,656 2013 6,235,000 1,755,245 2014 7,102,000 1,915,254 2015 7,344,000 2,011,025 2016 8,012,000 2,005,487 2017 8,705,000 2,245,269