Answered step by step
Verified Expert Solution
Link Copied!

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-

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Fraud Prevention And Detection

Authors: Joseph T. Wells

5th Edition

1119351987, 9781119351986

More Books

Students also viewed these Accounting questions

Question

What do you think accounts for the fact that turnover is low?

Answered: 1 week ago