Business Finance Homework Help

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