#of units that can be built according to availability of pieces needed for unit.

hi every one. first time ever posting on a forum. ill try to keep it simple.
I have to built several lamps. I'm trying to create an excel sheet that contains all the data i need to built specific lamps. Ill start with what i know. I've put in all the data i have. it takes 33 different types or sizes of materials to built this lamp called the totem. I know what i have in stock and how much i need to built one totem.
I would like excel to calculate how many totem lamps i can built with the available materials that i have in stock and how much material it will take to built a determined amount of totems.
Examples of the materials are different size screws, wires, switches and fixture.
Thank you for taking the time to read this.

Thank you. was bot expecting such a quick response. really thank you.

This is the first time i use excel in about 20 years. i had some beginner lessons in high school. basicly i have no idea how to use this programe besides the most basic stuff. this has been amazing help. if you don't mind helping me further I need a formula to know which pieces im missing to complete the lamps. if it says i can make 17 but i need to make 20 is there a shortcut to know which materials are missing? sorry if i seem really lame or slow. i feel like it should be obvious but im struggling. i might sort it out on my own but i think it would be smoother with proper formula and faster. thank you for your time again.

amazing. long live the lone star state!
now one more and i think the data sheet will be complete
say i need to make 50 totems
can excel tell how much of every pieces of material ill need.I
i type in 50 into a cell and all the numbers in another column tell me exactly what quantities i need to order.
my goodness my boss is going to love me. if i ever visit Texas i will bring you what ever you like

YES I love you man. i like to help people when ever i can, unfortunately i don't think ill be able to help many people on this site but ill do my best and i will definitely pay it forward in other ways.
i would like to add another formula. i need to have a cell that represents the amount of totems completed and when i write the number of completed totems i would like it to change all the data in the on hand column. please and thank you!!?

i've been surfing the web and i cant find an example of this. i've found very helpful spread sheets but would still like to accomplish what i'm trying to do, if its possible. or am i combining to many formulas

Hope this format is suitable. Click the cells in the bottom graph to see the formulas used (shown in the formula bar).

not quite what i was hoping for. when i change the number of completed units it should change the entire inventory list by subtracting what was used to built the unit. this might come in handy though. im starting to realize i might need more than one sheet.

.
Regarding the layout shown, how should the headers appear ?
.
.
Max Units.jpg

i don't really care about the layout. i need the number in the "completed" cell to change what i have on hand.

See if this works for you.

Too many formulas to list here.

thanks i guess i might have to do it like that.
unless there's a way to eliminate the remaining column and just have the numbers in the onhand column change every time i add completed units and ofcourse it would also change the max units can build cell.
even the can make column could be ditched if it helps.
only have the ;required; on hand; max units; completed and need to order displayed.