Question

Ebony Co. has forecast sales to be $300,000 in May, $375,000 in June, $475,000 in July...

Ebony Co. has forecast sales to be $300,000 in May, $375,000 in June, $475,000 in July and $600,000 in August. Forty percent of sales are made in cash, the remainder is on account. Credit sales are partially collected in the month of sale, with all collections completed by the end of the month following the sale. The August 31 accounts receivable is budgeted to be $108,000. What are budgeted cash collections for July?

a. $389,500

b. $267,000

c. $457,000

d. $415,000

Homework Answers

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
Northern Company has budgeted sales for the upcoming months as follows: April     450,000 May     465,000 June    ...
Northern Company has budgeted sales for the upcoming months as follows: April     450,000 May     465,000 June     490,000 July       515,000 August    500,000 Septemeber    475,000 18% percent of the sales are credit sales and the remainder are cash sales. Credit sales are collected 45% in the month of sale, 36% in the month following the sale, and 19% in the second month following the sale. Required: Prepare a schedule of cash collections for June, July, & August
E Company has budgeted sales revenues of $170,000 for May, $215,000 for June, $240,000 for July,...
E Company has budgeted sales revenues of $170,000 for May, $215,000 for June, $240,000 for July, and $160,000 for August. To prepare a cash budget, the company must determine the budgeted cash collections from sales. Generally the trend has been 55 percent collected in the month of sale, 25 percent collected in the month following sale, 18 percent collected in the second month following sale, and 2 percent uncollectible. Also, E Company grants a 2 percent cash discount to customers...
Felix Co. expects June sales to be $29,000, July sales to be $35,000, August sales to...
Felix Co. expects June sales to be $29,000, July sales to be $35,000, August sales to be $32,000, and September sales to be 33,000. 40% of sales are cash sales and remaining 60% are credit sales. Collection of credit sales are 50% in the month of sale, 40% in the month following sale and 5% two months following sale. The remaining 5% is uncollectible. What is the expected total cash collections in August?
Month Sales Purchases Cash Expenses Paid May $ 94,000 $ 61,000 $ 18,000 June 116,000 90,000...
Month Sales Purchases Cash Expenses Paid May $ 94,000 $ 61,000 $ 18,000 June 116,000 90,000 26,000 July 135,000 114,000 37,750 August 134,000 70,000 30,800 The majority of Martin’s sales (65 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 35 percent are collected in the month of sale and 65 percent are collected in the following month. All of Martin’s purchases are on account with 50 percent paid in the month...
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...
Cruises, Inc. has budgeted sales revenues as follows: June July August Credit Sales $135,000 $135,000 $90,000...
Cruises, Inc. has budgeted sales revenues as follows: June July August Credit Sales $135,000 $135,000 $90,000 Cash Sales 90,000 225,000 195,000 Total Sales $225,00 $380,000 $285,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Cash disbursements were $421,000 for July and $250,500 for August. The company wishes to maintain a minimum cash balance of $50,000 at the end of each...
Sushi House has budgeted sales revenue as follows: June July August Credit Sales $85,000 $80,000 $72,000...
Sushi House has budgeted sales revenue as follows: June July August Credit Sales $85,000 $80,000 $72,000 Cash Sales 14,000 25,000 32,000 Total Sales $99,000 $105,000 $104,000 Past experience indicates that 70% of the credit sales will be collected in the month of sale and the remaining 30% will be collected in the following month. Purchases of inventory are all on credit and 60% is paid in the month of purchase and 40% in the month following purchase. Budgeted inventory purchases...
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September,...
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September, and October as follows: Actual: May 5,930 units June 6,240 units Forecast: July 5,910 units August 6,890 units September 5,630 units October 5,210 units Required: a. The firm’s policy is to have finished goods inventory on hand at the end of the month that is equal to 70% of the next month’s sales. It is currently estimated that there will be 4,137 units on...
Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for...
Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $210,000 June 250,000 July 360,000 All sales are on account. 50 percent of sales are expected to be collected in the month of the sale, 38% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May,...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit Price Budgeted sales June 20,000 $10 $200,000 July 40,000 $10 $400,000 August 50,000 $10 $500,000 September 30,000 $10 $300,000 October 60,000 $10 $600,000 From past experience, the company has learned that 40% of a month’s sale are collected in the month of sale, another 60% are collected in the month following the sale. Prepare a schedule of expected cash collections from sales for the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT