Cost Management: A Strategic Emphasis 7th Edition by Edward Blocher,David Stout ,Paul Juras,Gary Cokins

Exercise 26

Relevant Cost Analysis-Conversion to JIT; Spreadsheet Application 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 As the management accountant for the company, construct an Excel spreadsheet that can be used to estimate the financial benefits associated with the adoption of JIT.