Use MS-Excel to plot a graph of the Demand Curve for hats

Reference no: EM132373944

Questions -

Q1. A clothing business finds there is a linear relationship between the number of hats, X, it can sell and the price, P, it can charge per hat. Historical data shows that 1,500 hats can be sold at a price of $40, while 2,000 hats can be sold at a price of $30. Find a linear equation in the form P(X) = bX + a that gives the price P they can charge for X hats

a. If they gave away the hats for free, how many hats will people take away?

b. How much must they reduce the price of the hats in order to sell an additional hat?

c. How many hats can be sold at a Price of $25 per hat?

d. Use MS-Excel to plot a graph of the Demand Curve for hats.

Q2. A car rental company offers two plans for renting a car.

Plan A: $30 per day and $0.18 per mile.

Plan B: $50 per day with free unlimited mileage.

How many miles would you need to drive for plan B to save you money?

Q3. For the following exercises, use the median home values in Mississippi and Hawaii (adjusted for inflation) shown in Table 1. Assume that the house values are changing linearly.

Table 1 (Median Home Values)
Year	Mississippi	Hawaii
1950	$25,200	$74,400
2000	$71,400	$272,700

a. In which state have home values increased at a higher rate?

b. If these trends were to continue, what would be the median home value in Mississippi in 2010?

Q4. A phone company charges for service according to the formula: C(n) = 21 + 0.08n, where n is the number of minutes talked, and C(n) is the monthly charge, in dollars.

a. What is the fixed charge, even if you do not talk on your phone?

b. How much are you charged for each minute of talk time (Rate of Change in total charges)?

c. What is the total charge, if you talked for 300 minutes on the phone?

d. Use the MS-Excel graphing tool to Graph the Function C(n) = 21 + .08n for values of n from 50 to 500, in increments of 25.

Reference no: EM132373944

Questions Cloud

Write a program which requests that requests a product name : Write a program which requests that requests a product name and a stock number. Store that data in a List or a Dictionary

Specified potential causes of personality : What does research say about the specified potential causes of personality disorders? Please use a detailed explanation and citations

Identify and describe the organizational holdings at risk : ICT 205 CYBER SECURITY-KING’S OWN INSTITUTE-Australia-Identify and describe the potential security threats to the organization.

Topic in industrial and organizational psychology : Work-based assessment is a central topic in industrial and organizational psychology. Work-based assessments are often criticized for lack of quantitative

Use MS-Excel to plot a graph of the Demand Curve for hats : Use MS-Excel to plot a graph of the Demand Curve for hats. How much must they reduce the price of the hats in order to sell an additional hat

Automate a business process : ITECH1100-Understanding the Digital Revolution-Hat World Federation University-Apply business information software for data visualization and analysis purposes

What did you learn this week about communication : What did you learn this week about communication that stood out to you, and what does scripture say about resolving conflicts.

Can you find and reconstruct a deductive argument : PHIL110 Critical Thinking: Discussion Assignment - Sherlock Holmes: Induction, Deduction or Both? CUNY School of Professional Studies, USA

Create a text-based program for storing data on hotel room : ITECH5403 – Comparative Programming Languages-Federation University- Australia-You are tasked with creating a text-based program for storing data on Hotel Room.

User Account

All Pages