Copy and paste the following data into Excel:

a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P).

b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination.

c. What is the point price elasticity of demand when P=$140.25? What is the point price elasticity of demand when P=$135.50?

d. To maximize total revenue, what would you recommend if the company was currently charging P=$122.04? If it was charging P=$135.50?

e. Use your first demand function to determine an equation for TR and MR as a function of Q, and create a graph of P and MR on the vertical and Q on the horizontal axis.

f. What is the total-revenue maximizing price and quantity, and how much revenue is earned there? (Round your price to the nearest cent, your quantity to the nearest whole unit, and your TR to the nearest dollar.) Compare that to the TR when P = $140.25 and P = $135.50.

Copy and paste the following data into Excel:

a.   Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P).

b.   Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination.

c.   What is the point price elasticity of demand when P=$210.00? What is the point price elasticity of demand when P=$185.50?

d.   To maximize total revenue, what would you recommend if the company was currently charging P=$201.60? If it was charging P=$185.50?

e.   Use your first demand function to determine an equation for TR and MR as a function of Q, and create a graph of P and MR on the vertical and Q on the horizontal axis.

f.    What is the total-revenue maximizing price and quantity, and how much revenue is earned there? (Round your price to the nearest cent, your quantity to the nearest whole unit, and your TR to the nearest dollar.) Compare that to the TR when P = $210.00 and P = $185.50.

in java

my code

double price[] = {26.99, 22.99, 13.99, 56.99, 38.99};

// Variable Declaration

Scanner keyIn = new Scanner(System.in);

//Header

System.out.println( "----------------------------------------\n"

+ " Grocery Shop Price Calculator \n"

+ "----------------------------------------\n") ;

System.out.print ("Please enter the quantities for each item in the list? ");

double totalCost = 0;

double fishAmount = 0;

for(int i=0; i<price.length; i++)

{

int items = Integer.parseInt(keyIn.nextLine());

if(i==4)

fishAmount = price[i]*items;

else

totalCost = totalCost + price [i]*items;

}

System.out.print("Do you have the membership(Y/N) ");

String st = keyIn.nextLine();

double off;

if(totalCost<250)

off = totalCost*0.1;

else if(totalCost<500)

off = totalCost*0.2;

else

off = totalCost*0.15;

totalCost = totalCost + fishAmount - off;

long points = 0;

if(st.equalsIgnoreCase("Y"))

{

if(totalCost<500)

points = Math.round(totalCost*2);

else

points = Math.round(totalCost*3);

}

System.out.print("The total price is $"+ totalCost+".");

if(st.equalsIgnoreCase("Y"))

System.out.println("You will receive " + points + " points.");

//close scanner

keyIn.close();

System.out.println ("Thanks for shopping! See you next time!");

}

}

and it is not working second question

this-System.out.print("Do you have the membership(Y/N) ");

just come out first question and stop

what is my problem?

Copy and paste the following data into Excel:

a.   Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P).

b.   Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination.

c.   What is the point price elasticity of demand when P=$210.00? What is the point price elasticity of demand when P=$185.50?

d.   To maximize total revenue, what would you recommend if the company was currently charging P=$201.60? If it was charging P=$185.50?

e.   Use your first demand function to determine an equation for TR and MR as a function of Q, and create a graph of P and MR on the vertical and Q on the horizontal axis.

f.          What is the total-revenue maximizing price and quantity, and how much revenue is earned there? (Round your price to the nearest cent, your quantity to the nearest whole unit, and your TR to the nearest dollar.) Compare that to the TR when P = $210.00 and P = $185.50.

A newly organized manufacturing business plans to manufacture and sell 50,000 units per year of a new product. Direct materials cost Rs. 47 per unit while direct labor cost is Rs. 32. Manufacturing overheads has two parts: variable part is Rs. 4 per unit while fixed costs are Rs. 340,000 per year. Selling expenses are Re.1 per unit while administrative expenses are Rs. 200,000 for a year.

1. What should the company establish as the selling price per unit if it sets a target of earning an operating income of Rs. 260,000 by producing and selling 50,000 units during the first year of operations?
2. At the unit price computed in part a, how many units must the company produce and sell to break even? Calculate breakeven point in currency value too.
3. What will be the margin of safety (in units and currency) if the company produces and sells 50,000 units at the sales price computed in part a)?
4. Compute operating income at 50,000 units.
5. Due to heavy competition, the marketing manager thinks that the selling price must not be more than Rs. 94, in order to maintain sales of 50,000 units. Can the company survive by making profits at this price? Show calculations to justify your answer.

Profitability Analysis
(Reference: Peters, Timmerhaus, West in Plant Design and Economics for Chemical Engineers 5^th Ed.)

A process, projected to have a total depreciable fixed capital investment of $100 million, with no allocated cost for off-site utilities, is to be installed over a 3-yr period (2018-2020). Just prior to start-up, $30 million of working capital is required. At 100% production capacity (projected for the third and subsequent operating years), sales revenues are projected to be $130 million/ yr. and the total annual production cost, excluding depreciation, is to be $ 90 million/yr. Also, the plant is subjected to operate at 50% and 75% of full annual capacity during the first and second operating years. Thus, during those years, revenues are anticipated to be 50% and 75% of the sales revenues projected in the third and subsequent years, respectively. Operating expenses in Y1 and Y2 are 75% of that in Y3.

Using the straight-line method to calculate for depreciation.
Perform a 10 year-period analysis and compute for the ROI and PBP.

Dear Prof., if you are going to use a spreadsheet, please provide the necessary formula and complete solution.

1.         Trading volume on the New York Stock Exchange has been growing in recent years. For the first two weeks of January 1998, the average daily volume was 646 million shares (Barron’s, January 1998). The probability distribution of daily volume is approximately normal with a standard deviation of about 100 million shares.

a.   What is the probability trading volume will be less than 400 million shares?

b.   What percentage of the time does the trading volume exceed 800 million shares?

3. If the exchange wants to issue a press release on the top 5% of trading days, what volume will trigger a release?

2. Suppose that the average client charge per hour for lawyers in the state of Iowa for out-of-court work is $125. Suppose further that a random telephone sample of 25 lawyers in Iowa is taken. If the population standard deviation is $50,

1. What is the probability of getting a sample mean equal or greater than $110 per hour?

2. What is the probability of getting a sample mean less than $100 per hour?

3. What is the probability of getting a sample mean of between $120 and $130 per hour?

Question 56

Compounding is the process of finding the present value of some future amount.

Select one:

True

False

Question 57

Sales divided by net income is referred to as the profit margin.

Select one:

True

False

Question 58

This morning, Alicia bought a ten-year 9% coupon bond that pays interest semi-annually. She paid $994 for a $1,000 bond. If the market interest rate on this type of bond declines to 8.5% tonight, how much will Alicia receive for her first interest payment?

Select one:

a. $90.00

b. $45.00

c. $46.29

d. $32.31

e. $69.58

Question 59

A firm earns net income of $125,000 in a given year and the firm's retained earnings increase $100,000 for that same year. The payout ratio is:

Select one:

a. 60%

b. 80%

c. 20%

d. 40%

e. 100%

Question 60

Suppose a project costs $375 and produces cash flows of $100 over each of the following six years. What is the IRR of the project?

Select one:

a. 10.0%

b. 15.3%

c. There is not enough information; a discount rate is required

d. 18.6%

e. 13.0%

Hi-Test Company uses the weighted-average method of process costing to assign production costs to its products. Information for the company's first production process September follows. Assume that all materials are added at the beginning of this production process, and that conversion costs are added uniformly throughout the process.

Required:
Compute each of the following using the weighted-average method of process costing.

1. & 2. The number of equivalent units for materials and conversion for the month.
3. & 4. The cost per equivalent unit of materials and conversion for the month.
5. The total cost of goods transferred out.
6. The total cost of ending work in process inventory.

Part A. Wollongong Credit Centre (WCC) provides loan to two types of clients; individuals and corporate client. WCC has two support departments: IT Support (IT) and Admin Support (Admin) department. In addition, WCC has two operation departments to deal with its two distinct clients named Individual clients and corporate clients department. For the next quarter, the following cost record including budgeted cost of support department to be allocated to operating department is as follows: Support Department Operation Department IT Admin Individual Corporate Total Budgeted costs $ 1,200,000 1,500,000 7,500,000 8,000,000 18,200,000 Support work supplied by IT 25% 40% 35% 100% Support work supplied by Admin 10% 30% 60% 100% Required (show your workings):

(a) Using the direct method, determine the amount of support department costs will be allocated to the two operation departments

(b) Using the step-down method, determine the amount of support department costs will be allocated to the two operation departments if the Admin department with the highest amount is allocated first.

(c) Compare and explain differences in the support-department allocated to each operation department.