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)
Math question: Find the x-intercept of the graph y = -2x + 6.
+
Math question: How many centimeters are in 3 meters?
+
Math question: What is the derivative of f(x) = 5x^3 - 2x^2 + 4x + 9?
+
New questions in Mathematics
Eight acts are scheduled to perform in a variety show how many different ways are there to schedule their appearances show your work
The function g:Q→Q is a ring homomorphism such that g(3)=3 and g(5)=5. What are the values of g(8) and g(9)?
Identify a pattern in the list of numbers.Then use this pattern to find the next number. 37,31,25,19,13
calculate the normal vector of line y = -0.75x + 3
Desarrolla (2x)(3y + 2x)5
(5y 9)-(y 7)
find f(x) for f'(x)=3x+7
User Before the election, a poll of 60 voters found the proportion who support the Green candidate to be 25%. Calculate the 90% confidence interval for the population parameter. (Give your answers as a PERCENTAGE rounded to TWO DECIMAL PLACES: exclude any trailing zeros and DO NOT INSERT THE % SIGN) Give the lower limit of the 90% confidence interval Give the upper limit of the 90% confidence interval
A box of numbered pens has 12 red, 12 blue, 12 green and 12 yellow pens. The pens for each colour are numbered from 1 to 12. There is a unique number on each pen, so no pen is exactly the same as any other pen in the box. When reaching into the box to randomly draw five pens without replacement, what is the proportion of getting exactly four pens of the same colour (Note: the numbers matter but the order does not)?
John he’s going to the carnival with his friends. He spends $25 on an admission ticket. He buys 10 games at X dollars each and two boxes of popcorn at Y dollars each. Write an expression to show the total cost of admission game, tickets and popcorn.
Quadratic equation 2X = 15/X + 7
A company made 150,000 in the first year 145,000 in the second 140,000 in the third year successively during the first decade of this company's existence it made a total of
Sections of steel tube having an inside diameter of 9 inches, are filled with concrete to support the main floor girder in a building. If these posts are 12 feet long and there are 18 of them, how many cubic yards of concrete are required for the job?
In poker, a full house consists of five cards, where two of the cards have the same number (or letter) and the remaining three also have the same number (or letter) as each other (but not as the previous two cards). Use a search engine or Wikipedia to understand the concept better if necessary. In how many different ways can one obtain a full house?
A person runs 175 yards per minute write a variable that represents the relationship between time and distance
How do you convert a fraction to a decimal
if y=1/w^2 yw=2-x; find dy/dx
Marc, Jean and Michelle have traveled a lot. Marc drove twice as much as Jean, but it was Michelle who drove the most with 100km more than Marc. They respected their objective of not exceeding 1350km of distance. How far did John drive?
How many digits are there in Hindu-Arabic form of numeral 26 Γ— 1011
Dano forgot his computer password. The password was four characters long. Dano remembered only three characters: 3, g, N. The last character was one of the numbers 3, 5, 7, 9. How many possible expansions are there for Dano's password?