70.2K
Verified Solution
Link Copied!
Row 3 needs to be 20% higher than row 4.
Write an if statement where if C7 = 0, then set it equals to E3 if not then set it equals to E3 * 1 + B2.
A B C D E F G H I
| ROW 1 Sales schedule |
| % Additional sales | 20% | March | April | May | June | July | August | Apr - July |
| original sales forecast | | 92.000 | 115.000 | 184.000 | 140.000 | 116.000 | 92.000 | 555.000 |
| Schedule 1: Sales Forecast | | | 92.000 | 115.000 | 184.000 | 140.000 | 116.000 | 92.000 | 555.000 |
| Credit sales | 40% | 36.800 | 46.000 | 73.600 | 56.000 | 46.400 | | |
| Cash sales | 60% | 55.200 | 69.000 | 110.400 | 84.000 | 69.600 | | |
| Credit sales new policy | 70% | 0.000 | | | | | | |
| Schedule 2: Cash Collections | | | | | | | | |
| Cash sales this month | | 55.200 | 69.000 | 110.400 | 84.000 | 69.600 | | |
| Credit sales last month | | | 36.800 | 46.000 | 73.600 | 56.000 | | |
| Total collections | | | 105.800 | 156.400 | 157.600 | 125.600 | | |
Answer & Explanation
Solved by verified expert
