Please submit your answer in an excel format and include, Ask an Expert

Management Studies

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.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M91985675

Have any Question?Write your Review or question?

Related Questions in Operation Management

Ldquocompany policy states that personnel are not to

“Company policy states that personnel are not to conduct business using mobile communications while driving,” David Finch reminds you. He’s a partner at the law firm Wilkes Artis in Washington, D. C., where you work as h ...

Atcs provides training for future air traffic controllers

ATCS provides training for future air traffic controllers. One of the skills air traffic controllers need is the ability to sequence aircraft for landing purposes. The controller decides who lands immediately and who goe ...

1 as discussed in the case amazon prime has been a

1. As discussed in the case, Amazon Prime has been a successful service for Amazon. Thoroughly discuss all aspects of the marketing mix as it relates to this service. 2. How do politics play a role in global procurement? ...

Diversity management is defined as ldquothe strategy of

Diversity management is defined as “the strategy of using best practices with proven results to find and create a diverse and inclusive workplace”. (Diversity 101) The three best practices that I chose are employee resou ...

The article as a synopsis is about crisis management though

The article as a synopsis is about crisis management. Though to go a bit further, it is also not only about managing a crisis, but attempting to plan as well as possible to avoid crisis. You cannot plan for everything, s ...

1 at first glance is the strategy change cycle an approach

1. At first glance, is the Strategy Change Cycle an approach that you would likely suggest if tasked with formatting a strategic plan process? If so, what aspects make it appealing? If not, what are some of the key short ...

1 if pricelinecom increases its advertising expenses by 30

1. If Priceline.com increases its advertising expenses by 30 percent while keeping its price and variable costs the same, does that mean the company’s breakeven point will increase 30 percent? Show this calculation for a ...

1 what is the significant benefit to the employees of us

1. What is the significant benefit to the employees of US Airways, after the merger with American Airlines? 2. How important is branding and is it necessary to protect it? 3. The correlation coefficient between a selecti ...

Karen maxwell a paralegal had had enough with her co-worker

Karen Maxwell, a paralegal, had had enough with her co-worker, Rich Sleazebag! At this year’s holiday party, Rich came on to Karen by making suggestive comments and inappropriately touching her lower back and leg. Rich’s ...

Module overviewthe real value of a dollar in your hand

Module Overview The real value of a dollar in your hand today is much more than what you will earn after a year. Why is it so? It is the value of time. Imagine you won a cash prize worth $50,000 and you can choose to rec ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert