EBK OM
EBK OM
6th Edition
ISBN: 9781305888210
Author: Collier
Publisher: YUZU
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 13, Problem 2CQD
Summary Introduction

Interpretation:

Requirement of number of FTE staff in May through August.

Concept Introduction:

FTE is (Full time equivalent) is the number of hours a full time employee works in a stipulated time period. It shows an average hours for work.

Expert Solution & Answer
Check Mark

Explanation of Solution

Variables used to calculate FTE staff are:

  • Month
  • Number of days in a month
  • Average forecast of a month
  • Percentage in product mix

Formula to be used are:

  Hoursrequiredforaproduct-i=Numberoffilesforaproduct-i×hoursperfileforproduct-i

  Numberoffilesforaproduct-i=Mixpercentofproduct-i×aggregateforecastofthemonth.

  (given).

  Totalrequiredhoursforthemonth=

  i=110Hoursrequiredforaproducti

  Numberofemployeesrequired=

  TotalrequiredhoursforthemonthNumberofdays×7

.

For the four-month time horizon, the mix percentages will remain the same as given.

    MonthMay
    Working days22
    Total forecast750
    ProductsProduct Mix (%)No. of filesHours per fileHours
    122165.003.60594.00
    217127.502.00255.00
    31397.501.70165.75
    41290.005.50495.00
    51075.004.00300.00
    6967.503.00202.50
    7752.502.00105.00
    8537.502.0075.00
    9322.501.5033.75
    10215.004.0060.00
    Total1007502286
    Required # of workers15
    MonthJune
    Working days20
    Total forecast825
    ProductsProduct Mix (%)No. of filesHours per fileHours
    122181.503.60653.40
    217140.252.00280.50
    313107.251.70182.33
    41299.005.50544.50
    51082.504.00330.00
    6974.253.00222.75
    7757.752.00115.50
    8541.252.0082.50
    9324.751.5037.13
    10216.504.0066.00
    Total1008252514.6
    Required # of workers18
    MonthJuly
    Working days22
    Total forecast900
    ProductsProduct Mix (%)No. of filesHours per fileHours
    122198.003.60712.80
    217153.002.00306.00
    313117.001.70198.90
    412108.005.50594.00
    51090.004.00360.00
    6981.003.00243.00
    7763.002.00126.00
    8545.002.0090.00
    9327.001.5040.50
    10218.004.0072.00
    Total1009002743.2
    Required # of workers18
    MonthJuly
    Working days22
    Total forecast775
    ProductsProduct Mix (%)No. of filesHours per fileHours
    122170.503.60613.80
    217131.752.00263.50
    313100.751.70171.28
    41293.005.50511.50
    51077.504.00310.00
    6969.753.00209.25
    7754.252.00108.50
    8538.752.0077.50
    9323.251.5034.88
    10215.504.0062.00
    Total1007752362.2
    Required # of workers16

In summary, the FTEs required can be written in the following table:

    MonthFTE
    May15
    Jun18
    Jul18
    Aug16

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
while making reference to the cartesian method demonstrate how being skepital has helped you transcend cultural, societal and social conditioning. Use practical example from your life as a kenya and student at university to demonstrate your answer?
Major League Baseball's World Series is a maximum of seven games, with the winner being the first team to win four games. Assume that the Atlanta Braves and the Minnesota Twins are playing in the World Series and that the first two games are to be played in Atlanta, the next three games at the Twins' ballpark, and the last two games, if necessary, back in Atlanta. Taking into account the projected starting pitchers for each game and the home field advantage, suppose the probabilities of Atlanta winning each game are as follows. Game 1 2 3 4 5 6 7 Probability of Win 0.61 0.56 0.47 0.44 0.47 0.54 0.49 Construct a simulation model in which whether Atlanta wins or loses each game is a random variable. Use the model to answer the following questions. (Use at least 1,000 trials.) (a) What is the average number of games played regardless of winner? (Round your answer to one decimal place.) games (b) What is the probability that the Atlanta Braves win the World Series? (Round your answer to…
Model File Available: Download NBAGIMS.xlsx The Iowa Wolves are scheduled to play against the Maine Red Claws in an upcoming game in the National Basketball Association (NBA) G League. Because a player in the NBA G League is still developing his skills, the number of points he scores in a game can vary substantially. Develop a spreadsheet model that simulates the points scored by each team. Assume that each player's point production can be represented as an integer uniform variable with the ranges provided in the following table. (Use at least 1,000 trials.) Player Iowa Wolves Maine Red Claws 1 [5, 20] [6, 12] 2 [7, 20] [15, 20] 3 [5, 10] [10, 20] 4 [10, 40] [15, 30] 5 [7, 20] [6, 10] 6 [2, 10] [1, 20] 7 [2, 5] [1, 4] 8 [2,4] [2,4] (a) Consider the points scored by the Iowa Wolves team. (Round your answers to two decimal places.) What is the average of points scored? What is the standard deviation? What is the shape of the distribution? O uniform bell-shaped skewed left skewed right
Knowledge Booster
Background pattern image
Operations Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
  • Text book image
    Practical Management Science
    Operations Management
    ISBN:9781337406659
    Author:WINSTON, Wayne L.
    Publisher:Cengage,
    Text book image
    Principles of Management
    Management
    ISBN:9780998625768
    Author:OpenStax
    Publisher:OpenStax College
    Text book image
    Marketing
    Marketing
    ISBN:9780357033791
    Author:Pride, William M
    Publisher:South Western Educational Publishing
  • Text book image
    MARKETING 2018
    Marketing
    ISBN:9780357033753
    Author:Pride
    Publisher:CENGAGE L
    Text book image
    Purchasing and Supply Chain Management
    Operations Management
    ISBN:9781285869681
    Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
    Publisher:Cengage Learning
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Principles of Management
Management
ISBN:9780998625768
Author:OpenStax
Publisher:OpenStax College
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Text book image
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY