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 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 end of May?  

Solutions

Expert Solution

As per question, Sales of march, April and may is $402,000, $652,000, $522,000 out of which half sales is in cash.

So, following will be cash and credit sales month-wise :

Month March April May
Total Sales (Given) $ 402,000 $ 652,000 $ 522,000
Less : Cash Sales (half of total sales) $ 201,000 $ 326,000 $ 261,000
Credit Sales $ 201,000 $ 326,000 $ 261,000

a)

Collection period is 60 days which means credit sale of March will be collected in May and credit sale of april will be collected in June.

So, Cash receipts in May = Cash sales in May + Credit sales in March
= $261,000 + $201,000
                                      = $462,000

So, Account receivables Closing Balance In May = Credit sales in April + Credit sales in May

                                                                        = $ 326,000 + $ 261,000

                                                                        = $ 587,000

b)

Collection period is 45 days which means (1) Half of credit sale of March will be collected in April & (2) half of credit sale of march as well as half of credit sales of april will be collected in May.

So, Cash receipts in May = Cash sales in May + half of Credit sales in March + half of Credit sales in April
= $261,000 + (1/2 * $201,000) + (1/2 * $ 326,000)
                                      = $261,000 + $100,500 +$163,000

                                      = $ 524,500

So, Account receivables Closing Balance In May = half of Credit sales in April + Credit sales in May

                                                                        = (1/2 * $326,000) + $ 261,000

                                                                        = $ 163,000 + $ 261,000

                                                                        = $ 424,000

jeff jeffy answered 2 years ago
Next > < Previous

Related 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 $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...
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 $438,000 $688,000 $558,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...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT