ASSIGNMENTGiven:A. Cash Receipts:Schedule of Sales (Values in Pesos)January 3,000February 3,000March 5,000April 6,000Of the sales transactions, 25% comprises cash sales, while the other75% will be collected after one month.B. Cash Disbursements:Schedule of Purchases (Values in Pesos)January 3,000February 0March 2,000April 4,000Of the purchases, 50% are to be paid in cash, while the other 50%will be paid one month later.In addition, the following cash expenses are also shown.(Values in Pesos)Rent 1,000 monthlySupplies 500 monthlyLabor 1,000 monthlyc. Other Information:Ending Cash Balance in December was P5,000.b. Interest is 1% per month, if applicableThere is no minimum ending cash balance required.a.C.Required:Construct a schedule of cash budget for the four-month period.

A cash budget is one of the types of budget which provides an estimation of the cash receipts for a…

Answered: Required: Construct a schedule of cash…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 18E

See similar textbooks

Similar questions

Guidry Corporation's beginning accounts receivable balance at January 1 was $200,000 and the ending accounts receivable balance at December 31 is $300,000. Assuming cash collections from receivables totaled $1,100,000, what were credit sales for the period? A. $1,300,000 B. $1,500,000 C. $1,200,000 D. $1,100,000
a. Prepare the expected cash collections during August.b. Prepare the expected cash disbursements during August. c. Calculate the expected cash balance on August 31.
You are given the following figures for sales and receivables: 20X7 20X6 $ Receivables at year end 74,963 69,472 Sales 697,104 Total cash received from customers 686,912 Specific allowance for receivables 2,014 1,578 Irrecoverable debts written off 1,697 What was the value of sales returns during 20X7? $ %24
Use the following information to answer questions 1-3: January Cash Sales $40,000 Credit Sales $120,000 February March April $35,000 $110,000 $25,000 $90,000 $30,000 $100,000 20% of the credit sales are collected in the month of sale, 70% in the month after sale, and 10% in the second month after sale. What is the balance of accounts receivable on March 31? Multiple Choice $11,000 $12,000 $72,000 $83,000
4.
Alfa completed the following transactions during the year ended 31 December 20x7 Credit sales during the year $53,300 Collection from receivables $56,100 During the year, total amount irrecoverable $560 Opening balance of receivables $8,600 Calculate the balance of receivables that will appear in the SOFP on 31 December 20x7. A.$5,800 B.$10,840 C.$5,240 D.$56,100
XYZ Company has the following information: Beginning accounts receivable: $50,000 Ending accounts receivable: $60,000 Credit sales: $200,000 Cash collections: $180,000 Calculate the company's accounts receivable turnover ratio and average collection period.
Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: • Sales are budgeted at $305,000 for November, $325,000 for December, and $225,000 for January. • Collections are expected to be 65% in the month of sale and 35% in the month following the sale. The cost of goods sold is 80% of sales. • The company desires to have an ending merchandise inventory at the end of each month equal to 70% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. • Other monthly expenses to be paid in cash are $22,600. Monthly depreciation is $28,500. . Ignore taxes. Assets Cash: Balance Sheet October 31 Accounts receivable Merchandise inventory Property, plant and equipment, net of $624,000 accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity The difference between cash receipts and cash…
Answer all Questions. Ch.5-1
A4
9. Company S purchased 1,000 units raw materials amounting to $5,000 and used $4,500 worth for the production during the current month. The standard price for these raw materials is $5.2 per unit. How much is the materials price variance for the current month if Company S analyzes the variance at the point of purchase? O $200 favorable O $200 unfavorable O $700 favorable O $700 unfavorable 10. T Corporation is authorized to issue 500,000 common stock at $10 par value. As of December 31, 2019 the corporation has 350,000 common stock issued and outstanding. On February 14, 2020, the market price of the stock is $17. On the same date, T Corporation acquired 50,000 stocks at $15. On March 5, 2020, the company reissued 25% of the treasury stocks at $20. Which of the following will be included in the entry to record the transaction on March 5, 2020? Debit Treasury Shares $187,500 Debit Common Stock $250,000 O Credit Additional Paid-in Capital $62,500 O Credit Cash $250,000
Parson Corporation, a wholesaler, provided the following information: Month January February March April May Merchandise Purchases 150,000 156,000 144,000 162,000 168,000 A. Cash collections B. Cash disbursements C. Cash balance Sales. 188,000 182,000 181,000 194,000 182,000 Customers pay 70% of their balances in the month of sale, 20% in the month following sale, and 10% in the second month following sale. The company pays all invoices in the month following purchase and takes advantage of a 3% discount on all amounts due. Cash payments for operating expenses in May will be $123,500; Parson's cash balance on May 1 was $135,800. Required: A. Determine the expected cash collections during May. B. Determine the expected cash disbursements during May. C. Determine the expected cash balance on May 31.

SEE MORE QUESTIONS

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

SEE MORE TEXTBOOKS

Required: Construct a schedule of cash budget for the four-month period.