Cost Management 6th Edition by Edward Blocher,David Stout ,Paul Juras,Gary Cokins

Exercise 37

Relevant Cost Analysis-Conversion to JIT As part of its commitment to quality, the J. J. Borden manufacturing company is proposing to introduce just-in-time (JIT) production methods. Managers of the company have an intuitive feel regarding the financial benefits associated with a change to JIT, but they would like to have some data to inform their decision making in this regard. You are provided with the following data:
Required You have been asked, in conjunction with your position as the management accountant for the company, to construct an Excel spreadsheet that can be used to estimate the financial benefits associated with the adoption of JIT.