Question

In: Accounting

The Pat Company has estimated its activity for May 2020. Selected data from these estimated amounts...

The Pat Company has estimated its activity for May 2020. Selected data from these estimated amounts are as follows:

Sales $350,000

Gross Profit (based on sales) 30%

Increase in trade A/R during May $10,000

Change in A/P during May $0

Increase in inventory during May $5,000

Variable selling and administrative expenses includes a charge for uncollectible accounts of 1% of sales. Depreciation expense of $20,000 per month is included in fixed selling and administrative expenses.

What are the estimated cash payments from operations for May?

Solutions

Expert Solution

Sales $                                 3,50,000
Gross profit $                                 1,05,000
Depreciation expense $                                    20,000
Variable selling and administrative expenses $                                      3,500
Net Profit $                                    81,500
Cashflow from operating activities
Particulars Amounts
Net profit as per P& L A/c $                                    81,500
Add: Non cash items
Depreciation expense $                                    20,000
Provision for doubtful account $                                      3,500
Less: Non cash items
Add: Increase in Current liab & decrease in current assets
Decrease in account payables $                                             -  
Less: Decrease in Current liab & Increase in current assets
Increase in inventory $                                     -5,000
Increase in trade receivables $                                   -10,000
Cashflow before Tax $                                    90,000
Less: Tax paid
Cashflow from operations $                                    90,000

Cash generated are $ 90,000

Please Like the solution if satisfied with the answer and if any query please mention it in comments...thanks


Related Solutions

The Pat Company has estimated its activity for May 2020. Selected data from these estimated amounts...
The Pat Company has estimated its activity for May 2020. Selected data from these estimated amounts are as follows: Sales $350,000 Gross Profit (based on sales) 30% Increase in trade A/R during May $10,000 Change in A/P during May $0 Increase in inventory during May $5,000 Variable selling and administrative expenses includes a charge for uncollectible accounts of 1% of sales. Depreciation expense of $20,000 per month is included in fixed selling and administrative expenses. What are the estimated cash...
Ravelo Corporation has provided the following data from its activity-based costing system: Activity Cost Pools Estimated...
Ravelo Corporation has provided the following data from its activity-based costing system: Activity Cost Pools Estimated Overhead Cost Expected Activity Assembly $ 510,520 50,000 machine-hours Processing orders $ 60,263 1,700 orders Inspection $ 83,589 1,710 inspection-hours Data concerning the company's product L19B appear below: Annual unit production and sales 550 Annual machine-hours 1,110 Annual number of orders 190 Annual inspection hours 140 Direct materials cost $ 49.74 per unit Direct labor cost $ 22.45 per unit According to the activity-based...
Vanguard Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total...
Vanguard Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total Cost Total Activity Assembly $ 1,078,920 74,000 machine-hours Processing orders $ 76,560 1,650 orders Inspection $ 119,616 1,680 inspection-hours The company makes 400 units of product O37W a year, requiring a total of 630 machine-hours, 50 orders, and 10 inspection-hours per year. The product's direct materials cost is $36.92 per unit and its direct labor cost is $30.06 per unit. According to the activity-based...
Feldpausch Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total...
Feldpausch Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total Cost Total Activity Assembly $ 1,471,965 60,500 machine-hours Processing orders $ 54,224 1,850 orders Inspection $ 152,154 2,140 inspection-hours The company makes 1,230 units of product W26B a year, requiring a total of 1,380 machine-hours, 103 orders, and 39 inspection-hours per year. The product's direct materials cost is $52.21 per unit and its direct labor cost is $17.15 per unit. The product sells for...
Petitte Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total...
Petitte Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total cost Total activity Assembly $612,560 31,000 machine hours Processing orders $35,451 1,300 orders Inspection $100,217 1,690 Inspection hours Data concerning the company's product K54A appear below: Selling price $150 per unit Annual production and sales 410 units Annual machine hours 700 machine hours Annual number of orders 30 orders Annual inspection hours 30 orders Direct materials cost $45.67 per unit Direct labor cost $31.24...
Paparo Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total...
Paparo Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total Cost Total Activity Assembly $ 794,300 47,000 machine-hours Processing orders $ 61,280 1,600 orders Inspection $ 109,681 1,430 inspection-hours Data concerning the company's product Q79Y appear below: Annual unit production and sales 500 Annual machine-hours 1,130 Annual number of orders 115 Annual inspection hours 20 Direct materials cost $ 42.00 per unit Direct labor cost $ 41.31 per unit According to the activity-based costing...
31. Houseal Corporation has provided the following data from its activity-based costing system: Activity Cost Pool...
31. Houseal Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total Cost Total Activity Assembly $ 613,250 55,000 machine-hours Processing orders $ 46,170 1,500 orders Inspection $ 146,110 1,900 inspection-hours Data concerning one of the company's products, Product W58B, appear below: Selling price per unit $ 113.70 Direct materials cost per unit $ 48.14 Direct labor cost per unit $ 11.62 Annual unit production and sales 360 Annual machine-hours 1,040 Annual orders 60 Annual...
Pecot Industries has provided the following data from its activity-based costing system: Activity Cost Pools Est....
Pecot Industries has provided the following data from its activity-based costing system: Activity Cost Pools Est. Overhead Cost Expected Activity Assembly $498,520 44,000 Machine hours Processing orders $54,263 1,100 Orders Inspection $77,589 1,110 Inspection hours Data concerning Pecot’s product LB28 appears below:             Number of units produced      430             Machine hours                        990             Number of orders                    70             Inspection hours                      20             Direct materials cost               $37.74 per unit             Direct labor cost                     $10.45 per unit Calculate the total unit product...
Kozlov Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total...
Kozlov Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total Cost Total Activity Assembly $ 1,022,580 78,000 machine hours Processing orders $ 104,650 2,300 orders Inspection $ 160,312 2,320 inspection hours The company makes 440 units of product A21W a year, requiring a total of 820 machine-hours, 50 orders, and 20 inspection-hours per year. The product's direct materials cost is $35.32 per unit and its direct labor cost is $29.32 per unit. According to...
From the e-Activity and based on the growth company selected, assess why it is a growth...
From the e-Activity and based on the growth company selected, assess why it is a growth stock and if that status is sustainable. Evaluate whether or not P/E is an effective indicator of a growth stock. Suggest an alternative.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT