Month 3 Month 4 Cash sales 29 25 Cash collection from accounts receivables month 1 31 155 month 2 35 35 175 month 3 87 29 145 month 4 75 125 Expected...
View the step-by-step solution to:

Question

I am working on the below homework problem, I built the attached excel file to solve, but the homework application

keeps telling me that I am wrong. I am inputing the answer not in thousands, but as "182" and "164"


Here is a forecast of sales by National Bromide for the first 4 months of 2017 (figures in thousands of dollars):

 

Month: 1 2  3  4

Cash sales  26   35   29   25 

Credit sales  155  175   145  125 

 

Screen Shot 2019-12-11 at 7.37.56 PM.pngScreen Shot 2019-12-11 at 7.35.41 PM.png

Screen Shot 2019-12-11 at 7.35.41 PM.png

Month 3
Month 4
Cash sales
29
25
Cash collection from accounts receivables
month 1
31
155
month 2
35
35
175
month 3
87
29
145
month 4
75
125
Expected cash
182
164

Screen Shot 2019-12-11 at 7.37.56 PM.png

Month 3
Month 4
Cash sales
29
25
Cash collection from accounts receivables
month 1
=D4*0.2
155
month 2
=D5*0.2
=D5*0.2
175
month 3
=D6*0.6
=D6*0.2
145
month 4
=D7*0.6
125
Expected cash
=SUM (B2:B8)
-SUM(C2:C8)

Top Answer

The Correct Expected Cash... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question