The following is based on the entire ("big" version) Pine Valley Furniture Company database.
Note: Depending on what DBMS you are using, some eld names may have changed to avoid using reserved words for the DBMS. When you first use the DBMS, check the table definitions to see what the exact eld names are for the DBMS you are using. See the Preface and inside covers of. List the MaterialID, MaterialName, Material, MaterialStandardPrice, and Thickness for all raw materials made of cherry, pine, or walnut. Order the listing by Material, StandardPrice, and Thickness.
For every product that has been ordered, display the product ID and the total quantity ordered (label this result TotalOrdered). List the most popular product first and the least popular last.

Franklin painting company is considering whether to purchase a new spray paint machine that costs $4,800. the machine is expected to save labor, increasing net income by $720 per year. the effective life of the machine is 15 years according to the manufacturer’s estimate. required determine the unadjusted rate of return based on the average cost of the investment.

The monthly payment m of a loan of amount p for y years with an interest rate r can be calculated by the formula: m = p(r/12) 1 â’ (1 + r/12)â’12y calculate the monthly payment and the cummulative total payment for a $100,000 loan with an interest rate of 4.85% if taken out for 10 years, for 11 years, etc., up to a 30 year term. display the results in a three-column table where the first column is the number of years, the second is the monthly payment, and the third is the cummulative total payment. note: use format bank; for this problem. also, remember to represent the interest rate as a decimal (e.g. 0.0485) 2. a torus-shaped water tube is designed to have a volume of 8, 000in3 . the volume of the tube, v , and its surface area, s, are given by: v = 1 4 ď€ 2 (a + b)(b â’ a) 2 s = ď€ 2 (b 2 â’ a 2 ) if a = kb, determine s, a, and b for k = 0.2, 0.3, 0.7. display the results in a table

Cardinal company is considering a project that would require a $2,725,000 investment in equipment with a useful life of five years. at the end of five years, the project would terminate and the equipment would be sold for its salvage value of $400,000. the company’s discount rate is 14%. the project would provide net operating income each year as follows: sales $2,867,000 variable expenses 1,125,000 contribution margin 1,742,000 fixed expenses: advertising, salaries, and other fixed out-of-pocket costs $706,000 depreciation 465,000 total fixed expenses 1,171,000 net operating income $571,000 1. which item(s) in the income statement shown above will not affect cash flows? (you may select more than one answer. single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. any boxes left with a question mark will be automatically graded as incorrect.) (a)sales (b)variable expenses (c) advertising, salaries, and other fixed out-of-pocket costs expenses (d) depreciation expense 2. what are the project’s annual net cash inflows? 3.what is the present value of the project’s annual net cash inflows? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.) 4.what is the present value of the equipment’s salvage value at the end of five years? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.) 5.what is the project’s net present value? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.)