Business, 28.08.2020 14:01 avery8626

Care Clinic is preparing a worksheet for their staff. Their average starting salary is $60,000. Benefits are 25% this year. They expect them to go up to 27% next year. They are expecting to give a raise of 5% next year. Care Clinic has 20 employees. Prepare a formatted Excel Spreadsheet for Care Clinic. How much is the Total Staff Expense

Answers: 2

Show answers

Answers

Answer from: 2023greenlanden

$1,600,200

Explanation:

The total staff expense can be calculated by using the following formula:

Total Staff Expense = (Salary For coming year with increment (STEP1) + Benefits In-Kind) * Total Employees

Here

Salary for Coming Year with Increment is $63,000 (Step1)

Total employees are 20 in Number

Benefits In-Kind per employee is 27% of salary which is $17,010 ($63,000 * 27%)

By putting values, we have:

Total Staff Expense = ($63,000 + $17,010) * 20 Employees

Total Staff Expense = $1,600,200

STEP 1: Find Salary for Coming Year with Increment

Salary for Coming Year with Increment = Average Salary Now * (1 + Increment)

Here

Average Salary is $60,000

Increment is 5%

Salary for Coming Year with Increment = $60,000 *(1 + 5%) = $63,000

EXCEL Formatted Spreadsheet For Care Clinic

Increment Avg. BIK T. Employees Total

5% Salary at 27%

Total Salary 60000 105% 63000- 20 1,260,000

Benefits In-Kind 60000 105% 6300027% 20 340200

1,600,200

Answer from: Quest

i think the answer to your question is b. directive

Answer from: Quest

it's actually a very difficult task, due to not many people can make 2 million dollars in 2 years. besides that, to the not-so-realistic ideas, you can create a business. it could be practically anything, but make it into a business that isn't that known yet, you get me? also, lets not forget about stock market. that's where all the good stuff happens. use investments at the beginning and begin to raise up your business or whatever you're going to do. as this is a very non-realistic idea, it's still worth the shot!

Other questions on the subject: Business

Business, 21.06.2019 20:20, chantelljenkins2

If the demand for a pair of shoes is given by 2p + 5q = 200 and the supply function for it is p − 2q = 10, compare the quantity demanded and the quantity supplied when the price is $90. quantity demanded pairs of shoes quantity supplied pairs of shoes will there be a surplus or shortfall at this price? there will be a surplus. there will be a shortfall.

Answers: 3

continue

Business, 22.06.2019 10:50, lindalu

Choose the statement that is incorrect. a. search activity occurs only in markets where there is a shortage. b. when a price is regulated and there is a shortage, search activity increases. c. the time spent looking for someone with whom to do business is called search activity. d. the opportunity cost of a good is equal to its price plus the value of the search time spent finding the good.

Answers: 3

continue

Business, 22.06.2019 23:50, yatayjenings12

Analyzing operational changes operating results for department b of delta company during 2016 are as follows: sales $540,000 cost of goods sold 378,000 gross profit 162,000 direct expenses 120,000 common expenses 66,000 total expenses 186,000 net loss $(24,000) suppose that department b could increase physical volume of product sold by 10% if it spent an additional $18,000 on advertising while leaving selling prices unchanged. what effect would this have on the department's net income or net loss? (ignore income tax in your calculations.) use a negative sign to indicate a net loss answer; otherwise do not use negative signs with your answers. sales $answer cost of goods sold answer gross profit answer direct expenses answer common expenses answer total expenses answer net income (loss) $answer

Answers: 1

continue

Business, 23.06.2019 00:10, jlang8

The food services division of cedar river amusement park inc. is studying the amount families who visit the amusement park spend per day on food and drink. a sample of 40 families who visited the park yesterday revealed they spent the following amounts: see worksheet 1 for data and answer the following questions: a. organize the data into a frequency distribution, using seven classes and 15 as the lower limit of the first class. what class interval did you select? b. what percent of families spent less than $45? c. what percent of families spent $55 or more? d. how many families spent from $65 to 74.99?

Answers: 3

continue

You know the right answer?

Care Clinic is preparing a worksheet for their staff. Their average starting salary is $60,000. Bene...