Mr. Zulhakim being assigned by his manager to develop their production planning for Year 2022. Table 3 shows the information that he able to obtain from the sales & marketing department. After doing the planning, Mr Zulhakim need to present it to his manager. Factory developed a demand forecast based on Table 3 with supplier charges about RM300.00 per unit. The demand forecast is stated as week but, in this planning, it is being considered as an annual quantity for the operation. Ordering cost is RM150.00. Annual holding cost is 10 percent of a purchased price. (b) Develop the ATP of this plan. Initial inventory on hand is 50 units obtained from Year 2021. Lot size for MPS can be obtained by using EOQ model. Table 3: Demand and Customer confirmed order quantity 2 3 4 5 | 6 | 7 8 | 9 | 10 0 0 30 20 40 20 0| 2 00|0 Period (Week) 1 Forecast (units) 20 10| 40 10 Customer orders (booked) (unit) | 30 | 20 5 8
Q: 11. Warren's Milk Tea Shop is talk of the town. As an owner, he wants to know the possible challenge…
A: Organizational planning is described as a process through which an organization states its…
Q: The options Outlook has for handling the seasonality of magazine are adding workers during the peak…
A: The problem statement right here is to make sure right making plans of manufacturing to meet…
Q: Demand for haircut at PogiPoints Barber Shop has increased steadily for the past few months as seen…
A: ANSWER IS AS BELOW:
Q: Case: Flamingo Educational Services Flamingo Educational Services, a company located in the…
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…
Q: b. Discuss how forecasting accuracy relates to the practical application of aggregate planning.
A: Aggregate planning is the process that involves the development, analysis and other operational…
Q: The Bango Toy Company produces several types of toys to seasonal demand. The forecast for the next…
A: : Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: Tracy is the the Director of Supply Chain at Circuits Inc. An accurate forecast at Circuits Inc. is…
A: Error = Actual demand - Forecast Absolute Error = Positive Value of Error MAD = Average of Absolute…
Q: Spring and Summer Fashions, a clothing producer, has generated a forecast for the next eight weeks.…
A: Steady production of 1,200 units is maintained. As the production rate per worker isn't given,…
Q: Given the following forecast and cost information, determine Production Costs the total cost of a…
A: Total cost = regular cost+overtime cost+subcontracting cost Given regular cost 50 overtime…
Q: he 2-month SMA forecast for Month 6 would be: * 565 haircuts 574 haircuts 578 haircuts 584…
A: THE ANSWER IS AS BELOW:
Q: Using the moving average forecast, is it possible to forecast a demand that is biggerthan any…
A: Forecasting is the procedure of prediction making for the future grounded on past as well as present…
Q: Week 1 2 3 4 5 6 7 8 9 10 Demand 20 21 27 37 26 29 36 20 25 28 The forecast for weeks 2 through 10…
A: Forecasting is the procedure of doing estimations of upcoming activities on the basis of past and…
Q: Product A is an assemble-to-order product. It has a lot size of 150, and currentlyhas an on-hand…
A:
Q: Given the following forecast and cost information, Regular time cost $ 40.00 per unit determine the…
A: Given data is Month Forecast 1 570 2 600 3 630 4 650 5 670 6 690 Regular…
Q: Article: Planning for Holiday Shipping at FedEx FedEx started as Federal Express in 1971 and made…
A: Company Introduction- FedEx began as Federal Express in 1971 and made its first conveyance in 1973…
Q: Forecast demand again with a weighted moving average in which sales in the most recent year are…
A: ANSWER IS AS BELOW:
Q: Over past 4 weeks, KAMM (Kuwait Arab Malls Monitor) reported a severe decline in French products…
A: Here, we could see that declination in the french products consumption, we would apply trend…
Q: John's House of Pancakes uses a weighted moving average method to forecast pancake sales. It…
A: Weighted moving average:In weighted moving average equal weights are assigned to all periods in the…
Q: a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1…
A: Exponential smoothing formula : Ft = At-1*α + (1- α)*Ft-1 Error = Actual value - Forecasted value…
Q: Create a minimum cost chase plan for the forecast shown in the table. There is no beginning…
A: Given, Regular production capacity - 350 units and costs - $8 per unit. Overtime is limited to - 50…
Q: 3. A toy manufacturer makes stuffed kittens and puppies which have relatively lifelike motions.…
A: In the question, we could see that there are three alternatives, these are wind-up action, Pneumatic…
Q: 5. (a) When a new business is started, or a patent idea needs funding, venture capitalists or…
A: The process used to predict future data and analysis of the trend is known as forecasting. With the…
Q: Zebra Technologies Corporation (ZTC) manufactures a number of navigation packages for pleasure…
A: Find the Given details below: Month Jan Feb Mar Apr May Jun Total Demand 700 600 400 650 850…
Q: The production manager at Zam Tech has developed following aggregate forecast of its products:…
A: Find the Given details below: Period 1 2 3 4 5 6 7 Total Forecast 50 44 55 60 50 40 51 350
Q: PROBLEM 2:The manager of a large manufacturer of industrial pumps prepare forecasts for a six- month…
A: Formula:
Q: A distributor uses the following equation for forecasting demand of ski goggles: Y = 834 + 18*t,…
A: seasonal forecast is obtained by multiplying the forecast with the relative values fo the periods.
Q: If we use a simple exponential smoothing method with ??=0.3, ??11=100 and ??12=120, what is your…
A: Inventory management is the management in which raw materials and finished products are stored and…
Q: 4. What is the difference between trend and seasonality in time series data? 5. Here are the errors…
A: Note: - Since the exact question that has to be answered is not specified, we will answer only the…
Q: Assuming actual product demand were 1,500; 1540; 1,520; 1,550; and 1,560 for Weeks 1, 2, 3, 4, and…
A: Error represents the deviations in the forecasted values in comparison to actual value. %error=…
Q: a Develop a 3-week moving average forecast for Weeks 4 through 9 Develop a 3-week weighted average…
A: Moving average forecast refers to a technique of getting all the ideas trend in the data set and…
Q: In each of the following, name the term defined or answer the question. Answers are listed at the…
A: The term used to describe demand that is uncertain and needs to be forecast. Answer: Independent…
Q: I'm trying to determine optimal order quantity but only have a Mean forecast and a standard…
A: The most cost-effective amount of a product to acquire at a given moment is the optimal order…
Q: Forecast Including TrendAssume a previous forecast, including a trend of 110 units, a previous trend…
A: Given Information: Forecast including trend = 110 units Previous trend estimate = 10 units Alpha =…
Q: Given below are the demands of a certain product over the past 10 weeks. Week | 1 | 2 | 3| 4 | 5 6 |…
A: Since you have submitted multiple questions with multiple subparts as per guidelines I have answered…
Q: Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are…
A: Given, Year Demand FOR FERTILIZER(1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8…
Q: a. A manufacturing firm manufactures electric motors. The sales during the last four months…
A: The mean absolute deviation is extremely high with a worth of 18.85% and this leads to extreme…
Q: a) Forecast demand for each week, including week 10, using exponential smoothing with a 5 .5…
A: Below is the solution:-
Q: The following table is given. What is the demand forecast for period 13 if the Winter model is used?…
A: Given data: Demand forecast for 8th period = 7056 Trend forecast for 8th period = 227 Observing the…
Q: Demand at Nature Trails Ski Resort has a seasonal pattern.Demand is highest during the winter, as…
A: Given data is
Q: Matrix uses simple exponential smoothing with S.F = 0.6 to forecast demand. The forecast for the…
A: Below is the solution:-
Q: The options Outlook has for handling the seasonality of magazine are adding workers during the peak…
A: The problem declaration here is to confirm proper preparation of production in directive to meet…
Q: March demand was pridicted at 590 units of gear cycles of trevaa ltd. But the actual demand was 400…
A: Given: March demand forecasted (Ft-1) = 590 Units March actual demand (At-1) = 400 Units Alpha =…
Q: Sales for Pandora’s Jewellery for the past three months have been 200,350, and 287. Use a…
A: Given data; Three months actual demands are 200,350,287. Fourth month actual demand = 300
Q: Specialty Toys, Inc., sells a variety of new and innovative children's toys. Management learned that…
A: : Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: Determine the total cost for this plan given the following forecast:Month 1 2 3 4 5 6Forecast 380…
A: Following is the brief of production schedule: While forecast for month 1 is 380, actual production…
Q: 5-17 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply…
A: Forecasting is the process of determining the estimated forecast for the future using the previous…
Step by step
Solved in 2 steps with 4 images
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?Year 1 Demand Year 2 Demand Year 3 Demand 1 12 1 16 1 14 45 25 32 3 76 52 3 71 84 4 4 62 4 47 a. Determine the seasonal factors for each quarter. b. Based on the result of part (a), determine the deseasonalized demand series. c. Predict the demand for each quarter of Year 4 for the deseasonalized series from a six-quarter moving average. d. Using the results from parts (a) and (c), predict the demand for the shoes for each quarter of Year 4.
- 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.] *2) A manager has prepared a forecast of expected aggregate demand. Develop an aggregate plan that assumes: A level production rate, back orders are allowed and are charged at the rate of $15 per unit per month, inventory holding costs are $2 per unit per month in average inventory, regular time cost is $7 per unit and beginning inventory is zero. Show the aggregate plan and determine the cost of this plan. (use excel to show formulas for your calculations) Month Forecast 270 2 310 280 4 350 310 280(b) Demand history of five different products of a company is shown below. Products 2012 2013 2014 2015 2016 2017 2018 2019 2020 A 37 40 41 45 49 26 34 30 26 23 33 28 32 C 58 55 32 38 45 56 62 70 77 86 95 83 88 81 92 85 i. Name the methods that is suitable to forecast the demand of the above five products? ii. Forecast demand of the product B or D with error for the year 2021. If you need a value of a then consider it 0.7.
- 1. Katherine is a forecast manager. She used exponential smoothing to forecast her sales with alpha equals 0.25. Her forecast for this week was 161 but the actual number is 232. What is her forecast for next week?2. Blue Pad Companyâs lead time L is1week and demand rate is119units per week.Holding cost is $29 per unit and ordering cost is $281. Assume 52 weeks in a year.What is the EOQ? Keep two decimal points!3.Blue Pad Companyâs lead time L is3week and demand rate is123units per week.Holding cost is $70 per unit and ordering cost is $726. Assume 52 weeks in a year.What is the ROP?4. Lugini Watchâs annual demand is 107. It can produce at a rate of 19 watches per month with a $249 setup cost for the production run. Find the order quantity (EPQ) assuming carrying cost is $57 per unit a year. Keep two decimal points!5. Lugini Watchâs annual demand is 108. It can produce at a rate of 24 watches per month. Using the…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).1. With examples and necessary figures, define the Key Inventory Terms ? 2. Suppose, you are newly appointed as a Sales Manager in Unilever Company and after joining your first assignment is to do the sales forecast for the next quarter. Therefore, explain what would be your approach to do a good sales forecast for the next quarter.
- The options Outlook has for handling the seasonality of magazine are adding workers during the peak season, subcontracting out some of the work, building up inventory during the slow months, or building up a backlog of orders that will be delivered late to customers. To determine how to best use these options through an aggregate plan, Outlook`s vice president of Marketing starts with the first task-building a demand forecast. Although Outlook could attempt to forecast this demand itself, a much more accurate forecast comes from a collaborative process used by both Outlook and its retailers to produce the forecast shown in Table (a). Outlook sells each book through retailers for Rs.40. The company has a starting inventory in January of 1000 books. At the beginning of January the company has a workforce of 80 employees. The company has a total of 20 working days in each month, and each employee earns Rs 4 per hour regular time. Each employee works eight hours per day on straight time…The options Outlook has for handling the seasonality of magazine are adding workers during the peak season, subcontracting out some of the work, building up inventory during the slow months, or building up a backlog of orders that will be delivered late to customers. To determine how to best use these options through an aggregate plan, Outlook`s vice president of Marketing starts with the first task-building a demand forecast. Although Outlook could attempt to forecast this demand itself, a much more accurate forecast comes from a collaborative process used by both Outlook and its retailers to produce the forecast shown in Table (a). Outlook sells each book through retailers for Rs.40. The company has a starting inventory in January of 1000 books. At the beginning of January the company has a workforce of 80 employees. The company has a total of 20 working days in each month, and each employee earns Rs 4 per hour regular time. Each employee works eight hours per day on straight time…March demand was pridicted at 590 units of gear cycles of trevaa ltd. But the actual demand was 400 units only so fourth the company now want to forecast the april demand using exponential smoothing model with constant alpha of 0.72., calculate the same