Excel: The initial number of workers 27 Required Production time (not using prefabs) 40 workerminute per unit
Fantastic news! We've Found the answer you've been seeking!
Question:
Excel:
The initial number of workers | 27 | |||
Required Production time (not using prefabs) | 40 | worker∙minute per unit | ||
Required Production time (using prefabs) | 30 | worker∙minute per unit | ||
Regular hours per month | 200 | hours | ||
Salary | 13 | $ per hour | ||
The additional material cost of using prefabs | 4 | $ per unit | ||
Inventory holding cost | 9.2 | $ per unit per month | ||
Backorder cost | 11.9 | $ per unit per month | ||
Hiring workers | 800 | $ per worker | ||
Laying off workers | 1100 | $ per worker | ||
Beginning Inventory of January | 200 | units | ||
Required Ending Inventory of June | 500 | units (at least these many units) |
Period | 1 | 2 | 3 | 4 | 5 | 6 | Total |
Demand | 9800 | 11200 | 12400 | 11200 | 9900 | 12800 | 67300 |
Total number of workers | --- | ||||||
Number of workers (not using prefabs | --- | ||||||
Number of workers (using prefabs) | --- | ||||||
Beginning Inventory | ---- | ||||||
Production quantity (not using prefabs) | |||||||
Production quantity (using prefabs) | |||||||
Ending Inventory (use negative for backorder) | ---- | ||||||
Costs: | |||||||
Hiring cost | |||||||
Laying off cost | |||||||
Labor cost | |||||||
Additional material cost (prefabs) | |||||||
Inventory holding cost | |||||||
Backorder cost | |||||||
Total Cost: |
Transcribed Image Text:
Use the forecasted demand and other data shown in sheet "Aggregate" to help Helen Industries Inc. to plan its production for one major products group for the next 6 months. Helen Industries Inc. used to adopt a standard production process in which it moulds and assemblies all parts by itself; the required production time of this standard process is provided in the cell "Aggregate!B2". As the quality of prefabrication parts from suppliers improves, the company now can choose to use a simplified production process in which prefabrication parts are used to shorten the requirement production time. The required production time of the simplified process is provided in the cell "Aggregate! B3". The additional material cost of using prefabrication parts are shown in the cell "Aggregate!B6". [Note that a production time of XX worker minute per unit means that it takes one worker XX minutes to produce 1 unit of product.] In order to satisfy the production requirement, the company can vary its capacity by (1) hiring or laying off workers and (2) scheduling workers to use standard production process (not using prefabrication parts) or to use a simplified production process (using the more expensive prefabrication parts). The following assumptions are made. ii. ● Hiring or layoff costs are incurred when the total number of workers changes. The number of workers in each month should be an integer. Once scheduled, all workers will produce at their full potential each month. The ending inventory requirement of June stated in the cell "Aggregate! B12" must be satisfied. Consider the following three different strategies. i. A level strategy without the use of prefabrications to meet the overall production requirement. That is, use a constant number of workers for these 6 months; all workers produce without the use of prefabrication parts; demand variations are absorbed by inventory and backorders. Hiring and layoff only happens at the beginning of January. A chase strategy by varying the number of workers when all workers produce with the use of prefabrication parts. That is, all scheduled workers produce with the use of prefabrication parts; use the minimum number of workers in each month to make the ending inventory of each month non-negative. Initial workers unchanged and not using prefabrications PLUS variable new workers using prefabrications. That is, schedule all initial workers to produce without prefabrication parts; this number is unchanged over these six months. Except these initial workers, new workers hired in these six months produce with the use of prefabrication parts. Vary the numbers of new workers. [Hint: input the initial number workers to the row "Number of workers (not using prefabs)", Aggregate! B18:G18; then, vary the numbers in Aggregate! B19:G19 to make your plan.] iii. ● . Inventory and backorder costs are calculated using ending inventory/backorder of each month. Question: Develop three plans using the above three strategies, respectively. Your plans should be cost- effective among the plans that satisfy the requirements. (For example, using one thousand workers can satisfy some of the above requirements, but it is obviously not cost-effective, i.e., not minimize the cost.) Use the forecasted demand and other data shown in sheet "Aggregate" to help Helen Industries Inc. to plan its production for one major products group for the next 6 months. Helen Industries Inc. used to adopt a standard production process in which it moulds and assemblies all parts by itself; the required production time of this standard process is provided in the cell "Aggregate!B2". As the quality of prefabrication parts from suppliers improves, the company now can choose to use a simplified production process in which prefabrication parts are used to shorten the requirement production time. The required production time of the simplified process is provided in the cell "Aggregate! B3". The additional material cost of using prefabrication parts are shown in the cell "Aggregate!B6". [Note that a production time of XX worker minute per unit means that it takes one worker XX minutes to produce 1 unit of product.] In order to satisfy the production requirement, the company can vary its capacity by (1) hiring or laying off workers and (2) scheduling workers to use standard production process (not using prefabrication parts) or to use a simplified production process (using the more expensive prefabrication parts). The following assumptions are made. ii. ● Hiring or layoff costs are incurred when the total number of workers changes. The number of workers in each month should be an integer. Once scheduled, all workers will produce at their full potential each month. The ending inventory requirement of June stated in the cell "Aggregate! B12" must be satisfied. Consider the following three different strategies. i. A level strategy without the use of prefabrications to meet the overall production requirement. That is, use a constant number of workers for these 6 months; all workers produce without the use of prefabrication parts; demand variations are absorbed by inventory and backorders. Hiring and layoff only happens at the beginning of January. A chase strategy by varying the number of workers when all workers produce with the use of prefabrication parts. That is, all scheduled workers produce with the use of prefabrication parts; use the minimum number of workers in each month to make the ending inventory of each month non-negative. Initial workers unchanged and not using prefabrications PLUS variable new workers using prefabrications. That is, schedule all initial workers to produce without prefabrication parts; this number is unchanged over these six months. Except these initial workers, new workers hired in these six months produce with the use of prefabrication parts. Vary the numbers of new workers. [Hint: input the initial number workers to the row "Number of workers (not using prefabs)", Aggregate! B18:G18; then, vary the numbers in Aggregate! B19:G19 to make your plan.] iii. ● . Inventory and backorder costs are calculated using ending inventory/backorder of each month. Question: Develop three plans using the above three strategies, respectively. Your plans should be cost- effective among the plans that satisfy the requirements. (For example, using one thousand workers can satisfy some of the above requirements, but it is obviously not cost-effective, i.e., not minimize the cost.)
Expert Answer:
Answer rating: 100% (QA)
1 Plan A Level Strategy Without the Use of Prefabrications The level strategy involves producing the same number of units each period with no prefabrication parts and adjusting production to meet dema... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Jen and Berry's sells ice-creams from its factory-shop in Petone. There is a managing director (Maynard Dibble), a marketing manager (Mary Salman) and a production manager (Peter Pritchard). Maynard...
-
In a survey of 1,002 people, 701 (or 70%) said that they voted in the last presidential election (based on data from ICR Research Group). The margin of error was 3 percentage points. However, actual...
-
In practice, there is often a tendency to simplify approximations of cost-behavior patterns, even though the true underlying behavior is not simple. Choose from the following graphs AH the one that...
-
How would the world differ if the plate rates were 2x faster? Focus first at least on the shapes and depths of ocean basins. How much might sea level change due to such a speed-up?
-
Visit www.pearsonglobaleditions.com/malhotra to read the video case and view the accompanying video. Subaru: Mr. Survey Monitors Customer Satisfaction presents an interesting overview of Joe...
-
George Robbins considers himself an aggressive investor. Hes thinking about investing in some foreign securities and is looking at stocks in (1) Bayer AG, the big German chemical and health-care...
-
- - - You have accepted a manager position with a new company In this company, business units do not need to convert CO2 grams to metric tons Upon arrival, you received a performance goal to reduce...
-
Blue Mountain Cabin Jack and Jill Smith have just retired and want to build a small, basic cabin in the Blue Mountains of Vermont. They have hired Daryl Hannah as the general contractor for the...
-
Develop a WBS for Brian Smiths project and include up to FOUR (4) levels of the structure.
-
You enter into a mortgage agreement for $ 1 . 2 5 million at 3 . 8 7 5 % for 2 0 years. What will be your monthly payments?
-
The price of a Starbucks tall vanilla latte in Zagreb is 25.83kn (kn or HRK). In New York City, the price of a tall vanilla latte is $2.69. The exchange rate between Croatian kunas (kn) and U.S....
-
Case Study: Auditing in Nonprofit Organizations Introduction: Auditing in nonprofit organizations presents a unique set of challenges and opportunities. In this case study, we examine the experiences...
-
In this problem you will count the exact number of steps for the code segment below. You should count each assignment and each comparison as one step. i = n; sum = 0; while (i > 0) { // this is the...
-
3 . Calculate the annual unit sales volume at which ABC Company would be indifferent between the two manufacturing methods. Use this info: Capital - intensive: Direct material: $ 5 / unit Direct...
-
Consider a two-wire transmission line made of two copper rods. The copper rod has a conductivity of 5.8107 S/m and radius of 1.25 mm. The center-to-center distance between the rods is 4 mm. (i) When...
-
Medi-Exam Health Services, Inc. (MEHS), located in a major metropolitan area, provides annual physical screening examinations, including a routine physical, EKG, and blood and urine tests. MEUS's...
-
Frank Willingham has the following transactions during the year: Sale of office equipment on March 15 that cost $20,000 when purchased on July 1, 2010. Frank has claimed $5,000 in depreciation and...
-
Mike purchases a heavy-duty truck (5-year class recovery property) for his delivery service on April 30, 2012. The truck is not considered a passenger automobile for purposes of the listed property...
-
Indicate, in each of the following situations, the number of exemptions the taxpayers are entitled to claim on their 2012 income tax returns. Number of Exemptions a. Donna, a 20-year-old single...
-
In this chapter, we had only expressed eigenstates of the harmonic oscillator Hamiltonian through repeated action of the raising operator, \(\hat{a}^{\dagger}\). This gives us a concrete algorithm...
-
In this chapter, we noted that the Hilbert space of the harmonic oscillator corresponds to all those states that can be accessed from the ground state through action by an anatic function of...
-
Supersymmetry is a proposed extension of the symmetries of space-time beyond that of just familiar Lorentz transformations and translations. A supersymmetry transformation interchanges fermions and...
Study smarter with the SolutionInn App