Question: IPC Company's CFO uses this equation, which was developed by regressing inventories on sales over the past 5 years, to forecast inventory requirements: Inventories =
IPC Company's CFO uses this equation, which was developed by regressing inventories on sales over the past 5 years, to forecast inventory requirements: Inventories = $32.0 + 0.125(Sales). The company expects sales of $400 million during the current year, and it expects sales to grow by 20% next year. What is the inventory forecast for next year? All dollars are in millions. You MUST show all work to get full credit. Any problem that cannot be calculated with a four function calculator, you must use Excel to answer those problem.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
