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
107 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: Using the Extreme Value Theorem, find the highest and lowest possible values of a function f(x) = 2x^3 - 6x^2 + 3x + 1 on the interval [0, 5].
+
What is the limit of (3x^2 - 2x + 1) / (x - 1) as x approaches 1?
+
What is the standard deviation of the data set: 5, 8, 12, 15, 18?
+
New questions in Mathematics
A circle with a 12-inch diameter is folded in half and then folded in half again. What is the area of the resulting shape?
Write 32/25 as a percent
Evaluate limx→∞tan−1(x) using that y=tan−1(x) exactly when x=tan(y) . (Hint: Both tan and tan−1 are continuous!)
The Lenovo company manufactures laptop computers, it is known that for every 60 laptops produced, 54 go on the market with the highest quality standards. If a sample of 15 laptops is taken, calculate the probability that: Exactly 2 are not of high quality
3x+2/2x-1 + 3+x/2x-1 - 3x-2/2x-1
The data set (75, 85, 58, 72, 70, 75) is a random sample from the normal distribution No(µ, σ). Determine a 95% two-sided confidence interval for the mean µ .
224 × (6÷8)
Perpetual annuities are a series of payments whose duration has no end. Explain how can we calculate them, if they have no end?
A company that manufactures personal hygiene items purchases machinery for $220,000 that is considered to last 7 years; it is estimated that at the end of the period it will have a salvage value of $1000. Find: to. The depreciation rate. b. The book value at the end of the sixth year.
-3(-4x+5)=-6(7x-8)+9-10x
Log5 625
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.
Let v be the set of all ordered pairs of real numbers and consider the scalar addition and multiplication operations defined by: u+v=(x,y)+(s,t)=(x+s+1,y+t -two) au=a.(x,y)=(ax+a-1,ay-2a+2) It is known that this set with the operations defined above is a vector space. A) calculate u+v is au for u=(-2,3),v=(1,-2) and a=2 B) show that (0,0) #0 Suggestion find a vector W such that u+w=u C) who is the vector -u D) show that axiom A4 holds:-u+u=0
We have received our p&l statement back from accounts. The board has asked for an innovation hub. What items should we prioritise reviewing to decide if we can afford an innovation hub?
find missing measure for triangle area = 48 m square base = 10m heaighy = ? m
A house located within the city limits has a current market value of $325,000 according to a recent appraisal. The assessed value from the last county wide tax valuation is $272,475. The tax rate is $0.36 per hundred for the county and $0.72 per hundred for the city. What is the total annual property tax liability on the property? $2340 $3510 $1962 $2943
We plan to test whether the mean mRNA expression level differs between two strains of yeast, for each of 8,000 genes. We will measure the expression levels of each gene, in n samples of strain 1 and m samples of strain 2. We plan to compute a P-value for each gene, using an unpaired two-sample t-test for each gene (the particular type of test does not matter). a) What are the null hypotheses in these tests (in words)? [2] b) If, in fact, the two strains are identical, how many of these tests do we expect to produce a P-value exceeding 1/4? [2]
Calculate the area of the parallelogram with adjacent vertices (1,4, −2), (−3,1,6) 𝑦 (1, −2,3)
94 divided by 8.75
A grain silo has a height of 8.8m with a 11.4m diameter. If it is filled 0.5% of it's volume, how much grain (m^3) is stored in the silo? (0 decimal places)