Track A: Mathematical Business Scenarios
The Price for a certain type of diamonds are given below.
Weight (carats) Price (US Dollars $)
Scenario 2 (college algebra and applications for business and life sciences 2e page 257
A manufacturer has daily production costs (in dollars per unit) as given in the table below where is ? ?
the number of units produced
Y (Manufacturing Cost in
$ per unit)
The US department of Energy has provided the following data explaining how the Fuel Economy (mpg)
changes against the speed (mph) of a medium sized car.
Speed (mph) (x) Fuel Economy (mpg) (y)
The following table shows the profit from the sale of public address systems and the number of units
produced. Here is the number of units produced and is the profit in $.? ?
Units Produced Profit
The state is trying to build a rectangular picnic area with one of the longer sides bordering a lake.
Fencing is needed for the three sides not bordering the lake. Let (in feet) be the width (shorter side) ?
of the picnic area and let (in feet) be the area of the picnic area. The final goal of this project is to find ?
the dimensions which will maximize the area if the state has only budgeted only $6000 to buy the
fencing at $10 per linear foot
A small college currently is trying to increase the tuition. It realizes from historic data that a $10 increase
in the tuition rate per credit hour will result in 100 fewer credit hours taken by students each semester.
The current tuition is $400 per credit hour. The school has 2000 students and a total 24000 credit hours
are taken each semester.
Let the revenue per semester in US$ by and let , be the number of $10 increments of the tuition ? ?
Suppose you owe $800 on your credit card and decide to pay only the minimum payment each month.
The balance $ that you will have after months is given by the equation ? ?
The following table shows how the average price of a house located in Northeastern United States
changed during the period 1987-1995. Let be the number of years after 1987 and y be the average ?
price in tens of thousands of dollars
Cost of a
An owner of a barbecue grill store has found out at a price per grill, grills can be ?(?) = 150 ―?/4 ?
sold for a week. Let in dollars be the weekly revenue that the store will obtain if the weekly demand is ?
Scenario 10 (Adapted College Algebra with Applications for Business and Life Sciences, 2e)
A company that produces calculators estimates that the profits (in dollars) from selling a particular ?
model of calculator was:
?= ―152?3 + 7545?2 ―169625 0 ≤?≤45
Where was the advertising expense (in tens of thousands of dollars)?
In 2001, adjustable rate mortgages (ARMs) were offered at different rates at different times of the year.
Let be the month of the year ( being January) and let interest rate (percent) for that month. ? ?= 1 ?
Then can be written as a function of as:? ?
?= 0.0008?4 ―0.0208?3 + 0.177?2 ―0.6705?+ 7.2331
Scenario 12 (College algebra with applications for business and life sciences 2e page 281)
When selling a certain commodity, the profit obtained depends on the advertising cost.
The following equation shows how the profit (in US $) varies with the advertising cost (in tens of ? ?
thousands of US$) when selling a certain sports equipment
?= ―141?3 + 5358?2 ―76560 0 ≤?≤35
The task for Part 1 asks students to set up functions based on the raw data provided in scenarios 1, 2, 3, 4, and 8. The results should be completed in a Microsoft Excel spreadsheet file, with each sheet containing one scenario (in all, there should be 5 sheets within the same excel file). All 5 sheets should include data tables, scatter plots with labeled axes, best fit graphs, and equations.
Please perform the following tasks for each of the scenarios 1, 2, 3, 4, and 8.
- Create a spreadsheet file, and name it “Track A Part One_Last Name_First Name” (e.g., Track A Part One_Roberts_Mike). Rename the sheet1 as Scenario1.
- Insert the data table in the Scenario1 sheet.
- Create a scatter plot from the data.
- Using the scatter plot, determine the polynomial type that should best fit the data.
- Fit the polynomial curve decided upon in the previous step, and display the equation in the spreadsheet itself.
- Add sheet2 by clicking the plus button, then rename the sheet2 as Scenario2. Repeat the last 4 steps for each scenario.
The task for Part 2 asks students to model equations based on the descriptions/from concepts in scenarios 5, 6, and 9. Download the “Assessment Form” below. Name your file “Track A Part Two_Last Name_First Name” (e.g., Track A Part Two_Roberts_Mike).