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
108 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 equation of a line passing through (3, 5) and (6, 11)?
+
Find the derivative of f(x) = sin(x)cos(x)tan(x) - sec^2(x) + csc(x), where x is in radians.
+
Math question: Find the limit as x approaches a of (sqrt(x^2 + a^2) - a) / (x - a) using L'Hospital's Rule.
+
New questions in Mathematics
a runner wants to build endurance by running 9 mph for 20 min. How far will the runner travel in that time period?
Add. 7/w²+18w+81 + 1/w²-81
The patient is prescribed a course of 30 tablets. The tablets are prescribed “1 tablet twice a day”. How many days does a course of medication last?
5 . {2/5 + [ (8/-9) - (1/-7) + (-2/5) ] ÷ (2/-5)} . 8/15
-6(3x-4)=-6
Find the equation of the normal to the curve y=x²+4x-3 at point(1,2)
P is a polynomial defined by P(x) = 4x^3 - 11×^2 - 6x + 9. Two factors are (x - 3) and (x + 1). Rewrite the expression for P as the product of linear factors.
3x+2/2x-1 + 3+x/2x-1 - 3x-2/2x-1
Log(45)
3. A rock is dropped from a height of 16 ft. It is determined that its height (in feet) above ground t seconds later (for 0≤t≤3) is given by s(t)=-2t2 + 16. Find the average velocity of the rock over [0.2,0.21] time interval.
Using the bank and exact method, calculate the interest on capital 10000 at 12% annual nominal interest rate for the period from 15.3. 2016 until 10/10/2016
Jasminder has made 55% of the recipes in a particular cookbook. If there are 9 recipes that he has never made, how many recipes does the cookbook contain?
Write the detailed definition of a supply chain/logistics related maximization problem with 8 variables and 6 constraints. Each constraint should have at least 6 variables. Each constraint should have At least 5 variables will have a value greater than zero in the resulting solution. Variables may have decimal values. Type of equations is less than equal. Numbers and types of variables and constraints are important and strict. Model the problem and verify that is feasible, bounded and have at least 5 variables are nonzero.
A buyer purchased a North Carolina home for $475,250. The seller allowed the buyer to assume his first small mortgage with a loan balance of $110,000. How much is the excise tax paid in the transaction? $951 $729.50 $950.50 $221 none of the above
You buy a $475,000 house and put 15% down. If you take a 20 year amortization and the rate is 2.34%, what would the monthly payment be?
a) 6x − 5 > x + 20
Write the inequality in the form of a<x<b. |x| < c^2
2+2020202
Select a variable and collect at least 50 data values. For example, you may ask the students in the college how many hours they study per week or how old they are, etc. a. Explain what your target population was. b. State how the sample was selected. c. Summarise the data by using a frequency table. d. Calculate all the descriptive measures for the data and describe the data set using the measures. e. Present the data in an appropriate way. f. Write a paragraph summarizing the data.
In a school playground When going out for recess, 80 men and 75 women coexist, the Patio measures 10 meters For 40 meters (what will be the population density in the break