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 receipts from operations for May?

Select one:

a. $ 350,000

b. $ 360,000

c. $ 340,000

d. $ 336,500

Solutions

Expert Solution

The sales for the period are $ 350,000.

30% of sales is Gross Profit which comes to $ 105,000.

The question requires us to calculate the cash receipts from operations during the month of May.

The Trade A/R has increased by $ 10,000. This means that Accounts Receivable has increased and that means that kuch amount will be less collected from sale made.

Thus, $ 10,000 will be reduced from total sales as this amount is yet to be recovered.

Their has been no change in A/P. Thus, it will not affect the cash receipts.

Inventory has increased by $ 5,000. But their has been no change in A/P. This means that inventory change will not affect the cash receipts.

1% of sales is considered to be bad debts and such amount will be uncollectible.

1% of $ 350,000 = $ 3,500 will be uncollectible.

Depreciation being no cash expenditure will not affect the cash receipts.

Thus cash receipts for month of May -

Cash sales - Increase in A/R - Bad debts

= $ 350,000 - $ 10,000 - $ 3,500

= $ 336,500

OPTION D


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...
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.
Traditional Product Costing versus Activity-Based Costing Assume that Panasonic Company has determined its estimated total manufacturing...
Traditional Product Costing versus Activity-Based Costing Assume that Panasonic Company has determined its estimated total manufacturing overhead cost for one of its plants to be $636,400 consisting of the following activity cost pools for the current month: Activity Centers Activity Costs Cost Drivers Activity Level Assembly setups $ 132,000 Setup hours 2,000 Materials handing 64,800 Number of moves 600 Assembly 360,000 Assembly hours 18,000 Maintenance 79,600 Maintenance hours 1,990 Total $636,400 Total direct labor hours used during the month were...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT