Question

CASE 6-1: PREPARE A PRODUCTION PLAN: WHAT PROBLEMS ARRIVE? Midwest Plastics Company has conducted profit planning for several years. The president stated (with justification) that inventory control and planning had not been satisfactory, which was mainly due to poor planning of production and inventory budgets. Please analyze and provide recommendations, in detail, on the issue regarding the 20B profit plan, which is now being prepared. Their analysis and recommendations will be presented to the executive committee. Despite the seasonality factor, the sales department has been successful in developing a sales plan, on a monthly basis, for each year. The following sales data is available for 20B. 1. Sales plan summary for 20B: 2. Finished goods inventory, as of January 1, 20B, is 96,000 units. 3. Work-in-process inventory will remain constant. 4. Actual annual sales in 20A, including the estimate for December, were 350,000 units. 5. The average finished goods inventory during 20A was 70,000 units. IT IS REQUESTED. 1. Prepare the annual production budget, assuming that management policy is to budget ending finished goods inventory at a standard quantity, based on the ratio of historical sales of 20A to inventory turnover. 2. Prepare a schedule showing sales, production, and inventory levels for each month, assuming: 1) stable inventory, 2) stable production, and 3) recommended inventory-production levels. In developing your recommendations, assume that the following policies have been established: a) The president has set the policy that a maximum inventory of 85,000 units and a minimum inventory of 75,000 units should be used, except in abnormal circumstances. b) A stable level of production is definitely preferred, except that during the holiday season in July and August, production may be reduced by 25 percent. Likewise, a variation in production of 7.5 percent above and below the average level is acceptable. 3. What are the main problems faced by the company in production planning? Make your general recommendations.

176

likes
880 views

Answer to a math question CASE 6-1: PREPARE A PRODUCTION PLAN: WHAT PROBLEMS ARRIVE? Midwest Plastics Company has conducted profit planning for several years. The president stated (with justification) that inventory control and planning had not been satisfactory, which was mainly due to poor planning of production and inventory budgets. Please analyze and provide recommendations, in detail, on the issue regarding the 20B profit plan, which is now being prepared. Their analysis and recommendations will be presented to the executive committee. Despite the seasonality factor, the sales department has been successful in developing a sales plan, on a monthly basis, for each year. The following sales data is available for 20B. 1. Sales plan summary for 20B: 2. Finished goods inventory, as of January 1, 20B, is 96,000 units. 3. Work-in-process inventory will remain constant. 4. Actual annual sales in 20A, including the estimate for December, were 350,000 units. 5. The average finished goods inventory during 20A was 70,000 units. IT IS REQUESTED. 1. Prepare the annual production budget, assuming that management policy is to budget ending finished goods inventory at a standard quantity, based on the ratio of historical sales of 20A to inventory turnover. 2. Prepare a schedule showing sales, production, and inventory levels for each month, assuming: 1) stable inventory, 2) stable production, and 3) recommended inventory-production levels. In developing your recommendations, assume that the following policies have been established: a) The president has set the policy that a maximum inventory of 85,000 units and a minimum inventory of 75,000 units should be used, except in abnormal circumstances. b) A stable level of production is definitely preferred, except that during the holiday season in July and August, production may be reduced by 25 percent. Likewise, a variation in production of 7.5 percent above and below the average level is acceptable. 3. What are the main problems faced by the company in production planning? Make your general recommendations.

Expert avatar
Rasheed
4.7
104 Answers
Midwest Plastics Company is facing challenges in production planning and inventory control, which have led to unsatisfactory results in previous profit plans. Let's address the issues and provide recommendations: **1. Annual Production Budget:** The company's management policy is to budget ending finished goods inventory at a standard quantity based on the ratio of historical sales in 20A to inventory turnover. This will ensure that inventory control is closely tied to historical sales trends. The formula for calculating the annual production target is: Annual Production Target = (Historical Sales / Average Inventory Turnover) Given data: - Historical Sales (20A) = 350,000 units - Beginning Inventory (January 1, 20B) = 96,000 units - Average Finished Goods Inventory during 20A = 70,000 units Average Inventory Turnover = (Beginning Inventory + Ending Inventory) / 2 Average Inventory Turnover = (96,000 + 70,000) / 2 = 83,000 units Annual Production Target = 350,000 / 83,000 ≈ 4.22 (rounded to the nearest whole unit) So, the annual production budget for 20B is approximately 4,220,000 units. **2. Sales, Production, and Inventory Schedule:** a) **Stable Inventory:** - Begin with the given January 1, 20B inventory of 96,000 units. - Calculate the monthly production required to maintain a stable inventory level between the maximum (85,000 units) and minimum (75,000 units) levels. Adjust production based on sales and inventory targets. b) **Stable Production:** - Calculate the average monthly production level based on the annual production budget (4,220,000 / 12 months). - During the holiday season in July and August, reduce production by 25 percent. - Adjust production for other months to meet the sales target while maintaining the desired inventory levels. c) **Recommended Inventory-Production Levels:** - Maintain a stable production level but adjust inventory to meet the recommended levels (75,000 to 85,000 units) based on company policy. - Calculate the monthly production and sales to achieve this balance. **3. Main Problems in Production Planning:** a) Poor planning of production and inventory budgets. b) Insufficient consideration of seasonality in production planning. c) Inventory turnover not optimized. **General Recommendations:** a) Implement more accurate and dynamic production and inventory budgeting procedures that take into account historical sales data and inventory turnover ratios. b) Develop a robust seasonality plan, especially for the holiday season in July and August, by adjusting production levels. c) Continuously monitor and optimize inventory turnover within the recommended range of 75,000 to 85,000 units to minimize holding costs and maintain customer service levels. By following these recommendations and creating detailed monthly plans based on the scenarios outlined above, the company can better manage its production and inventory, improve profitability, and meet its targets. Regular review and adjustment of plans based on actual performance are essential for ongoing success in production planning.

Frequently asked questions (FAQs)
Question: What is the limit as x approaches 0 of (sin(x) - x)/x^3?
+
What is the length of the altitude of a triangle with base 10 cm and height 6 cm?
+
What is the derivative of sin(x) + cos(x) - tan(x) - sec(x) + csc(x) - cot(x) ?
+
New questions in Mathematics
Hey👋🏻 Tap "Create New Task" to send your math problem. One of our experts will start working on it right away!
reduction method 2x-y=13 x+y=-1
-6n+5=-13
The derivative of a power is obtained just by subtracting 1 from the power True or false
The length and breadth of my rectangular vegetable garden is 12,5m and 7,25m respectively. What is the perimeter of the garden?
(5-(4-3)*3)-(8+5))
1. Suppose we have a good whose quantity supplied changed from 100 to 120 units when the price increased from $10 to $12 per unit. Compute the price elasticity of supply using the midpoint method
(2x+5)^3+(x-3)(x+3)
calculate the normal vector of line y = -0.75x + 3
logy/logx + logz/logy + logt/logz = 8x².t x=?
calculate the area in square units of A rectangle with length 6cm and breadth 5cm
Suppose that you use 4.29 g of Iron in the chemical reaction: 2Fe(s) + 3 Cu2 + (aq) 2Fe 3 + (aq) + 3Cu(s ) - . What is the theoretical yield of Cu (s), in grams?
A circular window has a rubber molding around the edge. If the window has a radius of 250 mm, how long is the piece of molding that is required ? (To the nearest mm)
Exercise 1 An ejidal association wishes to determine the distribution for the three different crops that it can plant for the next season on its available 900 hectares. Information on the total available and how many resources are required for each hectare of cultivation is shown in the following tables: Total available resource Water 15,000 m3 Fertilizer 5,000 kg Labor 125 day laborers Requirements per cultivated hectare Corn Soybeans Wheat Water 15 25 20 Fertilizer 5 8 7 Labor** 1/8 1/5 1/4 *The data in fraction means that with one day laborer it will be possible to care for 8, 5 and 4 hectares respectively. * Sales of crops 1 and 3, according to information from the Department of Agriculture, are guaranteed and exceed the capacity of the cooperative. However, soybeans must be limited to a maximum of 150 hectares. On the other hand, the profits for each hectare of crop obtained are estimated at: $7,500 for corn, $8,500 for soybeans and $8,000 for wheat. The objectives are to determine: • How many hectares of each crop must be allocated so that the profit is maximum. R= • The estimated profits for the ejidal cooperative in the next growing season. R=
0.1x8.2
392929-9
ind the z-score for which 72% of the distribution's area lies between -z and z. -1.7417, 1.7417 -1.1538, 1.1538 -1.0803, 1.0803 -2.826, 2.826
A psychologist is investigating the levels of test anxiety in various university courses. Anxiety is measured on a scale ranging from 0 to 100, where 0 indicates the complete absence of anxiety and 100 represents an extreme level of anxiety. From the data obtained, it has been discovered that the psychology score is triple that of nursing, and in turn, the latter has a score 10 points lower than the nutrition major. Furthermore, the score in the veterinary degree is 15 points higher than that of nutrition. Finally, if we add the scores of all the races, we will obtain a total of 173 points. Pose the equation that represents the situation described in the previous problem and determine: What is the score that psychology obtained regarding its anxiety level before the exams?
A candy manufacturer must monitor deviations in the amount of sugar in their products They want their products to meet standards. They selected a random sample of 20 candies and found that the sandard deviation of that sample is 1.7. What is the probabilty of finding a sample variance as high or higher if the population variance is actually 3277 Assume the population distribution is normal.
A gas is leaking at 3.5ft3/min in a room of 2.9m by 6.9ft by 15.7m. How long would it take (in seconds) for 22% of the room to reach the LFL, if the gas has a LFL of 2.51%?