Answer to Question 1.
Total Cash Inflow in January = (25% of January Sales) + (80% of December Credit Sales) + (20% of November Credit Sales)
December Credit Sales = $48,000 * 75% = $36,000
November Credit Sales = $38,000 * 75% = $28,500
Total Cash Inflow in January = (25% of $18,000) + (80% of
$36,000) + (20% of $28,500)
Total Cash Inflow in January = $4,500 + $28,800 + $5,700
Total Cash Inflow in January = $39,000
Answer to Question 2.
Total Expected Cash Outflow for Inventory in December = Cost of
Inventory purchased in December
Cost of Inventory purchased in December = Cost of Inventory to be
sold in January
Cost of Inventory purchased in December = (75% of $18,000)
Cost of Inventory purchased in December = $13,500
Total Expected Cash Outflow for Inventory in December = $13,500
Answer to Question 3.
Total Expected cash Outflow for January = Expected Cash Outflow for Inventory + Dividend Payment + Wages Payment + Rent Payment +Other Monthly Expense
Total Expected Cash Outflow for Inventory in January = Cost of
Inventory purchased in January
Cost of Inventory purchased in January = Cost of Inventory to be
sold in February
Cost of Inventory purchased in January = (75% of $16,000)
Cost of Inventory purchased in January = $12,000
Total Expected Cash Outflow for Inventory in January = $12,000
Total Expected cash Outflow for January = $12,000 + $15,000 +
$1,400 + $400 + (1% of $18,000)
Total Expected cash Outflow for January = $12,000 + $15,000 +
$1,400 + $400 + $180
Total Expected cash Outflow for January =
$28,980
Answer to Question 4.
Accounts Receivable, January 31 = January Credit Sales + (20% of December Credit Sales)
January Credit Sales = $18,000 * 75% = $13,500
December Credit Sales = $48,000 * 75% = $36,000
Accounts Receivable, January 31 = $13,500 + (20% of
$36,000)
Accounts Receivable, January 31 = $13,500 + $7,200
Accounts Receivable, January 31 = $20,700
General Data: 1. Sales are 25% cash, 75% on credit. 2. Of the credit sales, 80%...
Sales are 65% cash and 35% credit. Credit sales are collected 10% in the month of sale and the remainder in the month after sale. Actual sales in December were а. $57,000. Schedules of budgeted sales for the two months of the upcoming year are as follows: Budgeted Sales Revenue $58,000 January February $72,000 Actual purchases of direct materials in December were $25,000. The company's purchases of direct materials in January are budgeted to be $22,500 and $27,000 in February....
Timpco, a retailer, makes both cash and credit sales (ie, sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: Cash sales Credit sales Total October $ 100,00 160,000 5 200.000 November $ 120.000 150,000 $ 270, eee December $ 80,000 90,000 $ 170,000 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40%...
Wichita Industries' sales are 20% for cash and 80% on credit. Credit sales are collected as follows: 40% in the month of sale, 50% in the next month, and 10% in the following month. On December 31, the accounts receivable balance includes $29,000 from November sales and $30,000 from December sales. Assume that total sales for January and February are budgeted to be $67,000 and $134,000, respectively. What are the expected cash receipts for February from current and past sales?
Timpco, a retailer, makes both cash and credit sales (.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: Cash sales Credit sales Total October $ 115,000 115,800 $ 230,000 November $ 95,000 114,000 $ 209,000 December $ 95,000 104,500 $ 199,500 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: Cash sales Credit sales Total October $ 120,000 120,000 $ 240,000 November $ 99,000 118,800 $ 217,800 December $ 97,000 1 06,700 $ 203,700 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40%...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November $ 95,000 114,000 209,000 December $ 95,000 104,500 Cash sales 115,000 115,000 230,000 Credit sales 199,500 Total Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: November $59,000 October December $ 65,000 65,000 $130,000 $77,000 Cash sales Credit sales 70,800 $ 129,800 84,700 $161,700 Total Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month...
Information pertaining to Noskey Corporation's sales revenue follows: Cash sales Credit sales Total sales November 2018 (Actual) $ 105,000 270,000 $ 375,000 December 2018 (Budgeted) $ 115,000 395,000 $ 510,000 January 2019 (Budgeted) $ 70,000 200,000 $ 270,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
Please show full calculations for each. Thanks! 1) ABC Company's budgeted sales are as follows: July = 3,000 units; August = 2,500 units. June ending inventory = 1,200 units. Budgeted ending inventory must equal 40% of next month's budgeted sales. Production budgeted for July would equal units = ? units ------ 2) ABC Company's budgeted production is as follows: January = 5,000 units; February = 8,000 units. Each unit produced requires 3 pounds of raw material. January beginning inventory...
Question 4 (11 marks) The following information pertains to the operating budgets for Casey Corporation. • Budgeted sales: $200,000 in January and $100,000 in February. • All sales are on credit. Collections for sales are 60% in the month of sale and 40% the next month. • Cost of goods sold (COGS) is 75% of sales. • Beginning accounts receivable is $0. • Beginning inventory is $14,000. • Beginning accounts payable is $80,000, of which 10% is related to sales in November the year before, the remainder...