APPENDIX 3A Free Range, Inc. On December 28, 2013, Joan Davenport was reviewing the forecast for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
APPENDIX 3A Free Range, Inc.² On December 28, 2013, Joan Davenport was reviewing the forecast for the GD49-GD175 supplement compound. The forecasts for the GD supplements were to be used as the basis for developing aggregate monthly production plans for the Free Range, Inc. The demand for the GD supplement showed an exaggerated seasonal pattern. Joan felt that it was particularly important to have well-developed plans for the product line because competition was heating up. Customer service and goodwill were being threat- ened by the policy of hiring and firing. She was confident that the historical sales data were accurate enough for production planning for the GD product line. The GD division of the company produced a number of products that were sold to various poultry farms throughout the world. The GD supplements were added to prepared dietary compounds given to organic poultry during the winter months when there was insufficient feed from grazing. The sales of the GD products increased sharply during the winter months, when most of the customers purchased the GD products on an as-needed basis. Although the company had tried a number of incentives to get its customers to stockpile the supplement during the slack season, it had no success. In addition, its customers demanded immediate service and would rarely accept a back order when a particular supplement was out of stock. The GD supplement division employed manual labor, and the jobs generally required very little training. Although labor was readily available, there were some difficulties in hir- ing the people when needed. In addition, the company had developed a policy of hiring on a monthly basis. Employment varied considerably during the year, and in 2013, it had been as low as 50 and as high as 250 employees. This great variability led to increased union activity, and the company expected the union to demand increased compensation for layoffs. A recently passed labor law already provided for a large increase in the sever- ance payment to employees laid off. This severance was now mandatory for all employees, even those who had been employed less than a month. The monthly employment and pro- duction for the year 2013 are shown in Table A.1. The wages for manual labor at the plant were approximately the equivalent of $10 per hour for regular time. The employees were paid time and one-half for overtime, and overtime was restricted to no more than 10 hours a week over the normal 40-hour week. The new labor law virtually guaranteed a full month's regular pay for all employees whether or not they were uti- lized for the entire month. This was in addition to any severance pay. For planning purposes, the company used $1,800 per month as the base wage for each employee. On the average, each employee produced 1,000 pounds of GD supplement in a month. If he or she worked the max- imum overtime, the expected production would be 1,200 pounds during the month. In considering some of the other factors relevant to the production planning problem, Joan estimated that, under the new labor law, the costs of laying off a worker could be as much as $900. This estimate included the direct severance pay benefits under the new law, the paper- work and filing that needed to be done with the union. Although labor was generally available, there was always cost associated with hiring. Joan estimated the screening, paperwork, company introduction, and preliminary training costs to average approximately $175 per person hired. Any smoothing of employment levels would result in an accumulation of inventories; therefore, some provision would have to be made to carry these inventories. Only limited Table A.1 MONTH January February March April May June July August September October November December 2013 Production and Employment space was available at the plant; therefore, additional space would have to be rented. In addition, the cost of capital is high because of the company's low credit rating. Taking all of these factors into account, Joan estimated the cost of storing 1,000 pounds of product for one month to be nearly $120. The company had a policy of trying to maintain a buffer inventory to improve customer service. The management team recently decided that, for planning purposes, the minimum inventory level should be 10,000 pounds to provide sufficient buffer inventory. MONTH January February March 2013 PRODUCTION 1,000s 55 57 63 75 121 187 234 263 222 148 120 107 Simulating the Aggregate Planning Process Joan felt that a useful approach for determining the cost of alternative production plans was to develop a simulation based on the 2013 sales forecast. The forecast of the monthly sales for 2014 is presented in Table A.2. For simplicity in the simulation, she decided to use 12 average months to represent the year rather than actual months of varying length. This enabled her to use 1,000 pounds per month as the production rate for a worker on regular time for a month. Each employee on the payroll in any month would be paid the $1,800 base wage. Overtime would be limited to 25 percent of regular time and would be compensated for at a premium rate of 50 percent. April May June NUMBER OF EMPLOYEES The two variables in the production plan are the number of workers and the monthly production rate. Idle time could be specified as a part of the production plan. As an example, if 100 workers are specified to produce 90,000 pounds in a month with all workers receiving their full base wage equivalent. On the other hand, overtime could be scheduled, up to 25 percent over regular time, by specifying production in excess of the production capability on regular time. Joan also knew that she must meet the demand requirements and maintain the minimum inventory for each month in the plan. July August September October There were 100 production employees on the payroll in December 2013, and Joan wondered whether any of those should be laid off for January. With the current produc- tion schedule, the company would end up at the end of December with very close to the 10,000-pound minimum inventory requirement. Joan was most interested in comparing Table A.2 2014 Production and Employment November December 50 50 50 90 120 150 200 250 250 130 130 100 2014 PRODUCTION 1,000s 60 60 60 80 130 200 250 280 240 170 150 120 a pure level production plan, or one with a minimum number of hirings and firings, with the current policy of changing the workforce each month to meet the estimated production requirements. She also wanted to evaluate a hybrid with fewer hirings and firings than what would be required under the current policy. I need to see how to do the hybrid aggrgate planning strategy when solving this. I need to see the worked out formulas for the excel. DO NOT USE PURE CHASE MEATHOD. APPENDIX 3A Free Range, Inc.² On December 28, 2013, Joan Davenport was reviewing the forecast for the GD49-GD175 supplement compound. The forecasts for the GD supplements were to be used as the basis for developing aggregate monthly production plans for the Free Range, Inc. The demand for the GD supplement showed an exaggerated seasonal pattern. Joan felt that it was particularly important to have well-developed plans for the product line because competition was heating up. Customer service and goodwill were being threat- ened by the policy of hiring and firing. She was confident that the historical sales data were accurate enough for production planning for the GD product line. The GD division of the company produced a number of products that were sold to various poultry farms throughout the world. The GD supplements were added to prepared dietary compounds given to organic poultry during the winter months when there was insufficient feed from grazing. The sales of the GD products increased sharply during the winter months, when most of the customers purchased the GD products on an as-needed basis. Although the company had tried a number of incentives to get its customers to stockpile the supplement during the slack season, it had no success. In addition, its customers demanded immediate service and would rarely accept a back order when a particular supplement was out of stock. The GD supplement division employed manual labor, and the jobs generally required very little training. Although labor was readily available, there were some difficulties in hir- ing the people when needed. In addition, the company had developed a policy of hiring on a monthly basis. Employment varied considerably during the year, and in 2013, it had been as low as 50 and as high as 250 employees. This great variability led to increased union activity, and the company expected the union to demand increased compensation for layoffs. A recently passed labor law already provided for a large increase in the sever- ance payment to employees laid off. This severance was now mandatory for all employees, even those who had been employed less than a month. The monthly employment and pro- duction for the year 2013 are shown in Table A.1. The wages for manual labor at the plant were approximately the equivalent of $10 per hour for regular time. The employees were paid time and one-half for overtime, and overtime was restricted to no more than 10 hours a week over the normal 40-hour week. The new labor law virtually guaranteed a full month's regular pay for all employees whether or not they were uti- lized for the entire month. This was in addition to any severance pay. For planning purposes, the company used $1,800 per month as the base wage for each employee. On the average, each employee produced 1,000 pounds of GD supplement in a month. If he or she worked the max- imum overtime, the expected production would be 1,200 pounds during the month. In considering some of the other factors relevant to the production planning problem, Joan estimated that, under the new labor law, the costs of laying off a worker could be as much as $900. This estimate included the direct severance pay benefits under the new law, the paper- work and filing that needed to be done with the union. Although labor was generally available, there was always cost associated with hiring. Joan estimated the screening, paperwork, company introduction, and preliminary training costs to average approximately $175 per person hired. Any smoothing of employment levels would result in an accumulation of inventories; therefore, some provision would have to be made to carry these inventories. Only limited Table A.1 MONTH January February March April May June July August September October November December 2013 Production and Employment space was available at the plant; therefore, additional space would have to be rented. In addition, the cost of capital is high because of the company's low credit rating. Taking all of these factors into account, Joan estimated the cost of storing 1,000 pounds of product for one month to be nearly $120. The company had a policy of trying to maintain a buffer inventory to improve customer service. The management team recently decided that, for planning purposes, the minimum inventory level should be 10,000 pounds to provide sufficient buffer inventory. MONTH January February March 2013 PRODUCTION 1,000s 55 57 63 75 121 187 234 263 222 148 120 107 Simulating the Aggregate Planning Process Joan felt that a useful approach for determining the cost of alternative production plans was to develop a simulation based on the 2013 sales forecast. The forecast of the monthly sales for 2014 is presented in Table A.2. For simplicity in the simulation, she decided to use 12 average months to represent the year rather than actual months of varying length. This enabled her to use 1,000 pounds per month as the production rate for a worker on regular time for a month. Each employee on the payroll in any month would be paid the $1,800 base wage. Overtime would be limited to 25 percent of regular time and would be compensated for at a premium rate of 50 percent. April May June NUMBER OF EMPLOYEES The two variables in the production plan are the number of workers and the monthly production rate. Idle time could be specified as a part of the production plan. As an example, if 100 workers are specified to produce 90,000 pounds in a month with all workers receiving their full base wage equivalent. On the other hand, overtime could be scheduled, up to 25 percent over regular time, by specifying production in excess of the production capability on regular time. Joan also knew that she must meet the demand requirements and maintain the minimum inventory for each month in the plan. July August September October There were 100 production employees on the payroll in December 2013, and Joan wondered whether any of those should be laid off for January. With the current produc- tion schedule, the company would end up at the end of December with very close to the 10,000-pound minimum inventory requirement. Joan was most interested in comparing Table A.2 2014 Production and Employment November December 50 50 50 90 120 150 200 250 250 130 130 100 2014 PRODUCTION 1,000s 60 60 60 80 130 200 250 280 240 170 150 120 a pure level production plan, or one with a minimum number of hirings and firings, with the current policy of changing the workforce each month to meet the estimated production requirements. She also wanted to evaluate a hybrid with fewer hirings and firings than what would be required under the current policy. I need to see how to do the hybrid aggrgate planning strategy when solving this. I need to see the worked out formulas for the excel. DO NOT USE PURE CHASE MEATHOD.
Expert Answer:
Answer rating: 100% (QA)
Question We need to first find the demand and then average demand per month to create a level strategy Total demand 18001000s 10 safety stock Beginning inventory 10 Therefore total production needed 1... View the full answer
Related Book For
Intermediate accounting
ISBN: 978-0077647094
7th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson
Posted Date:
Students also viewed these general management questions
-
The circuit of Fig. 4.46c is to be used as a band-gap reference. If the op amp is ideal, its differential input voltage and current are both zero and V OUT = (V BE1 + I 1 R 1 ) = (V BE1 + I 2 R 2 ) V...
-
Exercise 11. Show that the natural base e is not in Q. Here, you will have to use the fact that e = k=0 1 k! Remark. Proving e is transcendental is significantly more difficult and, if I have to...
-
Identify three statistics that can be used as a basis for testing the utility of a regression.
-
Explain incremental cash flow, externality? Why is timing of cash flows important? What is scenario analysis? Would a project's NPV for a firm be higher or lower if the firm used accelerated rather...
-
What is reliability?
-
The Atlantic Grocery chain operates in major metropolitan areas on the eastern seaboard. The stores have a no-frills approach, with low overhead and high volume. They generally buy their stock in...
-
Walt Disney reports the following information for its two Parks and Resorts divisions. Assume Walt Disney uses a balanced scorecard and sets a target of 85% occupancy in its resorts. Using Exhibit...
-
Public University Transactions. The Statement of Net Assets of Green Tree State University, a governmentally owned university, as of the end of its fiscal year June 30, 2010, follows. The following...
-
Problem 4. Consider the following imperfect information game. Notice that both play- ers have two information sets. 5,2 1 a b 2 t 1 d d 4,3 6.0 4,6 0,4 6,0 (a) Find all subgame perfect Nash...
-
Worldwide, over a billion solder balls must be manufactured daily for assembling electronics packages. The uniform droplet spray method uses a piezoelectric device to vibrate a shaft in a pot of...
-
On 1 January 2013 a life insurance company issued a number of whole life insurance policies with sum insured $100,000 to select lives then aged 40. Level premiums are paid annually in advance and the...
-
What critical factors do leaders need to consider when setting goals and objectives?
-
Why do data need to be translated into useful information?
-
A consultant was asked to work with a large academic medical centers top leaders on their strategies and future plans. The leaders exhibited a great passion and desire to improve their organization...
-
Select a GPO. Identify its locations, services, facilities, and sites, and determine the criteria for membership.
-
Why is it not preferable to have more than seven strategic priorities? Would it be better to have fewer?
-
Potential crowd management strategies include: Adhere to industry standards where applicable, Conduct staff training, Establish plans, policies and procedures, Provide adequate parking and traffic...
-
A copper wire (density = 8.96 g/cm 3 ) has a diameter of 0.25 mm. If a sample of this copper wire has a mass of 22 g, how long is the wire?
-
Terms of a lease agreement and related facts were: a. Leased asset has a retail cash selling price of $100,000. Its useful life is six years. b. Annual lease payments at the beginning of each year...
-
The following questions are adapted from a variety of sources including questions developed by the AICPA Board of Examiners and those used in the Kaplan CPA Review Course to study pensions and other...
-
On March 31, 2013, Southwest Gas leased equipment from a supplier and agreed to pay $200,000 annually for 20 years beginning March 31, 2014. Generally accepted accounting principles require that a...
-
Discuss the main differences between the traditional and the modern finance paradigm in understanding the behavior of individual investors.
-
Discuss the disposition effect and the proposed explanations for this effect.
-
Define and describe the process of worrying within the finance domain.
Study smarter with the SolutionInn App