Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(Misusing the percent of sales method) The Caraway Seed Company has grown rapidly over the last decade and is trying to forecast the firm's inventory

(Misusing the percent of sales method) The Caraway 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 in the popup window, along with projected sales for the next 5 years.

SALES INVENTORIES

2005 5,450,000 1,480,692

2006 6,200,000 1,944,369

2007 6,940,000 1,899,147

2008 5,750,000 1,530,552

2009 6,055,000 1,956,425

2010 7,200,000 1,919,339

2011 7,450,000 1,920,914

2012 8,010,000 2,006,555

2013 8,775,000 2,102,646

2014 9,990,000 2,427,487

2015 11,300,000

2016 11,600,000

2017 12,600,000

2018 12,900,000

2019 13,600,000

a. Use the percent of sales method for forecasting Caraway'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.

Using the average of the percent of sales for the last 10 years, what are the projected inventories for 2015? $ (Round to the nearest dollar.) ANSWER:

Using the average of the percent of sales for the last 10 years, what are the projected inventories for 2016? $ (Round to the nearest dollar.) ANSWER:

Using the average of the percent of sales for the last 10 years, what are the projected inventories for 2017? $ (Round to the nearest dollar.) ANSWER:

Using the average of the percent of sales for the last 10 years, what are the projected inventories for 2018? $ (Round to the nearest dollar.) ANSWER:

Using the average of the percent of sales for the last 10 years, what are the projected inventories for 2019? $ (Round to the nearest dollar.) ANSWER:

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance Theory And Policy

Authors: Paul R. Krugman, Maurice Obstfeld, Marc J Melitz,

11th Edition

013451954X, 9780134519548

More Books

Students also viewed these Finance questions

Question

95% of what amount is $100?

Answered: 1 week ago

Question

a sin(2x) x Let f(x)=2x+1 In(be)

Answered: 1 week ago

Question

Describe key employee expectations.

Answered: 1 week ago

Question

Describe current business topics and their impact on HRM.

Answered: 1 week ago

Question

Define human resources management (HRM).

Answered: 1 week ago