My Math Forum  

Go Back   My Math Forum > High School Math Forum > Algebra

Algebra Pre-Algebra and Basic Algebra Math Forum


Reply
 
LinkBack Thread Tools Display Modes
February 22nd, 2012, 08:59 PM   #1
Newbie
 
Joined: Feb 2012

Posts: 1
Thanks: 0

Aluminium Window with wastage calculation

Hello,

I am trying to calculate aluminum sections required and feet wastage for making window frames.

Sections are available in only 2 sizes. 12 Feet and 15 feet.

Eg: If i want 1 window of size 5 x 6, i will need 2 sections of 12 feet and wastage would be 2. ( 6+6 for height, 5+5 for width )

Eg BUT 30 windows of 5x6 ( wont have wastage 2 x 30 = 60 ), i would need 30 sections of 12 feet ( 60 pieces of 6 feet ) and 20 sections of 15 feet. Wastage zero. ( I need 60 pieces of 5 feet, and from one section of 15 feet i can make 3 of them. So 20 sections of 15 feet. )

Eg: Window of size 8 x 4, 30 windows. I would need 60 sections of 12 feet. ( 2 section per window as 8+4 is twelve ) zero wastage..

Eg: 11 x 15, 5 windows. 10 sections of 15 feet. 10 sections of 12 feet. Wastage 10 feet. ( 1 feet wastage per section fo 12 feet. )


Cell A1 and A2. where i can enter size A x B and a third cell B1 where i can enter number of windows.

Wastage should be minimum and i would prefer lesser number of sections whenever possible. ( For size 12 x 3, 2 windows -- i would require 4 sections of 15 feet and not 5 sections of 12 feet. wastage would be zero in both cases. But its ok to have multiple options displayed if possible as in this case. )

TIA

Another explanation.

Lets first do it for only 1 type of section to avoid confusion. 12 Feet sections only. ( I will add 15 later )

Now for 5 x 6 window, i need something like this.
A B C D
Width 5 No of 12 feet sections 2
Length 6 Wastage 2

Quantity 1

D1 should show 2 as answer.

Since window is 5 x 6, we need 2 pieces of 5 feet for width and 2 pieces of 6 feet for length. ( Rectangle window with 4 sides, 2H + 2B )

12 feet section can be cut into 2 equal 6 feet sections for length. ( No wastage )

12 feet section can be cut into 2 pieces of 5 feet each for width. ( 2 feet will be wastage, as only 10 feet of the 12 will be utilized.

For second window, same would happen. ( The wastage cannot be used because sections cannot be joined ).

So if quantity is 10, we should have 20 in D1 and 20 feet waste in D2.

Suppose Width and length is 6.5 and 5.5

In this case, we will again need 2 sections of 12 feet per window ( 6.5 + 5.5 = 12 ) but wastage would be zero.

Another Eg: Width 12, Length 6. And quantity 10

We will need 3 sections per window, 30 sections total and wastage zero. ( 12 + 12 + "6 + 6" )

Now let me also have sections of 15 feet and take the above first example again.

For 5 x 6 window, i need something like this.
A B C D
Width 5 No of 12 feet sections 30
Length 6 No of 15 feet sections 20
Wastage 0
Quantity 30

I have changed the quantity of windows to 30 and also added 15 feet sections..

for 30 windows i will need 60 pieces of 6 feet and 60 pieces of 5 feet.

So 30 sections of 12 feet. ( Can make 2 - " 6 feet " from 1 "12 feet" )
20 sections of 15 feet. ( Can make 3 - "5 feet " from 1 - " 15 feet" )
Wastage 0.

If quantity would have been 31, 2 more sections of 12 feet, and wastage would be 2. Not 1 section of 12 and 1 of 15. Wastage should be minimum.

TIA
yserver144 is offline  
 
February 23rd, 2012, 07:24 AM   #2
Math Team
 
Joined: Oct 2011
From: Ottawa Ontario, Canada

Posts: 13,296
Thanks: 934

Re: Aluminium Window with wastage calculation

Your "problem" is clearly stated; plus you seem "pretty good" at programming;
which made me wonder: why aren't you a computer programmer instead of a window installer"?!
[unless you're making loads of money cheating your customers ]

But...but...but...
Quote:
Originally Posted by yserver144
Sections are available in only 2 sizes. 12 Feet and 15 feet.

Eg: If i want 1 window of size 5 x 6, i will need 2 sections of 12 feet and wastage would be 2.

Eg: 11 x 15, 5 windows. 10 sections of 15 feet. 10 sections of 12 feet. Wastage 10 feet.
You seem to be trying to buy your sections each time a job comes up, and the least number possible;
do you not keep an inventory?
Like, looking at the above 2 cases, wouldn't you be "happy" with a wastage od 10 feet,
since it would cover the "5" sizes of your next "5 x 6" job....get my drift?

Do you not carry/calculate stats, showing "popular sizes"?
You'd then (when doing an "unpopular" job) TRY for wastage, such accomodating "popular" sizes.

None of my business how you handle your business...twas just a thought/suggestion...
Denis is offline  
August 3rd, 2018, 03:11 PM   #3
Newbie
 
Joined: Aug 2018
From: Edo state

Posts: 2
Thanks: 0

What could be the calculation of aluminum casement window frame as follows
2 in 1 window 4 by 4 feets on 10 windows
3 in 1 window 4 by 6 feets on 1 window
Single window 2 by 2 feets on 6 windows
Kingidah2001 is offline  
August 3rd, 2018, 03:31 PM   #4
Math Team
 
Joined: Oct 2011
From: Ottawa Ontario, Canada

Posts: 13,296
Thanks: 934

Hey King...you reactivated a 6 years old thread...
are you getting ready to lay some spam on us?
Denis is offline  
Reply

  My Math Forum > High School Math Forum > Algebra

Tags
aluminium, calculation, wastage, window



Search tags for this page
Click on a term to search for related topics.
Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculation of the sum Anton29 Calculus 2 August 23rd, 2012 09:33 PM
Norman window problem :/ rgarcia128 Calculus 5 September 9th, 2011 08:45 PM
the math-knowledge freeze: window found! Abishai100 Applied Math 0 April 17th, 2009 07:41 AM
Finding the inside meaurement of a bay window ratcat Algebra 7 December 13th, 2008 05:42 AM
find the dimensions for rural gothic style window dai_lo Calculus 2 February 28th, 2008 01:54 PM





Copyright © 2018 My Math Forum. All rights reserved.