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 should Sharon do in this situation?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?
- 5. (a) When a new business is started, or a patent idea needs funding, venture capitalists or investment bankers will want to see a business plan that includes forecast information related to a profit and loss statement. What type of forecasting information do you suppose would be required? (b) A picnic spot is open on Thursday, Friday and Saturday. The manager hopes to improve resource availability and scheduling of part-time employees by forecasting visitors in the next week. Data on visitors of the recent 5 weeks at the spot has been found. On Saturday, Thursday, and Friday there were 182. 95, and 280 in week 1; 197, 105, and 295 in week2; 178, 92, and 275 in week 3; 210, 109, and 305 in week 4; and 192, 100. and 284 in week 5. i. Find seasonal relatives of the days. ii. Forecast number of visitors in the resort for week 6 and that is for the days of week 6.1 The demand for automobiles at Crescent Auto Dealers for the past 8 weeks is as follows. Week Auto Demand Weights1 9 0.12 11 0.33 8 0.64 125 106 137 78 12a Develop a 3-week moving average forecast for Weeks 4 through 9b Develop a 3-week weighted average forecast…This a 4 part question that am confused about. Please show the work by hand not excel. 4-1 Sales of a particular product (in the thousands of dollars) for the years 2015 through 2018 have been $48,000, $64,000, $67,000 and $83,000 respectively. (a)What sales would you predict for 2019, using simple four-year moving avaerage? (b) What sales would you predict for 2019, using a weighted moving average with weights of 0.50 for the immediate preceding year and 0.3, 0.15, and 0.05 for the three years before that? (I am able to calculate and know the answer for (a) $65,000 and (b) $73,000. What I don't understand is the following : 4-2 Using exponential smoothing with a weight of 0.6 on actual values: (a) If sales are $45,000 and $50,000 for 2017 and 2018, what would you forecast for 2019 ? (The first forecast is equal to the value of the preceding year.) (b) Given this forecast and actual 2019 sales of $53,000, what would you then forecast for 2020? 4-3 In Problem 4-1, taking…
- Th e manager of a small health clinic would like to useexponential smoothing to forecast demand for laboratory servicesin the facility. However, she is not sure whether to use a high orlow value of α . To make her decision, she would like to comparethe forecast accuracy of a high and low α on historical data. Shehas decided to use an α = 0.7 for the high value and α = 0.1 forthe low value. Given the following historical data, which do youthink would be better to use? Week Demand (lab requirements)1 3302 3503 3204 3705 3686 343MSE answer for part a = 5.95 is incorrect. Please do recalculations with the correct answer. also the rest of the question was not answered so here it is: Use ? = 0.2 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two decimal places.) Use ? = 0.4 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15a) The demand forecast for Month 6 would be: A. 565 haircuts B. 574 haircuts C. 578 haircuts D. 584 haircuts b) With Mean Absolute Deviation (MAD) as the criterion, the best forecasting model for this time series data is: A. Naïve approach B. 2-week Simple Moving Average (SMA) C. Weighted Moving Average (WMA) with weights: 0.5, 0.3, 0.2 D. Exponential Smoothing (ES) with alpha = 0.8
- Product A is an assemble-to-order product. It has a lot size of 150, and currentlyhas an on-hand inventory of 110 units. There is a 2-week demand time fence and a12-week planning time fence. The following table gives the original forecast and theactual customer orders for the next 12 weeks:Week 1 2 3 4 5 6 7 8 9 10 11 12Forecast 80 80 80 70 70 70 70 70 70 70 70 70Demand 83 78 65 61 49 51 34 17 11 7 0 0a. Given this information, develop a realistic master schedule, complete with ATPlogic.b. Tell how you would respond to each of the following customer order requests.Assume these are independent requests, and do not have cumulative effects.■ 20 units in week 3■ 40 units in week 5■ 120 units in week 7Corporate triple-A bond interest rates for 12 consecutive months follow. 9.6 9.4 9.5 9.7 9.9 9.8 9.8 10.6 10.0 9.8 9.6 9.6 (b) Develop three-month and four-month moving averages for this time series. (Round your answers to two decimal places.) Month Time SeriesValue 3-Month MovingAverage Forecast 4-Month MovingAverage Forecast 1 9.6 2 9.4 3 9.5 4 9.7 5 9.9 6 9.8 7 9.8 8 10.6 9 10.0 10 9.8 11 9.6 12 9.6 (c) Using the more accurate forecast, what is the moving average forecast for the next month? (Round your answer to two decimal places.)Sara manages one of the Albireds shoe lines, and is working to improve the group's forecasting capabilities so that production will more closely match actual demand (that's the goal, at least!). Work our the exponential smoothing with a smoothing constant equal to 0.2, (seed the model with a January forecast = 16,000). A weighted moving average using 0.6(t-1), 0.3(t-2) and 0.1(t-3)