Exercise:

$4.$ Suppose market research in one of the companies indicated that the expected sales volume for the next year is $2500$ units, with a selling price of $50$ SAR per unit.

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

$5.$ 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.