1. FERTILIZER NUTRIENTS (Please Use Excel and show screenshots :) ) A produce farmer is purchasing...

1. FERTILIZER NUTRIENTS (Please Use Excel and show screenshots :) )

A produce farmer is purchasing fertilizer containing three nutrients: nitrogen, phosphorus, and potassium. The farmer’s minimum weekly requirements are 240 units of nitrogen, 120 units of phosphorus, and 80 units of potassium. There are two popular blends of fertilizer on the market. Blend A costs $8.00 a bag, and contains 4 units of nitrogen, 6 units of phosphorus, and 4 units of potassium. Blend B costs $10.00 a bag, and contains 12 units of nitrogen, 2 units of phosphorus, and 2 units of potassium.

(a) How many bags of each blend should the farmer purchase each week to minimize the cost of meeting the nutrient requirements?

(b) What is the minimum weekly cost?

Expert Solution

milcah answered 2 years ago

Kindly use excel and use screenshots to show formulas 1. Suppose you plan to save $8,000...

Kindly use excel and use screenshots to show formulas 1. Suppose you plan to save $8,000 per year for the 35 years you are working. In addition to the amount you are saving each year, you expect to sell your house for $600,000 in year 32 and deposit this money into your account. How much can you withdraw in equal amounts each year for the 30 years you are retired. The interest rate you will earn during the 35 years...

Kindly use excel and use screenshots to show formulas Fisher, Inc., has identiﬁed an investment project...

Kindly use excel and use screenshots to show formulas Fisher, Inc., has identiﬁed an investment project with the following cash ﬂows. If the discount rate is 8 percent for the first 2 years and 6% for the years after, beginning in year 3, what is the future value of these cash ﬂows in Year 5? What is the future value of the cash flows in year 10? What is the present value of the cash flows? Year Cash Flow 1...

PLEASE SHOW WORKINGS ON EXCEL FM Corporation is considering either purchasing or leasing an asset that...

PLEASE SHOW WORKINGS ON EXCEL FM Corporation is considering either purchasing or leasing an asset that costs $1,000,000. The asset, if purchased, will be depreciated on a straight-line basis over six years to a zero residual value. Ace Leasing company is willing to lease the asset for $300,000 per year; the first payment on the lease is due at the time the lease is undertaken (i.e., year 0), and the remaining five payments are due at the beginning of years...

Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...

Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...

***Excel is required to solve this problem. Please use excel and show all formulas used in...

***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...

For this, problem, please include the excel procedure you used to arrive at an answer (screenshots,...

For this, problem, please include the excel procedure you used to arrive at an answer (screenshots, explanation, actual file, etc.). Brokerage Overall Satisfaction with Electronic Trades Satisfaction with Trade Price Satisfaction with Speed of Execution Scottrade, Inc. 3.5 3.4 3.4 Charles Schwab 3.4 3.2 3.3 Fidelity Brokerage Services 3.9 3.1 3.4 TD Ameritrade 3.7 2.9 3.6 E*Trade Financial 2.9 2.9 3.2 (Not listed) 2.7 2.5 3.2 Vanguard Brokerage Services 2.8 2.6 3.8 USAA Brokerage Services 3.6 2.4 3.8 Thinkorswim 2.6...

Please show workings clearly on excel sheet Your company is considering either purchasing or leasing an...

Please show workings clearly on excel sheet Your company is considering either purchasing or leasing an asset that costs $1,000,000. The asset, if purchased, will be depreciated on a straight-line basis over six years to a zero residual value. Ace Leasing company is willing to lease the asset for $300,000 per year; the first payment on the lease is due at the time the lease is undertaken (i.e., year 0), and the remaining five payments are due at the beginning...

Please explain your answers and use Excel to show the excel formula you used to get...

Please explain your answers and use Excel to show the excel formula you used to get your solution. 6. A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?

Please show fully functioning Java code and screenshots of outputs. Please separate by 1a and 1b....

Please show fully functioning Java code and screenshots of outputs. Please separate by 1a and 1b. #1. Design a Java JProduct class for a product which implements both cloneable and comparable interfaces The class should have the following private member variables: m_id: an integer that holds the product ID m_name: a string that holds the product name m_wholesaleprice: a double that holds the wholesale price m_retailers: a String array that holds all retailers who sell the product and the class...

Please show all your work if you use the Calculator. If done in Excel, please send...

Please show all your work if you use the Calculator. If done in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon...

Question