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).
Q: Problem 4. Considered a (s,S) system, with s = 80 and S = 200. The forecasted demand for the next 12…
A: In s,S system (minimum/maximum inventory system), the operator has to replenish the inventory in…
Q: a) Is there a strong linear trend in sales over time? b) Fill in the table with what Bob and Sherry…
A: Using excel for performing regression with Sales as the dependent variable and period as independent…
Q: Explain how flexibility in productions system relates to the forecast horizon and forecast accuracy?
A: Investigate how flexibility can be used in a manufacturing system to understand the concept of a…
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: A. From the following forecast determine the monthly inventory balances required to follow a plan of…
A: Find the Given details below: Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total…
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: 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: Create a level plan with a zero ending inventory for the forecast shown in the table. There is no…
A: It is given that, the regular production capacity is 300 units. Overtime costs are K15 extra and are…
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: A company wants to develop a level production plan for a family of products. Theopening inventory is…
A: Formula:
Q: Amalgamated Fish Sinkers makes a product group of fresh fish sinkers and wants to develop a…
A: Note: - Since we can answer only up to three subparts, we will answer the first three(a, b, and c)…
Q: This a 4 part question that am confused about. Please show the work by hand not excel. 4-1 Sales of…
A: Note: I have answered for 4-1 only. Kindly post the other question separately. Hence, the sales in…
Q: Agarwal Technologies was founded 10 years ago. It has been profitable for the last 5 years, but it…
A:
Q: With alpha = 0.8, the Exponential Smoothing (ES) forecast for Month 6 would be: A. 565 haircuts…
A: With alpha = 0.8, the Exponential Smoothing (ES) forecast for Month 6 would be:
Q: State an example of industries where the demand forecasting is dependent on the demand of other…
A: To is determined: example of industries where the demand forecasting is dependent on the demand of…
Q: NowJuice, Inc. produces bottled pickle juice. A planner has developed an aggregate forecast for…
A: As per our calculation, this answer is not correct. we are solving it the correct way given,
Q: Q_1Al-Amal Factory for Plastic Production Its expected production capacity is 2300 tons, while its…
A: Disclaimer- Since you have asked multiple questions we will solve the first question for you. If you…
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: 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: Dwayne Cole, owner of Florida firm that manufactures display cabinets, develops an 8-month aggregate…
A: Find the Given details below: Month Jan Feb Mar Apr May June Jul Aug Total Demand (Unit) 255…
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: Assuming actual product demand were 1,500; 1540; 1,520; 1,550; and 1,560 for Weeks 1, 2, 3, 4, and…
A: Forecasting is the process of estimating the future demand using previous or historic data or…
Q: PROBLEM 2:The manager of a large manufacturer of industrial pumps prepare forecasts for a six- month…
A: Formula:
Q: Mr. Zulhakim being assigned by his manager to develop their production planning for Year 2022. Table…
A:
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: In exponential smoothing method, which one of the following statements is true? O a. Alpha is…
A: Exponential smoothing is a predictable method of time series that can be extended to support data…
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: 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: The forecast demand for fudge for the next four months is 120, 160, 20, and 60 pounds. a. What is…
A: Given forecast, 1 120 2 160 3 20 4 60
Q: Mr. Zulhakim being assigned by his manager to develop their production planning for Year 2022. Table…
A: Available to promise: For 1st period = (MPS + Beginning inventory)-(sum of customers order till…
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 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: On August, a light business bought $3600 worth of lamps. At the beginning of September, the store…
A: The cost of goods sold is calculated with the help of following formula Cost of Goods Sold =…
Q: There is an ongoing debate about the roles of quantitative and qualitative inputs in demand…
A: ANSWER: Quantitative techniques depends up on historical data where as qualitative focuses up on…
Q: The historical data for 4 periods demand are 65, 60, 80, and 70 respectively. Calculate the weighted…
A: Period Demand 1 65 2 60 3 80 4 70 WMA (0.4,0.6)
Q: A new start-up company is conducting a SOP meeting in order to "plan ahead" to effectively address…
A: Production net requirement: Excel model: Solution:
Q: You have the data on the application during the 8 consecutive year period below Wanted / Find the…
A: Given that: Year Demand 2000 24 2001 48 2002 50 2003 68 2004 60 2005 66 2006 70…
Q: The operations manager has compiled data on demand for the two most popular books from order records…
A: Given data MONTH JHS Science SH Math 1 50 40 2 54 38 3 57 41 4 60 46 5 64 42…
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: What is the 3-month simple moving average for February 2017, given that demand was 100 during…
A: The 3-month simple moving average for February 2017 = (Demand…
Q: 1 demand of cotton(intones) by Westham textile S.C are shown below year 1 2 3 4 6 7 8 Actual demand…
A: Given information, Year Actual Demand 1 10 2 11 3 13 4 15 5 14 6 16 7 18 8 20
Q: Problem 3-28 (Algo) The following are historical demand data: АCTUAL DEMAND 206 YEAR SEASON Spring…
A: To anticipate demand on time series data, we'll use Excel software.First, we'll forecast using…
Q: A manager would like to know the total cost of a chase strategy that matches the forecast belowusing…
A:
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…
Trending now
This is a popular solution!
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?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.] *
- 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 numberSolve 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 20c. 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.
- This historical demand for 4 periods demand is 70, 60, 80, and 90 respectively. What is the two-period weighted moving average forecast for fifth period assuming equal weights of 0.5 each O a. None is correct O b. 81.20 O. 70.1 Od. 0.0 O e. 85.00Using the moving average forecast, is it possible to forecast a demand that is biggerthan any previously observed demand?a. Yesb. NoMarch 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
- Period Demand 1 2 3 4 5 64 ៩៩៨៖ 62 65 61 66 a. Compute a weighted average forecast using a weight of 0.4 for the most recent period, 0.3 for the next most recent, 0.2 for the next, and 0.1 for the next. (Round all your answers to two decimal points.) Forecast Period 5 Forecast Period 6 b. If the actual demand for period 6 is 65, forecast demand for period 7 using the same weights as in part a. Forecast Period 7← Given an actual demand this period of 100, a forecast value for this period of 110, and an alpha of 0.84, what is the exponential smoothing forecast for next period? (Round answer to the nearest whole number.) O A. 102 OB. 108 O C. 92 OD. 100 OE. 110Given the following data, use exponential smoothing (a=0.20) to develop a demand forecast. Assume the forecast for the initial period is 6. Period Demand Period Forecast 2 2 1 3 7 9 8 The exponential smoothing forecast is (round your responses to two decimal places): 1 5 6 6.00 2 3 4 8 4 5 13 6 s D 6 7