Bill Johnson is the materials manager at Bill’s Electric in Lexingoton, Kentucky. Bill is looking for ways to reduce inventories. A recent statement shows the following inventories: raw materials, $5,127,400; work-in-process, $6,432,000; and finished goods, $3,587,200. This year’s cost of goods sold will be about $34.7 million. Assume 52 business weeks per year. Answer following two questions: Show work
1A. What is the raw material inventory
1B. What is work in process inventory
1C. What is the finished goods inventory
1D. Average aggregate inventory value is
1E. Weekly sales is
1F. Express total inventory as weeks of supply.
1G. Express total inventory as Inventory turns.
Raw material inventory =$5,127,400
Work in process inventory =$6,432,000
Finished goods = $3,587,200
Average aggregate inventory value = Sum of above 3 = $5,127,400+$6,432,000+$3,587,200 =$15146600
Weekly sales = 34700000 / 52 = $667307.7
Weeks of Supply Total aggregate inventory / Weekly sales = 15146600 / $667307.7 = 22.70 weeks
Inventory turns = Cost of Sales / Total aggregate inventory =34700000 / 15146600 = 2.29 turns
Bill Johnson is the materials manager at Bill’s Electric in Lexingoton, Kentucky. Bill is looking for...
Chuck Conlon is the materials manager at Spencer Electric in Muncie, Indiana. Chuck is looking for ways to reduce inventories. A recent statement shows the following inventories: raw materials, $5,127,400; work-in-process, $6,432,000; and finished goods, $3,587,200. This year’s cost of goods sold will be about $34.7 million. Assume 50 business weeks per year. A. What is the raw material inventory B. What is the finished goods inventory C. What is work in process inventory D. Average aggregate inventory value is ...
Question Help Jack Jones, the materials manager at Precision Enterprises, is beginning to look for ways to reduce inventories. A recent accounting statement shows that the inventory investment for raw materials is $3,976,600, for work-in-process is $6,622,000, and for finished goods is $2,883,000. This year's cost of goods sold will be about $25,324,000. Assume that there are 52 business weeks per year. a. Express total inventory as weeks of supply. The weeks of supply isweeks. (Enter your response rounded to...
The Devon Motor Company produces automobiles. On April 1st the company had no beginning inventories and it purchased 6,950 batteries at a cost of $125 per battery. It withdrew 6,400 batteries from the storeroom during the month. Of these, 100 were used to replace batteries in cars being used by the company's traveling sales staff. The remaining 6,300 batteries withdrawn from the storeroom were placed in cars being produced by the company. Of the cars in production during April, 90...
The Devon Motor Company produces automobiles. On April 1st the company had no beginning inventories and it purchased 6,950 batteries at a cost of $125 per battery. It withdrew 6,400 batteries from the storeroom during the month. Of these, 100 were used to replace batteries in cars being used by the company's traveling sales staff. The remaining 6,300 batteries withdrawn from the storeroom were placed in cars being produced by the company. Of the cars in production during April, 90...
The Devon Motor Company produces automobiles. On April 1st the company had no beginning inventories and it purchased 6,290 batteries at a cost of $95 per battery. It withdrew 5,800 batteries from the storeroom during the month. Of these, 100 were used to replace batteries in cars being used by the company's traveling sales staff. The remaining 5,700 batteries withdrawn from the storeroom were placed in cars being produced by the company. Of the cars in production during April, 90...
Exercise 1-12 Product and Period Cost Flows [LO1-3] The Devon Motor Company produces automobiles. On April 1st the company had no beginning inventories and it purchased 6,950 batteries at a cost of $125 per battery. It withdrew 6,400 batteries from the storeroom during the month. Of these, 100 were used to replace batteries in cars being used by the company’s traveling sales staff. The remaining 6,300 batteries withdrawn from the storeroom were placed in cars being produced by the company....
Saddleback Company makes camping lanterns using a single
production process. All direct materials are added at the beginning
of the manufacturing process. Information for the month of March
follows:
Units
Costs
Beginning work in process (30% complete)
121,300
Direct materials
$
199,000
Conversion cost
351,000
Total cost of beginning work in process
$
550,000
Number of units started
250,000
Number of units completed and transferred to finished
goods
335,500
Ending work in process (65% complete)
?
Current period costs
Direct...
Sandia Corporation manufactures metal toolboxes. It adds all materials at the beginning of the manufacturing process. The company has provided the following information: Costs Units 43,000 $ 45,000 86,000 $131,000 Beginning work in process (28% complete) Direct materials Conversion cost Total cost of beginning work in process Number of units started Number of units completed and transferred to finished goods Ending work in process (55% complete) Current period costs Direct materials Conversion cost Total current period costs 67,000 ? 73,000...
Sandia Corporation manufactures metal toolboxes. It adds all materials at the beginning of the manufacturing process. The company has provided the following information: Costs Units 37,000 $ 40,000 87,000 $127,000 70,000 Beginning work in process (28% complete) Direct materials Conversion cost Total cost of beginning work in process Number of units started Number of units completed and transferred to finished goods Ending work in process (51% complete) Curren period costs Direct materials Conversion cost Total current period costs ? 73,000...
Description: You are consulting for the Kentucky Truck Plant Manager, Fergie Ferguson. Fergie is considering automating a major portion of the manufacturing process. She has provided you with as much data as she has. She has asked for to help her to determine which alternative, status quo or automation, will enhance the profitability of her plant. Fergie is also concerned that the automated process might change the end-of-year planned Raw Material, Work-in-Process, and Finished Goods inventory that will be on...