6-3 - Excel Templates Exercise 6-3 Part a specific...

Info icon This preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Templates Exercise 6-3 Part a specific identification Purchases Sales (at cost) Date Units Unit Cost Total Cost Units Unit Cost Units Jan. 1 Beginning inventory: 75 $ 12.00 $ 900.00 75 jan. 10 70 $ 12.00 $ 840.00 5 mar. 19 250 $ 13.00 $ 3,250.00 5 mar.25 3 $ 12.00 $ 30.00 3 177 $ 13.00 $ 2,301.00 2 july.30 500 $ 14.00 $ 7,000.00 73 oct. 5 50 $ 13.00 $ 650.00 2 400 $ 14.00 $ 5,600.00 70 50 2 23 100 total 825 $ 11,150.00 700 $ 9,427.00 125 Cost of goods available for sale = Cost of goods sold + E Cost of Goods Sold
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Balance Unit Cost Total Cost $ 12.00 $ 700.00 $ 12.00 $ 60.00 $ 12.00 $ 60.00 $ 13.00 $ 5,250.00 $ 12.00 $ 2,600.00 $ 13.00 $ 949.00 $ 12.00 $ 26.00 $ 13.00 $ 999.00 $ 14.00 $ 7,000.00 $ 12.00 $ 26.00 $ 13.00 $ 299.00 $ 14.00 $ 1,400.00 888888kklle $ 1,725.00 Ending inventory
Image of page 2
Excel Templates Exercise 6-2 Part b Moving Weighted Average Purchases
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern