Please find attached. it has all information you need to solve the problem.

Rusty Redlow has always independently managed his personal investment portfolio. After a 25year career as a chemical engineer with a large chemical company, Rusty retired and on January 1, 2014, opened an investment advisory business incorporated as R&R Financial Planning LLC. Rusty was eager to share his knowledge and investing experience with people in similar positions to himself; that is, those who have recently retired. Also, Rusty has discovered there is an unmet need for financial-planning advice for people living in rural areas. Through his parents, Rusty has learned that there are many seniors who cannot, or prefer not to, drive to larger cities for financial-planning help. Therefore, unlike other financial-planning firms, Rusty drives to his sometimes-remote rural clients who can be many kilometres from his home. The first year of operations of Rusty's company was very successful, and he quickly built his client list to 35 (which is the maximum he plans to serve). However, despite this success, his firm lost several thousand dollars last year. Prior to offering his services, Rusty had investigated client fee structures of several other firms. He discovered that some firms charge clients based on a percent of the amount of client investment dollars under management, some combine a fixed annual fee with a smaller percent of client investment amounts, and others charge an hourly fee. Rusty decided to charge clients a fixed fee for the first year. Because of an operating loss in 2014, however, Rusty is looking for help to analyze his financial results and is seeking advice on how much to charge clients in 2015. In his first year of operations, he found some clients require very little time while others call frequently and demand visits and monthly hard copies of statements. (Many older clients do not have Internet or email access and prefer face-to-face meetings.) Therefore, Rusty is considering a fee structure not currently being used in the industry; specifically, he would like to charge an annual fixed fee combined with a variable portion based on time spent on each client account (information he has carefully tracked during the first year). He believes this would better reflect the cost to service the various clients. Because most clients are in rural areas, on average, more than 90% of Randy's time is spent driving to and from the client. The firm employs an assistant to help with administrative responsibilities, and this person works 20 hours per week out of Rusty's home office. Rusty also contracted with another local person to help once a month with the preparation and mailing of a monthly investment news and portfolio update. The following sets out the operating results of R&R Financial Planning for 2014. Cost categories: Financial planner salary (Rusty Redlow) Assistant salary (extra quarter-end help) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec $4,50 0 $4,50 0 $4,50 0 $4,50 0 $4,50 0 $4,50 0 $4,50 0 $4,50 0 $4,50 0 $4,50 0 $4,50 0 950 950 950 950 950 950 950 950 950 950 950 950 Internet subscription Bloomberg monthly data feed 135 220 135 220 135 220 135 220 135 220 135 220 135 220 135 220 135 220 135 220 135 220 135 220 Depreciation (office equipment) Depreciation (car) Car - road side assist., Mtce and Gas Supplies Insurance Portfolio information and mailing Utilities 80 380 80 380 80 380 80 380 80 380 80 380 80 380 80 380 80 380 80 380 80 380 80 380 308 644 102 36 145 190 505 102 29 120 185 500 102 14 110 210 551 102 22 125 170 514 102 18 112 55 440 102 8 92 59 475 102 13 104 120 500 102 12 111 155 500 102 14 119 214 540 102 29 131 168 500 102 12 110 168 480 102 15 116 $7,50 0 $7,21 1 $7,17 6 $7,27 5 $7,18 1 $6,96 2 $7,01 8 $7,11 0 $7,15 5 $7,28 1 $7,15 7 254 148 142 149 109 19 21 55 85 151 105 Total Hours with clients (includes driving time) Required: Determine the independent variable and use the 2014 data above to determine which costs are variable (V), mixed (M), or fixed (F). (3) Use the high-low method to separate fixed costs per month and the variable costs. (6) Recommend a fee structure for Rusty, assuming his goal is to break even (including Rusty's annual salary). The fee should include a fixed cost per client based on the stated maximum of 35 clients and a variable portion. (3) If Rusty were to record odometer readings when visiting clients, could this data be used to improve the variable charge rate? Would this change the classification of any of the cost categories? (3) $4,500 $7,146 110