1. Determine the independent variable and use the 2020 data above to determine which costs are variable (V), mixed (M), or fixed (F).
2. Use the highlow method to separate fixed costs per month and the variable costs.

Mini Case 2 - Chpt 3 W21 - Word sign Layout References Mailings Review View Help Ginger Tell me what you want to do 12 A , . AaBbCeDd AaBbCcDd AaBb C 1 Normal 1 No Spac... Heading 1 abe -X2 x? A aby - A 21 Font 15 Paragraph Styles Rusty Redlow has always independently managed his personal investment portfolio. After a 25- year career as a chemical engineer with a large chemical company, Rusty retired and on January 1, 2018, 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 well liked by clients, and he quickly built his client list to 35 (which is the maximum he plans to serve). However, despite success in attracting clients, his firm is losing several thousands of dollars each 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 percentage of the dollar amount invested by the client, some combine a fixed annual fee with a smaller percent of client investment amounts, and others charge an hourly fee only. Rusty wanted to keep it simple for his clients and decided to charge only a fixed monthly fee for each client in the first two years. However, because of an operating loss again in 2020, Rusty is looking for help form you to analyze his financial results and is seeking advice on how structure (i.e. fixed versus variable) client fees in 2021. Over the past few years of operations he has found that some clients require very little time, while others call frequently and demand regular 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 by him and his assistant on each client account (information he has been carefully tracking). He believes this would better reflect the costs incurred to service his 35 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 is the operating results of R&R Financial Planning for the past full year of 2020. Canada) Mini Case 2 - Chpt 3 W21 - Word esign Layout References Mailings Review View Help Ginger Tell me what you want to do 12 U - . abe AaBbCcDd AaBbCeDd AaBb 1 Normal 1 No Spac... Heading - X2 x? A aly. A - 21 Font Paragraph 1 Styles Cost categories: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Financial planner salary (Rusty Bediew) $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 Assistant salary (extra quarter-end help) 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 - Internet subscription 140 140 140 140 140 140 140 140 140 140 140 140 Bloomberg monthly date feed 115 115 115 115 115 115 115 115 115 115 115 115 Depreciation (office equipment) 75 75 75 75 75 75 75 75 75 75 75 75 Depreciation (car) 385 385 385 385 385 385 385 385 385 385 385 385 Car-road side assist., Mtce and Gas 387 240 232 265 215 70 75 152 196 270 211 211 Supplies 676 530 525 579 540 462 499 525 525 567 525 504 Insurance 98 98 98 98 98 98 98 98 98 98 98 98 Portfolio information and mailing 38 30 15 23 19 8 14 13 15 30 13 16 Utilities 152 $8,416 126 $8,089 116 $8,051 131 $8,161 118 $8,055 97 109 $7,800 $7,860 117 $7,970 125 $8,024 13.8 $8,168 116 $8,028 122 $8,016 Total 239 151 145 Hours with clients (includes driving time) 152 111 20 21 56 87 154 107 112 Required: 1. Determine the independent variable and use the 2020 data above to determine which costs are variable (V), mixed.(M), or fixed (F). 2. Use the high-low method to separate fixed costs per month and the variable costs. 3. Recommend to Rusty a fee structure for the rest of the year (2021), assuming his goal is to Canada) PISCHE End Mini Case 2 - Chpt 3 W21 - Word sign Layout References Mailings Review View Help Ginger Tell me what you want to do 12 A , . AaBbCeDd AaBbCcDd AaBb C 1 Normal 1 No Spac... Heading 1 abe -X2 x? A aby - A 21 Font 15 Paragraph Styles Rusty Redlow has always independently managed his personal investment portfolio. After a 25- year career as a chemical engineer with a large chemical company, Rusty retired and on January 1, 2018, 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 well liked by clients, and he quickly built his client list to 35 (which is the maximum he plans to serve). However, despite success in attracting clients, his firm is losing several thousands of dollars each 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 percentage of the dollar amount invested by the client, some combine a fixed annual fee with a smaller percent of client investment amounts, and others charge an hourly fee only. Rusty wanted to keep it simple for his clients and decided to charge only a fixed monthly fee for each client in the first two years. However, because of an operating loss again in 2020, Rusty is looking for help form you to analyze his financial results and is seeking advice on how structure (i.e. fixed versus variable) client fees in 2021. Over the past few years of operations he has found that some clients require very little time, while others call frequently and demand regular 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 by him and his assistant on each client account (information he has been carefully tracking). He believes this would better reflect the costs incurred to service his 35 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 is the operating results of R&R Financial Planning for the past full year of 2020. Canada) Mini Case 2 - Chpt 3 W21 - Word esign Layout References Mailings Review View Help Ginger Tell me what you want to do 12 U - . abe AaBbCcDd AaBbCeDd AaBb 1 Normal 1 No Spac... Heading - X2 x? A aly. A - 21 Font Paragraph 1 Styles Cost categories: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Financial planner salary (Rusty Bediew) $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 Assistant salary (extra quarter-end help) 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 - Internet subscription 140 140 140 140 140 140 140 140 140 140 140 140 Bloomberg monthly date feed 115 115 115 115 115 115 115 115 115 115 115 115 Depreciation (office equipment) 75 75 75 75 75 75 75 75 75 75 75 75 Depreciation (car) 385 385 385 385 385 385 385 385 385 385 385 385 Car-road side assist., Mtce and Gas 387 240 232 265 215 70 75 152 196 270 211 211 Supplies 676 530 525 579 540 462 499 525 525 567 525 504 Insurance 98 98 98 98 98 98 98 98 98 98 98 98 Portfolio information and mailing 38 30 15 23 19 8 14 13 15 30 13 16 Utilities 152 $8,416 126 $8,089 116 $8,051 131 $8,161 118 $8,055 97 109 $7,800 $7,860 117 $7,970 125 $8,024 13.8 $8,168 116 $8,028 122 $8,016 Total 239 151 145 Hours with clients (includes driving time) 152 111 20 21 56 87 154 107 112 Required: 1. Determine the independent variable and use the 2020 data above to determine which costs are variable (V), mixed.(M), or fixed (F). 2. Use the high-low method to separate fixed costs per month and the variable costs. 3. Recommend to Rusty a fee structure for the rest of the year (2021), assuming his goal is to Canada) PISCHE End