Using the same previous data, suppose the company's policy is to maintain an ending inventory equal to $20\%$ of the expected sales volume. The beginning inventory was $100,000$ units.

Required: Prepare the production budget $($Grade$)$

Please solve correctly and apply the assignment in Excel.

With sincere appreciation and thanks for your efforts.