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
105 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: In how many ways can a committee of 3 members be chosen from a group of 8 people?
+
What is the product of multiplying 35 by 12?
+
What is the result of factoring the mixed number 3 1/2 into a product of its prime factors?
+
New questions in Mathematics
A normal random variable x has a mean of 50 and a standard deviation of 10. Would it be unusual to see the value x = 0? Explain your answer.
Add. 7/w²+18w+81 + 1/w²-81
Determine all solutions to the inequality |2x + 6| − |x + 1| < 6. Write your final answer in interval notation
3(4x-1)-2(x+3)=7(x-1)+2
Find the root of x^4-10x^ 5=0 using Newton's method, with a precision of the smallest positive root.
Suppose 50% of the doctors and hospital are surgeons if a sample of 576 doctors is selected what is the probability that the sample proportion of surgeons will be greater than 55% round your answer to four decimal places
9b^2-6b-5
(2b) to the 1/4th power. Write the expression in radical form.
If f(x,y)=6xy^2+3y^3 find (∫3,-2) f(x,y)dx.
form a key for your lock containing the numbers 2 2 5 8 How many different keys can you form?
A recurring sequence is one where elements repeat after completing one standard. If the sequence AB8C14D96AB8C1... is recurring its twentieth term is equal to: (A) B. (B) 8. (C) A. (D) 6. (E) D.
Shows two blocks, masses 4.3 kg and 5.4 kg, being pushed across a frictionless surface by a 22.5-N horizontal force applied to the 4.3-kg block. A. What is the acceleration of the blocks? B. What is the force of the 4.3-kg block on the 5.4 -kg block? C. What is the force of the 5.4 -kg block on the 4.3 -kg block?
A company receives sales in $20 per book and $18 per calculator. The per unit cost to manufacture each book and calculator are $5 and 4$ respectively. The monthly (30 day) cost must not exceed $27000 per month. If the manufacturing equipment used by the company takes five minutes to produce a book and 15 minutes to produce a calculator, how many books and calculators should the company produce to maximise profit? Please solve graphically and
In an audience of 4000 people, 2 people are chosen, at random, to appear on stage. How many ways can the people be chosen?
Fill in the P(X-x) values to give a legitimate probability distribution for the discrete random variable X, whose possible values are -5 ,3 , 4, 5 , and 6.
viii. An ac circuit with a 80 μF capacitor in series with a coil of resistance 16Ω and inductance 160mH is connected to a 100V, 100 Hz supply is shown below. Calculate 7. the inductive reactance 8. the capacitive reactance 9. the circuit impedance and V-I phase angle θ 10. the circuit current I 11. the phasor voltages VR, VL, VC and VS 12. the resonance circuit frequency Also construct a fully labeled and appropriately ‘scaled’ voltage phasor diagram.
In a 24 hours period, the average number of boats arriving at a port is 10. Assuming that boats arrive at a random rate that is the same for all subintervals of equal length (i.e. the probability of a boat arriving during a 1 hour period the same for every 1 hour period no matter what). Calculate the probability that more than 1 boat will arrive during a 1 hour period. (P(X>1) ) Give your answers to 4 decimal places and in a range between 0 and 1
Find the set of points formed by the expression 𝜋<|𝑧−4+2𝑖|<3𝜋.
How many moles are there in 235 grams of potassium thiosulfate pentahydrate? K2S2O3*5(H2O)
Two trains leave stations 294 miles apart at the same time and travel toward each other. One train travels at 95 miles per hour while the other travels at 115 miles per hourHow long will it take for the two trains to meet?