Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can i please have the formulas to derive the answers too? Thanks ABC Company manufacturcs a long-lasting cleaning product, Super Clean Spongs, using a pre-
can i please have the formulas to derive the answers too? Thanks
ABC Company manufacturcs a long-lasting cleaning product, Super Clean Spongs, using a pre- cut sponge und Chemical X. The company buys the pre-cut sponges and Chanical X from outside entities and infuses Chemical X into the sponge to make its finished product. Projections for the upcoming year are as follows: 1. 2. 3. 4. 5. 6. 7 In 2020, ABC Company expects to sell 40,000 Super Clean Sponges in the first quarter, 50,000 sponges 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 are 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 are 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 Each finished Super Clean sponge uses 1 pre-cut sponge and 8 oz of Chemical X. 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 sales: Fixed selling and administrative expenses are 40.000 per quarter. Assume 20% of sales are for cash. 70% are collected in the quarter following the sale. and 10% are collected in the 2nd quarter following the sale. 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, 2020 was $55,000 8. 9. 10. 11. 12. 13. 14. 15. I REQUIRED: USING EXCEL PREPARE THE FOLLOWING: Sales Budget for each quarter 2020 Production Budget for each quarter 2020 Budgeted Income Statement for each quarter 2020 Cash Budget for each quarter 2020 +Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started