Problem 5 (Preparation of Cash Budget) The sales forecast for January to May 20X4 and actual sales for November and December 20X3 for Purple Company are as follows: Month November December Sales (P) 80,000 70,000 Actual (20X3) 80,000 100,000 80,000 100,000 90,000 Forecast (20x4) January February March April Мay The 20% of sales is in cash and the rest is on credit, payment on which is realized on the third month. The following other information are also available. a. Amount of purchase is budgeted at 60% of the sales turnover of a month and paid on the third month of purchase. b. Variable expenses is 5% of turnover – time lag of payment half month. Commission on credit sales at 5% is payable on the third month. d. Rent and other expenses amounting to P3,000 paid every month. e. Payment for purchase of fixed assets amounting to P50,000 on March 20X4. f. Payment for taxes on April 20X4 amounting to P20,000. There will be an opening cash balance of P25,000. C. g.

Problem 5 (Preparation of Cash Budget) The sales forecast for January to May 20X4 and actual sales for November and December 20X3 for Purple Company are as follows: Month November December Sales (P) 80,000 70,000 Actual (20X3) 80,000 100,000 80,000 100,000 90,000 Forecast (20x4) January February March April Мay The 20% of sales is in cash and the rest is on credit, payment on which is realized on the third month. The following other information are also available. a. Amount of purchase is budgeted at 60% of the sales turnover of a month and paid on the third month of purchase. b. Variable expenses is 5% of turnover – time lag of payment half month. Commission on credit sales at 5% is payable on the third month. d. Rent and other expenses amounting to P3,000 paid every month. e. Payment for purchase of fixed assets amounting to P50,000 on March 20X4. f. Payment for taxes on April 20X4 amounting to P20,000. There will be an opening cash balance of P25,000. C. g.

Name: Problem 5 (Preparation of Cash Budget)The sales forecast for January
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Problem 5 (Preparation of Cash Budget)The sales forecast for January to May 20X4 and actual sales for November and December 20X3 for PurpleCompany are as follows:MonthNovemberSales (P)80,00070,000Actual (20X3)DecemberForecast (20X4)JanuaryFebruaryMa

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

Budgeting Cash Collections Lowell Consulting, which sells on terms 2/10, n/30, had credit sales for March and April of $90,000 and $75,000, respectively. Analysis of Lowell's operations indicates that the pattern of customers' payments on account is as follows (percentages are of total monthly credit sales) In month of sale in month of following sale Uncollectible accounts, returns, and allowances Receiving Discount Beyond Discount Period Totals 20% 60% 20% 35% 5% 100% 40% 15% Determine the estimated cash collected on customers' accounts in April.
Reck Chocolates reports the following information from its sales budget: Expected Sales amount: July RM 97,000 August RM117,000 September RM127,000 Cash sales are normally 30% of total sales and all credit sales are expected to be collected in the month following the date of sale. The total amount of cash expected to be received from customers in September is: a.120,000. b.38,100. c.127,000. d.81,900. e.208,900.
Do it on the Road Bus Co.’s sales budget for the second quarter is as follows: April $200,000 May 225,000 June 250,000 All sales are on account (credit) with 50% collected in the month of sale, 40% collected in the following month after sale, and 10% collected in the second month after sale. There are no uncollectable accounts. Required: What would be the budgeted cash collections in the month of June?
Problem 5 Prepare a cash budget by month for the month quarter ending September 30, 2009, from the following data obtained from the Peninsula Co. Support your solution with schedules of estimated receipts & payments. August P 16,000 150,000 120,000 18,000 2,000 July P 12,000 110.000 90,000 Operating Expenses 15,000 September P 18,000 120,000 110,000 16,000 Cash sales Credit sales Purchases Interest expense Credit are collected 50% in the month of sales. 40% in the month following, 8% in the second month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and P90,000 respectively. Purchases of merchandise, all on account are paid 60% in the month of purchase and 40% in the month fallowing. Purchase for June are estimated at 80,000 are paid in the month incurred. Cash balance on June 30, 2009 is P27,000.
Please do not give solution in image format thanku
QUESTION 1 Ginobili has forecast sales to be $120100 in February, $151200 in March, $162700 in April, and $174000 in May. 24% of sales are on made on credit, the rest are for cash. The sales on credit are collected 40% in the month of sale, and 60% the month following. What are the total budgeted cash receipts in April?
Accounting Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 256,167 262,962 282,872 Credit Purchases 97,465 111,565 137,292 Wages, Taxes, and Expenses 26,506 31,621 33,707 Interest 7,239 7,773 8,091 Equipment Purchases 54,832 61,271 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the following month. Credit purchases will be paid in the month following the purchase. In June, credit sales were $138,282, and credit purchases were $102,770 July’s beginning cash is $184,797 If TAP maintains a policy of always keeping a minimum cash balance of $75,000 as a buffer against uncertainty and forecasting errors, what is the cash surplus/deficit at the end of the quarter (i.e., end of…
1
COVID 19 Co has forecast purchases on account to be $312.000 in March, $377.000 in April, $421,000 in May, and $499,000 in June. Sixty percent of purchases are paid for in the month of purchase, the remaining 40% are paid in the following month. What are budgeted cash payments for May? Select one Oa $351.000 b. S403.400 C $125.000 Od $384.000
Surf Inc. has prepared the sales forecast as shown below: Description Month 1 Month 2 Month 3 Month 4 Sales Forecast 25,000.00 27,000.00 29,000.00 23,000.00 Prepare the production budget and show the required production for Months 1-3 Beg Inv Month 1 3,500.00 Required Ending Inventory 15% of the next months budgeted sales Description Month 1 Month 2 Month 3
Complete g cash budget table please and thank you
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $42,000 and $78,000, respectively. The company expects to collect 35% of its credit sales in the month of the sale, 55% in the following month, and 10% is deemed uncollectible. What amount of cash collections from credit sales would the company include in its cash budget for the second month? Multiple Choice $50, 400 $42,900 $27,300 $58, 200