Air corporation has the following projected sales: P958,450.00 (October) P1,001,515.00 (November) P1,200,000.00 (December). Air corporation collects 50% of the month's sales in the month of sales, 35% in the month following sale, and 15% in the second month following the sale. What would be the cash collection in December? A) P143,767.50 B P2,294,298.00 P1,837,730.00 P2,201,515.00

Air corporation has the following projected sales: P958,450.00 (October) P1,001,515.00 (November) P1,200,000.00 (December). Air corporation collects 50% of the month's sales in the month of sales, 35% in the month following sale, and 15% in the second month following the sale. What would be the cash collection in December? A) P143,767.50 B P2,294,298.00 P1,837,730.00 P2,201,515.00

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter21: Supply Chains And Working Capital Management

Section: Chapter Questions

Problem 3MC

See similar textbooks

Similar questions

A firm has projected sales in May, June, and July of P10,000, P20,000, and P30,000, respectively. The firm makes 20% of sales for cash and collects the balance one month following the sale. What is the firm’s total cash receipts in July?a. P18,000 c. P20,000b. P22,000 d. P24,000
0. Swetres Company has the following sales forecast for the selected three-month period in 2018. April, P120,000; May, P70,000; June, P80,000. 70% of sales are collected in the month of sale, and the balance are collected in the following month. Accounts receivable balance in April 1, P100,000. Cash balance in April 1, P60,000. Minimum cash balance required is P50,000. Cash can be borrowed in the multiples of P10,000 from local bank (disregard the interest charges). What is the cash balance at the end of April assuming that cash is received only from customers and that P200,000 is the cash out during April? 11.Selected information from the accounting records of Roleg Co. is as follows: Net accounts receivable at Dec. 31, 2018, P900,000; Net accounts receivable at Dec. 31, 2019, P1,000,000; Inventories at Dec. 31, 2018, P1,100,000; Inventories at Dec. 31, 2019, P1,200,000; Accounts receivable turnover, 5 times; inventory turnover, 4 times. What is Roleg's gross margin for 2019? 12.…
Black Corporation has forecasted sales in 2020 as follows: Jan-120,000 Feb-P160,000 Mar-P180,000 Apr-P240,000. December 2019 sales is P100,000. Sales are collected 25% for the month, 50% the following month and balance for the month again. What is the total cash receipts for the first quarter of 2020? P540,000 9420,000 P630,000 9400,000
A firm has projected sales in October, November, and December of P10,000, P20,000, and P30,000, respectively. The firm makes 20% of sales for cash and collects the balance one month following the sale. What is the firm’s total cash receipts in December? P18,000 P20,000 P22,000 P24,000
Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands): Month 1 Month 2 Month 3 Month 4 Cash sales 35 44 38 34 Sales on credit 300 320 290 270 On average, 45% of credit sales are paid for in the current month, 25% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place.
Here is a forecast of sales by National Bromide for the first 4 months of 2022 (figures in thousands of dollars): Month: Cash sales Sales on credit 1 2 3 4 27 36 30 26 160 180 150 130 On average, 50% of credit sales are paid for in the current month, 30% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? Note: Enter your answers in whole dollars not in thousands of dollars. Month 3 Month 4 Expected Cash Collections
Fine Co. has the following sales forecasts for the third quarter of 2021: P85,000 (July), P88,000 (Aug), P82,000 (Sep). All sales are on credit. Seventy-five percent are collected in the month of sales and remainder is collected the following month. Minimum cash balance is P10,000. How much cash would be collected in September from sales? A P61,500 P66,000 P87,250 D P83,500
Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands): Month 1 Month 2 Cash sales Sales on credit 16 110 25 130 Month 3 Month 4 19 100 15 80 On average, 51% of credit sales are paid for in the current month, 31% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place. Items Month 3 Month 4 Expected Cash Inflow from Operations (in $ thousands)
5. Pacific Place has developed the following sales forecast for the following months. Month Sales May $500,000 June $650,000 July $380,000 August $300,000 The collection policy for customers is: 40 percent in the month of sale 60 percent in the following month after sale How much is the expected total cash collections from customers in June? a)$260,000 b)$590,000 c)$610,000 d)$300,000 e)$560,000
Here is a forecast of sales by National Bromide for the first 4 months of 2022 (figures in thousands of dollars): Month: Cash sales Sales on credit 1 23 140 Month 3 Month 4 On average, 50% of credit sales are paid for in the current month, 30% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? Note: Enter your answers in whole dollars not in thousands of dollars. $ $ 2 3 32 26 160 130 > Answer is complete but not entirely correct. Expected Cash Collections 4 22 110 191,000 X 172,000 X
Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands) Month 1 Month 2 Month 3 Month 4 Cash sales Sales on credit 23 180 32 200 26 170 22 150 On average, 47% of credit sales are paid for in the current month, 27% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place. Items Month 3 Month 4 Expected Cash Inflow from Operations (in $ thousands) Help
Projector Limited has the following projection for the 4 months ending August 2018:MayJuneJulyAugustR’sR’sR’sSales320 000380 000420 000460 000Purchases160 000160 000230 000250 000Rent income11 00011 000??Salaries26 80026 800??1. 50% of the sales are for cash and the balance is on credit.2. All credit sales are collected one month after the sale.3. All purchases are on credit. Creditors are paid in full one month after the month of purchase.4. The tenants rent contract stipulates an increase of 20% from 1 July 2018.5. Salaries are expected to increase to R32 000 per month as at 1 August 2018.6. A new motor vehicle will be purchased during June 2017. Repayments of R6 000 per month will commence on 1 July 2017.7. Advertising costs are expected to be 2% of sales from 1 June 2018.8. A fixed deposit of R25 000 will mature in the month of July 2018.9. On 31 May 2018, the bank is expected to have a favourable balance of R420 000.Required:Prepare a Cash Budget for the three (3) months ending…