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 |
What is the cash collection for October? Sales are: In the month of sales: 25% In...
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 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...
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...
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...
Question: Cash Receipts 25% of sales are in cash and collected in the month the sale is made and 75% are on credit and collected in the month after the sale. December 2017 sales were $3 million. The sales forecast for 2018 is as follows: January 2,800,000 February 2,500,000 March 3,200,000 April 3,400,000 May 3,600,000 June 3,600,000 July 3,800,000 August 4,000,000 September 3,600,000 October 3,400,000 November 2,800,000 December 2,600,000 Cash Disbursements The disbursements for this firm are as follows: Payments...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 114,000 July $ 59,000 February 107,000 August 59,000 March 39,000 September 69,000 April 39,000 October 99,000 May 34,000 November 119,000 June 49,000 December 137,000 Total annual sales = $924,000 Bombs Away Video Games sells the popular Strafe and Capture video game. It sells for $5 per unit and costs $2 per unit to produce. A level production policy is followed. Each month's production is equal to...
Product Sales by Month Product X Product Y Product Z $100,000 $80,000 Value $60,000 $40,000 $20,000 May July Sept Nov Apr Aug Oct Dec $0 Jan Mar Feb June Month Activity: Interpret this line graph in 30-50 words. ....
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...
If there are any seasonality or relationship between the price and the US oil price? How to analyze? Jan-10 2.769 Jan-11 3.148 Jan-12 3.44 Jan-13 3.391 Jan-14 3.392 Feb-10 2.699 Feb-11 3.264 Feb-12 3.64 Feb-13 3.736 Feb-14 3.434 Mar-10 2.824 Mar-11 3.615 Mar-12 3.907 Mar-13 3.779 Mar-14 3.606 Apr-10 2.9 Apr-11 3.852 Apr-12 3.958 Apr-13 3.638 Apr-14 3.735 May-10 2.89 May-11 3.96 May-12 3.791 May-13 3.675 May-14 3.75 Jun-10 2.785 Jun-11 3.735 Jun-12 3.596 Jun-13 3.689 Jun-14 3.766 Jul-10 2.782...
Consider five years of monthly sales data for a company in the
attached file (Q5.xlsx). a) Forecast monthly sales for the next
year (2020). (10 marks) b) Discuss whether a simple exponential
smoothing model works well with this data or not. (5 m
7 9 Month Sales 747 Feb-14 697 Mar-14 1014 Jan-14 Ap4 1126 May-14 1105 Jun-14 1450 Jul-14 1633 Aug-14 1711 Sep-14 1307 Oct-1223 Nov-14 9T5 Dec-14S53 4J-15 1024 Feb-15928 Mar-151442 7Apr-151371 May-15 1536 Ju15 2004 Jul-15 1854...