Question

General Data: 1. Sales are 25% cash, 75% on credit. 2. Of the credit sales, 80% are collected in the month following the month of sale and 20% in the second month following the sale. 3, Gross Profit margin on sales averages 25% i.e., the COGS is 75% of sales. 4. All inventory purchases are paid during the month in which they are made 5. The store follows the policy of purchasing enough inventory each month to cover the following months sales at cost 6. A minimum cash balance of $5,000 is to be maintained by the store 7. A $15,000 dividend payment will be made in January 8. The cash balance as of July 31 is $10,400 9 Sales Budget August $14,000 November $38,000 September 26,000 December 48,000 October 22,000 January 18,000 February 16,000 10. Monthly Expenses
media%2Fa9f%2Fa9f167e0-ba47-4071-851c-b8
media%2F579%2F579a3ce7-ee0b-40c0-99a8-60
media%2Fa8c%2Fa8c9a7a4-ac62-4139-93c7-94
media%2F80f%2F80f6604d-241d-4bc5-9ccc-7b
media%2F634%2F634a16a5-7499-4fb8-b7a3-88
media%2Face%2Facea8b3c-7d05-472e-9e0f-ee
media%2F596%2F596bfc95-51a2-4e84-b19f-a6
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
General Data: 1. Sales are 25% cash, 75% on credit. 2. Of the credit sales, 80%...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Sales are 65% cash and 35% credit. Credit sales are collected 10% in the month of...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

  • Accounting Budgets

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT