Problem #4: Cost of Goods Sold and Purchasing Budget (16 points) The following information was obtained from the sales budget of Treed Diving Supplies for one of the most popular brands that it distributes: Treed Diving Supplies Monthly Sales Budget For the Three Months Ending June 30, 2022 Sales in Units Selling Price per Unit Total Sales Revenue Quarterly April May June Totals 91,500 94,000 82,700 268,200 $32.00 $2,928,000 $32.00 $3,008,000 $32.00 $32.00 $2,646,400 $8,582,400 Treed Diving Supplies purchases the goods from the manufacturer at a cost of $12.25 per unit. Treed incurs $0.15 per unit in freight costs to have the goods delivered from the manufacturer and $0.40 per unit in re-packaging costs for the goods. 1. Prepare a Cost of Goods Sold Budget for the product for the quarter ending June 30, 2022. (6 points) Treed Diving Supplies Monthly Coat of Goods Sold Budget For the Three Months Ending June 30, 2022 Quarterly April May June Totals Problem Set #2 2. Page 11 of 17 Prepare a Purchases Budget for the product for the two months ending May 31, 2022 assuming Treed Diving Supplies plans to have 30% of the next month's sales requirements on hand in ending inventory. At March 31, 2022 Treed will have 27,450 units on hand. (10 points) Treed Diving Supplies Monthly Purchases Budget For the Two Months Ending May 31, 2022 Units Required: For Sales For Ending Inventory Total Requirements Units from Beginning Inventory Net Purchases in Units Total Cost per Unit Total Cost of Net Purchases Supporting Calculations Required for Units Required in Ending Inventory: April May