I'm stuck on a question that is related to a production budget (finished goods). I essentially need to calculate the Closing balance (units), total units available, opening balance and production for the months July, August, September and October.

Additionally, finished goods (production budget) ending inventory for each month is required to be 36% of next months forecast sales.

Furthermore, finished goods inventories at the end of June are 150 units. I think I keep doing it wrong because my sales and productions are the exact same, and my opening and closing balances are the same too, but I can't figure out exactly what I'm doing wrong.

I've also included the predicted sales that was included however I'm not sure if it applies to this question.