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
106 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 the sum of the factors of 36?
+
What is the value of the square root function at x = 16?
+
How do you convert 45 degrees to radians?
+
New questions in Mathematics
5(4x+3)=75
I) Find the directional derivative of 𝑓(𝑥, 𝑦) = 𝑥 sin 𝑦 at (1,0) in the direction of the unit vector that make an angle of 𝜋/4 with positive 𝑥-axis.
2.3/-71.32
78 percent to a decimal
solve for x 50x+ 120 (176-x)= 17340
You mix a powder drug with a 4.5ml of liquid to get a reconstituted solution with a concentration of 250mg/ml. The prescribers order is for 500 mg . You will give what ml of the reconstituted solution
During a fishing trip Alex notices that the height h of the tide (in metres) is given by h=1−(1/2)*cos(πt/6) where t is measued in hours from the start of the trip. (a) Enter the exact value of h at the start of the trip in the box below.
A mutual fund manager has a $350 million portfolio with a beta of 1.10. The risk-free rate is 3.5%, and the market risk premium is 6.00%. The manager expects to receive an additional $150 million which she plans to invest in several different stocks. After investing the additional funds, she wants to reduce the portfolio’s risk level so that once the additional funds are invested the portfolio’s required return will be 9.20%. What must the average beta of the new stocks added to the portfolio be (not the new portfolio’s beta) to achieve the desired required rate of return?
User The average height of Aranka, Böske, Cili, Delinke and Lili is 172 cm. We know that Aranka and Cili are both 172 cm tall. The sum of the heights of Böské and Delinke is 336 cm. How tall is Lili?
Let A, B, C and D be sets such that | A| = |C| and |B| = |D|. Prove that |A × B| = |C × D|
You are the newly appointed transport manager for Super Trucking (Pty) Ltd, which operates as a logistics service provider for various industries throughout southern Africa. One of these vehicles is a 4x2 Rigid Truck and drawbar trailer that covers 48,000 km per year. Use the assumptions below to answer the following questions (show all calculations): Overheads R 176,200 Cost of capital (% of purchase price per annum) 11.25% Annual License Fees—Truck R 16,100 Driver Monthly cost R 18,700 Assistant Monthly cost R 10,500 Purchase price: - Truck R 1,130,000 Depreciation: straight line method Truck residual value 25% Truck economic life (years) 5 Purchase price: Trailer R 370,000 Tyre usage and cost (c/km) 127 Trailer residual value 0% Trailer economic life (years) 10 Annual License Fees—Trailer R 7,700 Fuel consumption (liters/100km) 22 Fuel price (c/liter) 2053 Insurance (% of cost price) 7.5% Maintenance cost (c/km) 105 Distance travelled per year (km) 48000 Truck (tyres) 6 Trailer (tyres) 8 New tyre price (each) R 13,400 Lubricants (% of fuel cost) 2.5% Working weeks 50 Working days 5 days / week Profit margin 25% VAT 15% Q1. Calculate the annual total vehicle costs (TVC)
Which of the methods below can be used to workout 95% of an amount? a. Dividing the amount 100 and multiply by 95 b. Working out 5% of the amount and taking it away from the full amount c. Dividing 95 by 100 and multiplying the answer by the amount d. Dividing the amount by 95 and then multiply by 100
Express the trigonometric form of the complex z = -1 + i.
A,B,C and D are the corners of a rectangular building. Find the lengths the diagonals if AB measures 38' - 9" and AD measures 56' - 3"
How to convert 45 kg into grams
17. A loan for $104259 is taken out for 10 years with an annual interest rate of 9.4%, compounded quarterly. What quarterly payment is required to pay the loan off in 10 years? Enter to the nearest cent (two decimals). Do not use $ signs or commas in the answer.
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
8. Measurement Jillian measured the distance around a small fish pond to be 27 yards. What would be a good estimate of the distance across the pond: 14 yards, 9 yards, or 7 yards? Explain how you decided.
How much does 7.2 moles of ammonium dichromate weigh? (NH4)2Cr2O7
To apply a diagnostic test, in how many ways can 14 students be chosen out of 25? if the order does not matter