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: In a circle, if a tangent and a chord intersect at a point on the circle, the angle between them is?
+
What is the measure of the angle formed by the bisector when an angle measures 60 degrees?
+
Question: Solve for x: log(x) + log(2) = log(20) + log(25)
+
New questions in Mathematics
A sample is chosen from a population with y = 46, and a treatment is then administered to the sample. After treatment, the sample mean is M = 47 with a sample variance of s2 = 16. Based on this information, what is the value of Cohen's d?
The patient is prescribed a course of 30 tablets. The tablets are prescribed “1 tablet twice a day”. How many days does a course of medication last?
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?
Kayla has $8,836.00 in her savings account. The bank gives Kayla 5%of the amount of money in account as a customer bonus. What amount of money does the bank give Kayla? Justify your answer on a 6th grade level.
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?
The profit G of the company CHUNCHES SA is given by G(x) = 3×(40 – ×), where × is the quantity of items sold. Find the maximum profit.
An integer is taken at random from the first 40 positive integers. What is the probability that the integer is divisible by 5 or 6?
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)?
the probabilty that a person has a motorcycle, given that she owns a car 25%. the percentage of people owing a motorcycle is 15% and that who own a car is 35%. find probabilty that a person owns any one or both of those
The sum of two numbers is equal to 58 and the largest exceeds by at least 12. Find the two numbers
41/39 - 1/38
Find 2 numbers whose sum is 47 and whose subtraction is 13
reduce the expression (7.5x 12)÷0.3
Determine the increase of the function y=4x−5 when the argument changes from x1=2 to x2=3
Fill in the P(X-x) values to give a legitimate probability distribution for the discrete random variable X, whose possible values are -5 ,3 , 4, 5 , and 6.
36 cars of the same model that were sold in a dealership, and the number of days that each one remained in the dealership yard before being sold is determined. The sample average is 9.75 days, with a sample standard deviation of 2, 39 days. Construct a 95% confidence interval for the population mean number of days that a car remains on the dealership's forecourt
Write the detailed definition of a supply chain/logistics related maximization problem with 8 variables and 6 constraints. Each constraint should have at least 6 variables. Each constraint should have At least 5 variables will have a value greater than zero in the resulting solution. Variables may have decimal values. Type of equations is less than equal. Numbers and types of variables and constraints are important and strict. Model the problem and verify that is feasible, bounded and have at least 5 variables are nonzero.
prove that for sets SS, AA, BB, and CC, where AA, BB, and CC are subsets of SS, the following equality holds: (A−B)−C=(A−C)−(B−C)
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.
if y=1/w^2 yw=2-x; find dy/dx