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)
What are the coordinates of a point on the ellipse with equation (x-h)^2/a^2 + (y-k)^2/b^2 = 1?
+
Math question: Graph the system of inequalities: y > 2x - 3 and y ≤ -3x + 2. (
+
What is the trend of sales for a company over the past 5 years?
+
New questions in Mathematics
Let f(x)=||x|−6|+|15−|x|| . Then f(6)+f(15) is equal to:
Let the vectors be u=(-1,0,2) , v=(0,2,-3) , w=(2,2,3) Calculate the following expressions a)<u,w> b) &lt;2u- 5v,3w&gt;
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?
Solve: −3(−2x+23)+12=6(−4x+9)+9.
Determine all solutions to the inequality |2x + 6| − |x + 1| < 6. Write your final answer in interval notation
(-5/6)-(-5/4)
-27=-7u 5(u-3)
The physician orders 15mg of tramadol(liquid). On hand is 30mg/2mL vials. How many mL will the MA administer?
Engineers want to design seats in commercial aircraft so that they are wide enough to fit ​95% of all males.​ (Accommodating 100% of males would require very wide seats that would be much too​ expensive.) Men have hip breadths that are normally distributed with a mean of 14.4 in. and a standard deviation of 1.2 in. Find P95. That​ is, find the hip breadth for men that separates the smallest ​95% from the largest 5​%.
Use a pattern to prove that (-2)-(-3)=1
9 x² + 2x + 1 = 0
2x2
Two particles of electrical charges Q1=3.8×10-⁶C and q,=4.4×10-⁶C are separated in vacuum by a distance of 4.0.10-⁸ m. Since K=9.0.10⁹ N.m²/C², the intensity of the interaction force between them, in newtons, is?
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
For the numbers below, select a number at random and find the probability that: a. The number is even b. The sum of the number’s digit is even c. The number is greater than 50 2 3 5 7 11 13 17 19 23 29 31 37 41 43 47 53 59 61 67 71 73 79 83 89 97
Consider the function f(x)=1/2(x+1)^2-3. Use the preceding/following interval method to estimate the instantaneous rate of change at 𝑥 = 1.
56 × 12 = 672. How should you adjust this answer 672 to determine 57 × 12? a) The answer increases by 1 b) The answer increases by 57 c) The answer increases by 56 d) The answer increases by 12
Sodium 38.15 38.78 38.5 38.65 38.79 38.89 38.57 38.59 38.59 38.8 38.63 38.43 38.56 38.46 38.79 38.42 38.74 39.12 38.5 38.42 38.57 38.37 38.71 38.71 38.4 38.56 38.39 38.34 39.04 38.8 A supplier of bottled mineral water claims that his supply of water has an average sodium content of 36.6 mg/L. The boxplot below is of the sodium contents levels taken from a random sample of 30 bottles. With this data investigate the claim using SPSS to apply the appropriate test. Download the data and transfer it into SPSS. Check that your data transfer has been successful by obtaining the Std. Error of the mean for your data which should appear in SPSS output as 0.03900.. If you do not have this exact value, then you may have not transferred your data from the Excel file to SPSS correctly. Do not continue with the test until your value agrees as otherwise you may not have correct answers. Unless otherwise directed you should report all numeric values to the accuracy displayed in the SPSS output that is supplied when your data has been transferred correctly. In the following questions, all statistical tests should be carried out at the 0.05 significance level. Sample mean and median Complete the following concerning the mean and median of the data. mean =  mg/L 95% CI:  to  mg/L Based upon the 95% confidence interval, is it plausible that the average sodium content is 36.9 mg/L?      median:  mg/L The median value is      36.9 mg/L. Skewness Complete the following concerning the skewness of the data. Skewness statistic =        Std. Error =  The absolute value of the skewness statistic     less than 2 x Std. Error Therefore the data can be considered to come from a population that is      . Normality test Complete the following summary concerning the formal testing of the normality of the data. H0: The data come from a population that     normal H1: The data come from a population that     normal Application of the Shapiro-Wilk test indicated that the normality assumption     reasonable for sodium content (S-W(  )=  , p=   ). Main test Using the guidelines you have been taught that consider sample size, skewness and normality, choose and report the appropriate main test from the following ( Appropriate ONE ) You have selected that you wish to report the one-sample t-test. H0: The mean sodium content     equal to 36.9 mg/L H1: The mean sodium content     equal to 36.9 mg/L Application of the one-sample t-test indicated that the mean is      36.9 mg/L (t(  ) =  , p =   ). You have selected that you wish to report the Wilcoxon signed rank test. H0: The median sodium content     equal to 36.9 mg/L H1: The median sodium content     equal to 36.9 mg/L Application of the Wilcoxon signed rank test indicated that the median is      36.9 mg/L (z =  , N =  , p =   ).
The supply of a good registers periodic increases. With each increase in the offer, the total receipts of the bidders increase. Indicate the correct statement: a) demand is elastic b) demand is inelastic c) supply is inelastic d) supply has unit elasticity.
A gas is leaking at 3.5ft3/min in a room of 2.9m by 6.9ft by 15.7m. How long would it take (in seconds) for 22% of the room to reach the LFL, if the gas has a LFL of 2.51%?