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 value of sinh(3π/4) - tanh(π/6)?
+
Question: What is the fifth derivative of f(x) = sin(x^2) at x = π/4?
+
Question: What is the equation of the exponential function that passes through the points (1, 4) and (2, 8)?
+
New questions in Mathematics
find the value of the tangent if it is known that the cos@= 1 2 and the sine is negative. must perform procedures.
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, 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.
How many percent is one second out a 24 hour?
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.
The length and breadth of my rectangular vegetable garden is 12,5m and 7,25m respectively. What is the perimeter of the garden?
You have been hired to estimate the average weight of quarters in circulation. Based on the sample of quarters you collect (below), create a 90% confidence interval for the weight of quarters in circulation. Quarter Weights (grams) 5.631 5.714 5.719 5.689 5.551 5.723 5.705 5.627 5.627 5.715 5.576 5.632 5.641 5.676 5.660 5.699 5.609 5.634 5.713 5.591 5.674 5.675 5.684 5.694 5.655 5.632 5.598 5.675 5.628 5.562 5.636 5.583 5.567 5.551 5.649 5.708 5.696 5.614 5.637 5.601 5.628 5.711 5.566 5.653 5.653 5.597 5.687 5.717 5.678 5.654 5.556 5.707 5.563 5.628 5.679 5.714 5.555 5.719 5.634 5.647 5.717 5.612 5.705 5.657 5.670 5.607 5.687 5.666 5.612 5.718 5.714 5.713 5.663 5.641 5.589 5.656 5.712 5.639 5.577 5.580 5.674 5.636 5.625 5.597 5.616 5.591 5.616 5.700 5.706 5.695 5.562 5.699 5.607 5.573 5.659 5.632 5.654 5.568 5.628 5.687 5.605 5.689 5.687 5.554 5.618 5.701 5.681 5.645 5.714 5.665 5.661 5.634 5.714 5.586 5.656 5.673 5.657 5.717 5.611 5.578 5.579 5.614 5.644 5.724 5.647 5.566 5.697 5.558 5.586 5.586 5.611 5.573 5.573 5.709 5.629 5.649 5.552 5.615 5.645 5.611 5.686 5.588 5.641 5.704 5.703 5.696 5.557 5.551 5.725 5.608 5.725 5.603 5.677 5.638 5.573 5.640 5.561 5.631 5.563 5.671 5.662 5.569 5.648 5.680 5.681 5.551 5.555 5.578 5.701 5.645 5.670 5.574 5.594 5.705 5.633 5.719 5.680 5.647 5.641 5.553 5.616 5.698 5.552 5.566 5.559 5.697 5.686 5.560 5.629 5.701 5.622 5.615 5.553 5.608 5.637 5.663 5.696 5.714 5.675 5.613 5.594 5.669 5.569 5.716 5.705 5.603 5.709 5.717 5.606 5.581 5.575 5.601 5.600 5.664 5.715 5.705 5.583 5.586 5.592 5.550 5.628 5.662 5.603 5.559 5.676 5.558 5.678 5.671 5.642 5.581 5.568 5.706 5.665 5.712 5.574 5.602 5.699 5.716 5.693 5.711 5.635 5.612 BLANK #1: Is this a question involving mean or proportion? ***ANSWER "MEAN" OR "PROPORTION" (WITHOUT THE QUOTATION MARKS)*** BLANK #2: What is the LOW end of the estimate ***ANSWER TO 3 DECIMALS*** BLANK #3: What is the HIGH end of the estimate ***ANSWER TO 3 DECIMALS***
find f(x) for f'(x)=3x+7
During a fishing trip Alex notices that the height h of the tide (in metres) is given by h=1−(1/2)*cos(πt/6) where t is measued in hours from the start of the trip. (a) Enter the exact value of h at the start of the trip in the box below.
Raúl, Gilberto and Arturo are playing golf; The probabilities of winning for each one are as follows: (Raúl wins) = 20% (Gilberto wins) = 0.05% (Arturo wins) = ¾%. Perform operations and order events from least to most probable.
In a order to compare the means of two populations, independent random samples of 410 observations are selected from each population, with Sample 1 the results found in the table to the right. Complete parts a through e below. X1 = 5,319 S1= 143 a. Use a 95% confidence interval to estimate the difference between the population means (H - H2) Interpret the contidence interval. The contidence interval IS (Round to one decimal place as needed.) Sample 2 X2 = 5,285 S2 = 198 Aa. Use a 95% confidence interval to estimate the difference between the population means (A1 - M2) Interpret the contidence interval. The contidence interval Is (Round to one decimal place as needed.) b. Test the null hypothesis Ho versus alternative hypothesis Ha (H What is the test statistic? H2) + Give the significance level of the test, and interpret the result. Use a = 0.05. Z=
The following table shows the frequency of care for some animal species in a center specializing in veterinary dentistry. Species % Dog 52.8 Cat 19.2 Chinchilla 14.4 Marmoset 6.2 Consider that the center only serves 10 animals per week. For a given week, what is the probability that at least two are not dogs? ATTENTION: Provide the answer to exactly FOUR decimal places
30y - y . y = 144
A teacher has 25 red and yellow counters altogether. She has 4 times as many red counters than yellow counters. How many yellow counters does the teacher have?
The average undergraduate cost per tuition, fees, room, and board for all institutions last year was $26,025. A random sample of 40 institutions of higher learning this year indicated that the mean tuition, fees, room, and board for the sample was $27,690, and the population standard deviation is $5492. At the 0.05 level of significance, is there sufficient evidence that the cost has increased? (Remember to follow the steps in hypothesis testing)
Salut👋🏻 Appuie sur "Créer une nouvelle tâche" pour envoyer ton problème de mathématiques. Un de nos experts commencera à travailler dessus immédiatement !
How many moles are there in 235 grams of potassium thiosulfate pentahydrate? K2S2O3*5(H2O)
Today a father deposits $12,500 in a bank that pays 8% annual interest. Additionally, make annual contributions due of $2,000 annually for 3 years. The fund is for your son to receive an annuity and pay for his studies for 5 years. If the child starts college after 4 years, how much is the value of the annuity? solve how well it is for an exam
Convert (324)𝑓𝑖𝑣𝑒 into base-ten
Define excel and why we use it?
In a cheese factory, one pie costs 3800 denars. The fixed ones costs are 1,200,000 denars, and variable costs are 2,500 denars per pie. To encounter: a) income functions. profit and costs; b) the break-even point and profit and loss intervals.