Need help with cost of goods sold budget

Cost of Goods Sold Budget- Assume FIFO (First-In, First-Out) and overhead is applied based on the number of units to be produced.Round dollars to two places, $##.##Beginning Inventory, Finished Goods$90,000.00{9.07}Production Costs:Materials:Lamp Kits:Beginning InventoryPurchasedAvailable for UseEnding Inventory of Lamp Kits$10,500.00{9.08}Lamp Kits Used In ProductionTotal Materials:$711,920.00{9.09}Labor$89,464.00{9.10}Overhead$352,768.00{9.11}Cost of Goods Available$1,236,242.00{9.12}Less:Ending Inventory, Finished Goods$65,352.00{9.13}Cost of Goods Sold$221,508.00{9.14}

PART 3BudgetsDivision N has decided to develop its budget based upon projected sales of 43,000 lamps at$48.00per lamp.The company has requested that you prepare a master budget for the year.This budget is to be usedfor planning and control of operations and should be composed of:1.Production Budget2.Materials Budget3.Direct Labor Budget4.Factory Overhead Budget5.Selling and Administrative Budget6.Cost of Goods Sold Budget7.Budgeted Income Statement8.Cash BudgetNotes for Budgeting:The company wants to maintain the same number of units in the beginning and ending inventories ofwork-in-process, and electrical partswhile increasing the inventory of Lamp Kits to 625 pieces anddecreasing the finished goods by 20%.Complete the following budgets1Production BudgetPlanned Sales43000Desired Ending Inventory of Finished Goods2400Total Needed45400Less: Beginning Inventory3000Total Production42,400 units{7.01}