1. Develop an aggregate plan for the following forecast 3 4 5 6 7 8 9 Total Period 1 2 Forecast 190 230 260 280 210 170 160 260 180 1,940 here are 20 workers who can produce 10 units per period at a cost of P6.00 per unit. here is no beginning invetory and the cost of carrying inventory is P5.00 per unit per period. acklog cost is P10.00 per unit per period. a. Will the present workforce able to produce the forecast? b. What is the total cost of the plan?
Q: A forecast of 240 units in January, 320 units in February, and 240 units in March has been approved…
A: January Forecast = 240 February Forecast = 320 Product C Forecast = 240*0.25 = 60 in January and…
Q: Level Capacity Production Plan Problem o Manager T. C. Downs of Plum Engines, a producer of lawn…
A: Find the given Details below: Month 1 2 3 4 5 6 7 8 Total Forecast 120 135 140 120 125 125 140…
Q: Hill is now considering plan C: Keep a stable workforceby maintaining a constant production ra te…
A: Stock on hand 200 unit MONTH DEMAND PRODUCTION HIRE LAY OFF COST Dec 1600 Jan 1400…
Q: An urgent care clinic is staffed by two physicians who can each see four patients per hour. The…
A: a.
Q: The opening backlog is 800 units. Forecast demand is as shown here. Calculate theweekly production…
A:
Q: A production line is to run at 1000 units per month. Sales are forecast as shown in the following.…
A: Given data is
Q: Required to prepare the action plan for the events show in table below and determine the Total Float…
A: Based on the Predecessor relationships given (the 2nd column of the tables show the predecessors of…
Q: The production manager at Zam Tech has developed following aggregate forecast of its products: The…
A: For a level plan the production level is kept constant. Here, since the cost of reuglar production…
Q: Hill’s operations manager (see Problems 13.3 through13.5) is also considering two mixed strategies…
A:
Q: Activity-Based Budgeting (ABB) with Continuous Improvement OFC Company (Exercise10-41) has decided…
A: The main drawbacks of Kaizen (continuous-improvement) budgets are: 1. For reducing the costs the…
Q: What role does collaborative forecasting play in a supply chain of a build to order manufacturer…
A: The bullwhip effect in businesses disturb the supply chain at many production and operational…
Q: You have developed the following simple productstructure of items needed for your gift bag for a…
A: Given Number of attendees forecasted = 200
Q: Develop a production schedule to produce the exact production requirements by varying the workforce…
A: Aggregate production plan using chase strategy by varying workforce to match production exactly with…
Q: Briefly describe the planning techniques listed as follows, and give an advantage and…
A: The aggregate plan is the output of sales and operations planning. The major concern of aggregate…
Q: Deb Bishop Health and Beauty Products has developeda new shampoo, and you need to develop its…
A: The given information can be tabulated as below:
Q: Identify the two categories of aggregate planning strategies,and explain the difference between…
A: The process of creating, reviewing, and preserving a tentative, estimated schedule of an…
Q: i. Define Scope Planning ii.Purpose of Scope Definition iii.Explain the documents needed for…
A: The scope can be defined as the highest level by defining the parameters and delivery of your…
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: Describe the aggregate planning yield. When is it most beneficial to use aggre- gate planning?…
A: Total arranging is the way toward creating, investigating, and keeping a fundamental, inexact…
Q: Co.PL Manufacturing makes many components for print machines and copy machines. The company makes 20…
A: The process to predict the future by analyzing the trend is known as the forecasting technique. The…
Q: Macon Controls produces three different types of controlunits used to protect industrial equipment…
A: Meanwhile, the plant functions for two 8 hrs each week, 5 days/ week & 52 weeks yr. Plants…
Q: what is Canadian Tire's vertical and horizontal analysis of their income statement for last 5 years…
A: Flat Analysis alludes to the method involved with contrasting the line of things over the period, in…
Q: Given the following data, can an order for 40 more units for delivery in week 5 beaccepted? If not,…
A: Solution The following table shows the ATP for each week - Week 1 2 3 4 5 6 7 8 Customer…
Q: A resort cum restaurant spot in the area of Gazipur is open on the days of the week. The manager…
A: Given,
Q: Southeast Soda Pop, Inc., has a new fruit drink forwhich it has high hopes. John Mitten thai, the…
A: A Small Introduction about Inventory A stock is the supply of things utilized in an association. A…
Q: The planner at a company that makes garden tractors is about to prepare an aggregate production plan…
A: Disclaimer-Since you have asked multiple question we will solve the first question for you. If you…
Q: Prepare a master schedule given this information: The forecast for each week of an eight-week…
A:
Q: Prepare a Master Production Schedule (MPS) for an Agri-Chemical company in Malawi given the…
A: According to the given data, Inventory = Inventory from previous week - Current weeks requirements…
Q: Suppose SureStep could begin a machinery upgrade and training program to increase its worker…
A: In this table, we are also given and use the following cell formulas: we enter the formula =B5 into…
Q: Let’s say that Glass For Sale, Inc. manufacturers replacement glass for the home remodeling…
A: Linear programming model formulation- Decision Variable: Suppose-F = The no. of windows manufactured…
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: An aggregate plan provides justification for: Select one: a. the budget amount requested b. demand…
A: Aggregate planning is a popular concept used in company operations. It refers to a system of making…
Q: 11 A ______ is a customer order that a company accepts in one period but promises to deliver at a…
A: Here we focus on three fundamental order types: market orders, limit orders, and stop orders—how…
Q: The Baldwin Company, in its master budget for 2019, predicted total sales of $160,000, variablecosts…
A: Formula for Total static budget (operating-income) variance, simply subtract the actual spend from…
Q: Crystal Clear Health Drinks: A health drink production company, Crystal Clear Health Drinks,…
A: Since you have submitted multiple questions, as per guidelines we have answered the first question…
Q: EZ-Windows, Inc. manufacturers replacement windows for the home remodeling business. In January, the…
A: Let F = Number of windows manufactured in February M = Number of windows manufactured in…
Q: An aggregate plan is to be developed for the forecast of demand covering nine periods shown in Table…
A: Aggregate planning is a process for creating a long-term manufacturing strategy that assures a…
Q: The Sales&Operations (S&OP) process is designed to produce a plan that all departments within the…
A: It is very important to understand where sales and Operations Planning, is a monthly integrated…
Q: A phone production company must prepare the production planning for the next 9 weeks. Complete the…
A: Gross requirements: It is the total requirement of a particular product. Receipt: It is the placed…
Q: Baker Manufacturing Company forecasts the following demand for a product (in thousands of units)…
A: Year 1 2 3 4 5 Forecast Demand 131 150 151 154 153
Q: Given the following data, can an order for 20 for delivery in week 4 be accepted?Calculate the ATP…
A: ATP for 1 week = on hand-customer orders = 50-50 = 0 units ATP for 2 week = MPS schedule…
Q: . At the conclusion of her first month of operating Val’s Donut Shop, Val computed the following…
A:
Q: P2. Over past 4 weeks, KAMM (Kuwait Arab Malls Monitor) reported a severe decline in French products…
A: Given data is
Q: Barington Mills manufactures denim cloth from two pri-mary raw materials, cotton and dye.…
A: Days in inventory, also regarded as the Days of supply, which is defined as the efficiency ratio,…
Step by step
Solved in 3 steps
- Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?
- Given 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 71. Omar has heard from some of his customers that they will probably cut back on order sizes in thenext quarter. The company he works for has been reducing its sales force due to falling demand andhe worries that he could be next if his sales begin to fall off. Believing that he may be able to convince his customers not to cut back on orders, he turns in an optimistic forecast of his next quartersales to his manager. What are the pros and cons of doing that?The historical data for 4 perlods demand are 65, 60, B0, ond 70respectively Calculate the weighted moving verae (WMA) forecast of perlod 5 with welghts (0,4, 0,6)
- 2. Fastway is a parcel delivery company based in Pretoria. It measures demand on a weekly basis in terms of the number of parcels which it is given to deliver (irrespective of the size of each parcel). The forecast for week 20 is 63. The table below shows actual demands for Fastway. Week Actual demand 20 63 21 62 22 67 23 66 24 67 25 69 26 65 27 71 28 68 29 68 30 70 31 72 32 66 33 68 34 67 Predict the forecast for week 35 using an exponential smoothing with a smoothing constant of 0.20.1. Solve manually. The following gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks. Pints Used 360 Week August 31 September 7 September 14 September 21 September 28 389 410 381 368 October 5 374 a. Forecast the demand for the week of October 12 using a 3-week moving average. b. Use a 3-week weighted moving average, with weights of 0.1, 0.3 and 0.6, using 0.6 for the most recent week. Forecast demand for the week of October 12. c. Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and c=0.2. d. Compute the MAD for the 3-week moving average, 3-week weighted moving average and exponential smoothing models above.Sab AV Aa Font A A A T Investigate D Paragraph Exercise 2 Appended below is an inventory record of a manufacturing company displaying purchase of quantity raw materials for the year 2022 and from 2023. FS Required: Calculate the estimated forecast for from July 2023 till December 2023. ww Shapes Arrange Quick V Styles Drawing Feb March January till June April May June July August September October Demand Forecast Year 2023 Month Jan November December V FS Editing y 1,700 1750 2110 1225 3230 4512 Dictate Sensitivity V Voice Sensitivity Year 2022 Raw Materials Purchased Month Jan Feb March April May June July August September October November December =Notes 25°C gg UU Add-ins Add-ins 60 Designer UNITAR Raw Materials Purchased 1230 1880 1100 2580 3820 4580 3330 2530 5120 4830 5230 5110 ENG 10:1 21/1
- 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 7A Juarez, Mexico, manufacturer of roofing supplies has developed monthly forecasts for a family of products. Data for the 6-month period January to June are presented in the table below. There are 8 hours of production per day. Table 1 Other data Month 1 January 22 Production Demand Days Forecast 950 2 February 18 750 Inventory carrying cost Subcontracting cost per unit Average pay rate Overtime pay Rate 3 March 21 750 4 April 21 1,000 5 May 22 1,300 6 June 20 1,050 Labor-hours per unit Cost of increasing daily production rate (hiring & training) Cost of decreasing daily production rate (layoffs) $5 per unit per month $10 per unit $5 per hour ($40 per day) $7 per hour (above 8 hrs per day) 1.6 hrs per unit $300 per unit $600 per unit This exercise only contains part b. b) Juarez has yet a sixth plan. A constant workforce of 7 is selected, with the remainder of demand filled by subcontracting. Evaluate this plan. The production rate per day = ☐ units. (Enter your response as a whole…The following table and plot show a variable "y" and the results of a model built to forecast its behavior. O a. O b. OC. Od. Actual @ 20 2.7 1129 43 3.5 5,8 4.6 Forecast MAE 0.083 Calculate the models MAE, MSE and MAPE MAE 1.150 MAE 1.886 1.1 3.9 MAE 1.150 4 MAE 1.271 3.6 4.8 4.7 6.0 6.3 90 MSE 1.445 MSE 1.445 MSE 6.909 MSE 1.445 MSE 1.810 MAPE 0.019 MAPE 0.321 MAPE 0.321 MAPE 0.431 # MAPE 0.418 Time Step Actual Forecast