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

  Create a culture for quality and performance excellence

Explain what knowledge, experience, and/or skills you possess that will help you create a culture for quality and performance excellence. Explain what knowledge, experience, and/or skills you need to develop in order to be better able to create a cul..

  Hypothetical-consolidate and goal seek

Which of following analysis tool you should use to quickly and easily find the value for a missing ONE variable in excel? 1 what if, 2.one way table 3.Hypothetical, 4. consolidate 5. goal seek

  What is berkshire partners'' corporate strategy

What is Berkshire Partners' corporate strategy. Is their organizational design aligned with their current strategy? Do they have a corporate advantage relative to other private equity firms

  Require employers to pay their employees while on leave

Currently the FMLA does not require employers to pay their employees while on leave. There is interest in many states and municipalities to require employers to pay employees while on family and medical leave. Take a position whether you want to see ..

  Formulate an integer programming model

2 new fire stations are to be located in a city and the major of the city wants to decide where to locate the 2 fire stations. For planning purposes, the region has been divided into five tracts.

  What are your strengths and weaknesses of business

What are your strengths and weaknesses as it relates to your business. How can you impact, influence others and your organization to deliver the results you expect

  Considering the use of a new predictor

Your boss is considering the use of a new predictor. The base rate is high, the selection ratio is low, and the validity coefficient is high for the current predictor. What would you advise your boss and why?

  Elucidate what is the recommended production rate

Elucidate what is the recommended production rate if a level strategy is adopted with no backorders or stock counts. Elucidate what is the ending inventory for month 4 under this plan.

  When positioned in specific business functions

ISs contribute to both the effectiveness and efficiency of businesses, especially when positioned in specific business functions, such as ____, finance, and engineering.

  Effective annual interest rate

What is your effective annual interest rate (an opportunity cost) on the revolving credit arrangement if your firm does not use it during the year?

  Empowerment is earned-it is not a right

"Empowerment is earned-it is not a right" and "empowerment must have limits - all empowerment involves appropriate checks and balances" Express your views on these statements, then link the support of our views to how quality is defined and to the Ka..

  Explain how do organizational structures influence

dq 1. how do organizational structures affect organizational functions? how does your organizations structure affect

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