Question
In: Accounting
: E Company has budgeted sales revenues of $170,000 for May, $215,000 for June, $240,000 for...
: 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 who pay in the month of sale (so they only collect 98 percent of the total amount for those sales instead of the usual 100 percent). Prepare a schedule of cash collections for the month of July only.
Solutions
Expert Solution
| Month | sales | May | June | July | Aug | |
| May | 170,000 | (55%(Less2% Discount),25%,18% | 91,630 | 42,500 | 30,600 | |
| (170000 X 55%)*98% | (170000 X 25%) | (170000 X 18%) | ||||
| June | 215,000 | (55%(Less2% Discount),25%,18% | 115,885 | 53,750 | 38,700 | |
| (215000 X 55%)*98% | (215000 X 25%) | (215000 X 18%) | ||||
| July | 240,000 | (55%(Less2% Discount),25% | 129,360 | 60,000 | ||
| (240000 X 55%)*98% | (240000 X 25%) | |||||
| August | 160,000 | (55%(Less2% Discount) | 86,240 | |||
| (160000 X 55%)*98% | ||||||
| 213,710 |
ekkarill92 answered 1 year agoRelated Solutions
Part #4: E Company has budgeted sales revenues of $160,000 for May, $210,000 for June, $235,000...
Part #4: E Company has budgeted sales revenues of $160,000 for
May, $210,000 for June, $235,000 for July, and $172,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...
Question 4: Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit Sales...
Question 4: Rodie Company has budgeted sales revenues as
follows:
Particulars
June
July
August
Credit Sales
$135,000
$145,000
$90,000
Cash Sales
$90,000
$255,000
$195,000
Total Sales
$225,000
$400,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. Purchases of inventory are all on
credit and 50% is paid in the month of purchase and 50% in the
month following purchase....
Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit sales $135,000 $145,000...
Rodie Company has budgeted sales revenues as follows:
Particulars June July August Credit sales $135,000 $145,000 $
90,000 Cash sales 90,000 255,000 195,000 Total sales $225,000
$400,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. Purchases of inventory
are all on credit and 50% is paid in the month of purchase and 50%
in the month following purchase. Budgeted...
Farley Company has budgeted sales revenues as follows: June July August Cash Sales 255,000 195,000 Credit...
Farley Company has budgeted sales revenues as follows:
June
July
August
Cash Sales
255,000
195,000
Credit Sales
135,000
145,000
90,000
Total Sales
135,000
400,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. Purchases of inventory are all on
credit and 50% is paid in the month of purchase and 50% in the
month following purchase. Budgeted inventory purchases are:...
Cruises, Inc. has budgeted sales revenues as follows: June July August September Credit sales ($)...
Cruises, Inc. has budgeted sales revenues as follows:
June
July
August
September
Credit sales ($)
135,000
125,000
$ 90,000
120,000
Cash sales ($)
90,000
255,000
195,000
175,000
Total sales ($)
225,000
380,000
285,000
295,000
Purchases ($)
300,000
240,000
205,000
185,000
Past experience indicates that 60% of the credit sales will be
collected in the month of sale and 20% will be collected in the
following month and the remaining 20% after two months. Purchases
of inventory are all...
Marshall Department Stores has budgeted sales revenues as follows:
Marshall Department Stores has budgeted sales revenues as
follows:
Credit
sales July
$250,000
August 190,000
September
150,000
October 140,000
In the past, 69% of the credit sales
were collected in the month of sale, 21% were collected in the
first month following the sale and 10% in the second month
following the sale. Purchases of inventory are all on credit and
28% is paid in the month of purchase and 72% in the...
Marshall Department Stores has budgeted sales revenues as follows:
Marshall Department Stores has budgeted sales revenues as
follows:
Credit
sales July
$250,000
August 190,000
September
150,000
October 140,000
In the past, 69% of the credit sales
were collected in the month of sale, 21% were collected in the
first month following the sale and 10% in the second month
following the sale. Purchases of inventory are all on credit and
28% is paid in the month of purchase and 72% in the...
Cave Hardware's forecasted sales for April; May; June; and July are $200,000; $230,000; $190,000; and $240,000;...
Cave Hardware's forecasted sales for April; May; June; and July
are $200,000; $230,000; $190,000; and $240,000; respectively. Sales
are 65% cash and 35% credit with all accounts receivables collected
in the month following the sale. Cost of goods sold is 75%of sales
and ending inventory is maintained at $60,000 plus 10% of the
following month's cost of goods sold. All inventory purchases are
paid 22% in the month of purchase and 78%in the following month.
What are the cash collections...
The Cambridge Company has budgeted sales revenues as follows. Jan Feb Mar__ Credit sales $45,000 $36,000...
The Cambridge Company has budgeted sales revenues as follows.
Jan Feb Mar__ Credit sales $45,000 $36,000 $27,000 Cash sales
27,000 76,500 58,500 Total sales $72,000 $112,500 $85,500 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. Purchases of inventory are all on credit; 40% is
paid in the month of purchase and 60% in the month following
purchase. Budgeted inventory purchases...
A retailer has the following budgeted sales: May $3 000 000 June $2 500 000 July...
A retailer has the following budgeted sales:
May $3 000 000
June $2 500 000
July $2 200 000
August $2 800 000
The store employees earn fixed monthly salaries totalling $120
000 and 10% commissions of
current monthly sales. Disbursements are made semi- monthly,
that is half to be paid a month
after salaries and commissions are earned. Other expenses are:
Rent $30 000 paid 1st day of each
month miscellaneous expenses 6% of sales insurance $3 000 per...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Boarder line and antisocial disorder are perhaps the most research personality disorder.What are the most common...
- Read at least 2 academically reviewed articles and Write an annotated bibliography paper on Master Budgeting
- Why normalization and referential integrity are important principles when designing relational databases?
- Respond to the following in a minimum of 175 words: Discuss what elements should be present...
- 1) The 3rd bright fringe of a double slit interference pattern is 30.0 cm above the...
- A solar cell generates a potential difference of 0.320 V when a 445.0 ? resistor is...
- A ceiling fan consists of a small cylindrical disk with 5 thin rods coming from the...
ADVERTISEMENT