Question
Windsor Company sells two types of pumps. One is large and is for commercial use. The other is smaller and is used in residential swimming
Windsor Company sells two types of pumps. One is large and is for commercial use. The other is smaller and is used in residential swimming pools. The following inventory data is available for the month of March.
Units | Price per Unit | Total | ||||||||||
Residential Pumps | ||||||||||||
Inventory at Feb. 28: | 216 | $ | 432 | $ | 93,312 | |||||||
Purchases: | ||||||||||||
March 10 | 540 | $ | 486 | $ | 262,440 | |||||||
March 20 | 432 | $ | 513 | $ | 221,616 | |||||||
March 30 | 324 | $ | 540 | $ | 174,960 | |||||||
Sales: | ||||||||||||
March 15 | 540 | $ | 583 | $ | 314,820 | |||||||
March 25 | 432 | $ | 616 | $ | 266,112 | |||||||
Inventory at March 31: | 540 | |||||||||||
Commercial Pumps | ||||||||||||
Inventory at Feb. 28: | 648 | $ | 864 | $ | 559,872 | |||||||
Purchases: | ||||||||||||
March 3 | 648 | $ | 972 | $ | 629,856 | |||||||
March 12 | 324 | $ | 1,026 | $ | 332,424 | |||||||
March 21 | 540 | $ | 1,080 | $ | 583,200 | |||||||
Sales: | ||||||||||||
March 18 | 972 | $ | 1,166 | $ | 1,133,352 | |||||||
March 29 | 648 | $ | 1,231 | $ | 797,688 | |||||||
Inventory at March 31: | 540 |
In addition to the above information, due to a downturn in the economy that has hit Windsors commercial customers especially hard, Windsor expects commercial pump prices from March 31 onward to be considerably different (and lower) than at the beginning of and during March. Windsor has developed the following additional information.
Commercial Pumps | Residential Pumps | |||
Net realizable value (per unit) | $972 | $626 |
The normal profit margin is 16.67% of cost. Windsor uses the FIFO accounting method.
Determine the dollar amount that Windsor should report on its March 31 balance sheet for inventory. Assume Windsor applies lower-of-cost-or-net realizable value at the individual product level.
Total amount of inventory | ? $ |
eTextbook and Media
Determine the dollar amount that Windsor should report on its March 31 balance sheet for inventory. Assume Windsor applies lower-of-cost-or-market at the major category level. Windsor places both commercial and residential pumps into the same (and only) category.
Total amount of inventory | ? $ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started