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 is the sum of 3 4/5, 2 1/3, and 5 2/7?
+
What is the derivative of sin(2x^3 + 5x)^2 using the chain rule?
+
What is the mode of the following dataset? 5, 8, 10, 10, 12, 15.
+
New questions in Mathematics
Students Ana Beatriz and Paula decided to register on a website with exercises to study for upcoming simulations, but to register on this website, they need to choose a password consisting of five characters, three numbers and two letters (capital letters). or lowercase). Letters and numbers can be in any position. They know that the alphabet is made up of twenty-six letters and that an uppercase letter differs from a lowercase letter in a password. What is the total number of possible passwords for registering on this site?
1 + 1
Convert the following function from standard form to vertex form f(x) = x^2 + 7x - 1
8x²-30x-10x²+70x=-30x+10x²-20x²
A book is between 400 and 450 pages. If we count them 2 at a time there is none left over, if we count them 5 at a time there is none left over and if we count them 7 at a time there are none left over, how many pages does the book have?
The mean temperature for july in H-town 73 degrees fahrenheit. Assuming that the distribution of temperature is normal what would the standart deviation have to be if 5% of the days in july have a temperature of at least 87 degrees?
7273736363-8
Serum cholesterol levels in men aged 18 to 24 years have a normal distribution with a mean 178.1mg/100 ml and standard deviation 40.7 mg/100 ml. The. Randomly choosing a man between 18 and 24 years old, determine the probability of your serum cholesterol level is less than 200. B. Whether a serum cholesterol level should be judged too high if it is above 7% higher, determine the value of the separation level of levels that are too high. w. Determine a 90% reference range for serum cholesterol level among men from 18 to 24 years old.
how many arrangements can be made of 4 letters chosen from the letters of the world ABSOLUTE in which the S and U appear together
A pair of die is thrown and the absolute difference of the two scores is recorded. What is the probability of the absolute difference being 4 or more?
4x/2+5x-3/6=7/8-1/4-x
Find all real numbers x that satisfy the equation \sqrt{x^2-2}=\sqrt{3-x}
The Humane Society has asked for our help again this week. Currently they are charging $50 for an adoption fee. Unfortunately they just pulled this number out of the air and do not know why they are charging this amount. They would like to charge an amount that covers all the adoption costs – both the variable costs for adoptions as well as the fixed cost for the kennel portion of the Humane Shelter operations. We can help them by doing a breakeven analysis. During a client meeting we gathered these facts. There are 2 part-time employees that each earn $1000 per month. The utilities for the kennel area (water, electricity) are $200 per month. The average food cost for animals in the kennel is $800 per month. In addition, each animal that is adopted receives a rabies vaccination that costs $4 and is micro-chipped that costs $6. At the current cost of $50, how many animals must be adopted to break-even? What would break-even be at a $60 adoption fee? What would break-even be if the fee were lowered to $40? The newspaper has suggested that the Humane Society advertise to increase pet adoptions. The package that they have recommended costs $1000 for a very small ad run every day for a month. If the Humane Society does this extra advertising, how will it affect breakeven? Based on what you have learned about elasticity, what price do you recommend for the adoption fee?
Equine infectious anemia (EIA) is considered the main infectious disease in Brazilian equine farming, for which there is no effective vaccine or treatment. It is caused by a retrovirus of the genus Lentivirus, which affects horses, donkeys and mules and is transmitted in nature mainly by hematophagous insects of the genus Tabanidae. Researchers analyzed the records of 9,439 equids from Acre, submitted to the agar gel immunodiffusion test (AGID) for equine infectious anemia (EIA), between 1986 and 1996. Of these, 6199 tested positive for equine infectious anemia (EIA) . Knowing that the age of AIE-positive horses follows a Normal distribution with a mean of 5 years and a standard deviation of 1.5 years, determine the expected number of AIE-positive horses in the Acre sample that will be aged less than or equal to 3 years. ATTENTION: Provide the answer to exactly FOUR decimal places.
DuocUC 2) The cost C, in pesos, for the production of x meters of a certain fabric can be calculated through the function: (x+185) C(x)=81300-6x+ 20000 a) It is known that C(90) 5.344. Interpret this result. (2 points) b) Calculate C'(x) (2 points) 3 x²+111x-0.87 20000 2000 c) Function C calculates the cost while producing a maximum of 500 meters of fabric. Determine the values of x at which the cost of production is increasing and the values of x at which the cost is decreasing. (3 points) d) If a maximum of 500 meters of fabric are produced, what is the minimum production cost? (
Translate to an equation and solve. Let x be the unknown number: What number is 52% of 81.
x²-7x+12=0
there are 500,000 bacteria at the end of a pin point. 1000 bacteria can make a person sick. then bacteria at the tip of a pin point can make 500 people sick. Also, many people do not know that bacteria can (reproduce). Let's say there are 5 bacteria and we leave it for 15 minutes. bacteria will multiply to 10. if left for up to 30 minutes, 20 bacteria will form. if left up to 45 minutes. bacteria will multiply up to 40. every 15 minutes the bacteria will double 2. if you start with five bacteria that reproduce every 15 minutes, how manu bacteria would you have after 12 hours ?
What js the greatest 4-digit even number that can be formed by 3,6,1,4?
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