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
56 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)
Question: What is the definition of an integral and how does it relate to finding the area under a curve?
+
What is the volume of a rectangular prism with length 5 ft, width 3 ft, and height 4 ft?
+
Math question: In a set of numbers, the median is the middle value. Find the median of the set {14, 23, 17, 9, 25}.
+
New questions in Mathematics
A normally distributed population has a mean of 118 with a standard deviation of 18. What score separates the lowest 72% of the distribution from the rest of the scores?
Let X be a discrete random variable with range {1, 3, 5} and whose probability function is f(x) = P(X = x). If it is known that P(X = 1) = 0.1 and P(X = 3) = 0.3. What is the value of P(X = 5)?
The random variable Y is defined as the sum between two different integers selected at random between -4 and 2 (both included). What are the possible values of the random variable Y? What is the value of P(Y=-3)? And whether it is less than or equal to -5?
A food delivery company charges on average a delivery fee of $5 per order (including food and shipping) and has monthly fixed costs of $600. If the average cost of each meal delivered that is revenue for the company is $10 and the company has a monthly profit of $800, how many orders must they deliver per month?
132133333-33
Analyze the following situation Juan is starting a new business, he indicates that the price of his product corresponds to p=6000−4x , where x represent the number of tons produced and sold and p It is given in dollars. According to the previous information, what is the maximum income that Juan can obtain with his new product?
We have spent 1/4 of the inheritance on taxes and 3/5 of the rest on buying a house. If the inheritance was a total of €150,000 How much money do we have left?
Determine the minimum degree that an algebraic equation can assume knowing that it admits 2 as a double root and -i as a triple root
Lim x → 0 (2x ^ 3 - 10x ^ 7) / 5 * x ^ 3 - 4x )=2
1. A pediatric client is prescribed digoxin for congestive heart failure. The dose prescribed is 40 mcg/kg twice daily. The child weighs 33 pounds. What is the dosage in mg to be given per dose? Round to the nearest hundredth. Calculate your answer in mg per dose. Enter numerical value only.____mg
A machine produces 255 bolts in 24 minutes. At the same rate, how many bolts would be produced in 40 minutes?
User One of the applications of the derivative of a function is its use in Physics, where a function that at every instant t associates the number s(t), this function s is called the clockwise function of the movement. By deriving the time function we obtain the velocity function at time t, denoted by v(t). A body has a time function that determines its position in meters at time t as S(t)=t.³√t+2.t . Present the speed of this body at time t = 8 s.
You want to study incomes in a large city. You take a simple random sample of 5012 households and find that the distribution of household incomes is skewed right. If you calculate the mean of the 5012 household incomes will the distribution of mean scores be skewed right as well? Hint: this involves the Central Limit Theorem.
To find the increased amount on a standard term deposit with the following conditions: starting amount: BGN 13000, type of deposit: annual, annual compound interest rate: 1.4%, after 4 years;
A buyer purchased a North Carolina home for $475,250. The seller allowed the buyer to assume his first small mortgage with a loan balance of $110,000. How much is the excise tax paid in the transaction? $951 $729.50 $950.50 $221 none of the above
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
Write an expression using compatible numbers that can be used to estimate the quotient 629\86
Sally’s sales for last Sunday were $1,278. That was an increase of 6.5% over her sales for the previous Saturday. What were her sales for the previous Saturday?
If the area of a circle is 75.7ft2, what is the radius? Give the answer in metres. Round answer to 2 decimal places and enter the units.
5 1/9 + 2 2/3