Question

In: Accounting

16. Camen Company projects the following​ sales: January February March Cash sales (45%) $12,150 $13,500 $14,400...

16. Camen Company projects the following​ sales:

January

February

March

Cash sales (45%)

$12,150

$13,500

$14,400

Sales on account (55%)

14,850

16,500

17,600

Total sales

$27,000

$30,000

$32,000

Camen collects sales on account in the month after the sale. The Accounts Receivable balance on January 1 is $13,100​, which represents December​'s sales on account. Camen projects the following cash receipts from​ customers:

January
February
March
Cash receipts from cash sales
$12,150
$13,500
$14,400
Cash receipts from sales on account
13,100
14,850
16,500
Total cash receipts from customers
$25,250
$28,350
30,900

Recalculate cash receipts from customers if total sales remain the same but cash sales are only 25​% of the total.Begin by computing the cash sales and sales on account for each month if cash sales are only 25​% of the total.

January

February

March

Cash sales (25%)

Sales on account (75%)

Total sales

$27,000

$30,000

$32,000

​Now, recalculate cash receipts from customers for each month if cash sales are only 25​%

of the total.

January

February

March

Cash receipts from cash sales

Cash receipts from sales on account

Total cash receipts from customers

Enter any number in the edit fields and then continue to the next question.

Solutions

Expert Solution

a.
Calculation of Cash sales and Sales on Account
January February March
Cash Sales (25%) $               6,750 $         7,500 $         8,000
Sales on account (75%) $             20,250 $       22,500 $       24,000
Total Sales $             27,000 $       30,000 $       32,000
b.
Cash receipts from Customer
January February March
Cash receipts from cash sales $         6,750 $         7,500 $         8,000
Cash receipts from sales on account $       13,100 $       20,250 $       22,500
Total cash receipts from customers $       19,850 $       27,750 $       30,500

Related Solutions

Given the following information, construct the firm's cash budget for January, February, and March. 45 percent...
Given the following information, construct the firm's cash budget for January, February, and March. 45 percent of sales for credit and are collected after thirty days; the rest of sales are for cash. Sales are December: $40,000, January: $43,000, February: $38,000, March: $35,000, and April: $33,000. Monthly fixed expenses include salaries, rent, and loan repayments and are estimated to be $9,000. Variable disbursements include material and wages and are estimated to be 75 percent of next month sales. A tax...
the cash sales and credit sales projected for sarahs kitchen are as follows: January february march...
the cash sales and credit sales projected for sarahs kitchen are as follows: January february march april may cash 17,000 19640 16200 15380 17390 credit 40,000 42000 48000 50000 49500 if collections of credit sales are 70% the first month and 30% the second month, what would be the cash receipts for march, april, and may
It is January 1 of Year 2. Sales for Harry Company for January, February, and March...
It is January 1 of Year 2. Sales for Harry Company for January, February, and March are forecasted to be as follows: January, $200,000; February $400,000; March, $500,000. 80% of sales are credit sales; the remaining 20% of sales are cash sales. Of these credit sales, 10% are collected during the month of sale, 30% in the following month, and 60% in the second following month. TOTAL sales for November and December of Year 1 were $200,000 and $400,000, respectively....
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The...
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The company’s past experience indicates that 60% of the accounts receivable are collected in the month of sale, 40% in the month following the sale. The anticipated cash inflow for the month of March is $247800. $365800. $413000. $401200.
Bill Johnson's Company Sales for January, February, and March are expected to be $200,000, $210,000, and...
Bill Johnson's Company Sales for January, February, and March are expected to be $200,000, $210,000, and $190,000, respectively. All sales are on account and are collected 50% in the month of the sale and 45% in the following month. The remaining 5% is determined to be uncollectible. Raw materials are purchased one month before being needed, and all purchases and expenses are paid for as incurred. The cash balance at February 1 is $8,750. Activities for January, February, and March...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units)...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, MATT, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told MATT his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information (above) to...
National Beverage Company anticipates the following​ first-quarter sales for​ 2015: ​$1,874,000​(January), $1,592,000​(February), and ​$2,142,000 ​(March). It...
National Beverage Company anticipates the following​ first-quarter sales for​ 2015: ​$1,874,000​(January), $1,592,000​(February), and ​$2,142,000 ​(March). It posted the following sales figures for the last quarter of ​2014: $1,928,000​(October), ​$2,052,000​(November), and ​$2,192,000​(December). The company sells 45% of its products on​ credit; 55% are cash sales. The company collects credit sales as​ follows: 31% in the following​ month, 51% two months​ later, and 17% three months​ later, with 1% defaults. What are the anticipated cash inflows for the first quarter of​ 2015?...
The following are budgeted data:   January February March Sales in units 16,600 23,200 19,600 Production...
The following are budgeted data:   January February March Sales in units 16,600 23,200 19,600 Production in units 19,600 20,600 19,300   One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 25% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Garrison 16e Rechecks 2017-10-03 Multiple Choice 20,925 pounds 20,575 pounds 20,275 pounds 18,325 pounds , Depasquale Corporation is...
The following are budgeted data: January February March Sales in units 15,500 21,000 18,500 Production in...
The following are budgeted data: January February March Sales in units 15,500 21,000 18,500 Production in units 18,500 19,500 17,400 One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 30% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Multiple Choice 19,970 pounds 18,630 pounds 18,870 pounds 20,130 pounds
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT