1.- The next table shows the demand forecast for a group of products Month July August September October November December Demand Forecast 1250 1100 950 900 1000 1150 Initial inventory is 500, desired final inventory is 400, and there are 20 days available to work every month. It is possible to work 8 hours every day. At the moment there are 30 workers available and each worker is capable to produce one product every 5 hours. a. Elaborate an aggregate production plan using a chasing strategy b. Elaborate an aggregate production plan using a constant work force level strategy
Q: 3.13. Given the following data, can an order for 40 more units for delivery in week 5 be accepted?…
A: Given data- On-hand inventory= 0 Week 1 2 3 4 5 6 7 8 Customer Orders 70 10 50 40 10 15 20 15…
Q: a) Given the product structure and master production scheduleshown in Figure 14.12, develop a gross…
A: A Small Introduction about Production Management Production the executives is a course of…
Q: David Villa Manufacturing has the following demand aggregate requirements And other data for the…
A: Plan A:
Q: A Pizza Company has a demand forecast for the next 12 months that is shown in Table 1 The current…
A: Find the Given details below: Month January February March April May June July August September…
Q: . After looking over the level production plan, David Griffin, vice president of manufacturing,…
A: Month Sales Forecast Sep 30,000 Oct 31,500 Nov…
Q: Being a resource planning manager of the firm how will you translate the company annual business…
A: Material requirements planning (MRP) refers to a computer-based inventory management system that is…
Q: Why do organisation have to do aggregate planning ?
A: Introduction Aggregate planning helps a company to improve customer satisfaction. Furthermore, it…
Q: A manager is going to purchase new processing equipment and must decide on the number ofspare parts…
A: Given Information: Unit spare part cost = $ 200 Salvage Value of a spare part = $ 50 Cost for idle…
Q: Complete the following input/output report. What are the planned and actual backlogs at the end of…
A: Cumulative Variance= Variance of previous periods+ (Actual Input - Planned Input) For period 1 =…
Q: . Jack is concerned about his company’s corporate image and has decided against using hires and…
A:
Q: I need help with question chapter 12, question 12 (12.12).
A: a)Construct a product tree:
Q: Amber's Fabrication has the following aggregate demand requirements and other data for the upcoming…
A: In chase plan production is always kept more than the demand (thats why it is called as chase as…
Q: a) How can be interference phenomenon shortened in production lines. b) What can be the production…
A: In a manufacturing company, challenge is always about inventory, flexibility, type of production…
Q: How does revenue management impact an aggregateplan?
A: Aggregate planning refers to developing a plan for maintaining and scheduling all the internal…
Q: Assume that you are the manager of a shop that assembles power tools. You have just received an…
A: Bill of Materials Master schedule and MRP for Saw Net requirement = Gross - inventory…
Q: Solve the attached problem
A: Solution As per the given information, the lead time is 2 weeks, and the anticipated on-hand stock…
Q: Task 2: A small Tennessee company makes fused magnesia and silica. To prepare input for the planning…
A: Given data is Production quantity = 40000 pounds Safety stock = 30000 pounds
Q: Explain what aggregate planning is and how it is useful.
A: Aggregate planning using transportation method helps to attain the minimum cost with the optimal…
Q: What is aggregate planning? What is its purpose?
A: Aggregate planning comprises specification of production requirements our medium period based on…
Q: Describe the following types of bills of material:a. Product tree.b. Multilevel bill.c. Single-level…
A: A structure that consists of the list of all the parts and their quantities required to manufacture…
Q: GOT7 Soda Pop, Inc., has a new fruits drink. The production planner has assembled the following cost…
A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…
Q: Why is it important to balance production capacity with market demand?
A: It is a production a yield (products or services) with required data sources (raw materials) by…
Q: What is the managerial significance of aggregate planning. Explain
A: Below is the solution:-
Q: Problem 4 A. Complete the following Table for Product A MPS Record for Product A Demand time fence:…
A: As per the given data, the lead time is 2 weeks and projected on hand inventory was 34. Fixed order…
Q: If t f the Edwards production plan for the next period includes 900 units of component 1 and 700…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: 9. Planned sales in the junior sportswear department for April are $842,100, and the planned…
A: Planned sales= $842,100 the planned stock-sales ratio = 3.2.
Q: Assume that you are the manager of a shop that assembles power tools. You have just received an…
A: Material requirement calculation: Components Gross requirement Stock On-hand Net…
Q: 2. A department has an average weekly sales rate of $12,000 and a planned stock turnover rate of 2.5…
A: 2. ) From the given information, the weekly sales rate, R = $12000 The planned stock over…
Q: Baxter Corporation’s master budget calls for the production of 5,000 units per month and…
A:
Q: 2) A manager has prepared a forecast of expected aggregate demand. Develop an aggregate plan that…
A: For level production planProduction per Month = (Sum of the total forecast for all period –…
Q: 1. The Wicked Witch Whisk Company manufactures a line of broomsticks. The mostpopular is the 36-inch…
A: Projected available balance is given by PAB for the first period = Opening inventory + MPS Receipts…
Q: Q 6. A production line is to run at 1200 units per month. Sales are forecast as shown in the…
A: Inventory primarily describes the assets like raw materials, work-in-process of products,…
Q: 2. Aggregate planning has been described as the process of matching supply and demand over a medium…
A: Aggregate planning is the act of creating, assessing, and maintaining a preliminary, estimated…
Q: 15. Hiking General Store prepared the following sales budget: Month Budgeted Sales March…
A: Given, Budgeted sales = $14000 Gross profit rate = 30% Inventory at end of February = $14,000…
Q: d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales…
A: The estimated level of inventory that a manufacturer has in stock which can be readily sold is…
Q: Using the scheduled receipts, calculate the ATP. There are zero units on hand.
A:
Q: A company's forecast of demand in shown in the following table. Regular production costs $133 per…
A: In the eve aggregate plan, an equal quantity has to be produced per month. Thus, the quantity that…
Q: Suppose that product A has the following parents and components, structure. Parentheses in the…
A: Following is the product tree:
Q: Ouesten 25 Question 18 A company faces the aggregate planning problem shown in the table below Cost…
A: Since it is given that the plant operates 7 days a week means it works all days. The number of units…
Q: Jack Jones, the materials manager at Precision Enterprises, is beginning to look for ways to reduce…
A: a.
Q: Problem 4 A. Complete the following Table for Product A MPS Record for Product A Demand time fence:…
A: Given information Period 1 2 3 4 5 6 7 8 Forecast 10 10 10 10 10 10 15 15 Customer order…
Q: Q. Jack is concerned about his company's corporate image and has decided against using hires and…
A: To determine the production hours: a). Total demand=33600 (34000-400) Therefore, for per period =…
Q: Problem 4 A. Complete the following Table for Product A MPS Record for Product A Demand time fence:…
A: Given information Period 1 2 3 4 5 6 7 8 Forecast 10 10 10 10 10 10 15 15 Customer order…
Q: Substitue for Mandatory problem #2 on exam in attachment )-Calculate the Tracking Signal(RSFE/MAD t)…
A: Forecasting is the process of predicting the future demand based on previous data or information.
Q: Describe in detail what are the aggregate planning goal's?
A: The aggregate strategy must meet a number of objectives concurrently. Several critical purposes of…
Q: Problem #2- Brown Manufacturing-Modified, from textbook page #198 If the annual demand is reduced to…
A: Given:Annual demand = 8,000 unitsDaily demand=60 unitsProduction per day= 80 unitsOrdering cost=$120…
Q: Zen product wants to decide whether to make-or-buy an accessory item for one of their products. It…
A:
Q: The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the…
A:
Q: Assume that you are the manager of a shop that assembles power tools. You have just received an…
A: Bill of Materials-
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
- Q2: A company has seasonal demand, with the forecast for the next 12 months as given below. The current labor force can produce 500 units per month. Each employee can produce 20 units per month, and is paid $2,000 per month. The inventory carrying cost is $50 per unit per period. It costs $100 to hire or layoff an employee. Assume 200 units of initial inventory and we would like to keep the similar level at the end of the year. Month 1 3 4 7 8 9 10 11 12 Demand 660 700 840 700 660 500 600 840 80 900 700 600 Please use level and chase strategy to calculate the total cost of two plans (please show your work).A method of estimating future demand usedfor decision making in order to set reasonable targets and control orlimit uncertainties or risks.Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *
- Problem Answer ALL questions from this section. Write your answers on the supplied answer sheet. Show sufficient work. If necessary, round intermediate calculations and final answers to three decimal places. J 1. The manager of a crew that installs carpeting has tracked the crew's output over the past several we eks, obtaining these figures: Week 10 20 30 43 50 6 Crew Size تمه 30 45 Yards Installed 96- 72- 92- 50, 699 52- 20 39 2₂ Compute the labor productivity for each of the weeks. On the basis of your calculations, what can you conclude about crew size and productivity?Month# Jan Feb Mar Apr May June Forecast# 1800 1500 1100 1500 2100 1600 Name Labor hours per unit (hr/unit) Initial number of workers Safety Stock (units) Working hours in a day(hr/day) Beginning inventory(units) Value 5 30 0 9 450 Month# Jan Feb Mar Apr May June Working Days available 21 21 21 21 21 19 The tables present forecasts, production, and cost information for aggregate planning. Using a level strategy with backorders to produce at average demand, now many workers are required each month? (Round up the calculated number of workers to the nearest whole number, and round the production rate to the nearest whole numberc. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). MONTH PRODUCTION DAYS DEMAND FORECAST DEMAND PER DAY JAN 2022 16 150 ? FEB 2022 16 150 ? MAR 2022 23 250 ? APR 2022 21 250 ? MAY 2022 22 400 ? JUN 2022 22 500 ? JUL 2022 21 600 ? AUG 2022 20 750 ? SEP 2022 20 450 ? OCT 2022 20 250 ? NOV 2022 16 150 ? DEC 2022 16 150 ? TOTAL ? ? d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited.
- A steel workshop of PT Mental Baja produces leaf springs for cars. theyhave a demand forecast for the next 6 months as anext:i. January 446 units (production time 20 days)ii. February 600 units (production time 18 days)iii. March 700 units (production time 20 days)iv. April 900 units (production time 20 days)v. May 650 units (production time 20 days)vi. June 550 units (production time 20 days) The following are some important information to be the basis for doingcalculation of production costs as follows:i. Inventory cost $4 per unitii. Subcontractor fee $15 per unitiii. Workers cost $10 per hour or $80 per dayiv. Production time per unit 1.6 hours Tasks and questionsa. Assuming that the number of units that can be produced is 35 units per dayand 1 person can make 7 units, make an estimated cost by usingConstant Workforce approach. b. Assuming that internal processing is carried out usingcapacitors of daily production are the lowest for 6 months and constant,calculate estimated…Solve the following questions Q1. A. From the following forecast determine the monthly inventory balances required to follow a plan of letting the inventory absorb all fluctuations in demand. In this case, we have a constant work force, no idle time or overtime, no back orders, no use of subcontractors, and no capacity adjustment. Assume that the firm does not use safety stock or cushion inventory to meet the demand. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Month Forecasted demand 90 220 210 400 612 700 378 220 200 110 100 260 Production days 22 18 21 20 22 20 21 22 20 25 19 20Calculate customer life time value for the data below. (Show Work) Purchase Occasion Transition Probability Average Basket Size 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ΝΑ 55% 75% 78% 83% 81% 81% 86% 82% 85% 90% 93% 85% 89% 85% 91% 97% 97% 96% 85% 83% 89% 82% 79% 82% 89% 88% 86% 67% 75% $46.71 $56.71 $57.93 $56.87 $58.26 $66.90 $63.62 $70.27 $63.03 $62.60 $71.81 $76.76 $78.14 $65.65 $74.84 $81.11 $72.08 $87.30 $71.94 $75.44 $70.35 $72.86 $66.68 $79.90 $93.91 $61.08 $94.16 $100.40 $77.89 $99.70
- On Week a) Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Customer Orders 13 8 4 PAB 20 Available to Promise MPS b) Determine if each customer order will be accepted. Order Amount Week Accept (Y/N) 1 40 2 30 3 4 30 25 462M 3 Update the MPS time-phased record for accepted orders. Item: P24 Forecast Customer Orders Problem 3: The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. a) Complete the MPS time-phased record for product P24. Use the table on the left. b) Determine if Murphy Motors can accept each of the following customer orders. Update the MPS time- phased record for accepted orders. Order 1234 Amount 40 Desired Week 4 30 30 25 623 8 4 On Week hand 1 2 3 4 5 6 30 30 30 40 40 40 74 45 45 PAB 20 Available to Promise MPS On hand = 203. A toy manufacturer makes stuffed kittens and puppies which have relatively lifelike motions. There are three different mechanisms that can be installed in these "pets." These toys will sell for the same price regardless of the mechanism installed, but each mechanism has its own variable cost and setup cost. Profit, therefore, is dependent upon the choice of mechanism and upon the level of demand. The manufacturer has in hand a forecast of demand that suggests a 0.2 probability of light demand, a 0.45 probability of moderate demand, and a probability of 0.35 of heavy demand. Payoffs for each mechanism-demand combination appear in the table below. Wind-up action Pneumatic action Electronic action Demand Light Moderate $250,000 $90,000 -$100,000 400,000 440,000 400,000 Heavy 650,000 740,000 780,000 Construct the appropriate decision tree to analyze this problem. Use standard symbols for the tree. Analyze the tree to select the optimal decision for the manufacturer.In past 4 weeks, AOC (Arab oil company) started producing and distributing national engine oil to substitute French Total and Esso brands. Production reported to be in thousands: 2, 4, 3, 5 TG Thousand Gallons). AOC production will be calculated after 5 more weeks.