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)
What is 0.75 written as a percentage?
+
Math question: Determine the absolute extrema of the function f(x) = x^3 - 8x^2 + 12x + 6 on the interval [-2, 4].
+
Question: What is the volume of a cube with side length 's' and surface area 'A'?
+
New questions in Mathematics
8x²-30x-10x²+70x=-30x+10x²-20x²
Since one of the three integers whose product is (-60) is (+4), write the values that two integers can take.
Imagine that you are in an electronics store and you want to calculate the final price of a product after applying a discount. The product you are interested in has an original price of $1000 MN, but, for today, the store offers a 25% discount on all its products. Develop an algorithm that allows you to calculate the final price you will pay, but first point out the elements.
How do you think the company has increased or decreased its income?
x/20*100
The mean temperature for july in H-town 73 degrees fahrenheit. Assuming that the distribution of temperature is normal what would the standart deviation have to be if 5% of the days in july have a temperature of at least 87 degrees?
find x in the equation 2x-4=6
The cost of unleaded gasoline in the Bay Area once followed an unknown distribution with a mean of $4.59 and a standard deviation of $0.10. Sixteen gas stations from the Bay Area are randomly chosen. We are interested in the average cost of gasoline for the 16 gas stations. 84. Find the probability that the average price for 30 gas stations is less than $4.55. a 0.6554 b 0.3446 c 0.0142 d 0.9858 e 0
Suppose you have a sample of 100 values from a population with mean mu = 500 and standard deviation sigma = 80. Given that P(z < −1.25) = 0.10565 and P(z < 1.25) = 0.89435, the probability that the sample mean is in the interval (490, 510) is: A)78.87% B)89.44% C)10.57% D)68.27%
Lim x → 0 (2x ^ 3 - 10x ^ 7) / 5 * x ^ 3 - 4x )=2
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?
From 1975 through 2020 the mean annual gain of the Dow Jones Industrial Average was 652. A random sample of 34 years is selected from this population. What is the probability that the mean gain for the sample was between 400 and 800? Assume the standard deviation is 1539
On+January+10+2023+the+CONSTRUCTORA+DEL+ORIENTE+SAC+company+acquires+land+to+develop+a+real estate+project%2C+which+prev%C3% A9+enable+50+lots+for+commercial+use+valued+in+S%2F+50%2C000.00+each+one%2C+the+company+has+as+a+business+model+generate+ cash+flow+through%C3%A9s+of+the+rental%2C+so+47%2C+of+the+50+enabled+lots+are+planned to lease+47%2C+and+ the+rest+will be%C3%A1n+used+by+the+company+for+management%C3%B3n+and+land+control
Calculate the change in internal energy of a gas that receives 16000 J of heat at constant pressure (1.3 atm) expanding from 0.100 m3 to 0.200 m3. Question 1Answer to. 7050J b. 2125J c. None of the above d. 2828J and. 10295 J
We have two distributions: A (M = 66.7, 95% CI = [60.3, 67.1]) / B (M = 71.3 95% CI = [67.7, 74.9]). Erin maintains that B is significantly larger than A. Provide your opinion on Erin’s argument and justify your opinion.
To paint a 250 m wall, a number of workers were employed. If the wall were 30 m longer, 9 more workers would be needed. How many were employed at the beginning?
Dano forgot his computer password. The password was four characters long. Dano remembered only three characters: 3, g, N. The last character was one of the numbers 3, 5, 7, 9. How many possible expansions are there for Dano's password?
The company produces a product with a variable cost of $90 per unit. With fixed costs of $150,000 and a selling price of $1,200 per item, how many units must be sold to achieve a profit of $400,000?
Exercise The temperature T in degrees Celsius of a chemical reaction is given as a function of time t, expressed in minutes, by the function defined on ¿ by: T (t )=(20 t +10)e−0.5t. 1) What is the initial temperature? 2) Show that T' (t )=(−10 t +15)e−0 .5t. 3) Study the sign of T' (t ), then draw up the table of variations of T . We do not ask for the limit of T in +∞. 4) What is the maximum temperature reached by the reaction chemical. We will give an approximate value to within 10−2. 5) After how long does the temperature T go back down to its initial value? We will give an approximate value of this time in minutes and seconds. DM 2: study of a function Exercise The temperature T in degrees Celsius of a chemical reaction is given as a function of time t, expressed in minutes, by the function defined on ¿ by: T (t )=(20 t +10)e−0.5t. 1) What is the initial temperature? 2) Show that T' (t )=(−10 t +15)e−0.5 t. 3) Study the sign of T' (t ), then draw up the table of variations of T . We do not ask for the limit of T in +∞. 4) What is the maximum temperature reached by the reaction chemical. We will give an approximate value to within 10−2. 5) After how long does the temperature T go back down to its initial value? We will give an approximate value of this time in minutes and seconds.
(3b)⋅(5b^2)⋅(6b^3)