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 |
What is the cash outflow for November?
Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box.
Cash Outflow for November will be as follows:
Purchases of October = 39034*78% = $30,446.52
Administrative Expenses = $7990
Tax Expenses in November = 0
Rent Expenses = 0
Cash outflow for November = $38,436.52
The table contains the Sales estimates for the next year. Month Sales $ Month Sales $...
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...
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...
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
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...
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...
Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows: Month Jan Feb Mar Apr May June July Aug Sep Oct Demand 46 47 50 49 50 48 51 49 52 53 Nov. Dec. 52 54 C. Forecast next year January sales using the following methods: I. Linear regression (You can use excel to get slope and intercept) ii. Trend adjusted exponential smoothing model. Use a = 0.2, B = 0.3, for the month...
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...
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. ....
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...