Question
In: Accounting
UpCo’s inventory data is as follows: Cases on hand Cost per case Market per case 1....
UpCo’s inventory data is as follows: Cases on hand Cost per case Market per case 1. Garden Supplies a. Snail Bait 35 $80 $75 b. Isotox 12 20 23 c. Shovels 20 100 99 2. Hardware a. Screws 20 $80 $96 b. Brackets 2 35 31 c. Nails 8 12 12 3. Paint a. Enamel -1 gal. 22 $120 $118 b. Spray Cans 15 45 54 c. Misc. Brushes 4 30 38 Calculate LCM by group: $10,082 $9,994 $10,378 $10,517 $10,241
Solutions
Expert Solution
| Computation of Upco inventory - LCM by Group | ||||||
| Particulars | Cases on hand | Cost per Case | Total Cost | Market price per case | Total Market Value | Lower of Cost or Market Value by Group |
| Garden Supplies: | ||||||
| Snail Bait | 35 | $80.00 | $2,800.00 | $75.00 | $2,625.00 | |
| Isotox | 12 | $20.00 | $240.00 | $23.00 | $276.00 | |
| Shovels | 20 | $100.00 | $2,000.00 | $99.00 | $1,980.00 | |
| Total Garden Supplies | $5,040.00 | $4,881.00 | $4,881.00 | |||
| Hardware: | ||||||
| Screws | 20 | $80.00 | $1,600.00 | $96.00 | $1,920.00 | |
| Brackets | 2 | $35.00 | $70.00 | $31.00 | $62.00 | |
| Nails | 8 | $12.00 | $96.00 | $12.00 | $96.00 | |
| Total Hardware | $1,766.00 | $2,078.00 | $1,766.00 | |||
| Paint: | ||||||
| Enamel 1 | 22 | $120.00 | $2,640.00 | $118.00 | $2,596.00 | |
| Spray Cans | 15 | $45.00 | $675.00 | $54.00 | $810.00 | |
| Misc Brush | 4 | $30.00 | $120.00 | $38.00 | $152.00 | |
| Total Paint | $3,435.00 | $3,558.00 | $3,435.00 | |||
| Grand Total | $10,082.00 | |||||
Hence first option is the right choice.
ekkarill92 answered 9 months agoRelated Solutions
Lower-of-Cost-or-Market Inventory On the basis of the following data: Product Inventory Quantity Cost per Unit Market...
Lower-of-Cost-or-Market Inventory
On the basis of the following data:
Product
Inventory
Quantity
Cost per
Unit
Market Value per Unit
(Net Realizable Value)
Model A
13
$198
$223
Model B
42
63
56
Model C
36
126
144
Model D
13
241
237
Model E
33
144
152
Determine the value of the inventory at the lower of cost or
market. Assemble the data in the form illustrated in Exhibit 9.
Inventory at the Lower of Cost or Market
Product
Total...
Lower-of-Cost-or-Market Inventory On the basis of the following data: Product Inventory Quantity Cost per Unit Market...
Lower-of-Cost-or-Market Inventory
On the basis of the following data:
Product
Inventory
Quantity
Cost per
Unit
Market Value per Unit
(Net Realizable Value)
Model A
12
$106
$102
Model B
45
84
70
Model C
36
254
243
Model D
31
85
88
Model E
41
132
148
Determine the value of the inventory at the lower of cost or
market. Assemble the data in the form illustrated in Exhibit 9.
Inventory at
the Lower of Cost or Market
Product
Total...
Lower-of-Cost-or-Market Inventory Data on the physical inventory of Ashwood Products Company as of December 31 follows:...
Lower-of-Cost-or-Market Inventory
Data on the physical inventory of Ashwood Products Company as of
December 31 follows:
Description
Inventory
Quantity
Unit Market
Price
B12
38
$ 57
E41
18
180
G19
33
126
L88
18
550
N94
400
7
P24
90
18
R66
8
250
T33
140
20
Z16
15
752
Quantity and cost data from the last purchases invoice of the
year and the next-to-the-last purchases invoice are summarized as
follows:
Last
Purchases Invoice
Next-to-the-Last
Purchases Invoice
Description
Quantity
Purchased...
Lower-of-Cost-or-Market Inventory Data on the physical inventory of Katus Products Co. as of December 31 follows:...
Lower-of-Cost-or-Market Inventory
Data on the physical inventory of Katus Products Co. as of
December 31 follows:
Inventory
Item
Inventory
Quantity
Market Value per Unit
(Net Realizable Value)
A54
37
$ 56
C77
24
178
F66
30
132
H83
21
545
K12
375
5
Q58
90
18
S36
8
235
V97
140
20
Y88
17
744
Quantity and cost data from the last purchases invoice of the
year and the next-to-the-last purchases invoice are summarized as
follows:
Last
Purchases Invoice
Next-to-the-Last...
Lower-of-Cost-or-Market Method On the basis of the following data: Item Inventory Quantity Cost per Unit Market...
Lower-of-Cost-or-Market MethodOn the basis of the following data: $$ \begin{array}{lccc} \text { Item } & \text { Inventory Quantity } & \text { Cost per Unit } & \begin{array}{l} \text { Market Value per Unit } \\ \text { (Net Realizable Value) } \end{array} \\ \hline \text { JFW1 } & 6,330 & \$ 10 & \$ 11 \\ \text { SAW9 } & 1,140 & 36 & 34 \end{array} $$Determine the value of the inventory at the lower-of-cost-or-market by applying...
1. Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory...
1. Lower-of-Cost-or-Market Inventory
On the basis of the following data, determine the value of the
inventory at the lower of cost or market. Assemble the data in the
form illustrated in Exhibit 9.
Inventory
Item
Inventory
Quantity
Cost per
Unit
Market Value per Unit
(Net Realizable Value)
Birch
43
$244
$231
Cypress
15
68
58
Mountain Ash
37
230
245
Spruce
49
151
170
Willow
43
113
111
Inventory at the Lower of Cost or Market
Inventory Item
Total Cost...
The following pertain to the cost of H’s only inventory item: Inventory on hand, January 1 &
The following pertain to the cost of H’s only inventory
item:
Inventory on hand, January
1 295
units @ $50 per unit
Purchases, January
12 590
units @ $88 per unit
Purchases, January
20 450
units @ $91 per unit
Purchases, January
31 300
units @ $93 per unit
1,635
Sales, January
5 75
units @ $200 per unit
Sales, January
15 350
units @ $200 per unit
Sales, January
22 550
units @ $200 per unit
Sales, January
30 140
units @ $200 per unit
1,115 (1,115
x...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at...
Lower-of-Cost-or-Market Inventory
On the basis of the following data, determine the value of the
inventory at the lower of cost or market. Assemble the data in the
form illustrated in Exhibit 10.
Product
Inventory
Quantity
Cost Per
Unit
Market Value per Unit
(Net Realizable Value)
Class 1:
Model A
19
$299
$295
Model B
23
78
86
Model C
44
237
241
Class 2:
Model D
9
78
83
Model E
9
244
228
a. Determine the value of the...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at...
Lower-of-Cost-or-Market Inventory
On the basis of the following data, determine the value of the
inventory at the lower of cost or market. Assemble the data in the
form illustrated in Exhibit 10.
Product
Inventory
Quantity
Cost Per
Unit
Market Value per Unit
(Net Realizable Value)
Class 1:
Model A
10
$164
$144
Model B
20
253
269
Model C
47
48
33
Class 2:
Model D
26
48
37
Model E
35
49
37
a. Determine the value of the...
Lower-of-Cost-or-Market Inventory On the basis of the following data, determine the value of the inventory at...
Lower-of-Cost-or-Market Inventory
On the basis of the following data, determine the value of the
inventory at the lower of cost or market. Assemble the data in the
form illustrated in Exhibit 10.
Product
Inventory
Quantity
Cost Per
Unit
Market Value per Unit
(Net Realizable Value)
Class 1:
Model A
300
$140
$125
Model B
500
90
112
Model C
150
60
59
Class 2:
Model D
800
120
115
Model E
400
140
145
a. Determine the value of the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Holly Springs, Inc. contracted with Coldwater Corporation to have constructed a custom-made lathe. The machine was...
- You have just learned that you will have three students with disabilities in your classroom. List...
- Calendars imprints calendars with college names. The company has fixed expenses of $ 1 comma 065...
- The daily intake of calcium was measured (in milligrams) from a random sample of 16 women...
- Mount Alberta in Jasper National Park, Alberta, has an elevation of 3620 m above sea level....
- Reflect on what you have learned in this module by answering these questions: As a Human...
- Chapter 3 discusses social behavior, and some of the variables that allow humans to be “ultrasocial”...
ADVERTISEMENT