Find maximum monthly fixed cost that surfing usa would pay

Assignment Help Other Subject
Reference no: EM131638635

Assignment

How to build profit models?

Surfing USA, an Internet Service Provider, is considering to offer a service in Laramie County, WY that connects a device directly to televisions and allows customers to either watch TV or access the Internet. The expected price of the service per customer is $26 per month and the variable cost per customer to provide the service is expected to be $17 per month. The number of customers in Laramie County that are expected to subscribe to the service at that price is 20,000 per month.

1. Develop an Excel Model to find the maximum monthly fixed cost that Surfing USA would pay to offer the service in Laramie County and not operate at a loss.

2. Assume that Surfing USA's monthly fixed costs are $100,000 and monthly service cost per customer is $17. The price per customer will affect the monthly demand for the service. Assume that for a monthly price of $26 per customer, the demand will be 20,000 customers and for every $1 increase in price, demand will fall by 2,700 customers. Develop a second Excel Model to recommend a monthly price to Surfing USA and examine the sensitivity of monthly profit to changes in price for prices from $20 to $30.

Reference no: EM131638635

Questions Cloud

Find the fixed market basket food faddist price index : After a visit from his mother, he adds oranges to his diet. Oranges cost $0.56/pound in 1995. Here are the food faddist's food purchases in 2005.
Explain statement paper and literature evaluation : While the implementation plan prepares students to apply their research to the problem or issue they have identified for their capstone change
Define barriers to implementing ebp in nursing : What are some of the obstacles or barriers to implementing EBP in nursing
Find the fixed market basket guru price index : The Guru Price Index. A guru purchases only olive oil, loincloths, and copies of the Atharva Veda, from which he selects mantras for his disciples.
Find maximum monthly fixed cost that surfing usa would pay : Develop an Excel Model to find the maximum monthly fixed cost that Surfing USA would pay to offer the service in Laramie County and not operate at a loss.
Discuss the historical perspectives and belief systems : Discuss the historical perspectives and belief systems of these cultures that influence the high-risk nutritional behaviors
What was the overall trend in prices during this period : How much can a dollar buy? The buying power of a dollar changes over time. The Bureau of Labor Statistics measures the cost of a "market basket" of goods.
Summarize the outcome of the case : Summarize the seminal facts of the case that you chose. Summarize the outcome of the case, and indicate whether the judge or jury made the decision.
Summarize the process of developing a needs assessment : Explain the use of a needs assessment when developing curriculum related to your topic

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd