ORIGINAL PROBLEM DATA ( 1sT Excel File): CHECK FIGURES: Units started and Completed 160,000 Conversion: \$1.27, per EU 8/31/2023 EB WIP $128,097 Supreme Manufacturing was founded over 35 years ago in East Brunswick, NJ. Supreme's Muy Refres de Tropical line of Horchata, Tamarindo, and Jamaica drinks are lovingly re-created from Latino recipes handed down through the generations. The Muy Refres de Tropical line uses only natural cinnamon, vanilla, rice, tamarind root, and hibiscus flower, and is sweetened only with all-natural cane sugar. A long-time cultural favorite, the popularity of Horchata, Tamarindo, and Jarpaicas, has exploded in recent years. This is due to both the general market's exposure to agyas frescas, and the rapid growth of the Latino market's population and buying power. The U.S. Latino population is currently growing faster than the general market with growth of 43% over the last 10 years - or 16.3% of the entire U.S. population. Along with this growth, a new awareness of the potential health dangers of processed, sugary foods has emerged across all markets. Muy Retrescga' de Tropical's, natural ingredients and real cane sugar mean they're free of fat, cholesterol, caffeine, lactose, and gluten. Supreme's Horchata, Tamarindo, and Jamaica: a naturally delicious, healthier alternative to today's sugary sodas. Each flavor is available in 64fl. oz. bottles and sold for $12 each. The first stage in the production process is carried out in the Mixing Department, which removes foreign matter from the raw materials and mixes them in the proper proportions in large vats. The company uses the FIFO method in its process costing system. Production data for the month of August appears below: Data Block: SUPREME MANUFACTURING Mixing Department For the Month Ended August 31, 2023 Production data: Units in process, beginning Units started into production Units completed \& transferred out Units in process, ending Prior Period Percent Materials Conversion 30,000 200,000 190,000 40,000 Current Period Percent Materials 10% Conversion 20% 100% 75% Cost data Work in process inventory, beginning Cost added during month: \begin{tabular}{ccc} Materials & Conversion \\ \$ 67,800 & $30,200 \end{tabular} \$ 579,000$248,900 ORIGINAL PROBLEM DATA ( 1sT Excel File): CHECK FIGURES: Units started and Completed 160,000 Conversion: \$1.27, per EU 8/31/2023 EB WIP $128,097 Supreme Manufacturing was founded over 35 years ago in East Brunswick, NJ. Supreme's Muy Refres de Tropical line of Horchata, Tamarindo, and Jamaica drinks are lovingly re-created from Latino recipes handed down through the generations. The Muy Refres de Tropical line uses only natural cinnamon, vanilla, rice, tamarind root, and hibiscus flower, and is sweetened only with all-natural cane sugar. A long-time cultural favorite, the popularity of Horchata, Tamarindo, and Jarpaicas, has exploded in recent years. This is due to both the general market's exposure to agyas frescas, and the rapid growth of the Latino market's population and buying power. The U.S. Latino population is currently growing faster than the general market with growth of 43% over the last 10 years - or 16.3% of the entire U.S. population. Along with this growth, a new awareness of the potential health dangers of processed, sugary foods has emerged across all markets. Muy Retrescga' de Tropical's, natural ingredients and real cane sugar mean they're free of fat, cholesterol, caffeine, lactose, and gluten. Supreme's Horchata, Tamarindo, and Jamaica: a naturally delicious, healthier alternative to today's sugary sodas. Each flavor is available in 64fl. oz. bottles and sold for $12 each. The first stage in the production process is carried out in the Mixing Department, which removes foreign matter from the raw materials and mixes them in the proper proportions in large vats. The company uses the FIFO method in its process costing system. Production data for the month of August appears below: Data Block: SUPREME MANUFACTURING Mixing Department For the Month Ended August 31, 2023 Production data: Units in process, beginning Units started into production Units completed \& transferred out Units in process, ending Prior Period Percent Materials Conversion 30,000 200,000 190,000 40,000 Current Period Percent Materials 10% Conversion 20% 100% 75% Cost data Work in process inventory, beginning Cost added during month: \begin{tabular}{ccc} Materials & Conversion \\ \$ 67,800 & $30,200 \end{tabular} \$ 579,000$248,900