Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. exercise problems in microsoft excel, complete t

EXERCISE PROBLEMS In Microsoft Excel, complete the exercises 1. Based on...

70.2K

Verified Solution

Question

Accounting

EXERCISE PROBLEMS

In Microsoft Excel, complete the exercises

1. Based on the following data, calculate the single-factor productivity ratio using hours

of labor for a housekeeping department.

Number of employees = 100

Average hourly rate = $5.50

Total hours worked in September = 15,570

Total square feet maintained = 190,000

2. In the preceding problem, using sensitivity analysis, if the productivity ratio was 13.1

the previous month, has productivity increased or decreased? By what percentage?

3. Assume that a new piece of equipment could allow 25% of the labor force in Question

1 to be eliminated. Using a 173-hour working month for each employee, a total

equipment cost of $60,000 (which has a useful life of 3 years), and ignoring the effect

of cash flow and time value of money, would this be a good use of capital?

4. If a hospital reported the following results, calculate the full-time equivalent

employees per adjusted occupied bed:

image

Inpatient revenues Outpatient revenues Total patient revenues Inpatient days Productive labor hours $129,215,678 44,996,104 $174,211,782 23,926 916,882

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students