Month Sales $ Month Sales $ Jan 88,498 July 28,618 Feb 34,044 Aug 58,273 Mar 58,273 Sep 88,498 Apr 28,618 Oct 58,273 May 88,498 Nov 34,044 June 34,044 Dec 28,618 The table contains the Sales estimates for the next year. Sales are collected as follows: In the month of Sales: 33% In the next month: 21% After 2 months: 7% After 3 months: remainder is collected What is the cash collection for September? Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box.
Solution:
Collection for June Sales (34044*39%) | 13277.16 |
Collection for July Sales (28618*7%) | 2003.26 |
Collection for August Sales (58273*21%) | 12237.33 |
Collection for September Sales (88498*33%) | 29204.34 |
Total cash collection for September | 56722.09 |
Month Sales $ Month Sales $ Jan 88,498 July 28,618 Feb 34,044 Aug 58,273 Mar 58,273...
The table contains the Sales estimates for the next year. Month Sales $ Month Sales $ Jan 19,034 July 99,711 Feb 5,265 Aug 80,177 Mar 80,177 Sep 19,034 Apr 99,711 Oct 80,177 May 19,034 Nov 5,265 June 5,265 Dec 99,711 Sales are collected as follows: In the month of Sales: 43% In the next month: 33% After 2 months: 9% After 3 months: remainder is collected What...
Month Sales $ Month Sales $ Jan 39,597 July 39,428 Feb 51,408 Aug 84,330 Mar 84,330 Sep 39,597 Apr 39,428 Oct 84,330 May 39,597 Nov 51,408 June 51,408 Dec 39,428 The table contains the Sales estimates for the next year. The Purchases are 76% of Sales. Purchases are paid in the following month. The administrative expenses of $11,695 are paid each month Tax expenses of $25,555 are...
What is the cash collection for October? Sales are: In the month of sales: 25% In the next month: 22% After 2 months: 7% After 3 months: remainder is collected Month Sales $ Month Sales $ Jan 34,599 July 20,706 Feb 33,253 Aug 67,777 Mar 67,777 Sep 34,599 Apr 20,706 Oct 67,777 May 34,599 Nov 33,253 June 33,253 Dec 20,706
The table contains the Sales estimates for the next year. Month Sales $ Month Sales $ Jan 46,442 July 37,618 Feb 36,143 Aug 39,034 Mar 39,034 Sep 46,442 Apr 37,618 Oct 39,034 May 46,442 Nov 36,143 June 36,143 Dec 37,618 The Purchases are 78% of Sales. Purchases are paid in the following month. The administrative expenses of $7,990 are paid each month Tax expenses of $12,127 are...
ABC Company has the following projected sales: Month Sales Jan $3,000 Feb $12,000 Mar $25,000 Apr $57,000 15% of the sales are collected in the same month. 23% of the sales are collected after one month, 41% of the sales are collected after two months, and the remainder are collected after three month. What is the amount of the April collections? Enter your answer rounded off to two decimal points. Do not enter $ or...
Month Sales $ Jan 46140 FEB 12824 MAR 17042 APR 19855 may 46140, june 12824, Month Sales $ July 19855, aug 17042, sep 46140 0ct 17042 nov12824 dec 19855 The company has estimated expenses as follows: General and administrative expenses: $5592 Material purchases are 73 percent of sales. Material purchases are paid in the month following the purchase. Interest payment per month: $4212 Rent expenses per quarter starting March: $2565 Calculate the cash outflows for June. Enter your answer rounded...
please explain the answer. ocaut Coipany Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Month Seasonal index 1.2 1.3 1.1 1.0 1.0 0.9 0.8 0.7 0.9 1 L Sales (S '000s) 9.6 10.5 8.6 1 The seasonal index for December is: 1.0 1.1 6.4 7.2 8.3 7.4 7.1 6.0 5.4 A 0.8 B 0.9 C 1.0 D 1.1 E 1.2
Jan Feb Mar Apr May June $172,180 $171,965 $169,100 $170,048 $168,204 $172,003 July Aug Sep Oct Nov Dec $172,938 $172,709 $171,500 $170,677 $170,732 $170,206 If the monthly staffing budget was $171,022 for all months last year, and one standard deviation equals $1,458, are any of these variances beyond the expected range of variation for the 2007 budget year? Illustrate this with a control chart that shows the actual budget by month, a mean line, +2 and -2 Standard deviations.
The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar 16 Apr May 15 13 Jun 18 Jul 15 Aug Sept Oct Nov Dec 18 19 22 202 This exercise contains only parts de b) The forecast for the next month (Jan) using the naive method = 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach = 22 sales (round your...
The monthly sales for Yazici Batteries, Inc., were as follows: Jan Month Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 24 Sales 19 23 16 15 13 15 17 18 22 21 23 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach 22.67sales (round...