The following is the summary of the receipts and issues of material in a Special Ice factory during December 2020. Prepare Store Ledger according to First in First Out Method. December 2020 1 Dec. Opening balance 500 units @ GH¢25 per unit 3 Dec. Issue 70 units 4 Dec. Issue 100 units 8 Dec. Issue 80 units 13 Dec. Received from supplier 200 units @ GH¢24.50 per unit 14 Dec. Returned to store 15 units @ GH¢24 per unit 16 Dec. Issue 180 units. 20 Dec. Received from supplier 240 units @ GH¢24.75 per unit 24 Dec. Issue 304 units. 25 Dec. Received from supplier 320 units @ GH¢24.50 per unit 26 Dec. Issue 112 units 27 Dec. Returned to store 12 units @ GH¢24.50 per unit 28 Dec. Received from supplier 100 units @ GH¢25 per unit

Century 21 Accounting Multicolumn Journal
11th Edition
ISBN:9781337679503
Author:Gilbertson
Publisher:Gilbertson
Chapter20: Accounting For Inventory
Section: Chapter Questions
Problem 1MP
icon
Related questions
icon
Concept explainers
Question

The following is the summary of the receipts and issues of material in a Special Ice factory during December 2020. Prepare Store Ledger according to First in First Out Method.

December 2020

1 Dec. Opening balance 500 units @ GH¢25 per unit

3 Dec. Issue 70 units

4 Dec. Issue 100 units

8 Dec. Issue 80 units

13 Dec. Received from supplier 200 units @ GH¢24.50 per unit

14 Dec. Returned to store 15 units @ GH¢24 per unit

16 Dec. Issue 180 units.

20 Dec. Received from supplier 240 units @ GH¢24.75 per unit

24 Dec. Issue 304 units.

25 Dec. Received from supplier 320 units @ GH¢24.50 per unit

26 Dec. Issue 112 units

27 Dec. Returned to store 12 units @ GH¢24.50 per unit

28 Dec. Received from supplier 100 units @ GH¢25 per unit

 

B. Two components P, Q are used as follows.

Normal usage 1000 units per week each.

Re-ordering quantity P - 20,000 units

                                 Q -  8,000 units

Re-ordering period  P - 4 to 6 weeks

                               Q - 2 to 4 weeks

The minimum usage is 2000 units per week; with their maximum usage being 3000 units per week each.

Required

You are required to calculate the following each of the components:

(i) Minimum Stock Level

(ii) Maximum Stock Level

(iii) Average Stock Level

(iv) Re-ordering Level

Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,