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: What is the limit of (x^2 + 3x - 1)/(2x^2 - 5x + 2) as x approaches 1?
+
What is the area of a rectangle with length 10cm and width 5cm?
+
What is the equation of a parabola with its vertex at (-2, 4) that opens downward?
+
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?
find the value of the tangent if it is known that the cos@= 1 2 and the sine is negative. must perform procedures.
5 . {2/5 + [ (8/-9) - (1/-7) + (-2/5) ] ÷ (2/-5)} . 8/15
A hotel in the Algarve had to offer 1 week of vacation to one of its employees as an Easter gift in a random choice. It is known that 80 people work in this hotel unit, 41 of whom are Portuguese and 39 are foreign nationals. There are 14 Portuguese men and 23 foreign women. Using what you know about conditional probability, check the probability that the gift was offered to a Portuguese citizen, knowing that it was a woman.
If f(x) = 3x 2, what is the value of x so that f(x) = 11?
A mutual fund manager has a $350 million portfolio with a beta of 1.10. The risk-free rate is 3.5%, and the market risk premium is 6.00%. The manager expects to receive an additional $150 million which she plans to invest in several different stocks. After investing the additional funds, she wants to reduce the portfolio’s risk level so that once the additional funds are invested the portfolio’s required return will be 9.20%. What must the average beta of the new stocks added to the portfolio be (not the new portfolio’s beta) to achieve the desired required rate of return?
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?
7=-4/3y -1
Scores are normally distributed with a mean of 25 and standard deviation of 5. Find the probability that sixteen randomly selected students have a mean score that is less than 24.
Professor Vélez has withdrawn 40 monthly payments of $3,275 from her investment account. If the investment account yields 4% convertible monthly, how much did you have in your investment account one month before making the first withdrawal? (Since you started making withdrawals you have not made any deposits.)
In measuring the internal radius of a circular sewer the measurement is 2% too large. If this measurement is then used to calculate the circular cross-sectional area of the pipe: Determine, by using the binomial theory, the percentage error that will occur compared to the true area.
(X+2)(x+3)=4x+18
Determine the Linear function whose graph passes through the points (6, -2) and has slope 3.
The annual real property tax liability for a residential property is $4302 and has been paid by the seller in advance of closing. Using the 30-day month/260-day year method what will be the tax proration entry on the settlement statement round to the nearest dollar for a closing on Oct. 26 if the buyer owns the day of closing? a. $3525 credit to the buyer and $777 debit to the seller b. $777 debit to the buyer and $3525 debit to the seller c. $777 credit to the buyer and $777 debit to the seller d. $3525 debit to the buyer and $3525 credit to the seller *Can anyone help with this? I am studying for my real estate exam and am having trouble with some of the calculations :)
At the end of a lively discussion within your study group, your class neighbor, for the relevance of your points of view, asks your opinion on the subject of their debate which is the following question Am I the slave of my unconscious? Solve the problem posed by this subject in an argumentative production.
A 20,000 kg school bus is moving at 30 km per hour on a straight road. At that moment, it applies the brakes until it comes to a complete stop after 15 seconds. Calculate the acceleration and the force acting on the body.
a) 6x − 5 > x + 20
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 ?
9n + 7(-8 + 4k) use k=2 and n=3
23,456 + 3,451