Employee works eight hours a day for five straight days

Assignment Help Operation Management
Reference no: EM131229776

Please submit your answer in an Excel format and include text boxes providing a verbal summary of any main conclusions. ----- A post office requires sufficient full and part time people to satisfy the following daily needs for employee hours:

Day M T W R F Sa Su

Hrs.Needed 136 104 120 152 112 128 88

A full time employee works 8 hours a day for five straight days. A part time employee works 4 hours a day for five straight days. Full or part time employees can be hired to begin their five straight days on any day that the post office chooses. Full time employees earn $20/ hour while part time employees earn $15/hour. A union agreement limits the number of part time employees to no more than 25% of the total number of employees. Determine how many full and part time workers should begin their work on each day of the week to satisfy the manpower requirements at minimum cost. Ignore lunch and other breaks. Produce a two way SolverTable to show the minimum cost as the part time wage varies from $10/hour to $20/ hour in increments of $5/hour while the full time wage varies from $15/hour to $25/hour in increments of $5/hour. ---- Please provide a detailed step-by-step description of your proposed solution. please solve this using excel solver.

Reference no: EM131229776

Questions Cloud

Design specifications reflecting customer requirements : Design specifications reflecting customer requirements for a product are known as
Resource ability to generate sustainable competitive : What are the four tests of a resource's ability to generate a sustainable competitive advantage are often referred to as:
Counting the number of defects in the bolts : A textile company monitors its process by counting the number of defects in the bolts of cloth it produces. To establish its control chart limits, a random sample of 20 bolts of cloth was selected and the average number of defect per bolt calculated.
According to the process capability index for this process : A company manufactures a product that has a design (nominal) target width of 5 inches with tolerances of + .05 inch. The process that produces the product has a mean of 4.995 inches and a standard deviation of 0.01 inch. According to the process capa..
Employee works eight hours a day for five straight days : A full time employee works 8 hours a day for five straight days. A part time employee works 4 hours a day for five straight days. Full or part time employees can be hired to begin their five straight days on any day that the post office chooses. Prod..
Identify potential risks and mitigation plans : Identify potential risks and mitigation plans. Analyze a stakeholder and include mitigation and contingency strategies. Develop a metric and target for each strategic objective using a balanced scorecard format.
What is the bonds yield to maturity : The bond has a call provision that allows Regal to call the bond in four years at a call price of $1,060 - What is the bond's yield to maturity?
What are the benefits of emotion in negotiation : Does emotion delay the negotiation process, or prevents parties from reaching an agreement? Why or why not? As a negotiator, what are the benefits of emotion in negotiation?
Disparate impact in a compensation context : Distinguish between disparate treatment and disparate impact in a compensation context.

Reviews

Write a Review

Operation Management Questions & Answers

  Why probability is important-the logical interpretation

Using the video, “Why Probability is Important,” list five reasons to study probability theory. Choose two of these reasons and explain why each is either a compelling reason for you or not a compelling reason for you.  Using the video, “Probability ..

  How would you define morality and ethics

How would you define morality and ethics? Does morality and ethics mean the same, or are they different? If they are different, discuss the differences between them. Also, provide examples to validate your responses.

  Nonlinear programming queuing theory

Bushwood Supermarkets is a major food retailer in the Philadelphia area. The chain has over 60 stores that receive merchandise from their Scranton, Pennsylvania warehouse.

  The critical path and the expected project duration

For each of the following network diagrams, determine both the critical path and the expected project duration. The numbers on the arrows represent expected activity times. Use Excel.

  Determine the critical path

Determine the critical path and the expected project completion time

  Providing deeper insights for business intelligence

Do you think that data mining is useful for providing deeper insights for business intelligence? Provide an example related to your own job environment. Also, what are the possible pitfalls of data mining?

  What must prosecutor prove to establish guilt of keith

While walking on the sidewalk next to Sue’s home, Keith sees a DVD player on a blanket spread out on the lawn near the sidewalk. After looking around to see if anyone can observe his conduct, Keith takes the DVD player back to his home and tells ever..

  Fcfs service which requires an average

a Poisson distribution. The customers are given a FCFS service which requires an average of 2 minutes and follows a Poison distribution. Based on the information above, determine,

  Why is operations management relevant to managers

Why is operations management relevant to managers in other organization functions? Base your discussion on your experience of operations within your organization or an organization with which you are familiar. For example, talk with the operations ma..

  What activities need to be identified and performed right

What procurement-related activities do you anticipate that you will be expected to complete as the project manager for IRTC. What activities need to be identified and performed right now

  Communicable diseases in a city health department

When you get to the office and check your email you learn that the World Health Organization has placed a number of East Asian cities off limits for all but essential travel. You also learn that Canada has reported deaths they believe are due to S..

  Find the optimal order quantity and the reorder point

Ignoring the uncertainty in the demand (i.e. looking only at average values), find the optimal order quantity and the reorder point. What is the annual inventory holding and ordering cost for this policy?

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