Foodies Supply Company manufactures and sells a pesticide called Snare. The following data are available for preparing budgets for Snare for the first 2 quarters of 2030.

1. Sales:
   1. Expected units sales are: 10,000 bags for quarter 1 and quarter 2's sale is going to increase by 10% of the quarter 1's sale.
   2. Selling price is $50 per bag.
2. Cost of each bag is $20.
3. Desired inventory levels are:
   1. January 1 (Beginning of Quarter 1), 2,000 bags
   2. April 1 (Beginning of Quarter 2), 2,500 bags
   3. July 1 (Beginning of Quarter 3), 3,000 bags.
   4. HINT: Ending inventory in one period becomes beginning inventory in the following period. In other words, your beginning inventory for one period was ending inventory for the previous period.
4. Selling and administrative expenses are expected to be 10% of sales plus $30,000 per quarter.
5. Interest expense is $100,000 and income taxes are expected to be 25% of income before income taxes.

Prepare the production budget.

• For number of units, do NOT include decimal places. For example, if your answer is 5 units, then you should be typing 5 and NOT 5.00.
• For Production budget, all numbers should be entered without any decimal places.

Production Budget

Foodie's Supply Company Production Budget For the Six Months Ending in June 30, 2030
	Quarter 1 (Jan - Mar)	Quarter 2 (Apr - Jun)	Total (Six Months)
Expected Unit Sales
Desired Ending Finished Goods Units
Total Required Units
Beginning Finished Goods Units
Required Production Units