11.4 Given the following data, calculate the average demand and the standard deviation. Period 1 2 3 4 5 69 8 00 a 10 Total Actual Demand 1700 2100 1900 2200 2000 1800 2100 2300 2100 1800 Deviation Deviation Squared
Q: Graph all constraints. Label each constraint line to identify which it represents. 1.What are the…
A: Note: - As we can answer only up to three subparts we will answer the first three here. If an answer…
Q: Use the data below to compute the following: Period (t) At or Yt 1 410 2 407 3 333 4 428 5 332 6 355…
A: *As per the guideline first 3 parts are answerable, please repost the remaining parts. Formulae…
Q: Differentiate Statistical Quality Control and Statistical Process Control.
A: The distinctions between SPC and SQC are obvious, yet there is still considerable disagreement…
Q: review the concepts of a pull versus a push production system. How are these related to MRP and…
A: Keeping inventory low while yet having enough on hand to meet customer demand and planning the…
Q: Max 1x₁ + 1x2 s.t. 5x₁ + 6x₂ ≤ 41 1x1 + 5x₂ ≤ 20 2x₁ + 1x₂ ≤ 15 X₁, X₂20 and integer
A: Linear programming is a mathematical technique that is also used in operations management…
Q: a) The time Determine and also estimate: Activity A estimates. the find expected to 10 which of…
A:
Q: What does it mean to match a process' capabilities to a product's requirements?
A: Those in charge of managing current operations and choosing processes get information from matching…
Q: ABC company creates specialty shipping bags that they sell to pharmaceutical companies across the…
A: NOTE: We are allowed to do the first three sub-parts only. Productivity = output/input Multifactor…
Q: Raw materials can create a sourcing issue for businesses. How can a business reduce this potential…
A: Material is an important resource for any organization that is into manufacturing products for their…
Q: What is the difference between productivity and performance? Why is it important to know the…
A: The quantity of products and services produced by a productive unit in a given length of time is…
Q: The manager of Redline Trucking believes that the demand for tires used on his trucks is closely…
A: Given data is
Q: A toy manufacturer makes its own wind-up motors, which are then put into different types of toys.…
A: Given data: Annual demand (D) = 62500 unitsCarrying cost (Ch) = $11.5 /unit per year. Set up cost…
Q: What terms would you use to characterize the various steps in the design and analysis process?
A: Design and analysis are two stages of a process that play a role in process or product success or…
Q: Dave Fletcher was able to determine the activity times for constructing his laser scanning machine…
A: Early Start Time (ES): The earliest date by which an activity can start without delaying the…
Q: What is the total vehicle life cycle cost of this hybrid car given the information provided in the…
A: Life cycle costing is a technique for totaling all expenses related to an asset, from the beginning…
Q: You have recently been appointed as the executive director responsible for the purchasing function…
A: There are six criteria that you need to consider when selecting fruit and vegetable suppliers. These…
Q: Consider the following LP problem developed at Zafar Malik's Carbondale, Illinois, optical scanning…
A: In order to find the optimal answer to a mathematical model, a procedure known as linear programming…
Q: Describe the many ways in which project management software packages might aid in the project…
A: Definitions Project management software: - The computer-based methods or ways to manage some parts…
Q: explain the project management and planning software importance in the control and prevention of…
A: Project management helps in managing every project in the company. it is like a single system that…
Q: Compute the projected profit for the order quantities suggested by the management team under three…
A: Selling price = $24 Cost = $16 Salvage value = $5
Q: Discuss the impact of strategic management in project implementation.
A: The strategic management of a company's resources is essential to achieving its goals and…
Q: Avery Collins Kinsley McDonnough Ross Shannon 2012 Total Sales by Agent January - June January…
A: Find the Given details below: Given details January February March April May June Avery $…
Q: Week 1 2 The Build-Em-Fast Company has agreed to supply its best customer with three widgets during…
A: Overtime cost is $100 more than the regular time production. Overtime production cost in week 1 =…
Q: Can you please solve the linear function with clear steps. it is better to be graphically instead of…
A: First let us define the variables x1 as the stocks and x2 as bonds. Now since the objective is to…
Q: Jse the Big M method, work through the simplex method step by step to demonstrate that the problem…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: A good or service purchased and brought in from another country. Question 11 options:…
A: Any item or service that is acquired outside of the country of origin is considered an import.…
Q: Which of the following best characterizes JIT systems? Part 2 A. Annual review of operation…
A: A management technique that reduces inventory and boosts efficiency is the just-in-time (JIT)…
Q: Mary Williams, owner of Williams Products, is evaluating whether to introduce a new product line.…
A: Given: Fixed cost = 70000 Variable cost = 8 Selling price = 15 Unit sales = 12000
Q: Take into account the traits that you believe make a project stand out.
A: Projects of a business are of core importance to its people working internally and associated…
Q: TQM stresses three principles for achieving high levels of process performance and quality. Which of…
A: Error detection, reduction, or elimination are continual processes in total quality management…
Q: Business transactions taking place within geographical boundaries of a nation is known as
A: Internal commerce is the buying and selling of commodities and services within the borders of a…
Q: project risk management, and what are the necessary measures, and what are they
A: Managing a project is similar to solving a Rubik's cube in that you must maintain numerous aspects…
Q: Several companies and firms fail diee to not having a functional business model that has a profit…
A: The business model is formed by the big business firms to show their purpose, their goals, and their…
Q: Give an example of an IT project.
A: Information technology project management is the process of planning, scheduling, monitoring and…
Q: A catalog order-filling process can be described as follows:12 Telephone orders are taken over a…
A: Lean principles are described as the process through which transformation can be brought into the…
Q: How do hotel integrate online and social media touchpoints, customer information, and insights…
A: NOTE: We are allowed to do only one question. Hotels are now more than just a place to stay. They…
Q: Manager at FreeAir Lid, a leading manufacturer of fans used in air conditioning systems. The company…
A: The Breakeven Point is that level of sales at which there is no profit no loss. In other words at…
Q: Design an assembly line to manufacture cupcakes from scratch. - Assume the bakery operates for 1…
A: The bakery operates for 1 eight-hour shift per day, so there are 8×60=480 minutes available for…
Q: rivers purchased $80 billion of ExxonMobil-produced gasoline during a recent year, with one-half…
A: GDP refers to Gross Domestic Product. GDP is defined as the standard measure of value added with…
Q: What many minutes does the bottleneck step take? O a. 42.90 Ob. 12.10 O c. 4.90
A: The bottleneck step in a process is the step that slows down the whole process. The bottleneck step…
Q: A company incurs an ordering cost of $232 each time it places an order, regardless of the order…
A: The EOQ formula's objective is to determine the ideal quantity of product units to order. If…
Q: The following table lists the components needed to assemble an end item, lead times (in weeks), and…
A: FORMULA TO BE USED Gross requirement = Required Item Quantity * Usage Rate Net requirement…
Q: Find the minimum value of the function z=2x+2y subject to the following constraints. x≤17 y≤16…
A: Linear programming is a mathematical technique for the optimization of resources, such as time and…
Q: Slim-Down Manufacturing makes a line of nutritionally complete, weight-reduction beverages. One of…
A: Given data is Ingredient Calories from fat Total Calories Vitamin content Thickeners Cost…
Q: The Sellinger Business School's Information Technology Service (ITS) is considering a new process to…
A: Capacity indicating the proportion between total available time and unit processing time. Bottleneck…
Q: Develop a linear programming model to minimize cost. (Let x, be the number of square yards of carpet…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: A mechanic at the Department of Maintenance makes minor repairs to faulty golf electric carts. The…
A: From the above given information, Arrival rate, λ =4 carts per day (1 day= 8 hour shift)…
Q: How does risk management operate and what is it? What exactly about risk and asset vulnerability…
A: Risk management can be broadly defined as the process of identification, evaluation, prevention and…
Q: The accidental baker Mamello Morongwe, a certified food technologist was working on a biscuit…
A: "Since you have asked multiple questions, we will answer the first question for you. If you want…
Q: he number of plumbing repair jobs performed by Augur’s Plumbing Service during each month last year.…
A:
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
- The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?Management of a home appliance store wants to understand the growth pattern of the monthly sales of a new technology device over the past two years. The managers have recorded the relevant data in the file P13_05.xlsx. Have the sales of this device been growing linearly over the past 24 months? By examining the results of a linear trend line, explain why or why not.Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.
- The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?3. Quarterly sales of a car dealer exhibit an almost constant mean over time, but sales fluctuate depending on the quarter of the year (exhibits seasonality). Quarter Q1 - Spring Q2 - Summer Q3 - Fall Q4 - Winter Mean Year 1 32 74 53 22 45.25 Year 2 30 71 63 15 44.75 Year 3 35 83 45 19 45.5 (a) Using three years' worth of quarterly data that is provided, develop a set of seasonal factors that could be used to forecast car sales (b) Forecast car sales in each of the four quarters (Q1-Q4) of the following year (Year 4), using these seasonal factors.
- DFC Company has recorded the past years sales for the company: Year(t) Sales(x) (in Million Pesos) 2011(1) 2012(2) 2013(3) 2014(4) 2015(5) 2016(6) 2017(7) 2018(8) 2019(9) 2020(10) 219 224 268 272 253 284 254 278 282 298 Use the naïve model. Compute for MAE and MSE Use a three period moving average. Compute for the MAE and MSE Use the simple exponential smoothing to make a forecasting table. Compute the MAE and MSE of the forecasts. Alpha = 0.1 Use the least square method to make the forecasting table. Compute the MAE and MSE *** Use excel or r programmingyear quarterly sales (000 units) Q1 Q2 Q3 Q4 2016 1300 1500 1200 2000 2017 1600 1800 1100 2200 2018 1700 1900 1300 2300 2019 1800 2100 1400 2500 Using a simple regression analysis, determine the trend equation of the sales and use it to estimate the number of units of clothing sold throughout the fiscal year 2020. Assume that Q1 of 2016 is 1, Q2 of 2016 is 2, etc. Show all relevant cakculation detailQuarterly sales of a local department store over a 4-year period are given below: Quarters 2016 Q1 Sales (in millions) 500 Quarters 2018 Q1 Sales (in millions) 560 2016 Q2 490 580 2018 Q2 2018 Q3 2018 Q4 2019 Q1 2019 Q2 2016 Q3 570 630 2016 Q4 2017 Q1 2017 Q2 750 720 480 540 500 590 2017 Q3 580 2019 Q3 620 2017 Q4 740 2019 Q4 790 The data shows sign of seasonality. By computing seasonal indices for each quarter, forecast the sales for each quarter in year 2020, given that the estimated sales in 2020 is
- The following table shows the three-period moving average and five-period moving average for monthly sales of Budget Furniture's during 2019. Moving averages of Budget Furniture's Time period Months Sales Three-period moving average (rounded off to Five-period moving average four decimals) R'millions 1 Jan 7 5.0000 6.2 February 5.6667 6.6 March 5 7.0000 B 4 April 8.3333 8.2 May 7 9.3333 8.4 June 8.3333 9.6 7 July 12 8.6667 9.6 August 4 A 9.2 September 10 10.6667 10 October 13 10.6667 11 November 9 12 December 10 The seasonal index for the month of February in 2019 is: LOA pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were as follows:Day 1 2 3 4 5 6 7 8 9Number sold 36 38 42 44 48 49 50 49 52Day 10 11 12 13 14 15Number sold 48 52 55 54 56 57a. Which method would you suggest using to predict future sales—a linear trend equation or trend-adjusted exponential smoothing? Why? b. If you learn that on some days the store ran out of the specific pain reliever, would that knowledge cause you any concern? Explain c. Assume that the data refer to demand rather than sales. Using trend-adjusted smoothing with an initial forecast of 50 for day 8, an initial trend estimate of 2, and α = β = .3, develop forecasts for days 9 through 16. What is the MSE for the eight forecasts for which there are actual data?The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES 154 190 154 145 216 236 208 175 Use time series decomposition to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number.) Quarter Forecest 19 10 11 12