Production Planning in Excel?

[oval]

Dear All,

I am new to this forum - Need help in production planning of a manufacturing unit with the following conditions-

1. If I start the manufacturing unit would like to produce at least 1000 units ( or 4 days of production - 250 every day) due to cost optimization
2. One I start the production would like to keep on doing the production until inventory becomes "0"

Attaching file for your suggestions. Thanks for your help