A company blends and bottles an energy drink in various flavors for college students. The aggregate forecast for the next four quarters (1 year) in thousands of gallons is as follows: Quarter Demand forecast per 1000 gallons 1 400 2 700 3 850 4 650 Each employee works 550 standard straight-time hours each quarter. On average, it takes 27 hours to produce and package 1 unit (1,000 gallons). Straight-time labor costs $6.00/hour; overtime labor costs $9.00/hour. Inventory holding cost is approximately $4.50/unit (1,000 gallons) per quarter, based on ending inventory per quarter. Due to the extremely hot weather, there is no initial inventory on hand to start the first quarter. Management wants a constant workforce (no hiring and no layoffs). Managers have also decided to always round the number of employees needed to the next integer, i.e., 37.2 yields 38 employees. Using a level strategy program, what will the annual labor cost be if only 30 employees are available and overtime is used?

A company blends and bottles an energy drink in various flavors for college students. The aggregate forecast for the next four quarters (1 year) in thousands of gallons is as follows: Quarter Demand forecast per 1000 gallons 1 400 2 700 3 850 4 650 Each employee works 550 standard straight-time hours each quarter. On average, it takes 27 hours to produce and package 1 unit (1,000 gallons). Straight-time labor costs $6.00/hour; overtime labor costs $9.00/hour. Inventory holding cost is approximately $4.50/unit (1,000 gallons) per quarter, based on ending inventory per quarter. Due to the extremely hot weather, there is no initial inventory on hand to start the first quarter. Management wants a constant workforce (no hiring and no layoffs). Managers have also decided to always round the number of employees needed to the next integer, i.e., 37.2 yields 38 employees. Using a level strategy program, what will the annual labor cost be if only 30 employees are available and overtime is used?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section4.8: Data Envelopment Analysis (dea)

Problem 42P

See similar textbooks

Similar questions

At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.
Jefferson Company’s demand for its only product exceeds its manufacturing capacity. The company provided the following information for the machine whose limited capacity is prohibiting the company from producing and selling additional units. Actual run time this week 6,106 minutes Machine time available per week 8,600 minutes Actual run rate this week 4.32 units per minute Ideal run rate 6.00 units per minute Defect-free output this week 11,315 units Total output this week (including defects) 15,500 units 1. Compute the utilization rate.2. Compute the efficiency rate. 3. Compute the quality rate. 4. Compute the overall equipment effectiveness (OEE).
A department works on 8 hours shift, 288 days a year and has the usage data of a machine, as given below: Processing time (Standard time in hours) Annual Demand Product (units) A 325 5 B 450 4 550 6 Calculate: (a) Processing time needed in hours to produce products A, B and C (b) Annual production capacity of one machine in standard hours (c) Number of machines required
SkyChefs, Inc., prepares in-flight meals for a number of major airlines. One of the company's products is grilled salmon with new potatoes and mixed vegetables. During the most recent week, the company prepared 4,000 of these meals using 960 direct labor- hours. The company paid its direct labor workers a total of $19,200 for this work, or $20.00 per hour. According to the standard cost card for this meal, it should require 0.25 direct labor-hours at a cost of $19.75 per hour. Required: 1. What is the standard labor-hours allowed (SH) to prepare 4,000 meals? 2. What is the standard labor cost allowed (SH x SR) to prepare 4,000 meals? 3. What is the labor spending variance? 4. What is the labor rate variance and the labor efficiency variance? (For requirements 3 and 4, indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values. Do not round intermediate calculations.) 1.…
Kilmer Company's customer demand for its only product exceeds its manufacturing capacity. The company provided the following information for the machine whose limited capacity is prohibiting the company from producing and selling additional units: Actual run tine this week Machine time available per week Actual run rate this week Ideal run rate Defect-free output this week Total output this week (including defects) 1-a. Utilization rate 1-b. Efficiency rate. 1-c. Quality rate 1-d. Overall equipment effectiveness 2-a. Utilization loss in units 12,800 minutes 16,000 minutes. 2-b. Efficiency loss in units 2-c. Quality loss in units 6.30 units per minute. 9 units per minute. Required: 1. and 2. With respect to the company's overall equipment effectiveness, calculate the following: Note: Do not round intermediate calculations. Round final answers to 2 decimal places and "Units" answers to the nearest whole number. 72,576 units 80,640 units
Kilmer Company's customer demand for its only product exceeds its manufacturing capacity. The company provided the following information for the machine whose limited capacity is prohibiting the company from producing and selling additional units: Actual run time this week Machine time available per week Actual run rate this week Ideal run rate Defect-free output this week Total output this week (including defects) 1-a. Utilization rate 1-b. Efficiency rate. 1-c. Quality rate 1-d. Overall equipment effectiveness 2-a. Utilization loss in units 2-b. Efficiency loss in units 2-c. Quality loss in units 23,310 minutes 25,900 minutes 0.90 8.00 units per minute 10 units per minute Required: 1. and 2. With respect to the company's overall equipment effectiveness, calculate the following: Note: Do not round intermediate calculations. Round final answers to 2 decimal places and "Units" answers to the nearest whole number. 149,184 units 186,480 units
QuestionByron Sports is a manufacturer of sportswear. It produces all of its products in one department using a process costing system.The information for the current month is as follows:Beginning work in process (30% complete as to conversion cost) 12,000 unitsUnits started 90,000 unitsUnits completed and transferred out ?Ending work in process (70% complete as to conversion) 8,000 unitsCosts:Beginning work-in-process direct materials $28,800Beginning work-in-process conversion $5,040Direct materials added during month $216,000Conversion costs incurred during the month $139,200Direct materials are added at the beginning of the process. Conversion costs are incurred uniformlythroughout the production process. Costing is handled on a FIFO basis Required:a. Prepare a production cost worksheet using 5 steps approach.b. Under what conditions would a process costing system be more appropriate than a job order costing system? Explain.
Jefferson Company's demand for its only product exceeds its manufacturing capacity. The company provided the following information for the machine whose limited capacity is prohibiting the company from producing and selling additional units. 4,900 minutes 7,000 minutes 3.8 units per minute 4.0 units per minute 15,827 units 18,620 units Actual run time this week Machine time available per week Actual run rate this week Ideal run rate Defect-free output this week Total output this week (including defects) Required: 1. Compute the utilization rate. (Round your answer to 2 decimal places.) 2. Compute the efficiency rate. (Round your answer to 2 decimal places.) 3. Compute the quality rate. (Round your answer to 2 decimal places.) 4. Compute the overall equipment effectiveness (OEE). (Do not round intermediate calculations. Round your final answer to 3 decimal places.) Utilization rate Efficiency rate Quality rate Overall equipment effectiveness
I submitted this question a couple days ago. However, I am still a little confused. Here was the original question: Collins Little Company has a staff of 4 employees, each working 8 hours per day at a rate of $20/hour. Their overhead expenses are $200/day. Collins processes and closes on 12 titles each day. They are considering purchasing a computerized title search system that will allow the processing of 20 titles per day. With the new system, they could cut their staff to 2 employees working the same hours at the same pay, but their overhead expenses would double to $400 per day. 1. Compute the labor productivity with the old system (in titles / hour). 2. Compute the labor productivity with the new system (in titles / hour). 3. Compute the multifactor productivity with the old system (in titles / dollar). 4. Compute the multifactor productivity with the new system (in titles / dollar). One of the answers is: Labor Productivity = 12/(4*8) Another is: Labor Productivity =…
Prevost Chemicals manufactures an industrial solvent at its only processing plant. A liquid chemical and labor are the two primary inputs. All other resources are included in manufacturing overhead. The plant never has any work-in-process or finished goods inventories. Information from the previous four periods of production follows: Chemical input (gallons) Labor input (hours) Solvent sales (gallons) Average price of chemical per gallon Average wage rate per hour Average sales price per gallon Manufacturing overhead (total) Required A Required B Required C Required: a. Compute the partial productivity measures for chemical for the four periods. b. Compute the partial productivity measures for labor for the four periods. c. Compute the total factor productivity for the four periods. Complete this question by entering your answers in the tabs below. Period Period 1 125,000 12,500 110,000 Period 1 $ 2.00 28.00 10.26 236,000 Compute the partial productivity measures for chemical for the…
The measure of production that considers historical and estimated future production levels and cyclical fluctuations is referred to as: Group of answer choices expected capacity normal capacity theoretical capacity practical capacity
A bicycle component manufacturer produces hubs for bike wheels. Two processes are possible for manufacturing, and the parameters of each process are as follows: Process 1 Production rate Daily production time Process 2 35 parts/hour 4 hours/day 20% 15 parts/hour 7 hours/day 9% Percent parts rejected Assume that the daily demand for hubs allows all defect-free hubs to be sold. Select the process that maximizes profit per day if each part is made from $4 worth of material and can be sold for $30. Both processes are fully automated, and variable overhead cost is charged at the rate of $40 per hour.