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)
Based on the problem you are trying to estimate the cost of building your ... 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...
-
The following data were taken from recent annual reports of Southwest Airlines, which operates a low-fare airline service to over 50 cities in the United States. a. Determine the number of times...
-
Florin Frenti operates a small, used car lot that has three Mercedes (M1, M2, M3) and two Toyotas (T1, T2). Two customers, Cezara and Anda, come to his lot, and each selects a car. The customers do...
-
10. Babe Ruth was one of the greatest baseball players of all time. After Ruth's death, his daughters registered the words "Babe Ruth" as a trademark. MacMillan, Inc., published a baseball calendar...
-
On December 31, 2008, Ed Abbey Co. performed environmental consulting services for Hayduke Co. Hayduke was short of cash, and Abbey Co. agreed to accept a $200,000 zero-interest-bearing note due...
-
Informat Use the following information for the next 2 questions: ion On January 1, 2021, Opal Company had the following general borrowings. A part of the proceeds was used to finance the construction...
-
In 1879, A.A. Michelson measured the velocity of light in air using a modification of a method proposed by the French physicist Foucault. Twenty of these measurements are in table 6E.27 (the value...
-
What Diagnosis with F and Z codes would you give a patient with the following information. Look for Somatic symptom and related diagnosis as well as other DSM 5 diagnosis. IDENTIFYING/DEMOGRAPHIC...
-
Why is a sample more desirable than a census? What are some of the reasons for taking a sample?
-
How can the challenges of sampling for Internet surveys be addressed?
-
Why is inspecting raw data important?
-
a. With what speed are pollen grains ejected from a bunch berry flower? See Problem 47 for information. b. Suppose that 1000 ejected pollen grains slam into the abdomen of a 5.0 g 5.0 g bee that is...
-
To what extent do you think that Minskys financial instability hypothesis is the most accurate theory to explain the Financial Crisis of 20079?
-
What stress coping strategies do you find the most useful in your usual life? What coping strategies do you find less useful? Why is that? In ways/ areas do you think you might want to change any...
-
The diagram shows the two forces acting on a small object. Which of the following is the resultant force on the object? A. 8 N downwards B. 8 N upwards C. 2 N downwards D. 2 N upwards 3 N 5 N
-
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...
-
A large company has a standard sales contract, but sales personnel frequently modify the terms of the contract. Sales personnel frequently grant authorized and unrecorded sales discounts to customers...
-
How should auditors search for hidden liabilities?
-
How could auditors have stopped Parmalat's deceptions?
Study smarter with the SolutionInn App