Concept explainers
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.
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:
.
For the four-month time horizon, the mix percentages will remain the same as given.
Month | May | |||
Working days | 22 | |||
Total forecast | 750 | |||
Products | Product Mix (%) | No. of files | Hours per file | Hours |
1 | 22 | 165.00 | 3.60 | 594.00 |
2 | 17 | 127.50 | 2.00 | 255.00 |
3 | 13 | 97.50 | 1.70 | 165.75 |
4 | 12 | 90.00 | 5.50 | 495.00 |
5 | 10 | 75.00 | 4.00 | 300.00 |
6 | 9 | 67.50 | 3.00 | 202.50 |
7 | 7 | 52.50 | 2.00 | 105.00 |
8 | 5 | 37.50 | 2.00 | 75.00 |
9 | 3 | 22.50 | 1.50 | 33.75 |
10 | 2 | 15.00 | 4.00 | 60.00 |
Total | 100 | 750 | 2286 | |
Required # of workers | 15 |
Month | June | |||
Working days | 20 | |||
Total forecast | 825 | |||
Products | Product Mix (%) | No. of files | Hours per file | Hours |
1 | 22 | 181.50 | 3.60 | 653.40 |
2 | 17 | 140.25 | 2.00 | 280.50 |
3 | 13 | 107.25 | 1.70 | 182.33 |
4 | 12 | 99.00 | 5.50 | 544.50 |
5 | 10 | 82.50 | 4.00 | 330.00 |
6 | 9 | 74.25 | 3.00 | 222.75 |
7 | 7 | 57.75 | 2.00 | 115.50 |
8 | 5 | 41.25 | 2.00 | 82.50 |
9 | 3 | 24.75 | 1.50 | 37.13 |
10 | 2 | 16.50 | 4.00 | 66.00 |
Total | 100 | 825 | 2514.6 | |
Required # of workers | 18 |
Month | July | |||
Working days | 22 | |||
Total forecast | 900 | |||
Products | Product Mix (%) | No. of files | Hours per file | Hours |
1 | 22 | 198.00 | 3.60 | 712.80 |
2 | 17 | 153.00 | 2.00 | 306.00 |
3 | 13 | 117.00 | 1.70 | 198.90 |
4 | 12 | 108.00 | 5.50 | 594.00 |
5 | 10 | 90.00 | 4.00 | 360.00 |
6 | 9 | 81.00 | 3.00 | 243.00 |
7 | 7 | 63.00 | 2.00 | 126.00 |
8 | 5 | 45.00 | 2.00 | 90.00 |
9 | 3 | 27.00 | 1.50 | 40.50 |
10 | 2 | 18.00 | 4.00 | 72.00 |
Total | 100 | 900 | 2743.2 | |
Required # of workers | 18 |
Month | July | |||
Working days | 22 | |||
Total forecast | 775 | |||
Products | Product Mix (%) | No. of files | Hours per file | Hours |
1 | 22 | 170.50 | 3.60 | 613.80 |
2 | 17 | 131.75 | 2.00 | 263.50 |
3 | 13 | 100.75 | 1.70 | 171.28 |
4 | 12 | 93.00 | 5.50 | 511.50 |
5 | 10 | 77.50 | 4.00 | 310.00 |
6 | 9 | 69.75 | 3.00 | 209.25 |
7 | 7 | 54.25 | 2.00 | 108.50 |
8 | 5 | 38.75 | 2.00 | 77.50 |
9 | 3 | 23.25 | 1.50 | 34.88 |
10 | 2 | 15.50 | 4.00 | 62.00 |
Total | 100 | 775 | 2362.2 | |
Required # of workers | 16 |
In summary, the FTEs required can be written in the following table:
Month | FTE |
May | 15 |
Jun | 18 |
Jul | 18 |
Aug | 16 |
Want to see more full solutions like this?
Chapter 13 Solutions
OM (with OM Online, 1 term (6 months) Printed Access Card)
- Briefly describe each of these priority rules:a. FCFSb. SPTc. EDDd. S/Oe. Rusharrow_forwardThe forecasted requirements for an electric hand drill for the next 6 weeks are 15, 40, 10, 20, 50, and 30 units. The marketing department has booked orders totaling 20, 25, 10, and 20 units for delivery in the first (current), second, third, and fourth weeks. Currently, 30 hand drills are in stock. The policy is to order in lots of 60 units. Lead time is one week.a. Develop the MPS record for the hand drills.b. A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order?arrow_forwardWhat precisely is the key distinction between planning for the long term and planning for the short term when it comes to process scheduling?arrow_forward
- Print Item Equivalent Units of Production Data for the two departments of Kimble & Pierce Company for June of the current fiscal year are as follows: Drawing Department Winding Department Work in process, June 1 10,000 units, 38% completed 4,000 units, 35% completed Completed and transferred to next processing department during June 60,000 units 60,500 units Work in process, June 30 11,500 units, 70% completed 3,500 units, 60% completed Production begins in the Drawing Department and finishes in the Winding Department. a. If all direct materials are placed in process at the beginning of production, determine the direct materials and conversion equivalent units of production for June for the Drawing Department. If an amount is zero, enter in "0". Drawing Department Direct Materials and Conversion Equivalent Units of Production For June Whole Units Direct MaterialsEquivalent Units ConversionEquivalent Units Inventory in process, June 1 fill…arrow_forwardExplain what is the purpose of the Gantt chart as a scheduling tools and discuss when do they use a Gantt chart instead of a network based method?arrow_forwardWSS company makes weatherproof surveillance systems for parking lots. Demand estimates for the next four quarters are 25, 9, 13, and 17 units. Prepare an aggregate plan that uses inventory, regular time, and over time, and backorders. Subcontracting is not allowed. The regular time capacity is 15 units for quarters 1 and 2, 18 units for quarters 3 and 4. Overtime capacity is 3 units per quarter. The regular time cost is $2000 per unit, while the overtime cost is $3000 per unit. Backorder costs $300 per unit per quarter; inventory holding costs $100 per unit per quarter. The beginning inventory is zero. How many total units will be produced in quarter 1 for delivery in quarter 1? How many units in total will be used to fill back orders over the four quarters? What is the cost to produce one unit in Quarter 4 using overtime to fill a back order in quarter one?arrow_forward
- How do the concepts of master production scheduling and material requirements planning translate to a service organization? Provide an example.arrow_forwardGiven the following data, can an order for 40 more units for delivery in week 5 beaccepted? If not, what do you suggest can be done? There are zero units on hand.arrow_forwardWSS company makes weatherproof surveillance systems for parking lots. Demand estimates for the next four quarters are 25, 9, 13, and 17 units. Prepare an aggregate plan that uses inventory, regular time and overtime and back orders. Subcontracting is not allowed. Regular time capacity is 15 units for quarters 1 and 2, 18 units for quarters 3 and 4. Overtime capacity is 3 units per quarter. Regular time cost is $2000 per unit, while overtime cost is $3000 per unit. Back order cost is $300 per unit per quarter; inventory holding cost is $100 per unit per quarter. Beginning inventory is zero. Questions At the end of quarter 3, what is the ending inventory of finished systems? Answer: No ending Inventory =0 What is the total cost? 15*2000 + 6*2300 +4*2600 + 9*2000 + 13*2000 + 17*2000 =$132, 200 What is the average cost per unit? Answer 132200 / 64 = $2,066.arrow_forward
- document key factors a production manager needs to consider when scheduling production in the organization and to develop a training plan for production managers that emphasizes oversight of these factorsarrow_forwardHow does the Wilson approach handle demand forecasting and inventory planning for new product launches?arrow_forwardBased on past experience, Moss Company has developed the following budget formula for estimating its shipping expenses: Shipping costs = $21,000 + ($0.40 × pounds shipped). The company's shipments average 13 pounds per shipment. The planned activity and actual activity regarding orders and shipments for the current month are given in the following schedule: Plan Actual Sales orders 900 880 Shipments 900 920 Units shipped 9,000 10,000 Sales $ 130,000 $ 154,000 Total pounds shipped 10,600 13,300 The actual shipping costs for the month amounted to $26,000. The appropriate monthly flexible budget allowance for shipping costs for the purpose of performance evaluation would be:arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.