17-51 Relevant Cost Analysis—Conversion to JIT; Spreadsheet Application (25
Minutes)
Current After
Income Statement Items Situation JIT
Sales $1,350,000a$1,650,000g$300,000
Less: Costs
Direct materials 405,000b330,000h(75,000)
Direct labor 297,000c247,500i(49,500)
Notes:
aGiven
bSales × 30% = $1,350,000 × 30% = $405,000
cSales × 22% = $1,350,000 × 22% = $297,000
gGiven
hSales × 20% = $1,650,000 × 20% = $330,000
iSales × 15% = $1,650,000 × 15% = $247,500
Note to Instructor: An Excel spreadsheet solution file for this exercise is embedded
in this document. You can open the spreadsheet “object” that follows by doing the
following:
1. Right click anywhere in the worksheet area below.
2. Select “worksheet object” and then select “Open.”
3. To return to the Word document, select “File” and then “Close and return
to…” while you are in the spreadsheet mode. The screen should then return
you to the Word document.
17-36
Copyright © 2016 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill
Education.