This post is currently awaiting moderation.
Question
In: Accounting
Copper Corporation has the following sales budget for the last six months of 2016:
Copper Corporation has the following sales budget for the last six months of 2016:
| July | $200,000 | October | $180,000 |
| August | 160,000 | November | 200,000 |
| September | 220,000 | December | 188,000 |
Historically, the cash collection of sales has been as follows:
65 percent of sales collected in month of sale,
25 percent of sales collected in month following sale,
8 percent of sales collected in second month following sale, and
2 percent of sales is uncollectable.
Cash collections for October are
$117,000.
$174,000.
$184,800.
$199,000.
$176,400.
Solutions
Expert Solution
To calculate the cash collections of October we need to understand what sales collection will be received in October
As per the information given in the question
- 65 percent of sales collected in month of sale - This means (65% of $180,000) will be collected during the month of October. 65% of $180,000 = $117,000.
- 25 percent of sales collected in month following sale - This means 25% of the sales made in September will also be collected during October. 25% of $220,000 = $55,000.
- 8 percent of sales collected in second month following sale - This means 8% of the sales made in August will also be collected during October. 8% of $160,000 = $12,800.
Therefore cash collections of October is
= $117,000 + $55,000+ $12,800
= $184,800
$184,800
Junaid answered 2 years agoRelated Solutions
ABC Company has the following sales budget for the last six months of 2020:
Note: Not all sales are always collected. Remember Bad Debt Expense. So don’t worry if the problems do not add up to 100%.
1. ABC Company has the following sales budget for the last six months of 2020:
July $9,000
August $8,000
September $11,000
October $9,000
Historically, the cash collection of sales has been as follows:
35% of sales collected in the month of sale,
45% of sales collected in the month...
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six
months (January – June):
Month
Period
Sales
January
1
16
February
2
25
March
3
20
April
4
20
May
5
31
June
6
35
July
7
26
August
8
(a)
Use exponential smoothing (a= 0.10) to forecast the sales for
August (to 2 decimals). What is the value?
Compute the MSE for the exponential smoothing method from the
above question (to 2 decimals).
Use a 2-period moving average...
Based on an analysis of the last six months’ sales, your boss notices that sales of...
Based on an analysis of the last six months’ sales, your boss
notices that sales of beef products are declining in your chain’s
restaurants. As beef entrée sales decline, so do profits. Fearing
beef sales have declined due to several newspaper stories reporting
E.coli contamination discovered at area grocery stores, he suggests
a survey of area restaurants to see if the situation is
pervasive.
What do you think of this research suggestion?
How, if at all, could you improve on...
Thomas Train has collected the following information over the last six months.
Thomas Train has collected the following information over the
last six months.MonthUnits producedTotal costsMarch10,000$25,600April12,00026,200May19,60028,000June13,00026,450July12,00026,000August15,00026,500Using the high-low method, what is the variable cost per
unit?Round to two decimal places.
Fromme's Frocks has the following machine hours and production costs for the last six months of...
Fromme's Frocks has the following machine hours and production
costs for the last six months of last year:
Month
Machine Hours
Production Cost
July
15,000
$12,075
August
13,500
10,800
September
11,500
9,580
October
15,500
12,080
November
14,800
11,692
December
12,100
9,922
If Fromme expects to incur 14,000 machine hours in January,
what will be the estimated total production cost using the high-low
method?
Fromme's Frocks has the following machine hours and production costs for the last six months of...
Fromme's Frocks has the following machine hours and production
costs for the last six months of last year:
Month Machine Hours Production Cost July 16,600 $ 12,155 August
15,100 12,400 September 13,100 9,740 October 17,100 12,240 November
16,400 11,772 December 13,700 9,970 If Fromme expects to incur
12,200 machine hours in January, what will be the estimated total
production cost using the high-low method? $8,732.63. $9,177.50.
$7,625.00. $19,865.00.
(1) Fromme's Frocks has the following machine hours and production costs for the last six months...
(1) Fromme's Frocks has the following machine hours and
production costs for the last six months of last year:
Month
Machine Hours
Production Cost
July
17,000
$
12,175
August
15,500
12,800
September
13,500
9,820
October
17,500
12,280
November
16,800
11,792
December
14,100
9,982
If Fromme expects to incur 12,600 machine hours in January, what
will be the estimated total production cost using the high-low
method?
(A) $20,029.00.
(B) $8,841.60.
(C) $7,749.00.
(D) $9,266.50.
(3)
Case
(A)
Case
(B)
Case
(C)...
Simpson Glove Company has made the following sales projections for the next six months. All sales...
Simpson Glove Company has made the following sales projections
for the next six months. All sales are credit sales. March $41,000
June $47,000 April 50,000 July 58,000 May 32,000 August 62,000
Sales in January and February were $41,000 and $39,000,
respectively. Experience has shown that of total sales receipts 10
percent are uncollectible, 40 percent are collected in the month of
sale, 30 percent are collected in the following month, and 20
percent are collected two months after sale. Prepare...
Simpson Glove Company has made the following sales projections for the next six months. All sales...
Simpson Glove Company has made the following sales projections
for the next six months. All sales are credit sales.
March
$52,000
June
$58,000
April
61,000
July
69,000
May
43,000
August
73,000
Sales in January and February were $41,000 and $39,000,
respectively. Experience has shown that of total sales receipts 10
percent are uncollectible, 35 percent are collected in the month of
sale, 25 percent are collected in the following month, and 30
percent are collected two months after...
Cash budget) The Sharpe Corporation's projected sales for the first 8 months of 2016 are shown...
Cash budget) The Sharpe Corporation's projected sales for the
first 8 months of 2016 are shown in the following table:
January
$190,000
May
$300,000
February
$120,000
June
$270,000
March
$135,000
July
$225,000
April
$240,000
August
$150,000
Of Sharpe's sales, 30 percent is for cash, another 50 percent
is collected in the month following the sales, and 20 percent is
collected in the second month following sales. November and
December sales for 2015 were $220,000 and $175,000 respectively.
Sharpe purchases its...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 3) You are rolling a 12 sided die 8 times. a) What is the size for...
- explain the difference between quantitative and qualitative research strategies. Provide an example of a crime based...
- use postorder and inorder tree traversals to make preorder traversal. #!/usr/bin/env python3 # encoding: UTF-8 """Turning...
- 1. Write an if-else statement to describe an object. Print "Balloon" if isBalloon is true and...
- An investor is considering purchasing a Treasury bond with a 20 year maturity, an 8% coupon...
- Write a program that copies the contents of one file to a destination file. This program...
- how to conduct a marketing mix for 3d crest white strips
ADVERTISEMENT