Imagine that you are managing a hotel with 120 rooms. In order to track the occupancy rates you use 6 weeks trailing period. You just received information that 102 out of 120 rooms were occupied on Wednesday (10/16/13). Using updated information on the occupancy rates and the occupancy rates for the last 6 Wednesdays in Table 1, calculate the rolling average for Wednesdays. Table 1 Date Occupancy O 64% O 57% 82% O 61% 09/04/13 09/11/13 09/18/13 09/25/13 10/02/13 10/09/13 42.5% 55% 60% 45% 62.5% 77.5%
Q: A single server queuing system with a Poisson arrival rate and exponential service time has an…
A: As per the guidelines, the first question is taken for answering purposes,
Q: QUESTION 4 A juice manufacturer receives bottle caps under ANSI/ASQC Z1.4. Normal inspection has…
A: The Indifference quality level is the level of quality that separates the acceptability and…
Q: Best practices are followed by ERP systems. But which ones? Often, North American or European…
A: ERP is a software package designed for organizations that helps in managing important functions of…
Q: 2 3 4 5 6 7 8 9 10 Task Mode - - C Task Name MANAGEMENT PLANS AND PERMITS Complete kitchen drawings…
A: The Gantt chart is a visual representation of the overall progress of the project. Knowledge of…
Q: 5. A telephone company purchased a microwave equipment for P6 Million with a salvage value of…
A: Find the Given details below: Given details:Purchase cost6000000Salvage value600000Maintenance…
Q: Leary Chemical manufactures three chemicals: A, B, and C. These chemicals are produced via two…
A: Linear programming helps us to find the optimal solution/best outcome, given the constraints.We…
Q: Identify the critical path A.B.C.D.E A.B.C.D.F B.C.D A.D.E.F.G 000
A: The critical path can be identified by drawing a network diagram, generally AON and AOA diagram.…
Q: Flintstone Company is planning to spend up to $4,000,000 on new delivery trucks. Flintstone decided…
A: Note: The information provided in the question is about delivery trucks for the "Flintstone…
Q: 13.16 A large Omaha feed mill, B. Swart Processing, prepares its 6-month aggregate plan by…
A: Find the given details below: Given details:Regular time cost (Until April 30) $…
Q: Andy's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two…
A: Inventory level is the number of goods and materials that are stocked by a business at a point in…
Q: Jacob is the owner of Jacob’s Jam. What started as a hobby, quickly turned into a successful…
A: Answer) The report will contain congratulations to Jacob for the success of his business Jacob's…
Q: The United Kingdom has had multiple problems in the field of healthcare management when it comes to…
A: SWOT stands for Strength, Weakness, Opportunities, and Threats. SWOT analysis helps in identifying…
Q: The Fore and Aft Marina is located on the Ohio River near Madison, Indiana. Fore and Aft currently…
A:
Q: Agan Interior Design provides home and office decorating assistance to its customers. In normal…
A:
Q: Baker Mfg Inc. wishes to compare its inventory turnover to those of industry leaders, who have…
A: Inventory turnover is based on an estimation of how quickly a firm sells its inventory. A high…
Q: Questions 5 through 13 are based on the following information: A small manufacturing company uses…
A: Safety stock refers to the additional inventory that a company holds beyond its average stock levels…
Q: What are the common challenges faced during the planning of work activities and how do you overcome…
A: For any project to succeed, we must consider the planning of work activities, through effective…
Q: Available number of units on hand of M is 50 and O is 200. How many units of O is required to be…
A: Mathematic models of decision-making help businesses make the correct decisions for their…
Q: Inventory serves as an alternative to future production or procurement activities. Too little…
A: "Inventory management is a crucial component of contemporary companies, acting as the foundation for…
Q: C. Start A 3 B 2 C2 с 7 E3 F7 Finish b. Identify the critical path and estimate the project's…
A: The critical path is the sequence of tasks or activities in a project that takes the longest time to…
Q: How do you propose a lean operations strategy (a combination of 2 processes and 3 tools) that will…
A: Proposing a lean tasks procedure for a furniture organization includes distinguishing cycles and…
Q: You have recently joined as the project manager of ABC Company. Please refer to the Excel file to…
A: Find the Calculations methods below:
Q: Given the manpower allocation table of a Project, determine how many days do the peak manpower…
A: Find the Given details below:
Q: Below is a network diagram with information necessary for crashing. Above each Activity letter is…
A: The two possible paths (along with their durations) are:· A-B-D-E (7+5+6+3=21)· A-C-D-E (7+5+6+3=21)
Q: Shown below is a partially completed MPS record for ball bearings. a. Develop the MPS for ball…
A: Master production scheduling is a process that determines the quantity and timing of production for…
Q: What is meant by the term "outsourcing," and what are two benefits it offers to a company when it is…
A: The practice of contracting out some corporate operations or procedures to outside service providers…
Q: Explain the problems associated with purchasing through limited tendering exercise
A: Procurement is a process of identifying, selecting, and accepting a vendor or supplier with certain…
Q: In what ways do the Internet and information systems affect Porter's five forces of competition, and…
A: The Internet and information systems have a singificant impact on Porter's five forces of…
Q: A manager has 7 part-time workers and needs to assign different working days to them. The maximum…
A: Integer programming is a branch of mathematical optimization that deals with solving optimization…
Q: Give typing answer with explanation and conclusion manufacturing company is considering…
A: Follwing is the details provided in the above case- Variable cost- $60Total Fixed cost -…
Q: A local large company has adopted a policy of procuring from local SME, how can the implementation…
A: SCM is a strategic approach to integrating supply and demand in the market. It involves several…
Q: Please do not copy and paste from online or printed resources, instead use your own words. In your…
A: Business management is the process the managing the task that is important for the smooth conduction…
Q: A health and nutrition store stocks a multivitamin with an annual demand of 1,000 bottles has Co =…
A: Find the given details below: Annual Demand (D)1000Carrying (Holding) cost (H) $…
Q: Explain the process of obtaining certification and training, and cite specific instances from…
A: Obtaining certification and training in operations management is crucial for professionals seeking…
Q: The following table lists the components needed to assemble an end item, lead times (in weeks), and…
A: Material requirements planning - is based on the production planning, scheduling, and inventory…
Q: How would you explain the concept of risk management, including the procedures of detecting risks,…
A: Risk management in the operations management is systematic process that involves the identifying,…
Q: A paint company has three sources for buying bright red pigment for its paints: Vietnam, Taiwan, and…
A: A paint company has 3 sources to buy red pigment for its paints:VietnamTaiwanThailandThe…
Q: A project has the following activities, with specified precedents and expected durations (in days).…
A: A network diagram is a graphical representation of a project that helps to identify the activity…
Q: Please do not give solution in image formate thanku. The following text discusses three primary…
A: An effective leadership style focuses on the growth as well as the development of team members.…
Q: What opportunities for improvement does the shipping sector have to take use of the automation…
A: The shipping sector is a vital industry that plays a significant role in facilitating global trade…
Q: 3 The Sweet Smell Fertilizer Company markets bags of manure labeled "not less than 60 pounds dry…
A: The graphical LP method is a way to solve linear programming problems by graphing the constraints…
Q: Give short answers to the following questions: i. What makes the construction industry different…
A: The construction industry plays an essential role in influencing the constructed environment,…
Q: How do you see the future in terms of resourcing police functions?
A: The future of resourcing police functions is likely to be influenced by several factors, including…
Q: Suppose 1 worker is assigned to the cell, what is the cycle time of this cell?
A: Cycle time is a concept that is used in the manufacturing industry to measure and optimize…
Q: If a successor cannot start until the predecessor finishes, the dependency between the activities is
A: There are four types of dependency between the activities, these areFinish to startstart to…
Q: M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 725…
A: Inventory management is the process of planning, organizing, and controlling the flow of goods and…
Q: 34. Given the data in the figure (Figure for Standard Time Computation), compute the takt time if…
A: Takt time is a fundamental concept in manufacturing and process management that plays a crucial role…
Q: Jill is concerned that the latest short term demand forecast for dog grooming at her Fifteenth…
A: Schedule and Staffing: Jill should review her current staffing schedule and consider adding more…
Q: Use the following information to answer the question(s) below. Cerebro Manufacturing produces four…
A: Capacity management is the process of ensuring that an organization has the resources it needs to…
Q: Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the…
A: Find the given details below: Given details:Price (x)Number Sold…
Question Z
.
Full explain this question and text typing work only
We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line .
Step by step
Solved in 3 steps with 1 images
- 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?The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? b. Repeat part a with a span of 10. c. Which of these two spans appears to be more appropriate? Justify your choice.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?
- We all hate to bring small change to the store. Usingrandom numbers, we can eliminate the need for change andgive the store and the customer a fair shake.a Suppose you buy something that costs $.20. How could you use random numbers (built into the cash reg-ister system) to decide whether you should pay $1.00 or nothing? This eliminates the need for change!b If you bought something for $9.60, how would youuse random numbers to eliminate the need for change?c In the long run, why is this method fair to both thestore and the customer?Please help with correct answers in details: Step by step Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week Sales (1,000sof gallons) 1 17 2 21 3 20 4 24 5 18 6 17 7 21 8 19 9 22 10 21 11 16 12 22 (a) Compute four-week and five-week moving averages for the time series. Week Time SeriesValue 4-WeekMovingAverageForecast 5-WeekMovingAverageForecast 1 17 2 21 3 20 4 24 5 18 6 17 7 21 8 19 9 22 10 21 11 16 12 22 b) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) c) Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) d) What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? MSE for the three-week moving average is 9.65.…Because Tt reflects the overall trend component in the time series up to period t, we need to setthis value is equal to 1 for the first period as a starting point when using exponential smoothing withtrend adjustment True or False
- A version of simple exponential smoothing can beused to predict the outcome of sporting events. To illustrate,consider pro football. We first assume that all games areplayed on a neutral field. Before each day of play, we assumethat each team has a rating. For example, if the Bears’ ratingis 10 and the Bengals’ rating is 6, we would predict theBears to beat the Bengals by 10 6 4 points. Supposethe Bears play the Bengals and win by 20 points. For thisobservation, we “underpredicted” the Bears’ performanceby 20 4 16 points. The best a for pro football is 0.10.After the game, we therefore increase the Bears’ rating by16(0.1) 1.6 and decrease the Bengals’ rating by 1.6 points.In a rematch, the Bears would be favored by (10 1.6) (6 1.6) 7.2 points.a How does this approach relate to the equation At At1 a(et)?b Suppose the home-field advantage in pro football is3 points; that is, home teams tend to outscore visitingteams by an average of 3 points a game. How could thehome-field advantage be…To better plan for future growth of the restaurant, Karen needs to develop a system that will enable her to forecast food and beverage sales by month for up to one year in advance. Table shows the value of food and beverage sales ($1000s) for the first three years of operation. Food and Beverage Sales for the Vintage Restaurant ($1000s) Month First Year Second Year Third Year January 242 263 282 February 235 238 255 March 232 247 265 April 178 193 205 May 184 193 210 June 140 149 160 July 145 157 166 August 152 161 174 September 110 122 126 October 130 130 148 November 152 167 173 December 206 230 235 Managerial Report Perform an analysis of the sales data for the Vintage Restaurant. Prepare a report for Karen that summarizes your findings, forecasts, and recommendations. Include the following: A time series plot. Comment on the underlying pattern in the time series.…Overhead Costs Billable Hours 395000 2000 440000 3000 460000 4000 513000 5000 580000 6000 605000 7000 Develop a simple linear regression model between billable hours and overhead costs. Overhead Costsequals=enter your response hereplus+left parenthesis nothing right parenthesisenter your response heretimes×Billable Hours (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.)
- The following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (a)Use ? = 0.4 to compute the exponential smoothing values for the time series. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (b)Use a smoothing constant of ? = 0.6 to compute the exponential smoothing forecasts. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110Lifang Wu owns an automated machine shop that makes precision auto parts. He has just compiled an input—output report for the grinding work center. Period 1 2 3 4 Total Planned input 70 70 85 85 Actual input 75 75 75 75 Deviation Planned output 75 75 75 75 Actual output 85 85 80 80 Deviation Initial backlog: 20 For the given information related to "inputs," the values for deviation and total are: The deviation in period 2 = units (enter your response as an integer, including a minus sign if necessary). Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 126.0625 (thousand units).Fill in the missing values assuming there is no trend.Round seasonal indexes to 4 decimal places.Report Averages accurate to at most 2 decimal places.Report Actual sales ('000) accurate to the nearest integer. Year 1 Year 2 Year 3 Year 4 Average Seasonal Index Quarter 1 92 93 95 106 Quarter 2 105 106 105 101 Quarter 3 197 187 196 1.5211 Quarter 4 106 116 121 0.8865 PART BSuppose actual quarterly sales (in thousands) for Year 5 are 93, 123, 206, and 126 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 5.Use seasonal indexes (rounded to 4 decimal places) from Part A.Report forecast answers as integers accurate to the nearest thousand.Quarter 1 forecast = thousandQuarter 2 forecast = thousandQuarter 3 forecast = thousandQuarter 4 forecast =…