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...
-
How does a time draft become a banker's acceptance?
-
What are urban heat islands? What are dust domes?
-
Make-or-buy product component (Learning Objective 6) Fiber Systems manufactures an optical switch that it uses in its final product. Fiber Systems incurred the following manufacturing costs when it...
-
Auditors develop overall audit plans to ensure that they obtain sufficient appropriate audit evidence. The timing and extent of audit procedures auditors use is a matter of professional judgment,...
-
\f
-
Freddy Frolic consumes only asparagus and tomatoes, which are highly seasonal crops in Freddys part of the world. He sells umbrellas for a living, which provides a fluctuating income depending on the...
-
Dorsey Company manufactures three products from a common input in a joint processing operation. Joint processing costs up to the split-off point total $320,000 per quarter. For financial reporting...
-
Choose the new media category. The new media is revolutionizing this generation we live in. I chose new media because it helps spread information and news virally and efficiently. Prompt Through the...
-
Write an essay e Eastman Kodak Company downfall. The essay must be written in the form of an analysis for the CEO/board and recommend economic responses. It is important that the essay uses, and...
-
Dot owns a two-bedroom house in Woodley near West End College. She decides to help her son, Phil, out of his current financial difficulties by letting him use the house to raise income. She gives him...
-
A shoe factory produces the following product: No.41 dress shoe for men and in the month of July 2020 it produces 500 pairs Items needed for production: 125 mutton leathers at $ 3000 each 1,000 soles...
-
Explain what is meant by the phrase "Best practice or best fit?" What do you regard as the most pressing questions HRM should tackle? Why do you see them as most urgent? why "Context" is important.
-
Department R had 4 800 units in work in process that were 78 completed as to labor and overhead at the beginning of the period 38 400 units of direct materials were added during the period 40 700...
-
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...
-
You are considering the following investment: The discount rate is 11% and the corporate tax rate is 34%. a. Calculate the project NPV using straight-line depreciation. b. What will be the company's...
-
A factory is considering the purchase of a new machine for one of its units. The machine costs $100,000. The machine will be depreciated on a straight line basis over its 10-year life to a salvage...
-
The ABD Company is considering buying a new machine for one of its factories. The machine cost is $100,000 and its expected life span is 8 years. The machine is expected to reduce the production cost...
Study smarter with the SolutionInn App