Answered step by step
Verified Expert Solution
Question
1 Approved Answer
every step is done i am stuck at last step for excel sheet i have to find formula for the last question. Task 14: Using
every step is done i am stuck at last step for excel sheet i have to find formula for the last question.
Task 14: Using Formulas to Make the Yearly Projections, Cost per Table Top The final step in the Desi Planishings Inc (DFI) spreadsheet is to use formulas to calculate the cost per table for Oak and Maple. The formulas are not the same as we used to calculate cost per foot of wood or cost per hour of labour. For this calculation you will need to use "Requirements per table top" numerical data and the previously calculated cost per foot of wood for Oak and Maple and the cost per hour of labour. Be sure to use the fill handle to copy the formula to other cells and to use absolute address in your formula. This is not a difficult formula to figure out so I will let you come up with the solution on your own. Your result should match the results shown below. 28 Projected Costs 29 30 Years from now 21 32 Maple 1 2 33 Cost per foot of wood Oak $15.00 $10.00 $15.90 $10.40 $16.85 $10.82 $17.87 $11.25 $18.94 $11.70 $20.07 $12.17 Cost per hour Labour $30.00 $31.50 $11.08 $34.71 $36.47 $38.29 Cost per table top Oak Maple $1,275.00 $900.00 $1,345.50 SM0.50 $1,419.93 $99.85 $1.498.51 51,027.12 $1,581.4 $1,073.41 $1,669.07 51, 121.82 3 4 35 36 5 37 E31*B104B31'89 projecting table top manufil E B D cines for designer furnishing indtil G 4 input oak Requirment per table top 8 9 feet of wood 10 labour hours 11 Maple 45 45 20 15 12 13 costs in dollars per table top 14 15 price per foot of timber 16 labour rate of pay per hour oak Maple $15.00 $10.00 $30.00 $30.00 18 19. anticipated percentage increase in costs 20 oak Maple labour 6.00% 4.00% 5.00% Sheet Red HE Type here to search o Number Styles G31 31B101831.89 A D G 23 24 25 26 output 27 28 Projected costs 29 30 Years from now 31 32 cost per table top cak maple $1,275.00 0 1 2 cost per foot wood oak maple $15.00 $10.00 $15.90 $10.40 $16.85 $10.82 $17.87 $11.25 $18.94 $11.70 $20.07 $12.17 cost per hour labour $30.00 $31.50 $33.08 $34.73 $36.47 $38.29 33 34 3 35 4 5 36 37 38 39 40 41 42 43 Sheet1 Read Type here to search O Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started