Top-class security agency wants to schedule its security

Assignment Help Accounting Basics
Reference no: EM13590688

Top-Class Security Agency wants to schedule its security personnel who work either 8-hour shifts or 4-hour shifts. They work 8-hours nonstop or 4-hour nonstop without a break. The personnel who work 8-hour shifts are Officers: they are former FBI or Military personnel and are paid higher wages at $30/hour or $240 per 8-hour day. The personnel who work 4-hour shifts do not have higher level skills of those with the FBI or Military background and thus are paid $20/hour or $80 per 4-hour shift. For any given day, the number of security workers required varies depending on the time of the day. The staffing guidelines require the following minimum number of security personnel including Officers are as shown below.

The beginning time for the shifts is :

The staffing guidelines has an additional restriction at any given time, there must be at least one Officer for every two non-officer type security personnel.

The objective is to minimize daily personnel cost. Formulate the problem as a Linear Program and solve it using xl Solver.

Q1)Write down the complete Linear Program in algebraic form

Q2)Solve it and provide the answer: Write the optimal solution in plain English.

Q3)Provide a picture copy of the xl screen to fit on one page showing the optimal solution.

Reference no: EM13590688

Questions Cloud

A firm has experienced an increasing currrent ratio but a : a firm has experienced an increasing currrent ratio but a decreasing operating cash flow to current liabilities ratio
One account earned a simple interest rate of 64 and the : 1 an investor placed a total of 14000 in two simple interest accounts. one account earned a simple interest rate of
Morganton company makes one product and it provided the : morganton company makes one product and it provided the following information to help prepare the master budget for its
Prepare a schedule of lease payments for field ltd a : summer ltd entered into an agreement on 1 july 2010 to lease a harvester to field ltd. the lease agreement details are
Top-class security agency wants to schedule its security : top-class security agency wants to schedule its security personnel who work either 8-hour shifts or 4-hour shifts. they
How much additional money should they invest at an annual : an investment club invested 9000 at 7.4 annual simple interest. how much additional money should they invest at an
Palmer corporation issued and has outstanding 20000 shares : palmer corporation issued and has outstanding 20000 shares of 10 par-value common stock and 1000 shares of 60 par-value
A firm makes six types of juice-blends they are a : a firm makes six types of juice-blends. they are a orange-pineapple b orange-pineapple-mango c orange-kiwi-strawberry d
If the preferred stock is cumulative what is the most that : frostbite cold storage company was incorporated early in 2007 since then the following stock has been outstanding

Reviews

Write a Review

Accounting Basics Questions & Answers

  Should the product be processed further

Suppose that a product can be sold at split-off for $5,000 or processed further at a cost of $1,000 and then sold for $6,400. Should the product be processed further?

  Eampk company has a net book value of 220000 the company

eampk company has a net book value of 220000. the company has a 10 cost of capital. the firm expects to have profits of

  Problem regarding to capitalized lease

With respect to this capitalized lease, for 2008 calculate how much Carley should record for both interest expense and depreciation expense.

  Assume research in motion invested 834 million to expand

assume research in motion invested 834 million to expand its manufacturing capacity. assume that these assets have a

  Tamar co manufactures a single product in one department

tamar co. manufactures a single product in one department. all direct materials are added at the beginning of the

  Prepare a table that shows the computation of cash

aztec company sells its product for 180 per unit. its actual and projected sales follow.all sales are on credit. recent

  Problem related to process costing system

Write a brief summary (one paragraph) for each of the three companies that include the name, web site address, and a brief description of its business. Secondly, please discuss the reasons why the company would most likely use a process costing sy..

  Method of verifying accuracy of recorded dividend income

Jones was engaged to examine the financial statements of Gamma Corporation for the year ended June 30, 2002. Having completed an examination of the investment securities, which of the following is the best method of verifying the accuracy of recor..

  Prepare solutions to the construction contracts

Please prepare solutions to the following questions concerning topics covered in the first half of the course

  Perpetual inventory system for multiple debit

Make the journal entries to record the following transactions in Hunt Ltd’s records by using perpetual inventory system.

  Using the statement on auditing standard as your source

using the statement on auditing standard as your source list one standard you think relates directly to gathering audit

  What technique of accounting should web-browser use

What technique of accounting should Web-Browser use to account for its investment in Internet Access at 31 st December, 1998, and June 30, 1999 (i.e., cost or equity method)?

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