Question
In: Finance
Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were...
Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were as follows:
March $408,000 April $658,000 May $528,000
a. Assume that Sequoia’s collection period is 60 days. What would be its cash receipts in May? What would be its accounts receivable balance at the end of May?
- Cash Receipts: ?
- Accounts receivable balance:?
b. Now assume that Sequoia’s collection period is 45 days. What would be its cash receipts in May? What would be its accounts receivable balance at the end of May?
- Cash Receipts:?
- Accounts receivable balance:?
Solutions
Expert Solution
| 60 days collection period mean credit sales for March would be paid in May | |||||||
| March | April | May | Total | ||||
| Sales | $408,000 | $658,000 | $528,000 | $1,594,000 | |||
| Cash sales (50%) | $204,000 | $329,000 | $264,000 | $797,000 | |||
| Credit sales collection | $204,000 | $204,000 | |||||
| 408000*50% | |||||||
| Total cash collection | $204,000 | $329,000 | $468,000 | $1,001,000 | |||
| Accounts receivable | $204,000 | $533,000 | $593,000 | ||||
| Thus, total cash collection for May is $468,000 and accounts receivable balance is $593,000 | |||||||
| 45 days collection period mean payment for March would be paid in mid April | |||||||
| March | April | May | Total | ||||
| Sales | $408,000 | $658,000 | $528,000 | $1,594,000 | |||
| Cash sales (50%) | $204,000 | $329,000 | $264,000 | $797,000 | |||
| Credit sales collection | $204,000 | $329,000 | $533,000 | ||||
| 408000*50% | 658000*50% | ||||||
| Total cash collection | $204,000 | $533,000 | $593,000 | $1,330,000 | |||
| Accounts receivable | $204,000 | $329,000 | $264,000 | ||||
| Thus, total cash collection for May would be $593,000 and accounts receivable balance would be $264,000 | |||||||
jeff jeffy answered 1 year agoRelated Solutions
Sequoia Furniture Company’s sales over the past three months,half of which are for cash, were...
Sequoia Furniture Company’s sales over the past three months,
half of which are for cash, were as follows: March April May
$440,000 $690,000 $560,000 a. Assume that Sequoia’s collection
period is 60 days. What would be its cash receipts in May? What
would be its accounts receivable balance at the end of May? b. Now
assume that Sequoia’s collection period is 45 days. What would be
its cash receipts in May? What would be its accounts receivable
balance at the...
Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were...
Sequoia Furniture Company’s sales over the past three months,
half of which are for cash, were as follows: March April May
$402,000 $652,000 $522,000 a. Assume that Sequoia’s collection
period is 60 days. What would be its cash receipts in May? What
would be its accounts receivable balance at the end of May? b. Now
assume that Sequoia’s collection period is 45 days. What would be
its cash receipts in May? What would be its accounts receivable
balance at the...
The time series showing the sales of a particular product over the past 12 months is...
The time series showing the sales of a particular product over
the past 12 months is contained in the Excel Online file below.
Construct a spreadsheet to answer the following
questions.
Use a=0.2 to compute the exponential smoothing forecasts for the
time series (to 2 decimals).
Month
Time-Series
Value
Forecast
1
105
2
130
3
125
4
100
5
90
6
120
7
150
8
135
9
95
10
75
11
100
12
105
13
Use a smoothing constant of...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a particular
product over the past 12 months.
Month
Sales
1
105
2
135
3
120
4
105
5
90
6
120
7
145
8
140
9
100
10
80
11
100
12
110
(a)
Construct a time series plot.
(b)
Use α = 0.3 to compute the exponential smoothing
forecasts for the time series. (Round your answers to two decimal
places.)
Month t
Time Series Value
Yt
Forecast
Ft
1
105...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a particular
product over the past 12 months.
Month
Sales
1
105
2
135
3
120
4
105
5
90
6
120
7
145
8
140
9
100
10
80
11
100
12
110
(a)
Construct a time series plot.
A time series plot contains a series of 12 points connected by
line segments. The horizontal axis ranges from 0 to 13 and is
labeled: Month. The vertical axis ranges from 0...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a
particular product over the past 12 months. can be found in the
below excel file.
https://drive.google.com/file/d/1gIpr0IBYUGgCIRSO7g3mqZ84F89vJU_P/view?usp=sharing
1. Using the three-month moving average, what is the Mean
Squared Error (MSE)?
(Round your answer to 2 decimal places. Negative values
should be indicated by a minus sign.)
2. Using the three-month moving average, what is the
forecast for month 13 ?
(Round your answer to 2 decimal places. Negative values
should be indicated by...
Sales of floor cleaners at Lavoie's Flooring Co. over the past 13 months are as follows:...
Sales of floor cleaners at Lavoie's Flooring Co. over the past
13 months are as follows:
Sales of floor
cleaners -Lavoie's Flooring Co.
Month
Sale ($1,000s)
Total 3 Months
3 Months Avg.
January
11
February
14
41
13.66666667
March
16
40
13.33333333
April
10
41
13.66666667
May
15
42
14
June
17
43
14.33333333
July
11
42
14
August
14
42
14
September
17
43
14.33333333
October
12
43
14.33333333
November
14
42
14
December
16
41
13.66666667
January
11...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a particular
product over the past 12 months.
Month
Sales
1
105
2
135
3
120
4
105
5
90
6
120
7
145
8
140
9
100
10
80
11
100
12
110
Use α = 0.5 to compute the exponential smoothing
forecasts for the time series. (Round your answers to two decimal
places.)
Month t
Time Series Value
Yt
Forecast
Ft
1
105
2
135
3
120
4
105
5...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a particular
product over the past 12 months.
Month
Sales
1
105
2
135
3
120
4
105
5
90
6
120
7
145
8
140
9
100
10
80
11
100
12
110
(b)
Use α = 0.4 to compute the exponential smoothing
forecasts for the time series. (Round your answers to two decimal
places.)
Month t
Time Series Value
Yt
Forecast
Ft
1
105
2
135
3
120
4
105...
The actual returns of company A for the past three months were 15%, 25%, -5% and...
The actual returns of company A for the past three months were
15%, 25%, -5% and that of company B were 18%, 24% and -1%.. In case
of portfolio, there will be equal investment a) Calculate the
expected standard deviation of company B b) Find the correlation
coefficient between the rates of return c) Find the expected
portfolio return if you invest equally in the two companies d) Find
the weighted standard deviation of the portfolio e) Find the
standard...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- After reading David Hume's essay "On Suicide," can you identify his ethical approach when it comes...
- Eskom is a power company conglomerate in the South Africa and operates several power plants throughout...
- Explain the role ethos, logos, & pathos play in persuasive speeches
- A steel plant produces S tons of steel, at a total cost of S2 + X2...
- Titan Mining Corporation has 6.1 million shares of common stock outstanding, 210,000 shares of 3.4 percent...
- The background and concepts of social psychology The theories and theorists credited for influencing the development...
- A cube of side s = 2m sits 1 meter from the origin along the y-axis,...
ADVERTISEMENT