PRODUCT A PRODUCT B PRODUCT C Total Budgeted sales in pieces 2700 9500 5600 17800 Budgeted sale price in € 35 35 110 Actual sales in pieces 5000 18000 5800 28800 Actual selling price per piece 37 90 115 You are asked to find the total sales deviation, volume deviation and price deviation per product
Q: Based on the following equation for a moving average forecast, what would have been the three week…
A: Here, each week has the revenue data, I will apply the 3-week moving average technique, the 6-week…
Q: Given the project activity table below: Activity A B C D E F G H I J K Duration (weeks) 8 4 3 3 1 7…
A: Here, for each activity, I am given the dependency data and the duration data in weeks, Let me show…
Q: Explain what is normal distribution and why is it important
A: Normal distribution, also known as Gaussian distribution, is a type of continuous probability…
Q: How would you define a project?
A: A project can be defined as a temporary endeavor undertaken to create a unique product, service, or…
Q: How does lean manufacturing support environmental sustainability and waste reduction efforts?
A: When physical products are designed and made, lean methods, principles, and tools are used. This…
Q: What is the economic ordering quantity? How many orders will be placed during the year? What will…
A: Annual usage or Annual demand (A) = 97200Ordering Cost (B) = $4 per orderCarrying Cost (C) = $1.50…
Q: Bindley Corporation has a one-year contract to supply motors for all washing machines produced by…
A:
Q: Which of the following statements about big data is false? Firms use high-powered analytical models…
A: In reality, involvement of operations managers is crucial in the implementation of big data…
Q: Assume an initial starting Ft of 200 units, a trend (Tt) of 8 units, an alpha of 0.30, and a delta…
A: The objective of the question is to calculate the forecast including trend for the next period using…
Q: Discuss the implications of global manufacturing trends on production system design.
A: Production system design is creating a mechanism for production. It's similar to creating a map…
Q: A company wants to generate a forecast for unit demand for year 2017 using exponential smoothing.…
A: The objective of the question is to calculate the forecast for the year 2017 using the exponential…
Q: Ross White’s machine shop uses 2500 brackets during the course of a year, and this usage is…
A: Annual demand is 2500 brackets, The purchase price per bracket is 15The lead time is 2 days, The…
Q: Safety regulations require that the time between airplane takeoffs (on the same runway) will be at…
A: Find the given details below:
Q: I am doing a Project Study so please prepare a journal entry sharing your reflections on your…
A: The center issue recognized for this examining project revolves around figuring out the diverse…
Q: how does quality management contribute to enhancing customer satisfaction and loyalty?
A: Quality management is the act of supervising numerous roles and operations inside a company to…
Q: How does supply chain integration help companies respond more effectively to changes in customer…
A: Supply chain integration is the process of creating an efficient system that prevents delays,…
Q: Services differ from goods in that I. A service is a tangible process II. A…
A: The objective of the question is to identify the correct statements that differentiate services from…
Q: How do businesses balance cost-cutting measures with investments in productivity-enhancing…
A: Productivity measures a person, device, industrial facility, system, or other entity's ability to…
Q: Purell magazine and publishing house started construction of the office complex, Richard Green, who…
A: Business law is the aspect of the law that describes the rules, regulations, and laws that are…
Q: State. What are the implications of operations management on cost control and profitability?
A: Operations management, or OM, is the process of managing business procedures to achieve optimal…
Q: What are the key features and benefits of Failure Mode and Effects Analysis (FMEA) as a quality…
A: Failure Mode and Effects Analysis (FMEA) is a systematic method used to identify and mitigate…
Q: Johnson is an estate agent and he has been asked by his client to sell for him three products A,B…
A:
Q: (EOQ model with lead times and integer multiple policy): Consider the EOQ model discussed in class…
A: Find the given details: Fixed ordering cost (K), holding rate cost per unit item per unit of time…
Q: Haji Ismail Company is going to introduce one of the three new products: keropok, satay, and chips.…
A: Let me state the given data, Product FavorableStable…
Q: What is the role of KPIs in performance measurement? A. To identify data sources B. To set…
A: Identify data sources: KPIs rely on pre-existing data gathered from various sources; they do not…
Q: The total time taken to manufacture the first unit of Product A by Beta, Inc., was 80 hours. The…
A: Time taken to produce 1st unit = 80 hoursLearning Curve Percent = 90%
Q: What are some emergency procedures one would use in the workplace at a reposession company
A: The objective of this question is to understand the emergency procedures that should be in place in…
Q: Don't give AI solution pls Supply Chain Management can be described as the synchronisation…
A: A supply chain is an arrangement of interdependent systems, resources, capacities, and technologies…
Q: h ow is master production schedule created and how it is used ?
A: A key component of production planning in the industrial industry is the Master Production Schedule…
Q: There are several steps to follow (processes) in preparing research proposal. Discuss thosesteps.
A: The objective of this question is to understand the various steps involved in preparing a research…
Q: Operation management... discuss , what role does supply chain resilience play in mitigating…
A: Operation management is an aspect of management that deals with the management of the production,…
Q: Given the project activity table below: Activity A B C DEFGH I J K Duration (weeks) 8 4 3 3 1 7 5 6…
A: Let me state the given data, Activityduration weeksDependencyA8NoneB4NoneC3NoneD3AE1CF7CG5DH6B,…
Q: Construct a 3-sigma X-bar chart for the length in centimeters of a part from the following tabble .…
A: Sampleobservation 1observation 2observation 3observation…
Q: How does technology support value stream mapping activities, such as software tools and digital…
A: Value stream mapping, is the process of visualizing the data and important actions involved in…
Q: What is the number of breakeven units if the fixed costs are $25,000, the cost per unit is $24.36,…
A: The objective of this question is to calculate the breakeven point in units. The breakeven point is…
Q: Monthly data for the sales of certain product at a local company during the las 9 periods are shown…
A: The objective of the question is to calculate the forecasts for periods 5 through 9 using…
Q: 9. You have been asked to assess the success of a recently implemented system that has been deployed…
A: Supply chain management is the aspect of management that deals with all the movement or flow that…
Q: A builder has located a piece of property that she would like to buy and eventually build on. The…
A: We prepare a decision tree as shown below:Here, the profit for Node 4, 9 and 10 are calculated as…
Q: Consider the following project with activities A through H. Activity Immediate Predecessors |…
A: A precedence diagram is utilized in project management to describe the series and dependencies of…
Q: The company has the following information about its two service departments and two production…
A: analysis percentage (proportional) by the operated Maintenance Department by the Cutting Department…
Q: An electronic contractor is examining the amount of time his crews take to complete wiring jobs.…
A:
Q: What is the different between the power of design and the power of focus?
A: Power of Design: The ability to shape and create solutions, experiences, and objects that meet…
Q: The sales and finance team of a car company is evaluating a new proposed luxury model of its brand…
A: Estimating the annual revenue from selling the cars.Estimating the annual production…
Q: Required Information [The following information applies to the questions displayed below.] Professor…
A: A scatter graph, also commonly known as a scatter plot, is a mathematical diagram that displays the…
Q: Discuss the importance of agility and adaptability in operational decision-making.
A: Agility and adaptability are essential attributes in operational decision-making, enabling…
Q: A company must perform a maintenance project consisting of seven activities. The activities, their…
A: The objective of this question is to identify the activities that have slack in the project using…
Q: The following figure shows the product structure tree of product A. A D (2) B (2) E (1) C | D (3)…
A: Operations planning and control is a four-level structure consisting of S&OP, MPS, materials…
Q: Assuming you are a crimianl justice supervisor, how would you handle a coworker who faced an ethical…
A: The secret step incorporates seeing and sorting out the opportunity of the ethical circumstances.…
Q: Determine, How does break-even analysis assist businesses in making decisions regarding cost control…
A: Break-even analysis is the study is to determine the amount of revenue that will be needed to pay…
Q: how does the project life cycle influence resource allocation and utilization?
A: The project life cycle represents the stages a project progresses through from initiation to…
|
|
PRODUCT A |
PRODUCT B |
PRODUCT C |
Total |
|
Budgeted sales in pieces |
2700 |
9500 |
5600 |
17800 |
|
Budgeted sale price in € |
35 |
35 |
110 |
|
|
Actual sales in pieces |
5000 |
18000 |
5800 |
28800 |
|
Actual selling price per piece |
37 |
90 |
115 |
|
You are asked to find the total sales deviation, volume deviation and price deviation per product
Step by step
Solved in 5 steps with 21 images
- 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?A small computer chip manufacturer wants to forecast monthly ozperating costs as a function of the number of units produced during a month. The company has collected the 16 months of data in the file P13_34.xlsx. a. Determine an equation that can be used to predict monthly production costs from units produced. Are there any outliers? b. How could the regression line obtained in part a be used to determine whether the company was efficient or inefficient during any particular month?An antique collector believes that the price received for a particular item increases with its age and with the number of bidders. The file P13_14.xlsx contains data on these three variables for 32 recently auctioned comparable items. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Is the antique collector correct in believing that the price received for the item increases with its age and with the number of bidders? Interpret the standard error of estimate and the R-square value for these data.
- 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.Accountants at the Tucson firm, Larry Youdelman,CPAs, believed that several traveling executives were submittingunusually high travel vouchers when they returned from businesstrips. First, they took a sample of 200 vo uchers submitted fromthe past year. Then they developed the following multiple regressionequation relating expected travel cost to number of days onthe road (x1) and distance traveled (x2) in miles:y = $90.00 + $48.50x1 + $.40x2The coefficient of correlation computed was .68.a) If Barba ra Downey returns from a 300-miJe trip that took herout of town for 5 days, what is the expected amount she shouldclaim as expenses?b) Downey submitted a reimbursement request for $685. Whatshould the accountant do?c) Should any other variables be included? Which ones? Why?Rajan wanted a radio from Jacky's. It appears that Rajan is particularly interested in purchasing a Radio from the inexpensive retailer's sales manager for consumer electronics. He tells Jacky, the salesperson at the inexpensive store where he thinks he'll get the best deal, that his old radio died and he wants to listen to his favourite tunes. He wants a replacement radio as quickly as possible. In three and a half weeks, Rajan's favourite model will be 10% off.He suspects Rajan won't wait and will find another job. Jacky will earn less on the lowered price. He thinks that telling Rajan of the sale makes little sense.When Jacky tells Rajan that the radio set he wants is no longer available and won't be for another week, Rajan is enraged. Fearing losing the business, Jacky begs his sales manager, Michelle, to speed up delivery. Michelle says it's impossible and suggests Jacky tell Rajan the store can get the set in 24 hours and sell him the demo model. Michelle says the sample is new…
- The classified department of a monthly magazine has used a combination of quantitative and qualitative methods to forecast sales of advertising space. Results over a 20-month period are as follows:Month Error1 −8 2 −2 3 4 4 7 5 9 6 5 7 0 8 −3 9 −9 10 −4 11 1 12 6 13 8 14 4 15 1 16 −2 17 −4 18 −8 19 −5 20 −1 a. Compute a tracking signal for months 11 through 20. Compute an initial value of MAD for month 11, and then update it for each month using exponential smoothing with α = .1. What can you conclude? Assume limits of ± 4.b. Using the first half of the data, construct a control chart with 2s limits. What can you conclude?c. Plot the last 10 errors on the control chart. Are the errors random? What is the implication of this?Macomb Inc. used Excel to run a least-squares regression analysis on the production cost data resulting in the following output: Regression StatisticsMultiple R 0.9834 R Square 0.9596 Observations 30 Coefficients Standard Error T Stat P-ValueIntercept 174,980 61,580 2.84 0.021 Production units (X) 11.53 0.9265 12.44 0.000 What total cost would Macomb predict for a month in which production is 2,000 units? Multiple Choice $174,900 $63,433 $198,040 $23,0371.) Use the following dummy variables to develop an estimated regression equation to account for seasonal effects only in the data. Qtr1 = 1 if Quarter 1, 0otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise, Qtr3 = 1 if Quarter 3, 0otherwise. Based only on the seasonal effects in the data, compute estimates of quarterly sales for year 6.a. Report the estimate of sales for Year 6 Quarter 1. (Enter a whole value.)b. Report the estimate of sales for Year 6 Quarter 4. (Enter a whole value.)2.) Let Period t = 1 refer to the observation in quarter 1 of year 1; Period t = 2refer to the observation in quarter 2 or year 1; … and Period t = 20 refer to the observation in quarter 4 of year 5. Using the dummy variables defined in part (b) and Period (t), develop an estimated regression equation to account for seasonal effects and any linear trend in the time series. Based upon the seasonal effects in the data and linear trend, compute the estimates of quarterly sales for year 6.a. Report the estimate…
- 7. The following multiple-regression model was developed to predict job performance as measured by a company job performance evaluation index based on a preemployment test score and college grade point average (GPA): y=35+20x1+50x2, where y=job performance evaluation index, x1=preemployment test score, and x2=college GPA. Part 2 a) For an applicant who had a 3.0 GPA and scored 80 on the preemployment test, the forecast for the job performance index= __________ (enter your response as a whole number).. Jerry Sam owns and operates a chain of 12 department stores in New Ville. Sales figuresand advertising expenses for the stores are provided in the table below. Sales are given inmillions of dollars; advertising expenses are in tens of thousands of dollars.Store Advertising Sales1 14 62 11 33 15 54 16 55 24 156 28 187 22 178 21 129 26 1510 43 2011 34 1412 9 5i. Calculate the slope for the regression line. (show all working) ii. Calculate the intercept for the regression line. (show all working) iii. Write the equation for the regression line. iv. Forecast sales for a store if advertising spending is:-1. $240,000 2. $300,000An advertising executive claims that there is a difference in the mean household income for credit cardholders of Visa Gold and of MasterCard Gold. A random survey of 15 Visa Gold cardholders resulted in a mean household income of $68,420 with a standard deviation of $9100. A random survey of 6 MasterCard Gold cardholders resulted in a mean household income of $59,200 with a standard deviation of $9200. Is there enough evidence to support the executive's claim? Let μ1 be the true mean household income for Visa Gold cardholders and μ2 be the true mean household income for MasterCard Gold cardholders. Use a significance level of α=0.05 for the test. Assume that the population variances are not equal and that the two populations are normally distributed. Step 1 of 4: State the null and alternative hypotheses for the test. Step 2 of 4: Compute the value of the t test statistic. Round your answer to three decimal places. Step 3 of 4: Determine the decision rule for rejecting the…