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

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

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)

The Correct Expected Cash... 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