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)
Math question: What is the smallest positive integer solution to the equation x^n + y^n = z^n, where n > 2, according to Fermat's Theorem? (
+
Convert the number 3.25 x 10^6 to standard notation.
+
Question: What is the integral of f(x) = 3x^2 - 2x + 1 over the interval [0, 4]?
+
New questions in Mathematics
How to find the value of x and y which satisfy both equations x-2y=24 and 8x-y=117
Convert the following function from standard form to vertex form f(x) = x^2 + 7x - 1
The sum of an infinite geometric series is 13,5 The sum of the same series, calculated from the third term is 1,5. Q. Calculate r if r>0.
A book is between 400 and 450 pages. If we count them 2 at a time there is none left over, if we count them 5 at a time there is none left over and if we count them 7 at a time there are none left over, how many pages does the book have?
two particles start at the origin and move along the x axis. for 0 <= t <= 10, their respective position functions are given by x1 = cos(t) and x2 = (e^-3t) + 1. for how many values of t do the particles have the same velocity?
The derivative of a power is obtained just by subtracting 1 from the power True or false
Given that y = ×(2x + 1)*, show that dy = (2x + 1)" (Ax + B) dx where n, A and B are constants to be found.
Two events E and F are​ ________ if the occurrence of event E in a probability experiment does not affect the probability of event F.
(2x+5)^3+(x-3)(x+3)
A job takes 9 workers 92 hours to finish. How many hours would it take 5 workers to complete the same job?
4x-3y=24 and 5x-2y=9 solve by elimination
4x/2+5x-3/6=7/8-1/4-x
Let r: x - y 5 = 0. Determine a general equation of the line s parallel to the line r, which forms an isosceles triangle with area 8 with the line x = 5 and the Ox axis.
Solve : 15/16 divide 12/8 =x/y
It is known that the content of milk that is actually in a bag distributes normally with an average of 900 grams and variance 25 square grams. Suppose that the cost in pesos of a bag of milk is given by 𝐶(𝑥) = { 3800 𝑠𝑖 𝑥 ≤ 890 4500 𝑠𝑖 𝑥 > 890 Find the expected cost.
Derivative of 2x
A property sold for $745,000 in a co-brokered transaction. The seller has agreed to pay a 7% commission to the listing firm. The listing firm has agreed to equally split the commission with the selling firm. If the buyer’s broker will receive 8% of the selling firm’s commission, how much commission will the buyer’s broker receive? $14,900 $3725 $$37250 $18625
Read the “Local Communities as Stakeholders: Does Amazon Really Need Tax Breaks?” example on p. 83 in Ch. 3 of Management: A Practical Introduction. In your response, discuss whether you feel that tax breaks for big companies benefit local communities. Describe ways to attract business to a region without having a negative impact on the larger community.
did an analysis of dropout from the nursing faculty at the Universidad Veracruzana. With a poblation of 122 students, it turned out that according to the gender data, the female sex predominates with 82%, and the male sex male is found with 12%. The main factors why students drop out are, first of all, "Not "re-enrolled" at 49%, second place "Personal reasons" at 20%, third place "change of school" in 11%, "lack of documents" and "economic reasons" in 7%, change of residence and lack of social service in 3%. Of this sample, how many students dropped out for other reasons?
Hola👋🏻 Toca en "Crear Nueva Tarea" para enviar tu problema de matemáticas. ¡Uno de nuestros expertos comenzará a trabajar en ello de inmediato!