Question

In: Accounting

Fill in the missing amounts in the following schedules. April May June Sales* $248,000 $186,000 Cash...

Fill in the missing amounts in the following schedules.

April May June
Sales* $248,000 $186,000
Cash receipts:
From cash sales $139,800
From sales on account† 105,400
Total cash receipts
Accounts payable, 12/31/x0 €612,000
Purchase of goods and services on account during 20x1 248,000
Payments of accounts payable during 20x1
Accounts payable, 12/31/x1 €816,000
  • Fill in the missing amounts in the following schedules.

    Accounts receivable, 12/31/x0 ¥1,740,000
    Sales on account during 20x1 4,548,000
    Collections of accounts receivable during 20x1 (3,932,000)
    Accounts receivable, 12/31/x1
Accumulated depreciation, 12/31/x0 $409,000
Depreciation expense during 20x1 77,000
Accumulated depreciation, 12/31/x1
  • Retained earnings, 12/31/x0 $1,540,300
    Net income for 20x1 301,200
    Dividends paid in 20x1 0
    Retained earnings, 12/31/x1
  • *Half of each month’s sales are on account. March sales amounted to $186,000.

    †60% of credit sales is collected in the month of sale; 40% is collected in the following month.

    ‡Yen is the Japanese national currency.

Solutions

Expert Solution

April

May

June

Sales

248,000

186,000

279,600 (139,800 x 2)

Cash Receipt:

From Cash sales

124,000

(248,000 x 50%)

93,000

(186,000 x 50%)

139,800

From sales on Account

74,400

(60% of 124,000)April

55,800

(60% of 93,000) May

83,880

(60% of 139,800) June

37,200

(40% of 93,000) March

49,600

(40% of 124,000) April

37,200

(40% of 93,000) May

Total Cash receipt

235,600

198,400

260

Schedule-1

Schedule-2

Account payable, 12/31/x0

612,000

Purchase of Goods and services on account during 20x1

248,000

payment of account payable during 20x1

44,000

account payable, 12/31/x1

816,000

Account payable, 12/31/x0

612,000

Add: Purchase of Goods and services on account during 20x1

248,000

860,000

less: account payable, 12/31/x1

816,000

payment of account payable during 20x1

44,000

Schedule-3

Accounts receivable, 12/31/x0

1,740,000

Add: Sales on account during 20x1

4,548,000

6,288,000

less: Collections of accounts receivable during 20x1

3,932,000

Accounts receivable, 12/31/x1

2,356,000

Schedule-4

Accumulated depreciation, 12/31/x0

409,000

Depreciation expense during 20x1

77,000

Accumulated depreciation, 12/31/x1

486,000

Schedule-5

Retained earnings, 12/31/x0

1,540,300

Add: Net income for 20x1

301,200

1,841,500

Less: Dividends paid in 20x1

0

Retained earnings, 12/31/x1

1,841,500


Related Solutions

Swifty, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts,...
Swifty, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Swifty desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) October November December Quarter Beginning cash balance $ $15,100 $ $16,100 Collections from sales 55,980 242,380 Total cash...
Sheridan, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts,...
Sheridan, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Sheridan desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) October November December Quarter Beginning cash balance $ $15,930 $ $16,020 Collections from sales 55,850 241,890 Total cash...
Fill in the missing amounts for the following 4 companies. Each case is independent of the...
Fill in the missing amounts for the following 4 companies. Each case is independent of the others. Assume that only one product is being sold by each company: Company A Company B Company C Company D Units Sold 600               900     Sales in Dollars $30,000     $63,000     $235,000     $     Total Variable Expenses $6,600     $     $     $135,000     Per Unit C/M $     $60     $270     $140     Total Fixed Expenses $20,600     $35,000     $144,000     $     Net Operating Income (Loss) $     $7,000     $(9,000)     $(25,000)    
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 10200 14400 12000 36600 Selling price per unit x $30 x $30 x $30 Sales revenue $306000 $432000 $360000 $1098000 All of the sales are on credit. Quagmire collects from customers as follows: 40% of sales in the month of sale 25% in the month following the sale, and 35% in the second month following...
​12.​Use your knowledge of balance sheets to fill in the amounts missing in the text. ​Cash​$​50,000​Accounts...
​12.​Use your knowledge of balance sheets to fill in the amounts missing in the text. ​Cash​$​50,000​Accounts payable​$​12,000 ​Accounts receivable​​80,000​Notes payable​​50,000 ​Inventory​​​ ​Total current liabilities​$​ ​​Total current assets​$​​Long-term debt​​ ​Gross P&E​​​ Total liabilities​$​ ​Less accumulated​​​Common stock​​100,000 ​​depreciation​​130,000​Paid-in capital​​250,000 ​Net P&E​​$600,000​Retained earnings​​200,000 ​Total assets​​​Total stockholders’ equity​ ​​​​​Total liabilities and equity​$​830,000
Ruiz Co. provides the following sales forecast for the next four months:     April May June...
Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 690 770 720 810 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 207 units. Assume July's budgeted production is 720 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each month with...
Ruiz Co. provides the following sales forecast for the next four months:     April May June...
Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 690 770 720 810 The company wants to end each month with ending finished goods inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 276 units. Assume July's budgeted production is 720 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each month with...
Jackson's Auto Parts projects the following sales: April May June $ 225,000 $ 253,000 $ 178,000...
Jackson's Auto Parts projects the following sales: April May June $ 225,000 $ 253,000 $ 178,000 76 percent of Ellis' sales are on credit with 68 percent of receivables collected in the month after the sale and the rest of receivables collected in the second month after the sale. February sales were $237,000 and March sales were $251,000. In the past Ellis' bad debt percentage has been 0 and is expected to continue. a) Cash Receipts for April b) Cash...
Ruiz Co. provides the following sales forecast for the next four months:     April May June...
Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 620 700 650 740 The company wants to end each month with ending finished goods inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 248 units. Assume July's budgeted production is 650 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each month with...
Ruiz Co. provides the following sales forecast for the next four months: April May June July...
Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 680 760 710 800 The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 136 units. Assume July's budgeted production is 710 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT