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?

Reviews

Write a Review

Finance Basics Questions & Answers

  What was the firm cash flow to creditors during 2010

The 2010 income statement showed an interest expense of $118,000. What was the firm's cash flow to creditors during 2010?

  Explain what happens to expected return as beta increases

Financial researchers at Smith Sharon, an investment bank, esti- mate the current security market line as E(Ri) = 4.5 + 6.8(?i).

  Which one of the following will increase a bid price

Which one of the following will increase a bid price?

  Calculate the net cash flow from financing activities

A company reported $ 24000 of net income. in addition, dividends paid were $ 4000, accounts payable increased by $ 4000, accounts receivable decreased $ 3000, inventory increased by $ 6500, land was purchased for $ 21800, and depreciation expense ..

  Global finance-optimal financing-investment strategy

Employ foreign exchange and cost of capital data to determine appropriate capital sources. Please describe why and how you came to these conclusions. Also make sure to site sources.

  Finding the effective interest rate

Mime Theatrical Supply is in the process of negotiating a line of credit with two local banks. The prime rate is currently 8 percent. The terms follow: Calculate the effective interest rate of both banks.

  Should the firm undertake this project

If the tax rate is 35% and XYZ uses a capital structure of 30% debt and 70% equity. Should the firm undertake this project?

  How much did christina pay

Christina policy covered the medically necessary service performed in a nursing home setting. her total bill was $125,765. how much of Christina expenses was paid by her insurance policy? how much did Christina pay?

  Calculate the expected rate of return on investments

a. Calculate the expected rate of return on investments X and Y using the most recent year’s data. b. Assuming that the two investments are equally risky, which one should Douglas recommend? Why?

  What is the american quote based on this information

Assume a pair of Nike athletic shoes costs $95.00 (USD), but since you are a Japanese consumer, you can purchase it for 9,690 Yen. What is the American quote based on this information?

  Computation of firm''s weighted average cost

Computation of firm's weighted average cost of capital considering marginal tax rate and what is the firm's weighted average cost of capital.

  What is the most you are willing to pay as a lump

Atlas Insurance wants to sell you an annuity, which will pay you $3,200 per quarter for 25 years. You want to earn a minimum rate of return of 6.5 percent. What is the most you are willing to pay as a lump sum today to buy this annuity? please sho..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd