jfess63
Apr 18, 2007, 08:52 AM
Here is the "wording" for the problem and I've attached the spreadsheet in pdf form.
Assume the inventory in process on October 1 for th4e packing department included 1800 pounds of cereal in the packing machine hopper. In addition, there were 1,200 empty 24oz. boxes held in the package carousel of the packing machine. During October, 24000 boxes of 24oz. cereal were packaged. Conversion costs are incurred when a box is filled with cereal. On October 31, the packing machine hopper held 750 pounds of cereal, and the package carousel held 500 empty 24oz. boxes. Assume that once a box is filled with cereal, it is immediately transferred to the finished goods warehouse.
Determine the equivalent units of production for cereal, boxes and conversion costs for October.
I have attached the partially completed spreadsheet. I have tried this and tried this and just can't get it. Very frustrated - Thanks for anyone’s help!
Jill
Assume the inventory in process on October 1 for th4e packing department included 1800 pounds of cereal in the packing machine hopper. In addition, there were 1,200 empty 24oz. boxes held in the package carousel of the packing machine. During October, 24000 boxes of 24oz. cereal were packaged. Conversion costs are incurred when a box is filled with cereal. On October 31, the packing machine hopper held 750 pounds of cereal, and the package carousel held 500 empty 24oz. boxes. Assume that once a box is filled with cereal, it is immediately transferred to the finished goods warehouse.
Determine the equivalent units of production for cereal, boxes and conversion costs for October.
I have attached the partially completed spreadsheet. I have tried this and tried this and just can't get it. Very frustrated - Thanks for anyone’s help!
Jill