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.
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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5f799239-bf75-4c8c-a88f-30febcc0c4a0%2F767d223b-98d8-4b15-94d4-3c3cdaebb68d%2Facovu8e_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)