Question

Bill Johnson is the materials manager at Bill’s Electric in Lexingoton, Kentucky. Bill is looking for...

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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
Bill Johnson is the materials manager at Bill’s Electric in Lexingoton, Kentucky. Bill is looking for...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Chuck Conlon is the materials manager at Spencer Electric in Muncie, Indiana. Chuck 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 ra...

    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...

    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...

    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...

    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...

    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...

    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....

    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....

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT