Question: A B C D E F G H 4 Requirements per bookshelf Cherry Oak Pine Elmwood 5 Board-feet required 30 6 24 Labor hours required

A B C D E F G H 4 Requirements per bookshelf Cherry Oak Pine Elmwood 5 Board-feet required 30 6 24 Labor hours required 16 30 16 18 16 22 8 |Costs of wood Cherry Oak Pine Elmwood 9 Current cost per board-foot $6.1 $4.30 $5.65 67.85 10 Projected annual increase 4.2% 2.1% 2.3% 1.66% 11 12 Cost of labor 13 Current cost per labor hour $18.50 14 Projected annual increase 1.5% 15 16 Projected costs 17 Years from now Cost per board-foot Cost per hour Cost per bookshelf 18 Cher Oak Pine Elmwood Labor Cherry Oak 19 Pine Elmwood 20 Current Year $6.15 $4.30 5.65 $ 7.85 $18.50 $480.50 |$425.00 $397.70 $595.40 $6.41 $4.39 5.78 $ 7.98 $18.78 $492.69 | $432.15 $404.48 $604.6 21 $6.68 $4.48 5.91 $ 8.11 $19.06 $505.27 $439.42 $411.38 $614.01 $6.96 $4.58 6.05 $ $19.35 $623.53 $7.25 $4.67 S $ 6.19 $ 8.25 $518.26 $446.82 $418.40 8.38 $19.64 $531.67 $454.35 $425.55 $633.20 $7.55 $4.77 6.33 $ 8.52 $19.93 $545.52 | $462.00 $432.82 $643.02 $7.87 $4.87 6.48 $ 8.67 20.23 $559.82 | $469.79 $440.23 $652.99 $8.20 $4.97 6.62 $ 8.81 $20.53 $574.59 $477.71 $447.76 $663.12 $8.55 $5.08 6.78 $ 8.96 $20.84 $589.85 $485.78 $455.43 $673.40 $8.91 $5.18 6.93 $ 9.10 $21.15 $605.62 | $493.98 $463.24 $683.85 $9.28 $5.29 7.09 $ 9.25 $21.47 $621.92 |$502.32 $471.19 $694.46 $9.67 $5.40 7.26 $ 9.41 $21.79 $638.77 |$510.81 $479.28 $10.08 $5.52 $ 7 42 $ $705.23 9.56 $22.12 $656.18 |$519.44 $487.51 $716.17 $10.50 $5.63 S $ 7.59 $ 9.72 7.77 $ $22.45 $674. 19 |$528.23 $495.89 $727.28 $10.94 $5.75 .88 $22.79 $692.80 |$537.16 $504.42 $738.56 $11.40 $5.87 7.95 $ 10.05 $23.13 $712.06 $546.26 $513.11 $750.02 FINANCIAL PROJECTION FOR CURRENT YEAR MARKUP (Cost per bookshelf at profit) Cherry Oak Pine Elmwood Cherry Oak Pine Elmwood 40 Selling Price $ 652.58 $ 624.75 $ 457.36 $ 1, 101.49 1.15 1.47 1.15 1.85 41 Market Order 65 115 90 160 42 Total Revenue for each type 35,917.38 $ 71,846.25 $ 41, 161 95 $ 176,238.40 43 Total Revenue (Combined) 325,163.98 44 Total Profit for each bookshelf type 4,684.87 22,971.25 ,368.95 80,974.40 45 Variable Cost 31,232 50 $ 48,875.00 $ 35,793.00 $ 95,264.00 46 Tax 26,013.12 47 Marketing Cost 19,509.84 48 Fixed Cost 14,000.00 49 Salary 8,000.00 50 Other Cost 5.000.00 51 52 53 $41,476.52 54 55 NET PROFIT 56

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!

Instructions are: 1. Solve the following project free cash flow problem: Smooth Riding Company, a manufacturer of comfort bikes, is considering a new project involving the introduction of a new...

Autosove MOT2303 - Final Pro Insert Draw Formulas Data Page Layout Home Review View Calibri (Body) 11 ' E- Paste BIU Av 122 2 xv fx A B c D E F G H 1 MGT2303 - Final Project 2 13 Part 1: (a) FAN 5...

Q R S T U A B C D E F G H 4 Problem C (26 points): 5 Statue Company is able to produce two products, a Fancy Statue and a Plain 6 Statue with the same machine in its factory. NOTE that only ONE...

Studies have shown that the frequency with which shoppers browse internet retailers is related to the frequency with which they actually purchas products and/or services online. The following data...

PLEASE ANSWER THE FOLLOWING ............................... 1) 1. Find the P-value for a left-tailed hypothesis test with a test statistic of z= -1.55. Decide whether to reject Upper H 0H0 if the...

So far this is what i have. I have requirements #1, 2, 3, 4. I am needing #5, the four financial statements. ACCT 3103 Accounting Cycle Review Problem Due March 31,2019 40 points Facts: During...

Please help with 7 and 8 In the project you will assume the role of the staff accountant for Shipping Inc., and perform Shipping Inc.'s accounting for the transactions that occurred during January...

Prepare Schedule C and Form 4562. The question is on the first attach file. Form 4562 Depreciation and Amortization Attach Information to your tax return. about Form 4562 and its separate...

Please read the instructions and complete the project as required, USING EXCEL. Everything needed should be included. INSTRUCTIONS: Req. 16: Obtain the Labor Time Records for the week to determine...

Instruction : Complete a Master Budget in Excel using the following assumptions and template using Excel formulas SHOW ME ALL THE FORMULAS PLEASE! THAT'S THE MOST IMPORTANT PART. THANK YOU. Sales...

For Western Europe, the infant mortality rates reported by the Human Development Report 2006 were Sweden 3, Finland 3, Spain 3, Belgium 4, Denmark 4, France 4, Germany 4, Greece 4, Italy 4, Norway 4,...

For a recent year, there were 46 aircraft hijackings worldwide (based on data from the FAA). Using one day as the specified interval required for a Poisson distribution, we find the mean number of...

The work of the costing and finance function mitigate agency problems when _ _ _ _

You are reviewing a new project and have estimated the following cash flows: Year 0: CF = -100,000 Year 1: CF = 40,000; Year 2: CF = 40,000; Year 3: CF = 40,000; Assume the required rate of return is...

1. How does monopolistic competition differ from pure competition in its basic characteristics? From pure monopoly? Explain fully what product differentiation may involve. Explain how the entry of...

LO13.4 Relate how the ability of monopolistic competition to deliver product differentiation helps to compensate for its failure to deliver economic efficiency.

8. Explain verbally and graphically how price (rate) regulation may improve the performance of monopolies. In your answer distinguish between (a) socially optimal (marginal-cost) pricing and (b)...