Relevant Cost Analysis—Conversion to JIT; Spreadsheet Application As part of its commitmen...

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.