The table below shows the quarterly sales of television set (in thousands) in an electrical appliance shop in years 2017-2019. Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 2017 4.8 4.1 6.0 6.5 2018 5.8 5.2 6.8 7.4 2019 5.6 7.5 7.8 (a) Describe the trend and seasonal variation of the sales of television set by referring to the following time series plot. (In a short paragraph of around 30 words.) Sales of Television Set (1000s) 7 6 5 4 2 1 7 10 11 12 Time: (2017 Quarter 1 to 2019 Quarter 4) (b) Calculate the seasonal variation for Quarter 1, Quarter 2, Quarter 3, and Quarter 4 respectively by using the calculated 4-quarter moving average as below. Year Quarter Sales Centered Moving (1000) Average (1000) 2017 3 5.475 2017 4 6.5 5.7375 2018 1 5.8 5.975 2018 2 5.2 6.1875 2018 3 6.8 6.325 2018 4 7.4 6.4 2019 1 6.5375
Q: 1. "Suppose you company is going to lauch a New Product into market". In this task why its is import...
A: A ). Inter-functional cooperation plays significant role in launching the new product which may be p...
Q: BCG matrix for Macdonald's,
A: McDonald is a leading fast food company. BCG matrix is a combination of 4 components- Star:maximum...
Q: 4. The Toones Company has $30,000 for the purchase of materials to make three types of MP3 players. ...
A: Decision variable: Suppose-X be the no. of Type 1 MP3 playerY be the no. of Type 2 MP3 playerZ be ...
Q: What is a schedule that can be changed? Because it's good to be able to get schedules back. Are ther...
A: A modification in a previously prepared schedule in order to get more benefits, avoid any predicted ...
Q: How can the Chinese firm take more of a stakeholder view in iron ore mining in Australia?
A: based on the previous send case study we are answering this
Q: evelop a swot matrix for MacDonalds
A: SWOT is basically- S-strengths W-weaknesses O-opportunities T-threats
Q: Explain the applicable technology for each stage of the e-procurement model
A: The procurement process that between business to business, business to customer, or business to gove...
Q: Grace Greenberg, production planner for Science and Technology Labs, in New Jersey, has the master p...
A: A Small Introduction about production Plan A production plan is made intermittently for a particu...
Q: 2a Why is it important for the Operations Manager to forecast demand at Cutey Barber Salon? 2b. Us...
A: A Small Introduction about Operation Manager The Operations Manager's job is principally to carry...
Q: sensitivity analysis
A: Sensitivity analysis is the technique that is used by the management in order to know how the values...
Q: aste management.
A: In today's culture, it is essential to have a system in place for disposing of waste.The quantity of...
Q: Finance Applications. Refer to the PI Mortgages Example in the book about a firm that provides mortg...
A: Decision variable: Suppose-X1 = Amount ($ million) invested in First MortgagesX2 = Amount ($ million...
Q: Direction: Explain the Porter's Five Forces. 1, Threat of new entrants. 2. Bargaining power of buye...
A: Porter five forces is a powerful tool that is used to identify level of competition in any industry ...
Q: List down the secondary conversions for the following websites 1myntra 2goibibo 3snapchat 4timesofin...
A: A Small Introduction about Quality Management Quality administration is the demonstration of direct...
Q: Problem 4 A. Complete the following Table for Product A MPS Record for Product A Demand time fence: ...
A: Given data is
Q: For each project phase of a project life cycle, identify and describe at least one major deliverable...
A: Project management is the management in which different types of skills and knowledge are used to ma...
Q: 'n a system with a single capacity 1 server with Random.Exponential(0.25) minutes inter-arrival time...
A: The Utilization Rate is the rate at which you use the all-out accessible season of your assets. It e...
Q: Strategic Workforce Planning at Dutch Railway Infrastructure Manager- ProRail Traffic Control Intro...
A: A Small Introduction about Aggregate Planning Aggregate planning is a system for cultivating an o...
Q: Explain the RBT
A: Resource based theory(ROT) is a theory which states the firm to in order to get strategic benefits o...
Q: A company has 250 employees. In order to find the tardiness of the employees the company decided to ...
A: In the given context, the company has 250 employees. For finding the tardiness it decided to ask 10...
Q: Describe the Social Exchmage theory that Ted with remote working .
A: SOCIAL EXCHANGE THEORY : Social exchange theory depicts that employees who are content with their ar...
Q: A manager faces peak (weekly) demand for one of her operations, but is not sure how long the peak wi...
A:
Q: d. The average utilization of Benny's time. (Round your intermediate calculations to 3 decimal place...
A: Utilization refers to the average number of servers that are busy divided by the total number of ser...
Q: a. List the four areas of a balanced scorecard. Describe each area clearly and concisely. b. Define...
A: A Small Introduction about Layout Strategy The target of the layout procedure is to foster a succ...
Q: Describe the Importnance of liter review while doing Resersch and explain how remote working is affe...
A: A literature review is a review - or, all the more precisely, a study - including academic material,...
Q: What layout features stand out? 2. Is there anything that is not appealing? 3. Does something abou...
A: A Small Introduction about Layout Management Since they utilize different design chiefs to contro...
Q: LEAST-COST FISH FEED MIX PROBLEM The manager of a fish production facility wants to formulate a fish...
A: Part (A): Decision Variable:Suppose-C = Amount (in kg) of Cornmeal ingredient in the feed mixF = Amo...
Q: Think of one of the processes in your life you identified in Unit 3, and apply the 5S methodology to...
A: A Small Introduction about Processes Management process is a course of putting forth objectives, ...
Q: Discuss the method of procurement and procedure you will propose to procure the services of a contra...
A: Procurement refers to the goods and services which are needed to be procured for an organization's d...
Q: A jewelry firm buys semiprecious stones to make bracelets and rings. The supplier quotes a price of ...
A: Optimal order quantity is the order quantity that the company should purchase or buy to reduce its t...
Q: d) If the time to complete path A-C is normally distributed, what is the probability that this path ...
A: Probability of competing a path indicating the proportion between the difference in line duration an...
Q: Breakeven between Two AlternativesGiven:Option A – Buying a MachineFC = 400,000.00 pesosSV = 80,000....
A: Given information Option A Buying a Machine Fixed Cost= 400000Pesos Salvage value=80000 Pesos i=10% ...
Q: 4. Mancio Manufacturing Co. has asked you, as their IE, to check a labor standard prepared by a rece...
A: Since you have submitted multiple questions, as per guidelines we have answered the first question (...
Q: iscussing the best way to address conflict in the workplace
A: The effects of conflicts can be serious in an organisation. It can lead into decrease in productivit...
Q: (a) With the use of a diagram, show (illustrate) the typical levels of uncertainty or project risks ...
A: A Small Introduction about Project Life Cycle The undertaking life cycle incorporates the means e...
Q: a. What is the EOQ? (Round your answer to a whole number.) EOQ b. How many times per year does the s...
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for...
Q: Future express deals with futuristic robots and it purchase it by sourcing it to the local manufactu...
A: Production is the process of manufacturing finished products using raw materials and resources for t...
Q: Describe two approaches used to manage cooperative strategies
A: A Small Introduction about Strategic Management Strategic management is the idea of recognizable ...
Q: . Explain the importance of resource planning in project scheduling.
A: A resource plan is designed during the planning phase of any project. It is made by the person in c...
Q: List the four cri teria for determining the effectiveness of ascheduling decision. How do these crit...
A: Job scheduling rules are a method to prioritize jobs according to their various characteristics and ...
Q: The cost component of a project must be carefully planned and managed throughout the life of a proje...
A: Project plans give clarity in the obligations of each team member and stakeholder in the project. Th...
Q: Houston North Hospital is trying to improve its image by providing a positive experience for its pat...
A: Here, the question data states that for each day, we have got the numbers of unsatisfied patients, t...
Q: reflection on Why work ethics should be practice by individual/among ourselves when we are working?
A: Work ethics are an important component of an organisation and thus be practiced by individuals when ...
Q: What is the total cost of reducing this project by two weeks? O a. 44 b. 76 C. 48 d. 50 e. 34
A: Here, there are three critical paths, these paths are A-B-C-D-E, A-G-H-E and A-F-I-E, I have also be...
Q: Sourabh Gupta can purchase copper bottles for $ 34 per piece and can manufacture it in house where t...
A: In this scenario, there are two options, whether we would go with making the product in house or sou...
Q: a Cybersecurity expert has determined ICS vulnerability would destroy 50 percent of the process asse...
A: Cost of vulnerability = 50% of process Asset = 50100×10,000,000=$5,000,000 Frequency of Vulnerabilit...
Q: What are the steps of the assignment method of linear programming?
A: Linear programming refers to a maethematical model that is used for identifying maximum and minimum ...
Q: J .C. Howard's medical testing company in Kansas wishes to assign a set of jobs to a set of machines...
A: A Small Introduction about Production Management Production the executives is a course of plannin...
Q: multifactor productivity
A: Multifactor productivity indicating the proportion between output and input. Using the given informa...
Q: "he percent change in productivity for one month last year versus one month this year on a multifact...
A:
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.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_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?
- The management of a technology company is trying to determine the variable that best explains the variation of employee salaries using a sample of 52 full-time employees; see the file P13_08.xlsx. Estimate simple linear regression equations to identify which of the following has the strongest linear relationship with annual salary: the employees gender, age, number of years of relevant work experience prior to employment at the company, number of years of employment at the company, or number of years of post secondary education. Provide support for your conclusion.The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?
- 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?The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?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?
- An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.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?Dilberts Department Store is trying to determine how many Hanson T-shirts to order. Currently the shirts are sold for 21, but at later dates the shirts will be offered at a 10% discount, then a 20% discount, then a 40% discount, then a 50% discount, and finally a 60% discount. Demand at the full price of 21 is believed to be normally distributed with mean 1800 and standard deviation 360. Demand at various discounts is assumed to be a multiple of full-price demand. These multiples, for discounts of 10%, 20%, 40%, 50%, and 60% are, respectively, 0.4, 0.7, 1.1, 2, and 50. For example, if full-price demand is 2500, then at a 10% discount customers would be willing to buy 1000 T-shirts. The unit cost of purchasing T-shirts depends on the number of T-shirts ordered, as shown in the file P10_36.xlsx. Use simulation to determine how many T-shirts the company should order. Model the problem so that the company first orders some quantity of T-shirts, then discounts deeper and deeper, as necessary, to sell all of the shirts.