D E G - A B C PRODUCTION BUDGET: K - M The Citizens Against Gun Violence Foundation is selling Stop the Gun Violence T shirts, and the proceeds will go to help families who have lost loved ones due to gun violence. Projected sales are as follows: 5 6 7 Sales in Units April 100,000 8 May 150,000 9 June 180,000 10 July 160,000 11 August 200,000 The Foundation is now in the process of preparing a production budget for the April through July. Past experience has shown that end-of- 12 month inventory levels must equal 20% of the following month's sales. The inventory at the end of March was 10,000 units. 13 14 Required: Prepare a production budget for April through July. In your budget, show the number of units to be produced each month and for the quarter 15 in total. 16 17 18 Production Budget April May June 19 20 July August Sales in units 21 22 Add: 23 24 25 Total Needs 26 Less: 27 28 29 30 Units to be produced 31 32 DIRECT MATERIAL PURCHASES BUDGET 33 34 35 Sheet1 Past