Total sales revenue is $1000, total variable costs are $600 and total fixed costs are $1000. The price is $10 per unit. Compute the break-even volume in units (assume that the break-even point is in the relevant range).

A) 166.7 units

B) 250 units

C) 280 units

D) 2500 units

Beta company allocates fixed overhead costs based on direct labor dollars, with an allocation rate of $5 per DL$. Beta sells 1000 units of product X per month at a price of $40 per unit. The variable costs are: direct materials, $10/unit, direct labor $4/unit, and variable overhead $2/unit. Compute the profit margin per unit of product X

A) $4

B)$20

C) $21.5

D) $24

E)$26

Beta is planning to increase the price of Product X to $50 per unit. It expects sales volume to decrease by 20%(from the original level of 1000 units per month) after the price increase. How much will the profit change in the short term after this price increase?

A) decrease by $2800

B) decrease by $800

C) No change

D) increase by $3200

E) increase by $7200

You have the following data for product X: sales revenue is $10000, variable costs are $4000, allocated fixed costs are $3000. If you drop product X in the long term total profit will:

A) decrease by $6000

B)decrease by $3000

C) remain the same

D) increase by $3000

E) increase by $6000

Explanation for answers please

What do we expect to happen to Netflix's revenue due to the price increase?

Essay

Regardless of the implementation of the price increase, the higher monthly prices seem to have impacted the growth of membership among US subscribers. In the two quarters before the price increase, Netflix added net membership of 1.6 million and 2.2 million members. By contrast, the number of members added in Q2 was only 160,000, and in Q3 only 400,000. The Q2 growth in US subscribers was the lowest since Netflix began reporting those numbers.

1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow.

1. Is the estimated regression equation coefficient for television advertising expenditures the same in par a), in part b) and in part c)? Interpret the coefficient in each case
2. Obtain and compare the multiple coefficient of determination and the adjusted multiple coefficient of determination for parts a), b) and c). How does the coefficient of determination changes as a result of adding more independent variables in the equation?
3. What is the estimate of the weekly gross revenue for a week when $3500 is spent on television advertising, $1800 is spent on newspaper advertising, and $350 in radio advertising?

PLEASE SHOW IN EXCEL AND HOW TO DO IT. Thank you!

1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow.

1. Use the F test to determine the overall significance of the relationship. What is the conclusion at the .05 level of significance?
2. Use the t test to determine the significance of each independent variable. What is your conclusion at the .05 level of significance?
1. Determine the sample correlation coefficient between all possible pairs of independent variables to measure multicollinearity. Is there any value high enough to predict any potential problem in the regression model? Explain

PLEASE SHOW HOW TO DO IN EXCEL. Thank you!

Refer to Revenue Data Excel File. The 4 QTR Centered Moving Average for the 2nd quarter of 2017 is: Select one: a. 222.125 b. 333.875 c. 269.250 d. 243.625

1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow.

1. Develop an estimated regression equation in Excel with the amount of television advertising as the independent variable
2. Develop an estimated regression equation in Excel with both television advertising and newspaper advertising as the independent variables
3. Develop an estimated regression equation in Excel with all three independent variables: television advertising, newspaper advertising, and radio advertising
4. Is the estimated regression equation coefficient for television advertising expenditures the same in par a), in part b) and in part c)? Interpret the coefficient in each case
5. Obtain and compare the multiple coefficient of determination and the adjusted multiple coefficient of determination for parts a), b) and c). How does the coefficient of determination changes as a result of adding more independent variables in the equation?
6. What is the estimate of the weekly gross revenue for a week when $3500 is spent on television advertising, $1800 is spent on newspaper advertising, and $350 in radio advertising?

I ONLY need help with D through F. Please show how to do in Excel. Thank you!!

Question 1:

Consider the following revenue and cost data for Shannon’s Brewery in Keller, Texas. Shannon’s sells 35% of its craft beer production through its own on-premise taproom. The bulk of its sales (65%) are made off-premise via various retail outlets including supermarkets, bars, and restaurants. 40% of its of sales (on-premise and off-premise) consists of package sales (bottles and cans). Of this 40%, beer sold in cans accounts for 80% with sales of bottled beer accounting for the remaining 20%. Finally, the bulk of Shannon’s craft beer sales (60%) occurs in kegs (31 gallons per keg). Assume that overall sales for FY 2018 are expected to be $1,278,360. Given the proportions of beer sold in kegs, bottles, and cans, what will be the predicted dollar sales of beer sold in kegs? Round your answer to the nearest one dollar.

Question 2:

Assume the following costs in each of the categories identified in question one are:

What is Shannon's cost of goods sold?

Question 3:

Assume that projected revenue for 2018 is 1,155,212. Also assume the following projected 2018 costs in each of the cost categories from question one:

Given these costs, compute Shannon’s projected contribution in dollars.

BC Travel Services is considering a new 10-year project that will generate additional sales revenue of $200,000 per year. The associated costs are $120,000 per year. The required rate of return for the project is 12%. The tax rate is 40%. What is the present value of the after-tax operating cash flows?

A. $250,374

B. $271,211

C. $417,289

D. $452,018