explain eaxh step. do not handwrite

Lock Tight, Inc, produces outside doors for installation on homes. The following information was gathered to prepare budgets for the upcoming year. Sales forecast in units 8000 doors Finished goods inventory, Jan. 1 700 doors Target finished goods inventory, Dec. 31 590 doors Raw materials inventory of steel Jan. 1 50000 pounds Target Inventory of steel, Dec. 31 52500 pounds Raw materials inventory of glass, Jan. 1 7000 square feet Target inventory of glass, Dec. 31 5500 square feet Budgeted purchase price of steel $5 per pound Budgeted purchase price of glass $5 per square foot The manufacture of each door requires 35 pounds of steel and 5 square feet of glass. Determine (a) how many doors Lock Tight should produce in the upcoming year and (b) how many pounds of steel will be used in production