Need Help with the COGS budget (cybertext I see the light)

All blank yellow spaces need filling out, the ones that are filled in already are correct (and assumably need to be used to determine the rest)

Other given info:

Round dollars to two places, $##.## $ 90,000.00 90,000.00 19.07) LUST UI Goods Sold Budget- Beginning Inventory, Finished Goods Production Costs: Materials: Lamp Kits: Beginning Inventory Purchased Available for Use Ending Inventory of Lamp Kits Lamp Kits Used In Production units = units = units = units = 500 $ 24450 $ 24400 $ 550 $ 16.400 8.200.000 400,980.000 400,160.000 9,020.00 {9.08) Total Materials: Labor Overhead Cost of Goods Available Less: Ending Inventory, Finished Goods Cost of Goods Sold $ $ 50,020.00 320,020.00 {9.09) {9.10) {9.11) {9.12) {9.13) {9.14) 2 Materials Budget Lamp Kits Needed for Production Desired Ending Inventory Total Needed Less: Beginning Inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, St###) 1 24,400 units 550 units 2 4,950 units 500 units 24450 16.40 400.980.00 {8.01) (8.02) {8.03) {8.04) IS $ {8.05) {8.06) 1 Production Budget Planned Sales Desired Ending Inventory of Finished Goods Total Needed Less: Beginning Inventory 25000 2400 27400 3000 Total Production 24,400 units {7.01) Round dollars to two places, $##.## $ 90,000.00 90,000.00 19.07) LUST UI Goods Sold Budget- Beginning Inventory, Finished Goods Production Costs: Materials: Lamp Kits: Beginning Inventory Purchased Available for Use Ending Inventory of Lamp Kits Lamp Kits Used In Production units = units = units = units = 500 $ 24450 $ 24400 $ 550 $ 16.400 8.200.000 400,980.000 400,160.000 9,020.00 {9.08) Total Materials: Labor Overhead Cost of Goods Available Less: Ending Inventory, Finished Goods Cost of Goods Sold $ $ 50,020.00 320,020.00 {9.09) {9.10) {9.11) {9.12) {9.13) {9.14) 2 Materials Budget Lamp Kits Needed for Production Desired Ending Inventory Total Needed Less: Beginning Inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, St###) 1 24,400 units 550 units 2 4,950 units 500 units 24450 16.40 400.980.00 {8.01) (8.02) {8.03) {8.04) IS $ {8.05) {8.06) 1 Production Budget Planned Sales Desired Ending Inventory of Finished Goods Total Needed Less: Beginning Inventory 25000 2400 27400 3000 Total Production 24,400 units {7.01)