Question

The table contains the Sales estimates for the next year. Month Sales $ Month Sales $...

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 paid in March, June, September, and December each year.
  • Rent expenses of $24,482 are paid in June and December.

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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
The table contains the Sales estimates for the next year. Month Sales $ Month Sales $...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Month Sales $ Month Sales $ Jan         39,597 July     39,428 Feb         51,408 Aug...

    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 $...

    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...

    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...

    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...

    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...

    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:...

    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...

    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...

    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) Foreca...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT