a - Find the equation of the general trend line using the ordinary least squares method? Then predict the value of sales in 2012. b - Draw the general trend line by moving averages (the length of the cycle Three years).
Q: Volkswagen Operations Strategy Product Design In 1945, a rare and curious Volkswagen car was shipped…
A: Automobiles and private transportation have a bright future ahead of them.. Volkswagen is poised to…
Q: In the game shown below, Player 1 can move Up or Down, and Player 2 can move Left or Right. The…
A: Given data: Player 2 Player 1 Left Right Up 3, 2 2, 3 Down 0,9 1, 1
Q: Kenneth's Auto Tire sells all types of tires, but a popular r portion of Harry's overall sales.…
A: Given data: Demand for Tires Frequency(Days) 0 19 1 67 2 88 3 25 4 49 5 52 Here we…
Q: How can the location of a start-up business can influence its future?
A: Start up a business is not so easy because the firm has to make balance between all the important…
Q: For the following payoff table, what alternative should be chosen if you are following a Maximin…
A:
Q: Lead time usage refers to the length of period it takes to order and receive goods and also called…
A: Lead time usage indicating the demand during the lead time. Lead time period indicating the period…
Q: Consider the optimization problem represented by this graph. The objective function is represented…
A: Optimal solution is determined from the feasible points. Feasible points are the points that touches…
Q: Q4: The following time series shows the annual production of a factory: 2009 2008 2007 2006 2005 the…
A:
Q: Why do some executives receive more than 50% of their compensation in bonuses?
A: ANSWER : Executive Bonus In the base salary of executives, most receive variable pay, a compensation…
Q: why do social networks matter?
A: Running a small home-grown business or an enormous countrywide corporation social broadcasting is…
Q: ) Discuss the registration process of ISO 9000 and list the benefits it offers to the organizations.…
A: ISO 9000 is described as a group of international measures on quality management & quality…
Q: pastries, and cakes made of first-class flour. The bakery uses 150 sacks of 20 kg flour every…
A:
Q: Sanchez Trucking has been experiencing delays at its warehouse operations. Management hired a…
A: Given data: No. of members in crew = 6 Full time hrs/member = 40 hrsPermanently hired cost/week =…
Q: Describe the two types of operational responsibility.
A: Operational Responsibility:- Operational responsibilities take place in a company’s day-to-day…
Q: Tom has several years of experience computer program. he signs a six month contract with the Metro…
A: Self-employment can be stated as the state of working for oneself instead of doing the job for…
Q: Is it possible for a firm to implement a cost-leadership and product-differentiation strategy…
A: Business strategy refers to the plans and policies that an organisational manager develops and…
Q: A bakery buys flour in 25-pound bags. The bakery uses 1.215 bags a year. Ordering Cost is »1o per…
A: Economic order quantity (EOQ) is a inventory ordering technique which helps to reduce the total cost…
Q: Briefly discuss what measures can be taken for effective people management?
A: Management of people is one of the most important parts of any business or organization, so it’s…
Q: Is there any way to control the influence pharmaceutical companies have on the decisions made by…
A: There are several measures that can be taken in order to control the influence of the pharmaceutical…
Q: A publisher for a promising new novel figures fixed costs (overhead, advances, promotion, copy…
A: The Break-even point is the point where the production cost and the production revenue of an…
Q: Dear students, for this assignment I want you to think (critically!) about what the advantages and…
A: The Modes of Transportation is defined as various ways of Transportation or transporting goods or…
Q: 3. A large bakery buys sugar in 50-kg bags. The bakery uses an average of 1,344 bags a year.…
A: As per guidelines we are supposed to answer only three subparts if there are multiple sub-parts…
Q: Car owners fill up when their tanks are exactly half full. At the present time, an average of 8.5…
A: Scenario 1: Arrival rate = 8.5 cars/hr Service rate = 1Service time×60=13.68×60=16.3 cars/hr…
Q: A corporation that is incorporated North Dakota and doing business in South Dakota is called a(n)…
A: Any alien corporation is one that was formed in another nation yet conducts business in the United…
Q: Outline some general control strategies that can reduce the number and seriousness of workplace…
A: Workplace injuries are an important matter of concern of every kind of firm whether small or large.…
Q: How can a new business assure its survival through adaptability and the agility to adapt.
A: A competitive market is described as the structure of a market system within which neither the…
Q: Scheduling in service organizations is different from manufacturing in all of the following ways…
A: Scheduling process in service organization and manufacturing organizations are different while…
Q: 1. Given the following linear programming model: Minimize Z = 480x1 + 160x2 subject to X1 + X2 >= 40…
A: MIN zx = 480 x1 + 160 x2 subject to x1 + x2 ≥ 40 x1 + 4 x2 ≥ 60 3 x1 +…
Q: Green Grass Industries Limited (GGIL) has used a fixed-time period inventory system that involved…
A: ABC class Importance % share in usage A Very important 75% B Moderately important 20% C…
Q: What is the latest start (LS) of activity F ? Choose. Choose. What is the slack (SL) value of…
A: Slack = LS-ES
Q: c. Is there benefit (or loss) from the current inspection process? How much? answers to 2 decimal…
A:
Q: Optimum orders refers to the order size that will minimize the total of relevant costs, namely…
A: The optimum order is known as economic order quantity (EOQ). It is a company's optimal order…
Q: Describe how organizations benefit from total quality management.
A: Total quality management (TQM) is an ongoing process of identifying and reducing any kind of errors…
Q: A local gas station is open 7 days per week, 365 days per year. Sales of 10W40 grade premium oil…
A:
Q: Types of product Capacity in min Source A C F1 3 1 20 F2 5 4 8 15 F3 6. 30 Demand is $ 20 30 25
A: Since the matrix is unbalanced i.e. supply is not equal to demand. We need to insert a dummy row F4…
Q: Mr. ichul is a Director of a pastry factory in Bandung. To produce 350 cakes per day it takes the…
A:
Q: define descriptive research
A: A descriptive research is a tool which is used to collect data related to specified group or area.
Q: A JIT system schedules ______. Parts Capacity MPS Operations
A: A just in time inventory refers to the inventory management in which the firms orders the resources…
Q: Operations management is the process of creating a set of specifications from which the product can…
A: Operations management is a management area where the designing and controlling part of the…
Q: Which of the following is NOT an objective of sales and operations planning? Establish greater…
A: Sales and operating plannings are made by the firm in order to have regular operations of the…
Q: Write a sample and sampling technique for the research topic: Relationships between Job Stress and…
A: Research topic: Relationships between Job Stress and Employee Well-Being in the Implications of…
Q: How does a desire for personal control affect managers and how can they balance it with…
A: Organizational control is the systematic method by which managers govern organizational operations…
Q: What are some factors that influence employee work performance and productivity?
A: Employee is an integral part of the business and without them it's impossible for organisation to…
Q: Is it possible to offer value to a customer's project idea by using two unique control structures?
A: Control structures would define the complete implementation phase of the project. It is necessary to…
Q: A campany wants to plan production for the months of January, February, March and April. The demand…
A: Find the Given details below: Month January February March April Total Demand (Unit) 35000…
Q: differences of salary and insurance from the perspective of compensation. Plz do fast asap
A: In return for the work they do, companies will pay their workers a salary or some other kind of…
Q: Application Development: Build In-House or Outsource Use the information in the table below to…
A:
Q: Sit-Yuen Foo has produced monthly forecasts of demand for a family of products as shown below. At…
A: Find the Given details below: Month 1 2 3 4 5 6 7 8 9 10 Total Aggregate demand 460 420 390 450…
Q: Lead time usage refers to the length of period it takes to order and receive goods and also called…
A: Lead time is the duration that is taken to compete the process of producing a product till the final…
Q: __________ involves the assignment of players toless central positions on the basis of race…
A: __________ involves the assignment of players to less central positions on the basis of race or…
Step by step
Solved in 3 steps with 3 images
- 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 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 owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
- 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?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_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?
- 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?The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. 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. Does it make much of an improvement over the model in part b?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.
- 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 following equation summarizes the trend portion of quarterly sales of condominiums over a long cycle. Sales also exhibit seasonal variations. Using the information given, prepare a forecast of sales for each quarter of next year (not this year), and the first quarter of the year following that.Ft = 40 – 6.5t + 2t2whereFt = UnitSales t = 0 at, the first quarter of last yearQuarter Relative1 1.12 1.03 .64 1.3Consider the monthly sales data of a company for last year as well as first six month data for current year. Use a three- quarter weighted moving average, Forecast the sales of company for 3rd Quarter of current year. Use Weights of 4/7, 2/7 and 1/7, giving more weight to more recent data. Note, the 1ist quarter is Jan, Feb and March , 2nd quarter is Apr, May, June, 3rd quarter is July, Aug and Sept, and 4th quarter is Oct, Nov and Dec. Month Jan Feb Mar April May June July Aug Sept Oct Nov DecLast Year 100 125 135 175 185 200 150 140 130 200 225 250Current Year 125 135 135 190 200 190
