Question: hi please help. i just need step by step instructions on how to make the graph for part b on this excel sheet this is

hi please help. i just need step by step instructions on how to make the graph for part b on this excel sheet

hi please help. i just need step by step

this is the original question, with b requesting the graph

hi please help. i just need step by step

A B D E TI G H 1 Problem 6 2 3 a. cost of each plan 4 5 Plan a: $20 +$.45(120)+$.20(40) = 6 Plan b 7 Planc 8 9 b. use a line plot 10 c. 11 Plan a: $20+$.45(120) = 12 plan b 13 Plan c up to 200 minutes 14 Plan cover 200 minutes 15 Collecting terms for Plan C to solve for D 16 17 which plan is better 18 19 d. Given 20 Plan A cost for Daytime and Evening Minutes: $20 +$.45D=$.20E 21 Plan B cost for Daytime and Evening Minutes: $20 +$.55D=$.15E 22 23 Set equations and solving for D 24 25 which plan is best based on what type of hours are used. 26 6. A real estate agent is considering changing her land line phone plan. There are three plans to choose from, all of which involve a monthly service charge of $20. Plan A has a cost of $.45 a minute for daytime calls and $.20 a minute for evening calls. Plan B has a charge of $.55 a minute for daytime calls and $.15 a minute for evening calls. Plan C has a flat rate of $80 with 200 minutes of calls allowed per month and a charge of $.40 per minute beyond that, day or evening. a. Determine the total charge under each plan for this case: 120 minutes of day calls and 40 minutes of evening calls in a month. b. Prepare a graph that shows total monthly cost for each plan versus daytime call minutes. c. If the agent will use the service for daytime calls, over what range of call minutes will each plan be optimal? d. Suppose that the agent expects both daytime and evening calls. At what point (i.e., percentage of call minutes for daytime calls) would she be indifferent between plans A and B

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!