Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A B C D E Avg. Monthly Profit Avg. Monthy Expense Avg. Monthly Deficit 531,470 $43,400 $11,930 Current Avg. Monthly Subscribers Avg. Price per Subscriber

image text in transcribedimage text in transcribedimage text in transcribed
A B C D E Avg. Monthly Profit Avg. Monthy Expense Avg. Monthly Deficit 531,470 $43,400 $11,930 Current Avg. Monthly Subscribers Avg. Price per Subscriber 332 $37.82 Breakeven Point Option 1 Employee Count: 550 Monthy Fee: $17 10%/Mo. Visit Rate: 50 Tota $9,350.00 $3,300.00 $12,650.00 Breakeven Point Option 2 Employee Count: 220 Monthy Fee: $55 $12,100.00 Breakeven Point Option 3 (Mix) Employee Count: 400 Monthy Fee: $17 10%/Mo. Visit Rate: 40 Sub Total 56,800.00 $2,400.00 $9,200.00 plus Employee Count: 100 Monthy Fee: $55 Monthly Visit Fee: $0 Sub Total 2750 SO $2,750 Total $11,950.00Employee's Enrolled - 2023 Estimates Company Effective Date Jan Feb. March April May July Total Amount Paid - 2021 Company 1 Aug. Sept. Oct. Nov. Dec. Average 2015 5 Jan. Feb. March April 5 May 5 June 5 July Aug. Sept. Company 2 S 325.00 325.00 $ Oct. Nov 5/1/2021 9 Dec. 9 9 325.00 9 S 325.00 Total 325.00 5 325.00 Company 3 S $ 325.00 5 325.00 325.00 S 2015 106 325.00 S 110 325.00 108 325.00 110 108 585.00 110 585.00 585.00 520.00 5 $ 3,900.00 105 108 108 585.00 Company 4 108 585.00 455.00 585.00 2015 59 108 108 585.00 5 58 56 55 108 585.00 585.00 585.00 58 $ 5,830.00 57 $ 5,940.00 |$ 5,775.00 5,825.00 58 60 $ 6,050.00 5 5,940.00 5 6,050.00 Company 5 57 57 57 57 2/1/2022 425 431 57 $ 6,050.00 $ 5,940.00 5 5,940.00 $ 5,940.00 |$ 5,940.00 425 417 422 433 $ 5,940.00 436 425 425 425 425 425 426 $ 3,245.00 $ 3,190.00 $ 3,080.00 $ 3,025.00 $ 3,190.00 $ 3,190.00 $ 3,300.00 5 3,135.00 $ 3,135.00 $ 3,135.00 $ 3,135.00 $ 71,335.00 Company 6 2/1/2022 30 56 33 27 39 37 30 34 34 $ 5,312.50 5 5,387.50 $ 5,312.50 $ 5,212.50 |$ 5,275.00 $ 5,412.50 | $ 5,450.00 s 3,135.00 $ 37,895.00 Company 7 5/1/2020 6 35 $ 5,312.50 5 5,312.50 $ 5,312.50 |$ 5,312.50 |$ 5,312.50 |$ 63,925.00 $ 1,800.00 5 3,360.00 $ 1,980.00 $ 1,620.00 $ 2,340.00 $ 2,220.00 5 1,800.00 5 2,040.00 $ 2,040.00 $ 2,040.00 $ 2,040.00 $ 2,040.00 $ 25,320.00 Company s 1/1/2021 9 9 Company 9 $ 390.00 5 455.00 5 455.00 5 390.00 5 390.00 5 325.00 5 325.00 5 390.00 5 390.00 5 390.00 5 390.00 5 7/7/1905 2 2 2 2 2 2 $ 585.00 390.00 5 4,680.00 2 585.00 5 2015 11 11 12 2 520.00 $ 520.00 Company 10 520.00 5 520.00 5 520.00 520.00 5 520.00 5 12 11 520.00 11 520.00 5 520.00 11 5,370.00 Company 1 11 11 11 11 2015 26 27 27 11 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 29 28 11 26 26 27 27 $ 715.00 5 715.00 130.00 $ 130.00 $ 1,560.00 Company 17 27 2/1/2019 27 6 6 27 780.00 5 780.00 5 715.00 5 6 27 715.00 $ 715.00 5 715.00 5 715.00 5 715.00 5 715.00 5 715.00 $ 6,710.00 Company 13 7 2015 12 9 9 20 12 12 S $ 1,690.00 5 1,755.00 $ 1,755.00 $ 1,885.00 5 1,820.00 $ 1,690.00 |$ 1,690.00 |$ 1,755.00 $ 1,755.00 $ 1,755.00 $ 1,755.00 $ 1,755.00 5 21,060.00 Company 14 12 12 3 12 5/1/2019 12 2 12 390.00 5 390.00 5 390.00 5 390.00 5 520.00 5 520.00 5 520.00 5 455.00 $ 455.00 5 455.00 5 455.00 5 2 2 2 455.00 5 5,395.00 Company 15 2 1/1/2016 1 2 S 195.00 5 195.00 5 5 476.00 5 816.00 5 612.00 5 612.00 5 1,360.00 5 816.00 5 816.00 5 816.00 5 816.00 5 816.00 5 816.00 5 816.00 5 9,585.00 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 Company 16 4/1/2021 12 130.00 $ 130.00 $ 130.00 5 130.00 5 11 11 12 10 11 S 130.00 5 1,690.00 Company 17 12 65.00 5 11 11 11 65.00 65.00 5 65.00 S 65.00 5 65.00 5 65.00 5 65.00 2019 13 11 12 11 $ 780.00 5 715.00 5 715.00 5 780.00 5 650.00 5 65.00 5 13 11 65.00 5 12 12 65.00 5 12 65.00 780.00 Company 18 11 12 12 6/1/2018 20 22 12 25 12 25 26 12 715.00 5 780.00 5 715.00 5 715.00 $ 715.00 $ 715.00 5 715.00 5 8,710.00 26 26 Company 19 24 24 7 24 24 24 5 845.00 5 780.00 5 845.00 5 780.00 5 780.00 5 780.00 5 715.00 5 780.00 5 780.00 5 780.00 5 780.00 5 11/1/2016 6 24 6 780.00 5 9,425.00 Company 20 $ 1,300.00 5 1,430.00 $ 1,625.00 $ 1,625.00 5 1,690.00 |$ 1,690.00 5 1,690.00 5 1,560.00 $ 1,560.00 $ 1,560.00 $ 1,560.00 |$ 1,560.00 |$ 18,850.00 4/1/2020 1 5 585.00 5 455.00 5 455.00 $ 390.00 5 390.00 5 390.00 5 Company 21 11/1/2016 5 S 65.00 5 65.00 5 65.00 5 390.00 5 455.00 5 455.00 5 455.00 5 65.00 5 65.00 5 65.00 5 455.00 5 455.00 5 5,330.00 Company 22 65.00 5 1/1/2020 6 65.00 5 65.00 5 65.00 5 65.00 5 65.00 5 5 260.00 5 260.00 5 325.00 5 390.00 5 455.00 5 455.00 5 455.00 5 390.00 5 390.00 5 390.00 5 390.00 5 390.00 5 4,550.00 780.00 Company 23 2 2 N 2015 10 10 2 10 9 9 Company 24 10 10 10 10 10 $ 195.00 5 260.00 5 260.00 5 195.00 5 65.00 5 6/1/2019 14 10 10 10 10 10 10 10 65.00 5 260.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 1,950.00 Company 25 11 11 2 11 11 2022 2 11 11 $ 650.00 5 650.00 5 650.00 5 585.00 5 585.00 5 585.00 5 520.00 5 650.00 5 650.00 5 650.00 5 650.00 5 650.00 5 7,475.00 Company 26 $ 910.00 5 650.00 5 650.00 5 650.00 5 650.00 5 650.00 5 650.00 5 715.00 5 715.00 5 715.00 5 715.00 5 715.00 5 8,385.00 3/1/2019 21 2 15 15 16 18 17 15 17 17 Company 27 7 17 17 7 17 7 $ 1,365.00 5 975.00 5 5 130.00 5 130.00 5 130.00 $ 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 1,560.00 2015 Company 28 11 Employee's Enrolle 975.00 $ 1,040.00 $ 1,170.00 $ 1,105.00 5 975.00 $ 1,105.00 $ 1,105.00 $ 1,105.00 |$ 1,105.00 | $ 1,105.00|$ 13,130.00 8/1/2021 11 10 10 11 11 12 12 TotalAmount Paid 10 10 455.00 5 455.00 5 10 10 10 455.00 5 455.00 5 455.00 5 455.00 5 520.00 5 455.00 5 Company 29 2015 2 11 $715.00 5 650.00 5 650.00 5 715.00 5 715.00 5 455.00 5 455.00 5 455.00 455.00 5 5,525.00 IN ! 780.00 5 780.00 5 Company 30 650.00 5 2015 16 17 17 650.00 5 650.00 5 650.00 17 17 16 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 130.00 5 1,560.00 650.00 5 8,255.00 17 17 17 Total 850 881 849 837 865 862 863 853 853 853 853 853 832 $ 1,040.00 | $ 1,105.00 | $ 1,105.00 | $ 1,105.00 | $ 1,105.00 | $ 1,105.00 5 1,040.00 | $ 1,105.00 $ 1,105.00 $ 1,105.00 | $ 1,105.00 | $ 1,105.00 | $ 13,130.00 $ 31 158.50 $ 32,713.50 $ 31 094.50 $ 30,754.50 $ 32,275.00|$ 31 518.50|$ 31 391.00|$ 31,348.50|$ 31 348.50|$ 31 348.50|$ 31 348.50|$31,348.50|$ 377,648.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Enterprise Risk Management

Authors: Rick Nason, Leslie Fleming

1st Edition

1947098365, 978-1947098367

More Books

Students also viewed these General Management questions

Question

How do childhood experiences affect self-esteem?

Answered: 1 week ago

Question

What does stickiest refer to in regard to social media

Answered: 1 week ago

Question

Define broadbanding. What is the purpose of using broadbanding?

Answered: 1 week ago

Question

Distinguish between merit pay, bonus, spot bonuses, and piecework.

Answered: 1 week ago