Assignment 1- pg 16
.png
keyboard_arrow_up
School
Colorado Christian University *
*We aren’t endorsed by this school
Course
206A
Subject
Management
Date
Nov 24, 2024
Type
png
Pages
1
Uploaded by BrigadierMongooseMaster181
Kracker
Corp.,
Foodstuff,
Inc.,
and
Winston
Stores,
Inc.
are
three
grocery
chains
in
the
United
States.
Inventory
management
is
an
important
aspect
of
the
grocery
retail
business.
Recent
balance
sheets
for
these
three
companies
indicated
the
following
merchandise
inventory
(in
millions)
information:
Kracker
Foodstuff
Winston
Corp.
Inc.
Stores
Cost
of
merchandise
sold
$33,580.0
$34,675.0
$35,405.0
Inventory,
beginning
of
year
1,951.3
2,131.8
1,598.6
Inventory,
end
of
year
1,912.7
2,048.2
1,505.4
a.
&
b.
Determine
the
inventory
turnover
and
the
number
of
days’
sales
in
inventory
(use
365
days
and
round
to
the
nearest
day)
for
the
three
companies.
Round
all
interim
calculations
to
one decimal
place.
For
days'
sales
in
inventory,
round
final
answers
to
the
nearest
day,
and
for
inventory
turnover,
round
to
one
decimal
place.
Company
names
Inventory
Turnover
Days'
Sales
in
Inventory
Kracker
v
E]
v
days
Foodstuff
v
E]
v
days
Winston
Stores
v
v
days
c.
The
inventory
turnover
ratios
and
days’
sales
in
inventory
are
similar
v
v
for
Kracker
and
Foodstuff.
Winston
Stores
has
a
higher
v
v
inventory
turnover
and
a
lower
v
v
days’
sales
in
inventory
than
Kracker
and
Foodstuff.
These
results
suggest
that
Kracker
and
Foodstuff
are
less
v
v
efficient
than
Winston
Stores
in
managing
inventory.
d.
If
Kracker
had
Winston
Stores’
days’
sales
in
inventory,
how
much
additional
cash
flow
would
have
been
generated
from
the
smaller
inventory
relative
to
its
actual
average
inventory
position?
Round
interim
calculations
to
one
decimal
place
and
your
final
answer
to
the
nearest
million.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Perpetual Inventory Using LIFO
Beginning inventory, purchases, and sales data for DVD players are as follows:
November 1 Inventory
79 units at $63
10
Sale
63 units
15
Purchase
102 units at $67
20
Sale
57 units
24
Sale
14 units
30
Purchase
21 units at $70
The business maintains a perpetual inventory system, costing by the last-in, first-out method.
Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4.
Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER
unit cost first in the Inventory Unit Cost column.
Schedule of Cost of Goods Sold
LIFO Method
DVD Players
Quantity
Date
Purchased
Purchases
Unit Cost
Purchases
Total Cost
Quantity
Sold
Cost of Goods
Cost of Goods
Sold Unit Cost
Sold Total Cost
Inventory
Quantity
Inventory
Unit Cost
Inventory
Total Cost
Nov.
1
Nov.
10
Nov.
000…
arrow_forward
How does the Wilson approach adapt to seasonal variations in demand and inventory management?
arrow_forward
What is the role of an inventory manager?
arrow_forward
U.S. Airfilter has hired you as a supply chain consultant. The company makes air filters for residential heating and air-conditioning systems. These filters are made in a single plant located in Louisville, Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States, Canada, and Europe. You have collected the following data relating to the value of inventory in the U.S. Airfilter supply chain:
QUARTER 1 (JANUARY THROUGH MARCH)
QUARTER 2 (APRIL THROUGH JUNE)
QUARTER 3 (JULY THROUGH SEPTEMBER)
QUARTER 4 (OCTOBER THROUGH DECEMBER)
All amounts in millions of U.S. dollars
Sales (total quarter):
United states
300
350
405
375
Canada
75
60
75
70
Europe
30
33
20
15
Cost of goods sold (total quarter)
280
295
340
350
Raw materials at the Louisville plant (end-of-quarter)
50
40
55
60
Work-in-process and finished goods at the Louisville plant (end-of-quarter)
100
105
120
150
Distribution center…
arrow_forward
correct answer please
arrow_forward
Subject:- accounting
arrow_forward
Conduct a comprehensive comparative analysis between the Wilson approach and the ABC analysis method for inventory management.
arrow_forward
What are 3 potential risks associated with replacing the inventory management system, and how can they be mitigated?
arrow_forward
Watergate, Inc. uses a perpetual inventory system. It entered into the following purchases and
sales transactions. Use this information to answer the questions that follow.
Date
Watergate, Inc. Inventory
Activities
Oct. 1
Beginning Inventory
Oct. 5
Purchase
Oct. 9
Sale
Oct. 18
Purchase
Oct. 24
Sale
Details
110 units @ $20
50 units @ $22
60 units @ $40
70 units @ $25
55 units @ $40
Question 1
Watergate, Inc.: Assuming FIFO inventory method answer the following:
1. Total cost of goods sold at the end of the period.
2. Ending inventory in dollars not units at the end of the period.
3. Gross profit for the period.
Question 2
Watergate, Inc.: Assuming LIFO inventory method answer the following:
1. Total cost of goods sold at the end of the period.
2. Ending inventory in dollars not units at the end of the period.
3. Gross profit for the period.
arrow_forward
Analyze how different inventory control systems work.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Related Questions
- Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 79 units at $63 10 Sale 63 units 15 Purchase 102 units at $67 20 Sale 57 units 24 Sale 14 units 30 Purchase 21 units at $70 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Goods Sold LIFO Method DVD Players Quantity Date Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Goods Cost of Goods Sold Unit Cost Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost Nov. 1 Nov. 10 Nov. 000…arrow_forwardHow does the Wilson approach adapt to seasonal variations in demand and inventory management?arrow_forwardWhat is the role of an inventory manager?arrow_forward
- U.S. Airfilter has hired you as a supply chain consultant. The company makes air filters for residential heating and air-conditioning systems. These filters are made in a single plant located in Louisville, Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States, Canada, and Europe. You have collected the following data relating to the value of inventory in the U.S. Airfilter supply chain: QUARTER 1 (JANUARY THROUGH MARCH) QUARTER 2 (APRIL THROUGH JUNE) QUARTER 3 (JULY THROUGH SEPTEMBER) QUARTER 4 (OCTOBER THROUGH DECEMBER) All amounts in millions of U.S. dollars Sales (total quarter): United states 300 350 405 375 Canada 75 60 75 70 Europe 30 33 20 15 Cost of goods sold (total quarter) 280 295 340 350 Raw materials at the Louisville plant (end-of-quarter) 50 40 55 60 Work-in-process and finished goods at the Louisville plant (end-of-quarter) 100 105 120 150 Distribution center…arrow_forwardcorrect answer pleasearrow_forwardSubject:- accountingarrow_forward
- Conduct a comprehensive comparative analysis between the Wilson approach and the ABC analysis method for inventory management.arrow_forwardWhat are 3 potential risks associated with replacing the inventory management system, and how can they be mitigated?arrow_forwardWatergate, Inc. uses a perpetual inventory system. It entered into the following purchases and sales transactions. Use this information to answer the questions that follow. Date Watergate, Inc. Inventory Activities Oct. 1 Beginning Inventory Oct. 5 Purchase Oct. 9 Sale Oct. 18 Purchase Oct. 24 Sale Details 110 units @ $20 50 units @ $22 60 units @ $40 70 units @ $25 55 units @ $40 Question 1 Watergate, Inc.: Assuming FIFO inventory method answer the following: 1. Total cost of goods sold at the end of the period. 2. Ending inventory in dollars not units at the end of the period. 3. Gross profit for the period. Question 2 Watergate, Inc.: Assuming LIFO inventory method answer the following: 1. Total cost of goods sold at the end of the period. 2. Ending inventory in dollars not units at the end of the period. 3. Gross profit for the period.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning