Question
(Forecasting inventories) Findlay Instruments produces a complete line of medical instruments used by plastic surgeons and has experienced rapid growth over the past 5 years.
(Forecasting inventories)
Findlay Instruments produces a complete line of medical instruments used by plastic surgeons and has experienced rapid growth over the past 5 years. In an effort to make more accurate predictions of its financing requirements, Findlay is currently attempting to construct a financial-planning model based on the percent of sales forecasting method. However, the firm's chief financial analyst (Sarah Macias) is concerned that the projections for inventories will be seriously in error. She recognizes that the firm has begun to accrue substantial economies of scale in its inventory investment and has documented this fact in the following data and calculations:
YEAR | SALES ($000) | INVENTORY ($000) | % OF SALES |
| |
2011 | $16,000 | $1,230 | 7.69% | ||
2012 | 19,000 | 1,250 | 6.58% | ||
2013 | 18,500 | 1,240 | 6.70% | ||
2014 | 21,000 | 1,260 | 6.00% | ||
2015 | 26,000 | 1,300 | 5.00% | ||
Average 6.39% | |||||
(Click on the icon located on the top-right corner of the data table above in order to copy its contents into aspreadsheet.) |
.
a. Plot Findlay's sales and inventories for the past 5 years. What is the relationship between these two variables?
b. Estimate firm inventories for 2016, when firm sales are projected to reach $40 million. Use the average percentage of sales for the past 5 years, the most recent percentage of sales, and your evaluation of the true relationship between the sales and inventories from part (a) to make three predictions.
a. Findlay's sales and inventory balances for the past 5 years are plotted in the figure below.
10000150002000025000300003500040000100011001200130014001500Sales ($000)Inventory ($000)
x y graph
Press Continue to see more.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started