Budgeted sales in Washburn Company over the next four months are given below: September October November DecemberBudgeted sales $ 180,000 $ 240,000 $ 260,000 $ 200,00025% of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 15% are collected in the second month following sale. The remainder is uncollectible. Given these data, cash collections for December should be:Multiple Choice$244,000.$210,500.$163,200.$189,000.
Question
Budgeted sales in Washburn Company over the next four months are given below: September October November DecemberBudgeted sales 240,000 200,00025% of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 15% are collected in the second month following sale. The remainder is uncollectible. Given these data, cash collections for December should be:Multiple Choice210,500.189,000.
Solution
To calculate the cash collections for December, we need to consider both the cash sales for December and the collections from credit sales of previous months.
-
Cash sales for December: 25% of December sales = 0.25 * 50,000
-
Collections from credit sales:
- 50% of December's credit sales (75% of 200,000 = $75,000
- 30% of November's credit sales (75% of 260,000 = $58,500
- 15% of October's credit sales (75% of 240,000 = $27,000
Adding these up, the total cash collections for December would be 75,000 (50% of December's credit sales) + 27,000 (15% of October's credit sales) = $210,500.
So, the correct answer is $210,500.
Similar Questions
Mzwakhe Pty Ltd has provided you with the following information to assist in the budget preparation. The marketing department has estimated monthly sales as follows:MonthUnitsJuly6 000August7 000September5 000October4 000November3 000 The selling price per unit is R150 per unit. All sales are on credit. Based on the past experience, credit sales are expected to be collected in the following pattern: 40% in the month of sale. 50% in the month following sale. 10% uncollectable.The beginning of accounts receivable balance (excluding uncollectable amounts) on 1 July will be R130 000. The company maintains finished goods inventories equal 10% of the following month’s budgeted sales. The inventory of finished goods on 1 July will be 600 units. Each unit requires two (2) kilograms of Material B on hand at the end of each month equal to 20% of the following month’s production needs. The inventory of Material B on hand in July will be 2 400 kilograms. Material A costs R10 per kilogram. Each unit requires 1,5 hours at R50 per hour.Required:Filli in the missing figures by choosing the correct answer from the options provided:1. Production budget AugustSeptemberBudgeted sales in units7 0005 000Add: Blank 1Blank 2Blank 3Total needs Less: Blank 4Blank 5Blank 6Units to be producedBlank 7Blank 82. Collection from customers JulyAugustAccounts receivableBlank 9 July salesBlank 10Blank 11August sales Blank 12Total cash collectionsBlank 13Blank 143. Material purchases budget for AugustProduction requiredBlank 15X 2 kgBlank 16Total needsBlank 17Add: closing inventoryBlank 18Materials neededBlank 19Less: opening inventoryBlank 20Total material purchasesBlank 21Cost per kgBlank 22Total material costBlank 23
Our sourdough bakery had sales of $598 in December. Projected sales for the next quarter are: January $1,173 February $1,387 March $1,652 Sales are 59% cash and the remainder on credit. Debtors pay in the month following the sale. Calculate total cash collected from sales for the month of February. Please enter your answer to 2 decimal places.
Fill in the Blank QuestionFill in the blank question.A manufacturing company's sales budget indicates the following sales: January: $30,000; February: $20,000; March: $15,000. The company expects 80% of the sales to be on account. Credit sales are collected 30% in the month of the sale and 70% in the month following the sale. The total cash receipts collected during March will be $.
Gardner Company expects sales for October of $238,000. Experience suggests that 45% of sales are for cash and 55% are on credit. The company collects 50% of its credit sales in the month of sale and 50% in the month following sale. Budgeted Accounts Receivable on September 30 is $62,000. What is the amount of Accounts Receivable on the October 31 budgeted balance sheet?
company has projected the following sales for the spring quarter of 2014:April $200,000May $250,000June $275,00065% of all sales are paid for with cash. The remainder is on credit. The pattern for credit receivables collections are: Month of Sale 60%Month After Sale 30%Second Month After Sale 10%What are the forecasted cash collections for the month of June? $248,750 $275,000 $178,750 $269,750
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.