Precision Transfer, Inc. makes more than 300 types of precision gears. The operations to make the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Precision Transfer, Inc. makes more than 300 types of precision gears. The operations to make the different types are similar, but the time and materials required are different. Because all the gears made by Precision are similar, the aggregation unit for planning purposes is a gear. Forecasts for the aggregate demand of gears are given below. Month January February March April May June Total Forecast Demand 2700 3000 4000 4500 3200 2900 20,300 From historical data, it was determined that a worker can make 3.8 gears/day. Production costs do not change over the planning horizon and include worker wages and benefits. A unit produced but not sold in a month is counted as inventory for the entire month (end-of-month) inventory. The following summarizes the important cost and workforce information: Production Costs Inventory holding costs Backordering cost Worker hiring costs Worker layoff costs Worker wages and benefits Working day Beginning workforce level $30/unit $5/unit/month $15/unit/month $4500 worker $6000 worker $8/hour 8 hours/day 35 workers With this information, develop an aggregate production plan using chase, level, and Linear Programming Profit Maximization Model. Chase strategy K= Jan Feb Mar Apr May Jun Total 3.8 Forecasted Demand D 2700 3000 4000 4500 3200 2900 20300 Cost of Strategy Production Costs Hiring Costs Layoff Costs Inv Holding Costs Backorder Costs hourly worker costs gears/day Forecast less OH Inv 2700 29868 3946.8 4426 4 31576 2880.8 Cost (per unit) 30.00 4.500.00 6,000.00 5.00 15.00 Cost (per day) 64.00 Days per Month CARRERA 22 Units 20345,2 22 22 246.8 days 5354 Chase Strategy (include ending inventory in planning) Units Wkr per Month 79.8 76 87.4 79.8 83.6 83.6 unit cost subtotal hourly cost subtotal Total Cost Wkrs Required 33.83 39.30 45.16 55.47 37.77 34.46 Subtotal $610,356.00 $99,000.00 $132.000.00 $1.234.00 $0.00 $842.590.00 $342,656.00 $342.656.00 $1,185,246.00 Wkrs (rounded) 35 34 40 46 56 38 35 $1,185,246.00 Units Produced Hires 2713,2 3040 4020.4 4468.8 3176.8 2926 20345.2 0 6 6 10 0 0 22 Lay Offs 1 0 0 0 18 3 22 Ending Inventory 0 132 53.2 73.6 42.4 19.2 45.2 246.8 Level Strategy (No backorder allowed) K- Januar Februa ry March April May June 3.8 gears/day Cummulati Forecas ted Deman 2700 3000 4000 4500 3200 2900 Total 20300 Cost of Strategy Production Costs Hiring Costs Layoff Costs Inv Holding Costs Backorder Costs hourly worker costs Forecast 2700 $700 9700 14200 17400 20300 4.500.00 6,000.00 5.00 15.00 Cost (per day) Days per Month 8.00 21 Cost (per unit) Units 30.00 21568.8 20 23 21 22 ⠀ 9 0 4738.4 0 days 45408 Constant Workforce (with no backorders) Cumm Days 21 = 325 2 107 129 unit cost subtotal hourly cost subtotal Total Cost Units Wkr per Month 79.8 874 79.8 83.6 83.6 490.2 Subtotal $647,064.00 $40.500.00 $0.00 $23,692.00 $0.00 $711.256.00 $363,264.00 $363,264.00 $1,074,520.00 unt wkr mth 79.8 155.8 243.2 406.6 490.2 max #workers in month- Workers Needed 34 37 44 44 Wars Units Select Produc Hir ed ed 35 44 35112 44 6 3845.6 44 35112 0 44 21568 0 0 ooo 0 0 9 Lay Offs 0 0 000 0 0 Erding Invent 811.2 1155 2 1000 8 12 490.4 47384 Holdi Backor ng der 811.2 1155. 2 1000. 8 12 490.4 1268. 8 4738 4 0 0 0 0 0 0 0 Linear program (Profit Max) K- Given Parameters 3.8 Forecaste d Demand Jan Feb Mar Apr May Jun Total Cost of Strategy Layoff Costs 2700 3000 4000 4500 3200 2900 20300 Production Costs Hiring Costs Inv Holding Costs Backorder Costs hourly worker costs gears day Days per Month 21 20 23 21 22 22 4.500.00 6,000,00 5.00 15.00 Units W kr Costs Units 30,00 20352.8 Cost (per day (Shr) 64.00 per Month 79.8 76 87.4 79.8 83.6 83.6 0 1104.8 1595.2 days 5356 Profit Maximization Strategy Profit Maximization Strategy hourly cost $0.00 $5.524.00 $23.928.00 unit cost subtotal $676.036.00 Subtotal $610,584.00 Total Cost What if no backorder is allowed? What constraints are needed? $36,000.00 $342,784.00 subtotal $342,784.00 $1,018,820. 00 3032.4 3192 3670.8 Solver Variables LP Variables P..t Productio Hire 3351.6 3511.2 3594.8 20352.8 Ht Lt Lay Offs 4 0 00 1 8 0 0 0 0 0 0 WI 1+ Worker Holdin 35 38 42 42 42 Ending Inventory 1- Backord er 43 332.4 524.4 195.2 0 0 52.8 1104.8 0 0 953.2 642 0 1595.2 Precision Transfer, Inc. makes more than 300 types of precision gears. The operations to make the different types are similar, but the time and materials required are different. Because all the gears made by Precision are similar, the aggregation unit for planning purposes is a gear. Forecasts for the aggregate demand of gears are given below. Month January February March April May June Total Forecast Demand 2700 3000 4000 4500 3200 2900 20,300 From historical data, it was determined that a worker can make 3.8 gears/day. Production costs do not change over the planning horizon and include worker wages and benefits. A unit produced but not sold in a month is counted as inventory for the entire month (end-of-month) inventory. The following summarizes the important cost and workforce information: Production Costs Inventory holding costs Backordering cost Worker hiring costs Worker layoff costs Worker wages and benefits Working day Beginning workforce level $30/unit $5/unit/month $15/unit/month $4500 worker $6000 worker $8/hour 8 hours/day 35 workers With this information, develop an aggregate production plan using chase, level, and Linear Programming Profit Maximization Model. Chase strategy K= Jan Feb Mar Apr May Jun Total 3.8 Forecasted Demand D 2700 3000 4000 4500 3200 2900 20300 Cost of Strategy Production Costs Hiring Costs Layoff Costs Inv Holding Costs Backorder Costs hourly worker costs gears/day Forecast less OH Inv 2700 29868 3946.8 4426 4 31576 2880.8 Cost (per unit) 30.00 4.500.00 6,000.00 5.00 15.00 Cost (per day) 64.00 Days per Month CARRERA 22 Units 20345,2 22 22 246.8 days 5354 Chase Strategy (include ending inventory in planning) Units Wkr per Month 79.8 76 87.4 79.8 83.6 83.6 unit cost subtotal hourly cost subtotal Total Cost Wkrs Required 33.83 39.30 45.16 55.47 37.77 34.46 Subtotal $610,356.00 $99,000.00 $132.000.00 $1.234.00 $0.00 $842.590.00 $342,656.00 $342.656.00 $1,185,246.00 Wkrs (rounded) 35 34 40 46 56 38 35 $1,185,246.00 Units Produced Hires 2713,2 3040 4020.4 4468.8 3176.8 2926 20345.2 0 6 6 10 0 0 22 Lay Offs 1 0 0 0 18 3 22 Ending Inventory 0 132 53.2 73.6 42.4 19.2 45.2 246.8 Level Strategy (No backorder allowed) K- Januar Februa ry March April May June 3.8 gears/day Cummulati Forecas ted Deman 2700 3000 4000 4500 3200 2900 Total 20300 Cost of Strategy Production Costs Hiring Costs Layoff Costs Inv Holding Costs Backorder Costs hourly worker costs Forecast 2700 $700 9700 14200 17400 20300 4.500.00 6,000.00 5.00 15.00 Cost (per day) Days per Month 8.00 21 Cost (per unit) Units 30.00 21568.8 20 23 21 22 ⠀ 9 0 4738.4 0 days 45408 Constant Workforce (with no backorders) Cumm Days 21 = 325 2 107 129 unit cost subtotal hourly cost subtotal Total Cost Units Wkr per Month 79.8 874 79.8 83.6 83.6 490.2 Subtotal $647,064.00 $40.500.00 $0.00 $23,692.00 $0.00 $711.256.00 $363,264.00 $363,264.00 $1,074,520.00 unt wkr mth 79.8 155.8 243.2 406.6 490.2 max #workers in month- Workers Needed 34 37 44 44 Wars Units Select Produc Hir ed ed 35 44 35112 44 6 3845.6 44 35112 0 44 21568 0 0 ooo 0 0 9 Lay Offs 0 0 000 0 0 Erding Invent 811.2 1155 2 1000 8 12 490.4 47384 Holdi Backor ng der 811.2 1155. 2 1000. 8 12 490.4 1268. 8 4738 4 0 0 0 0 0 0 0 Linear program (Profit Max) K- Given Parameters 3.8 Forecaste d Demand Jan Feb Mar Apr May Jun Total Cost of Strategy Layoff Costs 2700 3000 4000 4500 3200 2900 20300 Production Costs Hiring Costs Inv Holding Costs Backorder Costs hourly worker costs gears day Days per Month 21 20 23 21 22 22 4.500.00 6,000,00 5.00 15.00 Units W kr Costs Units 30,00 20352.8 Cost (per day (Shr) 64.00 per Month 79.8 76 87.4 79.8 83.6 83.6 0 1104.8 1595.2 days 5356 Profit Maximization Strategy Profit Maximization Strategy hourly cost $0.00 $5.524.00 $23.928.00 unit cost subtotal $676.036.00 Subtotal $610,584.00 Total Cost What if no backorder is allowed? What constraints are needed? $36,000.00 $342,784.00 subtotal $342,784.00 $1,018,820. 00 3032.4 3192 3670.8 Solver Variables LP Variables P..t Productio Hire 3351.6 3511.2 3594.8 20352.8 Ht Lt Lay Offs 4 0 00 1 8 0 0 0 0 0 0 WI 1+ Worker Holdin 35 38 42 42 42 Ending Inventory 1- Backord er 43 332.4 524.4 195.2 0 0 52.8 1104.8 0 0 953.2 642 0 1595.2
Expert Answer:
Answer rating: 100% (QA)
Last year precision made 41600 gears in Days 260 Number of workers 40 Therefore Labor Standard 41600 ... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0078111006
14th edition
Authors: Ray Garrison, Eric Noreen and Peter Brewer
Posted Date:
Students also viewed these mathematics questions
-
ANutse is providing instruction to a client that follows a vegen diet, the nurse should instruct the vlient thst ehich ofvthr following foods is s reliable source of vitamin B12? A) yogurt. b) rice ....
-
of the 85 caught balls, it was determined that 34 were barehanded catches,49 were caught with a glove , and two were caught with a hat Whaat is the p
-
In a biomedical research activity it was determined that the survival time, in weeks, of an animal when subjected to a certain exposure of gamma radiation has a gamma distribution with a =5 and 3...
-
9.3.1 Which of the following statements are true concerning the mean of the differences between two dependent samples (matched pairs)? Select all that apply. A. The requirement of a simple random...
-
Light from a camera flash weakens with distance in accord with the inverse-square law. Comment on an airline passenger who takes a flash photo of a city at nighttime from a high flying plane.
-
On July 23 of the current year, Dakota Mining Co. pays $4,715,000 for land estimated to contain 5,125,000 tons of recoverable ore. It installs and pays for machinery costing $410,000 on July 25. The...
-
The function of a condenser is to (a) condense steam (b) maintain pressure below atmospheric pressure (c) increase work output of prime mover (d) all of the above
-
A company with no inventory buys the following three inventory items: On January 10, the company sells one item for $10. On January 15, the company sells a second item $10. The company uses a...
-
List and Explain two different legislation relevant to detailed designs of motorways and interchanges ?
-
A process stream is heated using a shell and tube heat exchanger. The exit temperature is controlled by adjusting the steam control valve shown in figure. During an open-loop experimental test, the...
-
Consider a beam with an applied vertical force, F, a couple moment, M, that is restrained at point A by a pin joint and at point B by a roller. F M In the free-body diagram of the beam shown here, F...
-
The list of 3 jobs Ross Co. worked on during the year: Cost Job B1 Job O1 Job B2 Prime costs $4,100 $6,250 $7,400 Manufacturing overhead ? ? ? Bob applies overhead at a rate of 65% of prime costs....
-
The client is employed in Amazon, India, and receives a competitive annual package that includes ESOPs that have increased in value. With a taste for success, your client is investing a large amount...
-
Write a C program named as countD.c that takes input text file and a digit as arguments, outputs how many times the digit appears in the file. If the text file does not exist, print out an error...
-
Economic progress within a country seems to depend on how well property rights are protected. Explain the relationship between property rights, corruption, and economic progress and their importance...
-
Discuss the characteristics of the rule of law, according to Hayek.
-
Describe, from your perspective, the essential role of the Senior Financial Analyst. Explain the roles' impact on the health care industry. Outline ways in which you can apply one of the discussed...
-
Explain the circumstances that could result in a long-term bank loan being shown in a statement of financial position as a current liability.
-
Triway Packaging Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the...
-
If you had to decide whether to continue making a component part or to begin buying the part from an overseas supplier, what quantitative and qualitative factors would influence your decision?
-
Scott Companys variable manufacturing overhead should be $2.50 per standard direct labor-hour and fixed manufacturing overhead should be $320,000 per year. The company produces a single product that...
-
At the beginning of a duct the nitrogen pressure is \(1.5 \mathrm{bar}\), the stagnation temperature is \(280 \mathrm{~K}\), and the Mach number is 0.80 . After some heat transfer the static pressure...
-
A \(50 \times 50 \mathrm{~cm}\) duct is \(10 \mathrm{~m}\) in length. Nitrogen enters at \(M_{1}=3.0\) and leaves at \(M_{2}=1.7\), with \(T_{2}=280 \mathrm{~K}\) and \(p_{2}=7 \times 10^{4}...
-
Air enters a constant-area duct with \(M_{1}=2.95\) and \(T_{1}=500^{\circ} \mathrm{R}\). Heat transfer decreases the outlet Mach number to \(M_{2}=1.60\). (a) Compute the exit static and stagnation...
Study smarter with the SolutionInn App