Question

In: Finance

-please answer this written out. Do not use excel I cannot access it. i need to...

-please answer this written out. Do not use excel I cannot access it. i need to know how to do it on paper-

Deluxe River Cruises operates a fleet of river vessels. The fleet has two types of vessels: A type A vessel has 60 deluxe cabins and 160 standard cabins, whereas a type B vessel has 80 deluxe cabins and 120 standard cabins. Under a charter agreement with the Odyssey Travel Agency, Deluxe River Cruise sis to provide Odyssey with a minimum of 360 deluxe and 680 standard cabins for their 15-day cruise in May. It costs $44000 to operate a type A vessel and $54000 to operate a type B vessel for that period. ii.) Find the range of values that the cost of operating a type A vessel can assume without changing the optimal solution. iii.) Find the range of values that the requirement for deluxe cabins can assume. iv.) Find the shadow price for the requirement for deluxe cabins.

Expert Solution

I have answered the question below

Please up vote for the same and thanks!!!

Do reach out in the comments for any queries

Answer:

a)

The number of cabins of each type of vessel should be used to keep the operating costs to a minimum.

The number of cabins of each type of vessel should be used to keep the operating costs to a minimum is $ 250,000$ 250,000 of 2 type A vessel and 3 type B vessel.

b)

c)

d)

jeff jeffy answered 1 year ago

Please do not use Excel to answer this. I need the computations as we are not...

Please do not use Excel to answer this. I need the computations as we are not allowed to use excel. Sequential Method Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three support departments support the production departments: Power, General Factory, and Purchasing. Budgeted data on the five departments are as follows: Support Departments Producing Departments Power General Factory Purchasing Pesticide Liquid Fertilizer Overhead $80,000 $312,000 $165,000 $78,500 $107,400 Square feet 1,500...

PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company...

PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company currently uses an injection-molding machine that was purchased 2 years ago. This machine is being depreciated on a straight-line basis, and it has 6-years of remaining life. Its current book value is $2,100, and it can be sold for $2,500 at this time. Thus, the annual depreciation expense is $350 [($2,100/6) = $350 per year]. If the old machine is not replaced, it can...

You may use Microsoft access or Derby DB Please I need an answer for this problem,...

You may use Microsoft access or Derby DB Please I need an answer for this problem, I have posted this problem 5 times. Put aggregate without condition for the following 6 queries: Queries: -- Query 1 -- Find the details of students who was born after 31st december 2004. select * from Student_Information where DOB>"2004-12-31"; -- Query 2 -- Find all student details whose first name begins with J. select * from Student_Information where FirstName like 'J%'; -- Query 3...

Business Analytics Could I get the answer on a downloadable excel sheet please? if i cannot...

Business Analytics Could I get the answer on a downloadable excel sheet please? if i cannot get the downloadable file here on chegg: my email is [email protected] i can paypal $10 for the answer. Market Insights Co. (MIC) is a full-service market research company. MIC is being hired to interview registered voters in a district to gain insight into their opinions about certain issues. Each voter is to be interviewed in person. The costs of interviewing different types of voters...

I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to...

I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to solve problem #31 (the PUTZ, Inc. project) for Chapter 10 in the textbook. 2) Conduct a sensitivity analysis that focuses on the sales price by increasing the price by 10% above the best estimate, and then by decreasing the price by 10% below the best estimate. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case,...

***You can use a calculator but I just need the work written out so I can...

***You can use a calculator but I just need the work written out so I can see what you did and how you did it*** I need the answer for number 4 which is based on number 3. Please answer number 4 based on number 3. Number 4 can be found at the bottom. Thank you! 3. A business takes out a loan for $250,000 at 4.8% interest compounded monthly. If the business can afford to make monthly payments of...

Please use EXCEL to answer and show all formulas. I can't understand the answer if I...

Please use EXCEL to answer and show all formulas. I can't understand the answer if I can't see the formulas for each field. Thank you very much. Newman manufacturing is considering a cash purchase of the stock of Grips Tool. During the year just completed, Grips earned $4.25 per share and paid cash dividends of $2.55 per share (D0=$2.55). Grips' earnings and dividends are expected to grow at 25% per year for the next 3 years, after which they are...

Please answer in excel only. How do I create the graphs in excel and show the...

Please answer in excel only. How do I create the graphs in excel and show the data. Discuss the following two cost functions: TC=20+4Q TC=20+2Q+0.5Q^2 a) Calculate all cost curves and plot these curves on graphs. Total Cost Total Fixed Cost Total Variable Cost Average Total Cost Average Fixed Cost Average Variable Cost Marginal Cost b) In each case, indicate the point at which diminishing returns occur. (For question a), compute the required costs and plot the curves for quantities...

I need to know how to do this IN EXCEL, please! Dennis wants to determine if...

I need to know how to do this IN EXCEL, please! Dennis wants to determine if the discount rate really makes any difference in the net present value of a project. He feels that if a project is acceptable at one rate of return, it will be acceptable at all rates of return. To explain why his thinking is incorrect, you are creating an example to illustrate your point. The cash flows you are using are as follows: time zero...

( i need Unique answer, don't copy and paste, please) (dont' use handwriting, please). (i need...

( i need Unique answer, don't copy and paste, please) (dont' use handwriting, please). (i need references URL Link) General Question ** How to perform logistic regression in SPSS?