Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

This was my first time original question: # Employee's Enrolled - 2023 Estimates Company Effective Date Total Amount Paid - 2021 Jan Feb. March April

This was my first time original question:

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Business Statistics A First Course

Authors: David M. Levine, Kathryn A. Szabat, David F. Stephan

7th Edition

9780321979018

Students also viewed these General Management questions