Use MATCH to find the year index for the "Year" in cell B20, and use INDEX to find the salesperson's performance during specified month in the highlighted box *** I need the excel formula/ function for YEAR INDEX C20 and SALES E20 ***
Q: Provide examples of reverse engineering in hotel industry
A: Opposite architecture is that the process of cutting down a division, goods, or software set to find…
Q: In terms of data collecting, you may choose between the following: Please include a brief summary of…
A: Data collection is a necessary practice in many companies because it can help the company to make…
Q: Question 1 A paint manufacturer uses 3,200 liters of chemicals a year. Currently the firm purchases…
A: Given data is Annual demand (D) = 3200 liters Purchase cost (P) = $3 per liter Order cost (S) = $100…
Q: In an assembly operation at a furniture factory, six employees assembled an average of 5550 standard…
A: Given- Value of output (Production)= 5550 chairsNo. of labour = 6 workersNo. of working days = 5 day…
Q: PLEASE EXPLAIN THE STAGE 4 TO 6 ONLY for my report. Asap please! Thank you
A: Resources needed:- Financial resources - money, cash flows , Foreign exchange Human Resources:-…
Q: Explain the function and significance of marketing control in business marketing management and…
A: Marketing control is the process of monitoring, reviewing, and adjusting marketing activities to…
Q: Provide an explanation of how the Spiral Model and the V Model are used in project management.
A: The spiral model, an approach to risk management which thus integrates the iterative development…
Q: What is the net impact of the firm’s implementation of its value analysis and business process…
A: Business process reengineering is the process of designing core business processes to achieve the…
Q: 2. Maximize z = 2x₁ − 1x₂ + 3x3 Subject to: 1x₁ - 5x₂ + x₂ ≤ 10 2x₁ - 1x₂ - 1x₂ + ≤ 40 X₁, X₂, X3 ²0…
A:
Q: Tropic Industrials Ltd. is a cement manufacturing company located in Old Harbour St. Catherine…
A: Supply chain management refers to management of flow of the goods and services from one to another…
Q: Select two guest service innovations that have revolutionized the hospitality industry in the last…
A: ANSWER : One guest service innovation that has revolutionized the hospitality industry in the last…
Q: Pizza Hut is very reliant on its suppliers for the quality, cost and availability of their goods,…
A: One of the biggest fast food chains in the food business is Pizza Hut. The corporation operates…
Q: QUESTION 3 (INVENTORY MANAGEMENT: ABC ANALYSIS) Booker's Book Bindery divides SKUs into three…
A: A method for categorizing inventory goods based on their consumption values is ABC analysis. The…
Q: The admissions office at State University wants to de-velop a planning model for next year’s…
A: Doing, Algebraic formulation: Assume, xj and yj be the In State and Out of State students admitted…
Q: Provide the business strategy or a possible business strategy of a local, national or global…
A: ANSWER : A business strategy for the global company can possibly be: Multi-domestic Strategy A…
Q: Order Point Example ● Daily demand = 20 units Lead time = 10 days S.D. of lead time demand = 50…
A: Given data: Daily demand (d) = 20 units Lead time (L) = 10 days S.D of lead time demand (σ) = 50…
Q: At Trojans Urgent Care Clinic, there is one triage nurse, 5 nurse practitioners, and 3 doctors.…
A: Given data is Triage nurse = 1 Nurse practitioners = 5 Doctors = 3 Time taken to determine patients…
Q: Draw Arrow Diagram WBS TO CLEAN
A: A work breakdown structure (WBS) is a tool used to break down complex tasks and activities into…
Q: markting question....when is the customer said to be satisfied ?
A: Customer is an individual or a group of individuals buying any product (good or services) to fulfil…
Q: ow can breaches of security can impact quality and other ways the misuse of IT can impact quality.
A: Breaches of security can have a significant impact on quality in a number of ways. Some examples…
Q: Q23 Explain organisational systems for the following procedures: (5.2) a) Sales invoicing b)…
A: a) Sales invoice means an accounting document sent by a provider of goods or services to a…
Q: Consider a firm like Zara that has developed production capabilities with very short replenishment…
A: As per the Q, here, we could see that the firm Zara has established manufacturing capabilities with…
Q: Solve the following linear program using the Simplex method: Z=-7x₁-6x2 Minimize Subject to. x₁ + x₂…
A: Simplex method helps to solve linear programming models manually using slack variables, tableaus,…
Q: State TWO (2) appropriate risk strategies that can be applied in managing the potential FIVE (5)…
A: Risk assessment is, broadly, the process of identifying and analyzing potential future events that…
Q: Using exponential smoothing with α = 0.40 and the forecast for year 1 being 3,000, the forecast…
A: Here, given the data stated below and for this dataset, For this dataset, I would apply the…
Q: You are required to throw light on legal and regulatory issues to be considered by Toyota while…
A: ANSWER : There are several legal and regulatory issues that Toyota would need to consider while…
Q: My lecturer asked me to use this to prepare for an upcoming assignment. Please note that this has…
A: ANSWER 1: Section/Question Number Theory Concept Theory Detail Application 1 Enterprise…
Q: Compare and contrast Predictive Maintenance with Preventive Maintenance.
A: Maintenance is keeping the machinery or things up to the mark by mending the faulty part or by…
Q: 1. Solve the following linear programming model using simplex method. Maximize Subject to: z = 3x₁ +…
A: Given LP- Max Z = 3x1 + 2x2Subject to-2x1 + x2 ≤ 23x1 + 4x2 ≤ 8x1, x2≥0
Q: What needs to be done: Formulate a profit-maximizing PL model given the maximum demand per product…
A:
Q: Solve the following LP problems: 1. Maximize z = 1x₁ + 2x₂ + 3x3 Subject to: 1x₁ - 2x₂ + 3x₂ ≤ 10 x₂…
A: Given LP- Maximize Z = x1 + 2x2 + 3x3Subject to-x1 - 2x2 + 3x3 ≤ 10x1 + 2x2 ≤ 5x1 ≤ 1x1, x2, x3≥0
Q: Determine the order size that will minimize the total cost. b. If the supplier offered the discount…
A: Here, I would determine the order size for each situation that will minimize the total cost, the…
Q: REQUIREMENTS: a) Formulate a linear programming model for this problem. b) Use the simplex method to…
A: Here, for the given data, I would first formulate the LP, then, I would solve this LP using the…
Q: QUESTION 5 (AGGREGATE PLANNING-GRAPHICAL METHOD) ...13.11 Deb Bishop Health and Beauty Products has…
A: In chase plan, the output is just equal to the requirements. Hence the ending inventory is usually…
Q: can you Describe in 1000 words, process evaluation?
A: Organizations always try to keep a regular check on their current and ongoing progress. It is the…
Q: In business parlance, what does it mean to have "several processes" in place? Could this idea be…
A: ANSWER : In business parlance, having "several processes" in place means that an organization has…
Q: Define pattern allowances.
A: To obtain suitable patterns, pattern allowances are crucial. The casting is susceptible to numerous…
Q: Operations Management covers various functional areas of business. What are the various functional…
A: Operations management is a field of business management wherein certain processes are managed and…
Q: Quality is believed to be an issue at Pizza Hut. Two approaches have been proposed to improve…
A: One of the biggest fast food chains in the food business is Pizza Hut. The corporation operates…
Q: Discuss the key decision-making criteria in ascertaining whether an agile or traditional methodology…
A: Here, it could be necessary to understand whether we should use agile methodologies or traditional…
Q: How would you evaluate the ERP implementation strategy of SAP vs. Microsoft? Do their products offer…
A: ANSWER : Evaluating the ERP (Enterprise Resource Planning) implementation strategy of SAP vs.…
Q: been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps.…
A: Ans) Product Structure Tree:
Q: Consider a manufacturing or service company of your choice, and make a list of the primary tasks…
A: Here, I would consider a manufacturing company, then, I would list out the primary tasks/main…
Q: FK Millers produces Super and Economy brands of maize flour. In the last quarter of the year of…
A: ANSWER : The discourse between the Management Accountant and Financial Accountant at FK Millers…
Q: e.) Explain the principles for how these costs are distributed between the Owners of Evita, Gard P &…
A: Evita had P & I Insurance and Hull insurance with Gard and Loss of Hire Insurance (LoH) with…
Q: DU 15 ES LS EF LF 0 DU 10 ES LS EF LF 0 DU 20 ES LS EF LF NETWORK FOR EXERCISE DU 15 ES LS EF LF DU…
A: Critical activities are those for which the beginning and finish times are totally characterized.…
Q: do the questions based on the toyota motors company Describe how Just In Time invetroty is…
A: 1. Just In Time inventory is supporting Toyota motors business strategy or mission statement and…
Q: Economic Order Quantity (EOQ) is a method used to calculate the ideal quantity to order. The…
A: The EOQ, or ideal order quantity, is how much your company should order. It restricts the expenses…
Q: Describe each component. What are the five functions that these components provide
A: The five components of an m-commerce system are: Mobile device: This is the device that customers…
Q: 56. Q&H Company advertises during soap operas andfootball games. Each soap opera ad costs…
A:
Use MATCH to find the year index for the "Year" in cell B20, and use INDEX to find the salesperson's performance during specified month in the highlighted box
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- The file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next six months. Does this method appear to track sales well? If not, what might be the reason?The file P13_04.xlsx lists the monthly sales for a company (in millions of dollars) for a 10-year period. a. Fit an exponential trend line to these data. b. By what percentage do you estimate that the company will grow each month? c. Why cant a high rate of exponential growth continue for a long time? d. Rather than an exponential curve, what type of curve might better represent the growth of a new technology?The file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next 30 weeks. Does this method appear to track sales well? If not, what might be the reason?
- Sometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excels Trend line options.)The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Create a chart of the series with the forecasts superimposed from this optimal smoothing constant. Does it make much of an improvement over the model in part b? d. Write a short report to summarize your results. Considering the chart in part c, would you say the forecasts are good?The file P13_03.xlsx contains monthly data on production levels and production costs during a four-year period for a company that produces a single product. Use simple regression on all of the data to see how Total Cost is related to Units Produced. Use the resulting equation to predict total cost in month 49, given that the proposed production level for that month is 450 units. Do you see anything wrong with the analysis? How should you modify your analysis if your main task is to find an equation useful for predicting future costs, and you know that the company installed new machinery at the end of month 18? Write a concise memo to management that describes your findings.
- Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P13_15.xlsx. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.The file P13_01.xlsx contains the monthly number of airline tickets sold by a travel agency. a. Does a linear trend appear to fit these data well? If so, estimate and interpret the linear trend model for this time series. Also, interpret the R2 and se values. b. Provide an indication of the typical forecast error generated by the estimated model in part a. c. Is there evidence of some seasonal pattern in these sales data? If so, characterize the seasonal pattern.b. The following table shows the number of televisions sold over the last ten years at alocal electronic store.YEAR TV SALES1 1502 3003 4804 6005 6306 6407 7008 8259 90010 980i. Using trend projection, develop a formula to predict sales for years 11 and 12. Youhave to show all working. You will need to develop a table to calculate the slope andthe intercept. ii. Use that formula to forecast television sales for years 11 and 12.
- Paraphrase this one. Analyze and elaborate in 120 words. Time series analysis is used for non-stationary data—things that are constantly fluctuating over time or are affected by time. Industries like finance, retail, and economics frequently use time series analysis because currency and sales are always changing. Stock market analysis is an excellent example of time series analysis in action, especially with automated trading algorithms. Likewise, time series analysis is ideal for forecasting weather changes, helping meteorologists predict everything from tomorrow’s weather report to future years of climate change. Examples of time series analysis in action include: Weather data Rainfall measurements Temperature readings Heart rate monitoring (EKG) Brain monitoring (EEG) Quarterly sales Stock prices Automated stock trading Industry forecasts Interest ratesb. The following table shows the number of televisions sold over the last ten years at alocal electronic store. YEAR TV SALES 1 1502 3003 4804 6005 6306 6407 7008 8259 90010 980 i. Using trend projection, develop a formula to predict sales for years 11 and 12. Youhave to show all working. You will need to develop a table to calculate the slope andthe intercept.A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand for clubs. The file P10_50.xlsx contains the price of a set of clubs and the monthly sales. Assume the only factor influencing monthly sales is price. Fit the following three curves to these data: linear (Y = a + bX), exponential (Y = abX), and multiplicative (Y = aXb). Which equation fits the data best? Interpret your best-fitting equation. Using the best-fitting equation, predict sales during a month in which the price is $470. File data: Price Demand $400 20,000 $420 19,000 $440 17,000 $460 16,000 $500 14,000 $380 22,000 $290 31,000 $340 26,000 $220 41,000 $700 6,000