Please show work and use the actual equations, not excel ones. An RV manufacturer estimates that...

Please show work and use the actual equations, not excel ones.

An RV manufacturer estimates that annual profits will increase if a mobile model is built and taken to trade shows to market their product line. A finance and engineering team has looked at the issue and has developed to options:

1.) A large model can be developed at a cost of $75,000, and it should increase annual profits by $25,000 per year.

2.) A small model can be developed for $40,000, but it will only increase annual profits by $14,500 per year.

The salvage value for the large model is $6000 more than the small model after their common useful life of 6 years, and it costs $1,500 more a year to transport to the trade shows. The manufacturer uses an interest rate of %18. Use an annual worth comparison to make a recommendation on which, if either, option should be chosen.

Expert Solution

Rahul Sunny answered 2 months ago

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...

Please solve the following breakeven analysis problem and show all systems of equations and work. (Excel...

Please solve the following breakeven analysis problem and show all systems of equations and work. (Excel solver is not neccessary for this problem) Jim and Pam are going to Culinary School! There are a group of students at the school who are drug dealers, and the Captain has received information that they are looking to start selling a dangerous new street drug to the residents of the town nearby. Jim and Pam infiltrate this group and propose that they use...

Please use excel and show all work and formulas. (I will give your work a like...

Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...

Please, use Excel and show the formulas The Oliver Cards Company is a card manufacturer. All...

Please, use Excel and show the formulas The Oliver Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,800 units that averaged 65 percent complete for conversion costs. Materials were done. Ending work in process inventory was 18,600 units averaged 85 percent complete for conversion costs. Materials...

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...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...

Please show the work in Excel Use the following data to construct a scatter diagram. Does...

***Please show the work in Excel*** Use the following data to construct a scatter diagram. Does there appear to be a relationship between hours of overtime and number of rejects? Discuss. Hours of Overtime Number of Rejects 127 33 90 25 95 23 160 40 10 9 80 19 27 14 103 28 48 19 65 31

Please show work (i.e. equations used) not just the final answer Use the data from the...

Please show work (i.e. equations used) not just the final answer Use the data from the Table to answer the questions below: Population Statistics for a Hypothetical County Measure Number Measure Number Total 1-year Population 200,000 Number of deaths of persons aged 55 years and older 850 Population of women 15-44 years of age 50,000 Number of deaths of among women aged 55 years and older 460 Population of women 55 years of age or older 55,000 Number one cause...

Please Use Excel to Show All Work, I will like your answer :) 15.54 The Tire...

Please Use Excel to Show All Work, I will like your answer :) 15.54 The Tire Rack, America’s leading online distributor of tires and wheels, conducts extensive testing to provide customers with products that are right for their vehicle, driving style, and driving conditions. In addition, the Tire Rack maintains an independent consumer survey to help drivers help each other by sharing their long-term tire experiences. The following data show survey ratings (1 to 10 scale with 10 the highest...

Please Use Excel To Show All Work, I will like your asnwer if you do this...

Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...

Question