Use excel to determine the number of each type of person

Assignment Help Finance Basics

Reference no: EM13294962

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.

Reference no: EM13294962

Questions Cloud

How well did your hedge perform : Assume that interest rates in general increase by 200 basis points. How well did your hedge perform? c. What is a perfect hedge? Are any real-world hedges perfect? Explain.

How many different integers can be represented in binary : A computerrepresents information in groups of 32 bits. How many different integers can be represented in (a) binary, (b) BCD, and (c) 8-bit ASCII, all using 32bits

What is the minimum pulling force : The drawing shows a circus clown who weighs 950 N. What is the minimum pulling force that the clown must exert to yank his feet out from under himself

Describe complete ionic equation and net ionic equation : For the following reactants, predict the products formed (if any) and write the balanced molecular equation, complete ionic equation and net ionic equation. NaHSO3(aq)+HI(aq)

Use excel to determine the number of each type of person : 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.

Determine how much energy is extracted from an electron : How much energy is extracted from an electron as it flows through a 9V battery from the positive to the negative terminal

Explain how to find the perfect square : Explain how to find the perfect square of 329476 without using a calculator, step by step.

Determine the tension in each cable attached to its ends : The steel I-beam in the drawing has a weight of 8.39 × 103 N, What is the tension in each cable attached to its ends

Would the future value larger or smaller : Would the future value larger or smaller if the compounded period was six month? How much more or less would they have earned with this shorter compounded period?

User Account

All Pages