You have been asked to forecast the sales of your lead product over the next 2 years. You have access to sales figures for the past 5 years. Using the sales forecasting spreadsheet and the numbers from the past 5 years, shown below, what are the expected sales in year 7? Year Units Sold 3 10000 4 10000 11000 13000 12500 QUESTION 2 According to your Average Total Cost Curve (ATC), average production costs per unit in the range of 14,000 units per year is $850 per unit. Marketing has decided the price should be $1000 per unit for the next 2 years. What is the estimated Net Income from the production operations in Year 7, using your answer from question 1 on this exam?
Q: Explain how product support is affected by the number of known defects in a programme at the time of…
A: Zero Defects has been described as an ideology, a mindset, or a movement. Its goal is to reduce the…
Q: Will arbitration be the prevalent form of dispute resolution for international businesses in the…
A: Arbitration has now become the favored method of dispute solution in international business contacts…
Q: A retail. Store stocks two types of shirts A and B. These are packed in attractive cardboard boxes.…
A:
Q: Here are the changes to the original problem and the revised conditions for this decision-making…
A: Find the Given details below:
Q: Four products are processed sequentially on three machines. The following table gives the data of…
A: Linear programming is a method that is used to determine an optimal solution with the given…
Q: State FIVE (5) importance of operation management towards the organization?
A:
Q: In quality assurance, x-bar charts to monitor:
A: Quality assurance is the process of preventing and controlling defects in the products and services…
Q: Given the following MRP matrix for Item D, Complete the MRP matrix below to identify the projected…
A:
Q: Why is it so important to understand how a business process works when trying to develop a new…
A: There are four main roles in the information system of any company involved in the implementation of…
Q: 3 A product is produced at three plants and shipped to three warehouses (the transportation costs…
A: given,
Q: Mattress Wholesalers, Inc. is constantly trying to reduce inventory in its supply chain. Last year,…
A: Given data Cost of goods sold last years = $7.53 million Cost of inventory = $1.49 million Cost…
Q: In quality assurance, reduction of variations allows us to increase the control limits and have a…
A: Reduction of Variation: Reduction of variation is defined as reduce the product…
Q: Subject: Business process reengineering Q# 5: How Lean sigma is different from Kaizen give…
A: Kaizen, Lean, & Six Sigma. All 3vare business improvement processes & three owe their roots…
Q: Given the demand, cost, and operating data shown below, evaluate the following production plans:…
A: Find the Given details below: Month January February March April May June Total Demand (Unit)…
Q: What is the current progress of the project? The budgeted cost for work scheduled is 700k. Is it on…
A: The two project performance measurements, that can be used are Sceduled performance index and Cost…
Q: 2. a. The following table contains figures on the monthly volume and unit costs for a random sample…
A: Given data is
Q: Consider the following problem: Minimize Z = 5X1 + 8X2 + 3X3 + 5X4 + 12X5…
A: Linear programming is a technique based on mathematics. It helps in getting the best outcome of the…
Q: What is achieved when multiple methods are used in combination with one another yielding more…
A: Marketing communication often called Marcom can be stated as the messages and media that the…
Q: The materials handling manager of a manufacturing company is trying to forecast the cost of…
A: a)The POS for Windows regression model is as follows
Q: Given the following MRP matrix for Item D, the planned order receipt for period 4 is ITEM: D Period…
A: An MRP table helps to plan the ordering process and manage the receiving process of materials. The…
Q: NOT likely to occur after crashing a project activity?
A: Crashing a project endeavor incorporates allocating more means so that a task can be done on /…
Q: a. Develop a network model of the distribution system for this problem. b. Solve the problem to…
A: Steps for part b
Q: The marketing department of the company forecasts a demand of 80,000 bottles of A, 22,000 bottles of…
A: Let x depict T1 and y depict T2.
Q: Demonstrate how companies can streamline the "goal of risk management" to optimise its benefits.
A: Risk management is a method for recognizing hazards quickly and effectively. It should be a…
Q: 5. Common resources versus private goods Spring is here, and Cho and her dad would like to go…
A: A public good is a good or service that can be consumed by everyone and no one can be excluded. A…
Q: My App is a small but growing start-up that sees demand for several of its apps increasing quickly.…
A: Double exponential smoothing is a forecasting model which identify the forecasting with the…
Q: How do you think benchmarking improves a company’s performance? Justify your answer with suitable…
A: Benchmarking is a practice of establishing baselines, defining best practices, identification of the…
Q: Let us revisit the project data from Question 7 of Homework #2, where all times are in days (and it…
A: Given data is
Q: mention advantages and disadvantages of single time estimate and three-time estimate. Bullet form
A: Single time estimates are generally used when the time of the tasks is known with certainty. Single…
Q: How in a supermarket, a manager would go about evaluating the criticalness of an inventory shortage?
A: Supermarkets generate a large portion of their revenue through merchandise sales (i.e. inventory).…
Q: Single time estimate vs. Three-time estimate
A: Time estimation can be stated as the technique of appropriately guessing how long an activity will…
Q: Tom's, Inc., produces various Mexican food products and sells them to Western Foods, New Mexico.…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: In terms of basic handling, what is the role of a unit load?
A: A unit load is nothing but item or number of items or bulk that is crafted so that materials can be…
Q: What are three options to consider when searching for win-win alternatives in negotiation? How does…
A: A win-win negotiation entails a thorough evaluation of both your own and your opponent's views in…
Q: How would a company as successful at foreign market entry as IKEA could have failed in Japan?
A: IKEA, a Swedish multinational corporation that develops and distributes ready-to-assemble furniture…
Q: A brewery produces regular beer and a lower-carbohydrate "light" beer. Steady customers of the…
A: Decision Variable: Suppose- R be the no. of units of regular beer to be producedL be the no. of…
Q: In quality assurance, we use P-charts for discrete defects when there can be more than one defect…
A: Quality is the ability to manufacture the products and services as set standards and increase…
Q: Please explain why large initial separations on the EV S-Curve between the lines for ACWP and BCWP…
A: EV S-Curve: In EV S curve (Earned Value S curve), the cost data is plotted on the graph cost vs time…
Q: 4. ( and deluxe. The estimated unit price on the standard, professional and deluxe model is $40,…
A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: Highbrow cafe employs both male and female chefs who display their culinary skill at diners' tables.…
A: Gary Becker stated that there might always be discrimination in the market, even it could be a…
Q: Create a flowchart about Supermarket Inventory System specifically about promotions and senior…
A: A grocery store is a self-administration store that is isolated into segments and offers a wide…
Q: Samuel is in his mid-40 and has worked for Andres Enterprise for almost 20 years. Samuel has seen…
A: Technology has a great impact on the business operation.Information Technology is the study or use…
Q: 7. Novelis at Oswego NY supplies rolled aluminum sheets to Ford Motor's Kansas City plant to make…
A: The company's nerve center and spiritual center is the Rouge Center. The massive industrial complex,…
Q: Explain with aid of practical examples the following: 1. Scope creep 2. WBS 3. Scope statement
A: Operations management is described as the management of business that is associated with the…
Q: Problem 2 The AB manufacturing company has two kinds of products: A and B. They earn $180 profit for…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: If the test/retest reliability of a measure is .80, it means The measure meets typical reliability…
A: A reliability measure helps to identify the acceptability of the information based on the…
Q: Pizza Hut is going through some challenges and has asked you to identify the most suitable market…
A: Pizza Hut is one of the top fast food chains in the world. They have a large selection of pizzas as…
Q: On what basis do you think AirFreight determined that this was a safety violation? Use lay terms to…
A: After an injury, most organisations, such as Airfreight, would initiate an investigation to…
Q: produce their hev next generation Corporation is plannin iPhone the said product will compete the…
A: Given, Fixed cost for investment of new product = $4500000 Variable cost = $0.75 per unit. Selling…
Q: 14.5. Mama's Stuffin' is a popular food item during months, but it is marginal in the spring and…
A: One of the most challenging issues in production and manufacturing business is failure to have…
1
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- 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?Under what conditions might a firm use multiple forecasting methods?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 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?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
- 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?Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.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_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?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.The table below shows the sales of widgets (in units) over the past 5 years. Using exponential smoothing with a smoothing constant of 0.2, what is the forecast for next year? The initial forecast (for 5 years ago) was 1,200 units. Forecast: Time Sales 5 years ago 1,140 4 years ago 1,220 3 years ago 1,450 2 years ago 1,090 Last year 1,150 (Do not round intermediate calculations, round your final answer to the nearest whole number.)