Spreadsheet

Dear Mr John,

🙂
Mun Wai ‘s policy to always maintain finished goods inventory at level equal to 30% of nect month’s forecast sales.

B3 -January C3- February D3) March
A4 – Production budget
A5 – Sales (units) B5- 5000 units C5- 6000 units D5-8000 units
A6- Production (units)

Which id correct formula for cell C6?
A= 5000-6000*0.3+5000*0.3
B=1.3*C5-D5*0.3
C=C5+C5*0.3-0.7*D5
D=c5+(d5-c5)*0.3

My answer is D

Thanks 🙂