The sales budget of Hasf Garment industries for the nine month ended 3-9-2020 follows

1^stquarter2^ndquarter3^rdquartertotal 9 month

Cash sales20%18,00028,00021,000 67,000

Credit sales 80%72,000112,00084,000268,000

Other information

• Cost of goods sold 65% of total sales
• Desired ending inventory should not go below 15,000 + 10% of cost the following quarter cost of goods sold
• 4^thquarter sales 100,000

Note: No need to enter currency symbol and comma and % just type numbers2 decimalnumber and percentages (if needed) according to excel (for example: 10000 or 10.65)

Required:

1. Total purchase

1st Quarter

2nd Quarter

3rd Quarter

2. Cost of goods sold

1st Quarter

2nd Quarter

3rd Quarter

Total 9 months

3. Ending inventory

1st Quarter

2nd Quarter

3rd Quarter