Lab. YOU ARE ADDING ONTO TO YOUR EXISTING HOME AND ARE TRYING TO GET AN ESTIMATE...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Lab. YOU ARE ADDING ONTO TO YOUR EXISTING HOME AND ARE TRYING TO GET AN ESTIMATE OF WHAT IT WILL COST YOU TO BUILD YOUR KITCHEN, EXCLUDING APPLIANCES. YOU HAVE SEVERAL DIFFERENT OPTIONS A, B AND C-DEPENDING ON HOW MUCH SPACE YOU ALLOCATE. YOU HAVE COMPILED DATA ON THE COST OF FLOORING AND CABINETS AS FOLLOWS KITCHEN PROBLEM 1 Unit Conversion 2 yards (SF/SY) 123456 PENS 3 plywood conv! square feet to square 2 Item 7 square feet per sheet of 3 3/4 inch plywood 4 vinyl flooring 8 9 10 11 12 prices! factor B Misc. Pricing Units sheet SY B с Price 9 32 $25.75 $37.50 D FT $/FT 1 2 Option 3 A 4 B 5 C 6 7 Outputs 8 Option 9 A 10 B 11 C 12 A calc! $ FT E Kitchen Dimensions & Pricing cabinet length Kitchen Kitchen (ft) length (ft) 15 $ $ $ F E cabinetry pricing Price/FT 0 B 10 20 35 50 10 20 15 825 725 700 675 650 trim pricing 0 10 3.00 $ 2.85 $ с G 20 18 subfloor trim vinyl cabinetry total cost 241.41 $1,250.00 $ 196.00 $ 7,250.00 $ 482.81 $2,500.00 $275.00 $ 14,000.00 $ 362.11 $1,875.00 $240.80 $ 10,875.00 $ width (ft) perimeter(ft) 20 30 25 50 2.80 $ H 100 70 100 86 2.75 F area(sf) 300 600 450 8,937.41 17,257.81 13,352.91 Page 1 of 3 ₂ ♥ ˆ à X Aa ✓ Po A ✔ A. 2 == |• AaBbCcDdE AABBC firstlevel_bull... labtitle AaBbCcDdEe 0 AaBbCcDi Normal | AaBbCcDdEe secondlevel..... List Paragraph Book Title Kitchen Estimating Problem in the file kitchen.xlsx: Floor: The kitchen floor will consist of a subfloor and vinyl floor cover and trim. The subfloor is composed of %4 inch plywood sold in sheets of 32 square feet (SF) at a price of $25.75 per sheet. The vinyl floor covering you have chosen is $37.50 per square yard (SY) The baseboard trim is used around the entire perimeter of the kitchen. Its price varies with the amount of trim used, as indicated by the table on the prices worksheet. • Pricing for the cabinetry also varies with the number of linear feet of cabinetry required. An appropriate table is also on the prices worksheet. For estimating purposes you have assumed that the contractor will only charge you for the exact amount used- so you do not have to assume any additional costs or round up to the nearest unit. Cabinets: The cabinets pricing varies based on the number of linear feet (FT) of cabinet space as listed on the price worksheet. 1. In cell calc!E3, write an Excel formula, which can be copied down the column, to determine the perimeter of the corresponding kitchen. 2. In cell calc!F3, write an Excel formula, which can be copied down the column, to determine the area of the corresponding kitchen. 3. In cell calc!B9, write an Excel formula, which can be copied down the column, to determine the cost of the subfloor for the corresponding kitchen. (Hint: components of the subfloor are described in the problem description) 4. In cell calc!C9, write an Excel formula, which can be copied down the column, to determine the cost of the vinyl floor covering for the corresponding kitchen. This formula should work even if the kitchen dimensions are later updated. 5. In cell calc!D9, write an Excel formula, which can be copied down the column, to determine the cost of the floor trim for the corresponding kitchen. 6. In cell calc!E9, write an Excel formula, which can be copied down the column, to determine the cost of the cabinetry for the corresponding kitchen-remember the cost per FT varies based on the total FT of cabinets. Again, this formula should work even if the kitchen dimensions are later updated. 7. In cell calc!F9, write an Excel formula, which can be copied down the column, to determine the total cost of the kitchen for this option. 8. You have decided to choose the option Ckitchen and now want to explore some financing scenarios. A table has been setup on worksheet loan for this purpose. Insert the appropriate data inputs (using cell referencing to kitchen option C as needed) and write the appropriate Excel formulas needed to complete. Highlight the answer to each loan option in yellow. Loan 1 - Assume that you are making a down payment of 10% of the cost of the kitchen and borrowing the rest from the bank at 4.25% annual interest rate compounded monthly. The loan will be entirely paid off in 3 years. Determine your monthly payment. AaBbCcDdEe 11 =x₂ ✓ Aˆ A™ Aa Po x² A✓ ✓ A EVE ¶ a AaBbCcDdE firstlevel_bull... AABBC AaBbCcDdEe labtitle Normal o AaBbCcDi AaBbCcDdEe List Paragraph secondlevel Loan 2 - The bank has offered a loan for the entire value of the kitchen that you can pay off over a 3 year period with quarterly payments of $1500. What is the annual interest rate being charged for this loan? Loan 3 - The contracting firm also has financing terms available. They will lend you 80% of the cost of the kitchen with a 3.5% annual interest rate and a $500 balloon payment due at the end of the loan. You will make payments of $300/month (interest is compounded monthly). How many years will it take to pay off this loan? Which do you think is the best loan and why? Place answer below data on loan worksheet. Save and close the workbook. Then Upload and save it to SIMnet under Resources Prelab 6 Kitchen and then Submit it. You will get 3 attempts to submit your file. Be sure to use only the file you downloaded from SIMnet and made changes to, that you submit. You must submit your file to SIMnet to get credit for Inlab. It is your responsibility to check that the correct completed file has been submitted. You can click on the submitted file and open it to check that the correct file was submitted. | AaBbCcDdEn Book Title A Home E3 1 2 3 A 4 ·23+56OTOOING 5 C 7 8 6 7 B Option 9 A 0 B 1 C 9 20 21 22 23 24 25 26 27 28 29 10 1 2 13 14 15 16 17 18 19 -0 SAWN÷O 1 Paste -2 3 -4 Option -5 BC A Outputs Insert Draw Page Layout xe + Arial BIU x ✓ fx B cabinet length (ft) subfloor 10 20 1812 с 15 Kitchen length (ft) Kitchen Dimensions & Pricing Kitchen width (ft) perimeter(ft) 20 15 20 18 D vinyl trim 10 Formulas 30 25 ✓ A^ E A A✔ Data Review F area(sf) cabinetry total cost G View H (0 Wrap Text Merge & Center K General $ % L H18 7 8 9 10 11 12 13 14 15 16 17 18 19 20 1 2 Item 3 3/4 inch plywood 4 vinyl flooring 5 6 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste 43 44 45 46 47 48 49 50 LA ✔ A X calc BIU ✓ fx B Misc. Pricing Units sheet square yard (SY) prices C Price $25.75 $37.50 conv ♥ A D FT $/FT FT === = loan E F cabinetry pricing 0 10 20 35 50 Price/FT trim pricing 0 10 $ 3.00 $ 2.85 $ + 825 725 700 675 650 G 50 2.80 $ H 100 2.75 Merge & Center J $ % 9 K L 5.00 9.00 M N Conditional Format Formatting as Table O P Home Insert Draw Page Layout D29 2 3 4 1 Unit Conversion 5 6 7 8 9 10 11 12 13 14 15 Paste 16 17 18 19 20 21 22 23 24 25 26 27 A Arial BIU fx square feet to square yards. (SF/SY) square feet per sheet of plywood factor B 10 Formulas Data Review View ✓ Aˆ A Αν 9 32 C lılı D |||||||| E F ab Wrap Text HI G Merge & Center H I General $ % 9 J K .00 .00 -0 L Cond Form M Home Insert Draw Page Layout 2. Paste A13 A 1 Kitchen Option C 2 ANNUAL RATE% 3 DURATION (YRS) 4 PERIODS/YR 5 PAYMENT 6 7 LOAN VALUE 11 12 13 14 15 16 17 18 X 19 20 21 22 23 24 25 26 27 28 29 30 31 32 8 BALOON PAYMENT 9 10 33 34 Arial DOWNPAYMENT% BIU fx Loan1 B V V Loan2 с 10 Formulas Data Review A Α' Α' A✔ D Loan3 ≡ ≡ ≡ E F View G a H Wrap Text ✔ Merge & Center I J General $ % 9 V K L ←.0 M V .00 ✔ Conditional Format Formatting as Table N O P C St Lab. YOU ARE ADDING ONTO TO YOUR EXISTING HOME AND ARE TRYING TO GET AN ESTIMATE OF WHAT IT WILL COST YOU TO BUILD YOUR KITCHEN, EXCLUDING APPLIANCES. YOU HAVE SEVERAL DIFFERENT OPTIONS A, B AND C-DEPENDING ON HOW MUCH SPACE YOU ALLOCATE. YOU HAVE COMPILED DATA ON THE COST OF FLOORING AND CABINETS AS FOLLOWS KITCHEN PROBLEM 1 Unit Conversion 2 yards (SF/SY) 123456 PENS 3 plywood conv! square feet to square 2 Item 7 square feet per sheet of 3 3/4 inch plywood 4 vinyl flooring 8 9 10 11 12 prices! factor B Misc. Pricing Units sheet SY B с Price 9 32 $25.75 $37.50 D FT $/FT 1 2 Option 3 A 4 B 5 C 6 7 Outputs 8 Option 9 A 10 B 11 C 12 A calc! $ FT E Kitchen Dimensions & Pricing cabinet length Kitchen Kitchen (ft) length (ft) 15 $ $ $ F E cabinetry pricing Price/FT 0 B 10 20 35 50 10 20 15 825 725 700 675 650 trim pricing 0 10 3.00 $ 2.85 $ с G 20 18 subfloor trim vinyl cabinetry total cost 241.41 $1,250.00 $ 196.00 $ 7,250.00 $ 482.81 $2,500.00 $275.00 $ 14,000.00 $ 362.11 $1,875.00 $240.80 $ 10,875.00 $ width (ft) perimeter(ft) 20 30 25 50 2.80 $ H 100 70 100 86 2.75 F area(sf) 300 600 450 8,937.41 17,257.81 13,352.91 Page 1 of 3 ₂ ♥ ˆ à X Aa ✓ Po A ✔ A. 2 == |• AaBbCcDdE AABBC firstlevel_bull... labtitle AaBbCcDdEe 0 AaBbCcDi Normal | AaBbCcDdEe secondlevel..... List Paragraph Book Title Kitchen Estimating Problem in the file kitchen.xlsx: Floor: The kitchen floor will consist of a subfloor and vinyl floor cover and trim. The subfloor is composed of %4 inch plywood sold in sheets of 32 square feet (SF) at a price of $25.75 per sheet. The vinyl floor covering you have chosen is $37.50 per square yard (SY) The baseboard trim is used around the entire perimeter of the kitchen. Its price varies with the amount of trim used, as indicated by the table on the prices worksheet. • Pricing for the cabinetry also varies with the number of linear feet of cabinetry required. An appropriate table is also on the prices worksheet. For estimating purposes you have assumed that the contractor will only charge you for the exact amount used- so you do not have to assume any additional costs or round up to the nearest unit. Cabinets: The cabinets pricing varies based on the number of linear feet (FT) of cabinet space as listed on the price worksheet. 1. In cell calc!E3, write an Excel formula, which can be copied down the column, to determine the perimeter of the corresponding kitchen. 2. In cell calc!F3, write an Excel formula, which can be copied down the column, to determine the area of the corresponding kitchen. 3. In cell calc!B9, write an Excel formula, which can be copied down the column, to determine the cost of the subfloor for the corresponding kitchen. (Hint: components of the subfloor are described in the problem description) 4. In cell calc!C9, write an Excel formula, which can be copied down the column, to determine the cost of the vinyl floor covering for the corresponding kitchen. This formula should work even if the kitchen dimensions are later updated. 5. In cell calc!D9, write an Excel formula, which can be copied down the column, to determine the cost of the floor trim for the corresponding kitchen. 6. In cell calc!E9, write an Excel formula, which can be copied down the column, to determine the cost of the cabinetry for the corresponding kitchen-remember the cost per FT varies based on the total FT of cabinets. Again, this formula should work even if the kitchen dimensions are later updated. 7. In cell calc!F9, write an Excel formula, which can be copied down the column, to determine the total cost of the kitchen for this option. 8. You have decided to choose the option Ckitchen and now want to explore some financing scenarios. A table has been setup on worksheet loan for this purpose. Insert the appropriate data inputs (using cell referencing to kitchen option C as needed) and write the appropriate Excel formulas needed to complete. Highlight the answer to each loan option in yellow. Loan 1 - Assume that you are making a down payment of 10% of the cost of the kitchen and borrowing the rest from the bank at 4.25% annual interest rate compounded monthly. The loan will be entirely paid off in 3 years. Determine your monthly payment. AaBbCcDdEe 11 =x₂ ✓ Aˆ A™ Aa Po x² A✓ ✓ A EVE ¶ a AaBbCcDdE firstlevel_bull... AABBC AaBbCcDdEe labtitle Normal o AaBbCcDi AaBbCcDdEe List Paragraph secondlevel Loan 2 - The bank has offered a loan for the entire value of the kitchen that you can pay off over a 3 year period with quarterly payments of $1500. What is the annual interest rate being charged for this loan? Loan 3 - The contracting firm also has financing terms available. They will lend you 80% of the cost of the kitchen with a 3.5% annual interest rate and a $500 balloon payment due at the end of the loan. You will make payments of $300/month (interest is compounded monthly). How many years will it take to pay off this loan? Which do you think is the best loan and why? Place answer below data on loan worksheet. Save and close the workbook. Then Upload and save it to SIMnet under Resources Prelab 6 Kitchen and then Submit it. You will get 3 attempts to submit your file. Be sure to use only the file you downloaded from SIMnet and made changes to, that you submit. You must submit your file to SIMnet to get credit for Inlab. It is your responsibility to check that the correct completed file has been submitted. You can click on the submitted file and open it to check that the correct file was submitted. | AaBbCcDdEn Book Title A Home E3 1 2 3 A 4 ·23+56OTOOING 5 C 7 8 6 7 B Option 9 A 0 B 1 C 9 20 21 22 23 24 25 26 27 28 29 10 1 2 13 14 15 16 17 18 19 -0 SAWN÷O 1 Paste -2 3 -4 Option -5 BC A Outputs Insert Draw Page Layout xe + Arial BIU x ✓ fx B cabinet length (ft) subfloor 10 20 1812 с 15 Kitchen length (ft) Kitchen Dimensions & Pricing Kitchen width (ft) perimeter(ft) 20 15 20 18 D vinyl trim 10 Formulas 30 25 ✓ A^ E A A✔ Data Review F area(sf) cabinetry total cost G View H (0 Wrap Text Merge & Center K General $ % L H18 7 8 9 10 11 12 13 14 15 16 17 18 19 20 1 2 Item 3 3/4 inch plywood 4 vinyl flooring 5 6 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Paste 43 44 45 46 47 48 49 50 LA ✔ A X calc BIU ✓ fx B Misc. Pricing Units sheet square yard (SY) prices C Price $25.75 $37.50 conv ♥ A D FT $/FT FT === = loan E F cabinetry pricing 0 10 20 35 50 Price/FT trim pricing 0 10 $ 3.00 $ 2.85 $ + 825 725 700 675 650 G 50 2.80 $ H 100 2.75 Merge & Center J $ % 9 K L 5.00 9.00 M N Conditional Format Formatting as Table O P Home Insert Draw Page Layout D29 2 3 4 1 Unit Conversion 5 6 7 8 9 10 11 12 13 14 15 Paste 16 17 18 19 20 21 22 23 24 25 26 27 A Arial BIU fx square feet to square yards. (SF/SY) square feet per sheet of plywood factor B 10 Formulas Data Review View ✓ Aˆ A Αν 9 32 C lılı D |||||||| E F ab Wrap Text HI G Merge & Center H I General $ % 9 J K .00 .00 -0 L Cond Form M Home Insert Draw Page Layout 2. Paste A13 A 1 Kitchen Option C 2 ANNUAL RATE% 3 DURATION (YRS) 4 PERIODS/YR 5 PAYMENT 6 7 LOAN VALUE 11 12 13 14 15 16 17 18 X 19 20 21 22 23 24 25 26 27 28 29 30 31 32 8 BALOON PAYMENT 9 10 33 34 Arial DOWNPAYMENT% BIU fx Loan1 B V V Loan2 с 10 Formulas Data Review A Α' Α' A✔ D Loan3 ≡ ≡ ≡ E F View G a H Wrap Text ✔ Merge & Center I J General $ % 9 V K L ←.0 M V .00 ✔ Conditional Format Formatting as Table N O P C St
Expert Answer:
Answer rating: 100% (QA)
1 Formula for Kitchen Perimeter 2C3 2D3 2 Formula for ... View the full answer
Related Book For
Managerial accounting
ISBN: 978-0471467854
1st edition
Authors: ramji balakrishnan, k. s i varamakrishnan, Geoffrey b. sprin
Posted Date:
Students also viewed these programming questions
-
3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...
-
Working with a partner, you can get an estimate of your reaction time by catching a falling meter stick. Have your partner hold the meter stick from a point near the top while you place the finger...
-
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Mo's Motor Corp. issued $ 380,000 of 7%, 5-year bonds on April 1, 2021. Interest is payable semi-annually on April 1 and October 1. On April 1, 2023,...
-
Requirement 1. Journalize the partners' initial contributions. (Record debits first, then, credits. Select the explanation on the last line of the journal entry table.) Begin by journalizing the...
-
On January 1, 2009, Affordable Financial, Inc., purchased the assets of Bisko Insurance Co. for $65,000,000, a price reflecting a $10,000,000 goodwill premium. On December 31, 2012, Affordable...
-
The Off-Campus Playhouse adjusts its accounts every month. Below is the companys un-adjusted trial balance dated September 30, 2011. Additional information is provided for use in preparing the...
-
To calculate \(r\) using MINITAB when the \(x\) values are in \(C 1\) and the \(y\) values are in \(C 2\), use Also, you can make a scatter plot using the plot procedure in Exercise 11.22. Use the...
-
The American black bear (Ursus americanus) is one of eight bear species in the world. It is the smallest North American bear and the most common bear species on the planet. In 1969, Dr. Michael R....
-
Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,900; winter, 8,400; spring, 7,100; summer, 12,900. Inventory at the beginning of fall is 545...
-
Fun Silly Toys (FST) produces a number of space themed toys (e.g., astronaut action figures). One of the newer divisions at FST is the board game division, which currently produces and sells one...
-
There are many types of waves, such as electromagnetic waves and radio waves. The equation used to calculate wave velocity is shown below: where v, is the wave velocity (in m/s), is the wavelength...
-
A system has three macrostates. Macrostates 1 and 3 are least likely and have one basic state each. Macrostate 2 is the equilibrium state and is six times more likely to occur than either of the...
-
Offenses against the state other than terrorism include sedition, sabotage, espionage, criminal syndicalism, and espionage. Treason, or [a] breach of allegiance to ones government, usually committed...
-
System 1 is in equilibrium, and a separate system 2 is also in equilibrium. The systems are independent of each other but have an equal probability of being in equilibrium. The number of basic states...
-
The volume of a cylindrical chamber is controlled by a movable piston. A sample of gas is placed in the chamber, and the volume is allowed to change from \(0.0100 \mathrm{~m}^{3}\) to \(0.100...
-
Congress has authority to regulate certain types of conduct that take place beyond the territorial borders of the United States. This is known as extraterritorial jurisdiction or ETJ. For example,...
-
Summarize the main points of the documentary called The Rise and Reign of Jeff Bezos. Who and what media companies produced it? When was it made? How does the documentary represent different people?...
-
3M Company reports the following financial statement amounts in its 10-K report: a. Compute the receivables, inventory, and PPE turnover ratios for both 2018 and 2017. (Receivables turnover and...
-
What are some of the problems that we are likely to encounter in measuring practical capacity? For concreteness, consider measuring the practical capacity of a purchasing department that has five...
-
The IRS exempts qualified charities from income taxes, provided the income relates to their charitable activities. The provision exists because many charities conduct activities deemed unrelated to...
-
Some experts argue that budgets have to be loose and flexible for companies that are in their growth phase. Other experts believe that good planning and control through well-formulated budgets can...
-
If youd like to have $5,000,000 at retirement in 45 years and you expect to earn 10 percent annually, which is around the average return over the past 50 years, what lump sum would you have to invest...
-
At what annual rate would the following have to be invested? a. \($820\) to grow to \($1,988.12\) in 13 years b. \($320\) to grow to \($423.10\) in 6 years c. \($57\) to grow to \($290.30\) in 18...
-
Obaidullah Hamzah, who recently sold his Ford Mustang, placed $15,000 in a savings account paying annual compound interest of 7 percent. a. Calculate the amount of money that will be accrued if he...
Study smarter with the SolutionInn App