Copyl Myers Sullivan reblem 2.49 Sart. Last updated 27m ago File Data Search Home Insert Page Layout Formulas Times New Roman - -AA BTU 2 . 0.A. Review View Help Wap Test Menge & Center - Number Paste $ % *4.8 Conditional Format Formatting Table Cel Styles Problem 2-49 The heat lost through the roof of a single story home is Heat loss in Btu per hour = (Temperature in "FArea in ft X(Conductance is Btu hou) (fr-F). O=(7. T. 4 U Consider a 2 400-ft single story house in Blacksburg The typical annual space heating load for this size of a house is 100% 10% Btu when the thermostat is set at 65F That is, with no insulation in the attitelose about 100 x 10 Btu in southwest Virginia the number of heating days per year is approximately 230, and the annual heating degree-days equals 230 (65F 16F) 4370 degree days per year. Here, 65 F is assumed to be the average inside temperature and 16 F is the the outside temperature each day Assume that the average inside temperature of the house in Virginia is increased from 65F to 72 F With insulation in the attic, the amount of heat lost each year will be reduced Assume that an electrical resistance furnace is installed by the builder, and its efficiency is near 100% The cost of electricity is $0.086 per kWh The cost of insulation has increased by 5096 The old values of cost of several insulation alternatives and the factors for them are given in the table below the life of the insulation is estimated to be 25 vears. What is the most economical insulation amount? (Note: Time value of money is not considered.) * Please note that the term "heating load' is similar to that loss 2.49 Type here to search Antalove : - Last updates - Copy of Myers Sullivan Problem - Vime Help e search File Home insen Page Layout Formatos Data Review Tom Roman - A W C BIV- A Merge Center - S -% Condial Formats Formatting Table St- Amount of Insulation R19 R30 S900 S1,300 0.2773 0.267 R11 S600 0.294 Old investment cost U factors R38 $1.600 0.263 Number of heating days Home area in Average inside temperature Average outside temperature Eficiency of electrical resistance furnace kWh per million Blu Cost of electricity per kWh Increase in investment cost Life of the insulation Hours per day 2.30 2400 72 F 46 F 100% 293 S0.086 509 5 Years E O Type here to search 0 te * Auto Copy of Myers Sub Last updated mage GD Home . Page Layout Preblem 40 Seart Search Insert Forma t View Help Times New Roman - -AA - W at Mergeam - 5 %9 Complete the steps belowing coll e ctive data or previous calculationsIn cas, a simple cell reference is all you need. To copy paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used the directions will specify the use of that function. Do not type in numerical data into a cell or function lustead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, inless otherwise incluse the earliest appearance of the data in your formulas, usually the Give Data section Atal heating degree days Cost of electricity 525.20 To Be RIIKIO Annual heat loss (10 ) 900.0 S1.350 $1.950 $2,400 Cost of heat loss per year Cost of heat loss Total life cycle costs to life What is the most economical in mount I O Type here to search 0 Ele toSave D Home = Page Layout Copy of Myers_Sulian Problem_2-49 Start - Sved. Help P Search Insert Formulas Data Review View Times New Roman - 14 AP AA Wrap Test E s Merge & Center - $ - % ) 18 Candtonal Formats Cell Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. Annual heating degree days Cost of electricity 7100 Btu RI R19R30R38 11 Annual heat loss (10 Btu) New investment cost Cost of heat loss per year Cost of heat loss over insulation life Total life cycle costs What is the most economical insulation amount? The most economical insulation amount is + Type here to search Copyl Myers Sullivan reblem 2.49 Sart. Last updated 27m ago File Data Search Home Insert Page Layout Formulas Times New Roman - -AA BTU 2 . 0.A. Review View Help Wap Test Menge & Center - Number Paste $ % *4.8 Conditional Format Formatting Table Cel Styles Problem 2-49 The heat lost through the roof of a single story home is Heat loss in Btu per hour = (Temperature in "FArea in ft X(Conductance is Btu hou) (fr-F). O=(7. T. 4 U Consider a 2 400-ft single story house in Blacksburg The typical annual space heating load for this size of a house is 100% 10% Btu when the thermostat is set at 65F That is, with no insulation in the attitelose about 100 x 10 Btu in southwest Virginia the number of heating days per year is approximately 230, and the annual heating degree-days equals 230 (65F 16F) 4370 degree days per year. Here, 65 F is assumed to be the average inside temperature and 16 F is the the outside temperature each day Assume that the average inside temperature of the house in Virginia is increased from 65F to 72 F With insulation in the attic, the amount of heat lost each year will be reduced Assume that an electrical resistance furnace is installed by the builder, and its efficiency is near 100% The cost of electricity is $0.086 per kWh The cost of insulation has increased by 5096 The old values of cost of several insulation alternatives and the factors for them are given in the table below the life of the insulation is estimated to be 25 vears. What is the most economical insulation amount? (Note: Time value of money is not considered.) * Please note that the term "heating load' is similar to that loss 2.49 Type here to search Antalove : - Last updates - Copy of Myers Sullivan Problem - Vime Help e search File Home insen Page Layout Formatos Data Review Tom Roman - A W C BIV- A Merge Center - S -% Condial Formats Formatting Table St- Amount of Insulation R19 R30 S900 S1,300 0.2773 0.267 R11 S600 0.294 Old investment cost U factors R38 $1.600 0.263 Number of heating days Home area in Average inside temperature Average outside temperature Eficiency of electrical resistance furnace kWh per million Blu Cost of electricity per kWh Increase in investment cost Life of the insulation Hours per day 2.30 2400 72 F 46 F 100% 293 S0.086 509 5 Years E O Type here to search 0 te * Auto Copy of Myers Sub Last updated mage GD Home . Page Layout Preblem 40 Seart Search Insert Forma t View Help Times New Roman - -AA - W at Mergeam - 5 %9 Complete the steps belowing coll e ctive data or previous calculationsIn cas, a simple cell reference is all you need. To copy paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used the directions will specify the use of that function. Do not type in numerical data into a cell or function lustead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, inless otherwise incluse the earliest appearance of the data in your formulas, usually the Give Data section Atal heating degree days Cost of electricity 525.20 To Be RIIKIO Annual heat loss (10 ) 900.0 S1.350 $1.950 $2,400 Cost of heat loss per year Cost of heat loss Total life cycle costs to life What is the most economical in mount I O Type here to search 0 Ele toSave D Home = Page Layout Copy of Myers_Sulian Problem_2-49 Start - Sved. Help P Search Insert Formulas Data Review View Times New Roman - 14 AP AA Wrap Test E s Merge & Center - $ - % ) 18 Candtonal Formats Cell Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. Annual heating degree days Cost of electricity 7100 Btu RI R19R30R38 11 Annual heat loss (10 Btu) New investment cost Cost of heat loss per year Cost of heat loss over insulation life Total life cycle costs What is the most economical insulation amount? The most economical insulation amount is + Type here to search