63. Summarized below are the Receipts ad Payments forecasts for the months of July to December 2010 Selling Purchases Wages Exp. 4,000 2,000 3,000 Misc. Exp. 8,000 7,000 9,000 Months Sales July August September 4,000 5,000 30,000 16,000 18,000 32,000 34,000 4,000 3,000 15,000 17,000 18,000 16,000 October 3,000 30,000 26,000 6,000 2,000 4,000 8,000 9,000 November 4,000 3,000 December 30,000 You are given the following further information: 1. Machinery costing Rs. 20,000 is due for delivery in Dec. payable 10% on delivery and balance after three months. 2. Advance income tax in Nov. Rs. 3,000. 3. Period of credit allowed: (i) (ii) By suppliers 2 months and To customers 1 month. 4. Lag of payments of wages – 12 month. 5. Lag of payment of selling expenses 1 month. You are required to prepare a cash budget for four months starting on 1 September 2010 when there was cash balance of Rs. 10,000.

63. Summarized below are the Receipts ad Payments forecasts for the months of July to December 2010 Selling Purchases Wages Exp. 4,000 2,000 3,000 Misc. Exp. 8,000 7,000 9,000 Months Sales July August September 4,000 5,000 30,000 16,000 18,000 32,000 34,000 4,000 3,000 15,000 17,000 18,000 16,000 October 3,000 30,000 26,000 6,000 2,000 4,000 8,000 9,000 November 4,000 3,000 December 30,000 You are given the following further information: 1. Machinery costing Rs. 20,000 is due for delivery in Dec. payable 10% on delivery and balance after three months. 2. Advance income tax in Nov. Rs. 3,000. 3. Period of credit allowed: (i) (ii) By suppliers 2 months and To customers 1 month. 4. Lag of payments of wages – 12 month. 5. Lag of payment of selling expenses 1 month. You are required to prepare a cash budget for four months starting on 1 September 2010 when there was cash balance of Rs. 10,000.

Name: 63. Summarized below are the Receipts ad Payments forecasts for the m
Uploaded: 2024-03-04T10:43:15.000Z
Channel: Bartleby
Description: 63. Summarized below are the Receipts ad Payments forecasts for the months of July toDecember 2010Purchases Wages4,000SellingExp.MonthsSalesMisc. Exp.30,00032,0004,0005,0008,000JulyAugustSeptember16,00018,00015,0002,0007,00034,00030,00026,00030,0003

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

nkt.2
Number 5
moodle1.du.edu.om/mod/quiz/atte Moodle English (en) - The following sales and purchases are expected over the Four-month period from December to March Purchases Sales December OMR 30000 OMR 26000 January OMR 25000 OMR 30000 February OMR 24000 OMR 24000 March OMR 26000 OMR 28000 Additional Information: 1. Wages are paid each month of OMR 2000, which are paid in month that they are incurred 2. 30% of the Sales are on credit - and we allow one-month credit period - and 70% of the sales for immediate settlement 3. 40% of the Purchases are on credit - and 1 month credit period - and 60% of the purchases are for immediate settlement 4. The balance of cash as at 1 January was OMR 9000 If the company is preparing a budget from January to March, what will be the Closing balance of cash on March ? Select one: O a. OMR 7800 Oh OMR 2500 to search DELL F5 F6 F10 44 41 # 24 % % & 3 4 5 8 A E Y F GY H i RY NI ÍM この * 00
For the month of December, the records of ABC Corporation show the following information:Cash received on accounts receivable ₱ 70,000Cash sales 60,000Accounts Receivable, December 1 148,000Accounts Receivable, December 31 160,000Accounts Receivable written-off as uncollectible 2,000How much are the gross sales in December?
Consider the following information for a given company: Month Cash Sales Credit Sales Jan $80.000 $350,000 Feb $60,000 $200,000 Mar $50.000 $145,000 Apr $45,000 $130,000 May $55,000 $170,000 Jun $50,000 $150,000 The firm's collection pattern is as follows: 60% in the month of sale 30% one month following sale 10% two months following sale The accounts receivable balance on 1 Jan is $70,000. Of this amount, $60,000 represents uncollected Dec sales and $10,000 represents uncollected Nov sales. Required: Determine the total cash collected during Jan. (INPUT YOUR ANSWER IN THOUSANDS USING A COMMA SEPARATOR. NO ROUNDING REQUIRED. FOR EXAMPLE: 100,000)
A company is preparing its cash buget for the month of May. Below is A/R information: Actual credit sale for March $130,000 Actual credit sale for April $160,000 Estimated credit sales for May $210,000 Estimated collections in the month of sale 25% Estimated collections in the first month after the month of sale 60% Estimated collections in the second month after the month of sale 10% Estimated provision of bad debts (made in month of sale) 5% ** Firm writes off all UNCOLLECTIBLE account receievables at the end of second month after the month of sale. Required: For the month of May, calculate the following: 1. Estimated cash receipts from account recievable collections. 2. The gross amount of A/R at the end of the month (after appropriate write off of uncollectiable amounts). 3. The net amount of A/R at the end of the month 4. Recalculate the requirement 1 & 2 under the assumption that estimated collections in the month of sale equal 60% and in the first…
Need answer
acc
kau.2
You collect 75% of a month's sales in the month of the sale and 25% of sales in the following month. May sales June sales July sales O $105 O $35 $120 Compute cash inflows for June. $135 $140 $100 not enough information, because sales revenue differs
A seller of goods had the following data during the month.Total Sales Invoice (billed price) Php 224,000Gross receipts, including VAT 201,600Sales returns and allowances, billed price 11,200Input VAT 12,000 How much is the VAT payable?
Fernando Company developed the following data for the month of August:1. August 1 cash balance P123,000.2. Cash sales in August P800,000.3. Credit sales for August are P300,000; for July P400,000; and for June P400,000. 70% of credit sales are collected in the month of sale, 15% in thefollowing month, and 10% in the second month following the sale. 4. Purchases for July were P500,000 and for August are P400,000. One-fourth of purchases are paid in the month of purchase and the remaining three-quarters in the following month. 5. August salaries are P314,000, utilities are P32,200, and depreciation on the building and equipment is P100,000. Required:1. Anticipated cash receipts from accounts receivable in August.