a. Calculate the average aggregate inventory value. b. Calculate the inventory turnover. c. The grocery store operates 52 weeks per year. Calculate the weeks of supply.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter4: Job Order Costing
Section: Chapter Questions
Problem 6EA: Logo Gear purchased $2,250 worth of merchandise during the month, and its monthly income statement...
icon
Related questions
Topic Video
Question

a. Calculate the average aggregate inventory value.
b. Calculate the inventory turnover.
c. The grocery store operates 52 weeks per year. Calculate the weeks of supply.
d. The weekly average inventory listed above cannot change much since the grocery store is limited in storage capacity, and can therefore assumed to remain constant over time. The store has calculated that having less than 3 weeks of supply will create problems keeping stock available for clients. What annual cost of goods sold will bring about this condition (3 weeks of supply)?
e. The grocery store is increasingly popular and management has calculated that, on average, the cost of goods sold increase by $5 million per year, reflecting better sales. How many years will it take for the grocery store to require expansion?

The following data was collected for a grocery store:
Annual cost of goods sold $30 500 000
$ 700 000
$ 500 000
$ 70 000
$ 900 000
$ 825 000
$ 475 000
$ 150 000
$ 50 000
$ 275 000
$ 22 000
$1 000
S 13 000
Meats
Fish
Fresh Produce
Canned goods
Dry goods
Bottled goods
Cleaning supplies
Dairy
Pharmaceutical
Clothing
Bakery
Other
The store believes the above figures represent the weekly average inventory for each category.
Transcribed Image Text:The following data was collected for a grocery store: Annual cost of goods sold $30 500 000 $ 700 000 $ 500 000 $ 70 000 $ 900 000 $ 825 000 $ 475 000 $ 150 000 $ 50 000 $ 275 000 $ 22 000 $1 000 S 13 000 Meats Fish Fresh Produce Canned goods Dry goods Bottled goods Cleaning supplies Dairy Pharmaceutical Clothing Bakery Other The store believes the above figures represent the weekly average inventory for each category.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
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, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,