Question

The cash? balance, May? 31, 20X4, is $ 12, 000. Sales proceeds are collected as? follows:...

The cash? balance, May? 31, 20X4, is $ 12, 000. Sales proceeds are collected as? follows: 80 % the month of? sale, 10 % the second? month, and 10 % the third month. Accounts receivable are $ 55,000 on May? 31, 20X4, consisting of $ 23,000 from April sales and $ 32,000 from May sales. Accounts payable on May? 31, 20X4, are $ 151,000. Carmen Company pays 20 % of purchases during the month of purchase and the remainder during the following month. All operating expenses requiring cash are paid during the month of? recognition, except that insurance and property taxes are paid annually in December for the forthcoming year. Requirement 1. Prepare a cash budget for June. Confine your analysis to the given data. Ignore income taxes. Requirement 1. Prepare a cash budget for June. ?(Round your answers to the nearest whole? number.)

Carmen Company

Cash Budget

For the Month Ended June 20, 20X4

(In thousands)

Beginning Cash, May 31, 20X4

Cash Reciepts:

Collections from customers from:

June sales

252

May sales

April sales

Total cash available during June

Data Table

Sales

$315

Inventory, May 31

$60

Purchases

195

Available for sale

255

Inventory, June 30

52

Cost of goods sold

203

Gross margin

$112

Operating expenses:

Wages

$45

Utilities

7

Advertising

16

Depreciation

3

Office expenses

2

Insurance and property taxes

5

78

Operating income

$34

Homework Answers

Answer #1

Solution:

Carmen Company
Cash Budget
For the month ended June 30, 20X4
Particulars Amount (In Thousand)
Beginning cash - May 31, 20X4 $12.00
Cash Receipts:
Collection from customer from:
June Sales ($315*80%) $252.00
May Sales ($32/20%*10%) $16.00
April Sales $23.00
Total cash available during June $303.00
Less: Cash disbursement:
Cash paid for merchandise purchase from:
June Purchases ($195*20%) $39.00
May Purchases $151.00
Cash paid for wages $45.00
Cash paid for utilities $7.00
Cash paid for advertising $16.00
Cash paid for office expenses $2.00
Total cash disbursement $260.00
Ending cash balance $43.00
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
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June...
The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding the cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2 percent...
1) Schedule of Cash Payments for a Service Company SafeMark Financial Inc. was organized on February...
1) Schedule of Cash Payments for a Service Company SafeMark Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $165,600 April 152,400 May 138,700 Depreciation, insurance, and property taxes represent $35,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 63% of the remainder of the expenses are...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 12600 16800 14400 43800 Selling price per unit x $60 x $60 x $60 Sales revenue $756000 $1008000 $864000 $2628000 All of the sales are on credit. Quagmire collects from customers as follows: 45% of sales in the month of sale 25% in the month following the sale, and 30% in the second month following...
Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for...
Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2017: April May June Credit sales $ 327,000 $ 307,000 $ 367,000 Credit purchases 135,000 158,000 183,000 Cash disbursements Wages, taxes, and expenses 44,700 12,200 63,700 Interest 11,700 11,700 11,700 Equipment purchases 87,000 164,000 0    The company predicts that 5 percent of its credit sales will never be collected, 25 percent of its sales will be collected in the...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 15600 19800 17400 52800 Selling price per unit x $30 x $30 x $30 Sales revenue $468000 $594000 $522000 $1584000 All of the sales are on credit. Quagmire collects from customers as follows: 40% of sales in the month of sale 25% in the month following the sale, and 35% in the second month following...
Problem 8-23 Schedule of Expected Cash Collections; Cash Budget [LO8-2, LO8-8] The president of the retailer...
Problem 8-23 Schedule of Expected Cash Collections; Cash Budget [LO8-2, LO8-8] The president of the retailer Prime Products has just approached the company’s bank with a request for a $51,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following...
CAT Co. had forecasted sales as follows: -April: $406,000 -May: $452,000 -June: $496,000 Sales are 30%...
CAT Co. had forecasted sales as follows: -April: $406,000 -May: $452,000 -June: $496,000 Sales are 30% credit and 70% cash. 50% of the credit sales are collected in the month of the sale, 30% in the month following the sale, and 20% in the following month. Total sales for the months of February and March were $950,000 with February having $500,000 credit sales and March $400,000. Prepare a sales budget schedule and a cash collections budget schedule for the months...
The Gammaro Company is preparing its cash payments budget. The following items relate to cash payments...
The Gammaro Company is preparing its cash payments budget. The following items relate to cash payments the company anticipates making during the second quarter of the upcoming year. a. The company pays for 50​% of its direct materials purchases in the month of purchase and the remainder the following month. The​ company's direct material purchases for March through June are anticipated to be as​ follows: March April May June $113,000 $137,000 $126,000 $146,000 b. Direct labor is paid in the...
Y&Z Co had forecasted sales as follows: -April= $406,000 -May= $452,000 -June= $496,000 Sales are 30%...
Y&Z Co had forecasted sales as follows: -April= $406,000 -May= $452,000 -June= $496,000 Sales are 30% credit and 70% cash 50% of the credit sales are collected in the month of the sale, 30% in the month following the sale, and 20% in the following month. Totals sales for the months of February and March were $900,000 with February having $500,000 credit sales and March $400,000 Prepares a sales budget schedule and a cash collections budget schedule for the months...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT