Select one of the options below and create a linear equation to represent the monthly bill for each Plan A and Plan B, you will have two equations, one for each plan. Find the common number of minutes at which both Plan A and Plan B cost the same amount. This number of minutes is called the break-even point. Which plan costs more before the break-even point and which cost more after the break-even point.
Option 1: Plan A $39.99 for 200 min and $1.25 for each min after. Plan B $29.99 for 200 min and $1.50 for each min after.
Option 2: Plan A $25.75 plus $.75 per min. Plan B $20.99 plus $1.00 per min
Option 3: Plan A $39.99 plus $1.25 per min. Plan B $25.99 plus $1.75 per min
Option 4: Plan A $45.99 for 400 min and $.50 for each min after. Plan B $49.99 for 400 min and $.40 for each min after
A Microsoft Excel spreadsheet is required.
SAMPLE SOLUTION
WE WRITE PAPERS FOR STUDENTS
Tell us about your assignment and we will find the best writer for your project.
Write My Essay For MeFor this option, the monthly bill for plan A is set at $ 25.75 plus $ 0.75 per min. Plan B on the other hand is set at $ 20.99 plus $ 1.00 per minute.
Taking the number of minutes to be x and the total cost of talking to be y, the entire talk time using plan A will be given as
Total cost (y1) = 0.75x + 25.75; it is important to underscore the fact that $ 25.75 is a flat cost and so cannot be multiplied by x. In the second plan B, a similar equation can be obtained as
Total cost (y2) = x + 20.99
At the point where the two plans have to cost the same can be obtained if y1 = y2.
Therefore, equating the two equations can be given as follows:
0.75x +25.75 = x + 20.99.
= 0.75x – x = 20.99 – 25.75
-0.25x = – 4.76 and x= 19.04.
This implies that the two plans will have similar costs when one opts to talk for 19.04 minutes after the allowable talk time which is not indicated. Furthermore, up to the 19.04-minute….



