Question

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 the current month. Construct a cash budget for March using your expected cash receipts from problem 7 and calculate the average net cash flow during the month of March. Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.

Previous Question: 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?

Homework Answers

Answer #1
Cash Budget
Expected Cash Receipts        437,250
Less: Purchases        247,500
Other Payments        138,750
Net Cash flow           51,000

Hence, average net cash flow will be $51,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
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...
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...
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...
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...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000 January 9,000 23,000 February 11,000 25,000 March 77,800 12,000 12,000 22,000 March 68,500 12,500 12,500 23,500 May 72,000 12,300 12,300 24,500 Wages & other operating expenses are estimated as follows: Month Wages Other Expenses March 20,000 28,000 April 17,500 22,000 May 20,000 23,000  Newequipment purchased in February for $16,750 istobepaid forin April.  New furniture purchased in March for $15,000 isto be paid...
The city of Charleston had the following sales of water for the selected months of 2017:...
The city of Charleston had the following sales of water for the selected months of 2017: Month Sales February $60,000 March 45,000 April 60,000 May 42,500 June                    100,000 July 120,000 All sales are on credit. Historically, 60 percent is collected in the month of sale, 30 percent during the first month following the sale, and 10percent in the second month following the sale. Water purchases by month are as follows: Month February $60,000 March 40,000 April 45,000 May 59,750 June...
4. The Khaki Company has the following budgeted sales data: January February March April Credit Sales...
4. The Khaki Company has the following budgeted sales data: January February March April Credit Sales $350,000 $320,000 $400,000 $360,000 Cash Sales $70,000 $90,000 $80,000 $70,000 The regular pattern of collection of credit sales is 30% in the month of sales, 25% in the month following sales, and the remainder in the second month following the month of sale. There are no bad debts. Required: a. Determine budgeted cash receipts for April. b. Determine budgeted accounts receivable balance on March...
LO 4 Joshua Studios expects the following sales in March, April, and May: Cash Sales Credit...
LO 4 Joshua Studios expects the following sales in March, April, and May: Cash Sales Credit Sales March $55,000 $240,000 April 50,000 250,000 May 75,000 300,000 The controller has determined that the company collects credit sales in the following pattern: 30% in the month of sale, 50% in the first month after sale, 10% in the second month after sale, and 10% uncollectible. How much cash will be collected from customers in May?(a) $ 75,000 (b) $239,000 (c) $290,000 (d)...
Bennett Inc. found that about 45% of its sales during the month were for cash. Bennett...
Bennett Inc. found that about 45% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August 300,000 Required: 1. Calculate credit sales for May. $ Calculate...
Bennett Inc. found that about 25% of its sales during the month were for cash. Bennett...
Bennett Inc. found that about 25% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August 300,000 Required: 1. Calculate credit sales for May. $ Calculate...