ACCT 322 SEU Sales & Production Budget for The Quarter Ending June 30 Excel Exercise
ABC prepares budgets for the quarter ending June 30 as follows:
Sales in units: April 20,000, May 50,000, June 30,000, July 25,000. Selling price is SR 10 per unit. , inventory in March 31, is 4,000 units. Desired inventory is 20% of the next month sales.
Required:
a. Prepare sales budget
b. Prepare production budge