Bahati Masimba Ltd are retailers who sell tiles. During the month of July to September 2019, there were price fluctuations. Due to the above problem the company had to adjust its selling prices. The following transactions took place during the period; July 3 Opening stock was 5,000 tiles valued at Sh.825,000 July 10 Orders placed with the company increased, so extra tiles had to be obtained from Mombasa. Therefore 22,000 tiles were purchased at a cost of Sh.140 each but in addition there was freight and insurance charges of Sh.5 per tile July 31 During the month 20,000 tiles were sold at a price of Sh.220 each August 4 A new batch of 14,000 tiles was purchased at a cost of Sh.175 per tile August 30 The sales for the month of August were 14,000 tiles at a selling price of Sh.230 each September 1 A further 24,000 tiles were purchased at a cost of Sh.195 each September 30 A total of 27,000 tiles were sold during September at price of Sh.240 each Required: a) A stores ledger account using weighted average method b) A stores ledger account using First in First out method c) A stores ledger account using Last in First out method d) Ascertain the gross profit of the company for the period under the above methods

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter7: Inventory Cost Flow Assumptions (fifolifo)
Section: Chapter Questions
Problem 9R: Click the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a...
icon
Related questions
Topic Video
Question

Bahati Masimba Ltd are retailers who sell tiles. During the month of July to September 2019, there were price fluctuations. Due to the above problem the company had to adjust its selling prices. The following transactions took place during the period;
July 3 Opening stock was 5,000 tiles valued at Sh.825,000
July 10 Orders placed with the company increased, so extra tiles had to be obtained from
Mombasa. Therefore 22,000 tiles were purchased at a cost of Sh.140 each but in
addition there was freight and insurance charges of Sh.5 per tile
July 31 During the month 20,000 tiles were sold at a price of Sh.220 each
August 4 A new batch of 14,000 tiles was purchased at a cost of Sh.175 per tile
August 30 The sales for the month of August were 14,000 tiles at a selling price of Sh.230
each
September 1 A further 24,000 tiles were purchased at a cost of Sh.195 each
September 30 A total of 27,000 tiles were sold during September at price of Sh.240 each
Required:
a) A stores ledger account using weighted average method
b) A stores ledger account using First in First out method
c) A stores ledger account using Last in First out method
d) Ascertain the gross profit of the company for the period under the above methods

Expert Solution
steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College