Question

Procter & Gamble is preparing its cash budget. It expects to have sales of $40,000 in...

Procter & Gamble is preparing its cash budget. It expects to have sales of $40,000 in January, $30,000 in February, and $25,000 in March. If 20% of sales are for cash, 40% are credit sales paid in the month after the sale, and another 40% are credit sales paid 2 months after the sale, what are the expected cash receipts for March?

Homework Answers

Answer #1

Answer is $33,000

January Sales = $40,000
February Sales = $30,000
March Sales = $25,000

20% of sales are received during the month of sale, 40% of sale in one month after the sale and remaining 40% in 2 months after the sale.

Expected Cash Receipts for March = 20% * March Sales + 40% * February Sales + 40% * January Sales
Expected Cash Receipts for March = 20% * $25,000 + 40% * $30,000 + 40% * $40,000
Expected Cash Receipts for March = $5,000 + $12,000 + $16,000
Expected Cash Receipts for March = $33,000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000...
Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000 in January, $375,000 in February, and $555,000 in March. If 20% of the sales are for cash, 45% are credit sales paid in the month after the sale, and another 35% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? Enter your answer rounded to two decimal places. Do not enter $ or comma in the...
1A. Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of...
1A. Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000 in January, $375,000 in February, and $555,000 in March. If 20% of the sales are for cash, 45% are credit sales paid in the month after the sale, and another 35% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? Enter your answer rounded to two decimal places. Do not enter $ or comma in...
Halloween Pty Ltd is preparing a cash budget for the first three months of 2016. Relevant...
Halloween Pty Ltd is preparing a cash budget for the first three months of 2016. Relevant estimates for the budget are as follow: January February March Sales 260,000 300,000 350,000 Materials Purchases 150,000 185,000 220,000 Salaries and Wages 30,000 30,000 35,000 Selling Expenses 14,500 19,000 22,000 Administration Expenses 20,500 24,800 27,600 Additional information: ? All sales are on credit. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20%...
Big City Manufacturing (BCM) assumed that all credit sales were paid in full, which is not...
Big City Manufacturing (BCM) assumed that all credit sales were paid in full, which is not realistic. BCM studied its past credit sales and determined that 3.25% of its credit sales resulted in Bad Debts that were never collected. Using the data from the previous problem with the new assumption that 3.25% of credit sales were never collected, what is your revised estimate for the expected cash receipts for March? Data from previous problem: Big City Manufacturing (BCM) is preparing...
In a previous question, Big City Manufacturing (BCM) assumed that all credit sales were paid in...
In a previous question, Big City Manufacturing (BCM) assumed that all credit sales were paid in full, with no bad debt expense. For this problem, please assume that bad debt expense is again 0% for BCM. Purchases for next month's sales are 50% of projected sales for the next month, and April sales are estimated to be $495,000; purchases for April are paid in cash in March. "Other payments," which include wages, rent, and taxes, are 25% of sales for...
A Landscaping Inc. is preparing its budget for the first months of 2019. The next step...
A Landscaping Inc. is preparing its budget for the first months of 2019. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. 10% of all sales are for Cash. Credit customers usually pay 20% of their fee in the month that service is provided, 60% the month after, 18% the second month after receiving service. The remaining 2% is written off...
In problem 7, Big City Manufacturing (BCM) assumed that all credit sales were paid in full,...
In problem 7, Big City Manufacturing (BCM) assumed that all credit sales were paid in full, with no bad debt expense. For this problem, please assume that bad debt expense is again 0% for BCM. Purchases for next month's sales are 50% of projected sales for the next month, and April sales are estimated to be $495,000; purchases for April are paid in cash in March. "Other payments," which include wages, rent, and taxes, are 25% of sales for the...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 245,000 April 155,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of...
A company expects that 90% of its sales will be on account and 10% will be...
A company expects that 90% of its sales will be on account and 10% will be in cash. It expects that 60% of its sales on account will be collected in the month of sale, 25% will be collected in the month following the month of sale, and 15% will be collected two months after the month of sale. It expects the following sales. Month Expected sales January $900,000 February $850,000 March $700,000 April $650,000 May $575,000 June $500,000 July...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Prepare a cash budget for 2 months. Collections from customers: January $85,000, February $150,000. Payments for direct materials: January $50,000, February $75,000. Direct labor: January $30,000, February $45,000.Wages are paid in the month they are incurred. Manufacturing overhead: January $21,000, February $25,000. These costs include depreciation of $1,500 per month. All other...