A janitorial service provides staff to clean buildings, Ask an Expert

Finance

A janitorial service provides staff to clean buildings during late evening hours using workers with two skill levels 1 and 2.

Each level 1 worker is paid $12 per hour
Each level 2 worker is paid $12 per hour

The workers wash floors and vacuum offices.
Each level 1 worker can vacuum 9 offices per hour
Each level 2 worker can vacuum only 2 offices per hour

Each level 1 worker can wash 2 floors per hour
Each level 2 worker can wash 3 floors per hour

In order to complete a new job in time 18 offices must be vacuumed and 12 floors must be washed per hours.

Use excel to determine the number of each type of person that will be needed to complete the job within the allotted time and at minimum cost.

Can someone please walk me thru Excel on this one? Or is there a way to solve this manually? Not too keen on Excel so I can use as much help as possible.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M9874290

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Consider the following information of company a 1 the

Consider the following information of Company A. 1. The pre-tax cost of debt of Company A is 12% 2. Company A is a constant dividend growth firm that just paid a dividend of $2 per ordinary share and has a dividend growt ...

Small fry inc has just invented a potato chip that looks

Small Fry, Inc., has just invented a potato chip that looks and tastes like a french fry. Given the phenomenal market response to this product, Small Fry is reinvesting all of its earnings to expand its operations. Earni ...

Y want to save enough money to retire as a millionairea

You want to save enough money to retire as a millionaire. a. If you could earn 10% with common stocks, how much would you have to set aside per year to have $1,000,000 when you are 65? Please use your own age. b. If you ...

Heliocorpular magnetics is currently valued at 32 per share

Heliocorpular Magnetics is currently valued at 32 per share. They are expected to pay a 3.20 dividend, because the dividend has been growing at 5% per year for the past 8 years. Find the dividend yield, the capital gains ...

Is there a particular capital structure that maximizes the

Is there a particular capital structure that maximizes the value of the firm? Explain.

You make 6000 annual deposits into a retirement account

You make $6,000 annual deposits into a retirement account that pays 10.3 percent interest compounded monthly. How large will your account balance be in 35 years?

Is an institutional client different from an institutional

Is an institutional client different from an institutional investor? If so could you please please give an example of each just so I understand?

Question - pkof considers bidding for a big dredging

Question - PKOF considers bidding for a big dredging project in the port of Lagos. The project would yield annual cash flows of 2.5 billion NGN for the next three years. At the current exchange rate of NGN 125/EUR, this ...

A preferred stock promises to pay 366 in interests every

A preferred stock promises to pay $3.66 in interests every year. The required rate of return is 7.60%. What's the fair price of this preferred stock?

A firm has sales of 1220 net income of 226 net fixed assets

A firm has sales of $1,220, net income of $226, net fixed assets of $544, and current assets of $300. The firm has $101 in inventory. What is the common-size statement value of inventory?

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert