Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David J. Auer David M. Kroenke

13th Edition

B01366W6DS, 978-0133058352

More Books

Students also viewed these Databases questions

Question

what is a peer Group? Importance?

Answered: 1 week ago

Question

How do modern Dashboards differ from earlier implementations?

Answered: 1 week ago