ABC Company manufactures a long-lasting cleaning product, Super Clean Sponge, using pre- cut sponge and Chemical X. The company buys the pre-cut sponges and Chemical X from outside entities and infuses Chemical into the sponge to make its finished product Projections for the upcoming year are as follows 1. 2 3. 3. 6. 7. In 2020, ABC Company expects to sel 40,000 Super Clean Sponges in the first quarter; 50,000 ponges in the second quarter, 70.000 sponges in the 3d quarter, and 60,000 sponges in the 4th quarter The selling price of each Super Clean Sponge is $10.00 At the beginning of the first quarter of 2020, there we 8,000 finished Super Clean Sponges on hand The desired ending inventory of finished goods is 20% of the next quarter's sales. The desired ending inventory of raw materials is 10% of the next quarter's production At the end of the 4th quarter 2020, the company must have 14,000 finished Super Clean Sponges on hand, and 3.400 pounds of Chemical on hand. At the beginning of the first quarter of 2020 there we 10,000 pre-cut sponges (untreated), and 8.000 pounds of Chemical X on hand. The cost of a pre-cut sponge is $2.00 and the cost of Chemical X is $3.00 per pound Fach finished Super Clean ponge uses 1 pre-cut sponge and 8 oz. of Chemical Direct Labor cost is $0.75 per sponge; variable overhead cost is $0.20 per sponge: fixed overhead is $20.000 per quarter Variable selling and administrative expenses are 12% of lex: Fixed selling and administrative expenses are 40,000 per quarter Assume 20% of sales are for cash. 10% are collected in the quarter following the sale. and 10% are collected in the 2nd quarter following the sake Assume sales in quarter 3 of 2019 were $350.000, and sales in quarter 4 of 2019 were $300,000 Assume all expenses and production costs are paid in the quarter incurred (Selling, administrative, materials, labor, and overhead) Assume the cash balance at the beginning of Quarter 1, 2000 a $55.000 & . 10 11 12 13 14. 15. REQUIRED: USING EXCEL, PREPARE THE FOLLOWING: Sale Hedeflorach an 2020 Product Beta quarter 3130 Huded ca 3020 Cash 2000 1 The ABC Company manufactures a long-lasting cleaning product, Super Clean Sponge, using pre- cut sponge and Chemical X. The company buys the pre-cut sponges and Chemical X from outside entities and infuses Chemical into the sponge to make its finished product Projections for the upcoming year are as follows 1. 2 3. 3. 6. 7. In 2020, ABC Company expects to sel 40,000 Super Clean Sponges in the first quarter; 50,000 ponges in the second quarter, 70.000 sponges in the 3d quarter, and 60,000 sponges in the 4th quarter The selling price of each Super Clean Sponge is $10.00 At the beginning of the first quarter of 2020, there we 8,000 finished Super Clean Sponges on hand The desired ending inventory of finished goods is 20% of the next quarter's sales. The desired ending inventory of raw materials is 10% of the next quarter's production At the end of the 4th quarter 2020, the company must have 14,000 finished Super Clean Sponges on hand, and 3.400 pounds of Chemical on hand. At the beginning of the first quarter of 2020 there we 10,000 pre-cut sponges (untreated), and 8.000 pounds of Chemical X on hand. The cost of a pre-cut sponge is $2.00 and the cost of Chemical X is $3.00 per pound Fach finished Super Clean ponge uses 1 pre-cut sponge and 8 oz. of Chemical Direct Labor cost is $0.75 per sponge; variable overhead cost is $0.20 per sponge: fixed overhead is $20.000 per quarter Variable selling and administrative expenses are 12% of lex: Fixed selling and administrative expenses are 40,000 per quarter Assume 20% of sales are for cash. 10% are collected in the quarter following the sale. and 10% are collected in the 2nd quarter following the sake Assume sales in quarter 3 of 2019 were $350.000, and sales in quarter 4 of 2019 were $300,000 Assume all expenses and production costs are paid in the quarter incurred (Selling, administrative, materials, labor, and overhead) Assume the cash balance at the beginning of Quarter 1, 2000 a $55.000 & . 10 11 12 13 14. 15. REQUIRED: USING EXCEL, PREPARE THE FOLLOWING: Sale Hedeflorach an 2020 Product Beta quarter 3130 Huded ca 3020 Cash 2000 1 The
