Desert Rose Electronics implemented a new returns authorization process. Returns require: inspection code (45% weighting), testing report (35% weighting), customer details (20% weighting). If a return scored 38 on inspection, 42 on testing, and 85 on customer details, your task is to identify the weighted acceptance score.

Desert Rose Electronics implemented a new returns authorization process. Returns require: inspection code (45% weighting), testing report (35% weighting), customer details (20% weighting). If a return scored 38 on inspection, 42 on testing, and 85 on customer details, your task is to identify the weighted acceptance score.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter3: Data Visualization

Section: Chapter Questions

Problem 19P: Heat maps can be very useful for identifying missing data values in moderate to large data sets. The...

See similar textbooks

Similar questions

You can use Excel functions to find the answers for the following question (round off the values to 4 decimal places): Supplier on-time delivery performance is critical to enabling the buyer’s organization to meet its customer service commitments. Therefore, monitoring supplier delivery times is critical. Based on a great deal of historical data, a manufacturer of personal computers finds for one of its just-in-time suppliers that the delivery times are random and well approximated by the Normal distribution with mean 51.7 minutes and standard deviation 9.5 minutes. (15p) a. What is the probability that a particular delivery will exceed one hour? b. What is the probability that a particular delivery arrives in less than one hour? c. What is the probability that the mean time of 5 deliveries will exceed one hour?
When a company has post-acquisition expenditures related to Property, Plant, and Equipment it must determine whether the amount should be expensed as an ordinary repair or capitalized as a major repair, addition, or betterment. This requires considering the nature of the expenditure and the use of judgment. Many companies use a threshold amount. Any expenditure below the threshold is expensed. Items over the threshold are examined and a decision is made about whether to expense or capitalize the item. This approach is justified by both materiality and considering costs and benefits. For example, a company with $94 million in net property, plant, and equipment and $250 million of operating expenses would not consider a $100 repair as material. Plus, if the company had to spend thousands of dollars examining every repair expenditure, the costs of doing the analysis could easily outweigh the benefits. SouthEast Equipment has a large number of machines and equipment that are available for…
Silver Lining Inc. has a balanced scorecard with a strategy map that shows that delivery time and the number of erroneous shipments are expected to affect the company’s ability to satisfy the customer. Further, the strategy map for the balanced scorecard shows that the hours from ordered to delivered affects the percentage of customers who shop again, and the number of erroneous shipments affects the online customer satisfaction rating. The following information is also available: The company’s target hours from ordered to delivered is 40. Every hour over the ordered-to-delivered target results in a 0.5% decrease in the percentage of customers who shop again. The company’s target number of erroneous shipments per year is no more than 65. Every error over the erroneous shipments target results in a 0.05 point decrease in the online customer satisfaction rating and an added future financial loss of $500. The company estimates that for every 1% decrease in the percentage of customers who…
You can use Excel functions to find the answers for the following question (round off the values to 4 decimal places): a. Supplier on-time delivery performance is critical to enabling the buyer’s organization to meet its customer service commitments. Therefore, monitoring supplier delivery times is critical. Based on a great deal of historical data, a manufacturer of personal computers finds for one of its just-in-time suppliers that the delivery times are random and well approximated by the Normal distribution with mean 51.7 minutes and standard deviation 9.5 minutes.
Heat maps can be very useful for identifying missing data values in moderate to large data sets. The file SurveyResults contains the responses from a marketing survey: 108 individuals responded to the survey of 10 questions. Respondents provided answers of 1, 2, 3, 4, or 5 to each question, corresponding to the overall satisfaction on 10 different dimensions of quality. However, not all respondents answered every question. a. To find the missing data values, create a heat map in Excel that shades the empty cells a different color. Use Excels Conditional Formatting function to create this heat map. Hint: Click on Conditional Formatting in the Styles group in the Home tab. Select Highlight Cells Rules and click More Rules. Then enter Blanks in the Format only cells with: box. Choose a format for these blank cells that will make them obviously stand out. b. For each question, which respondents did not provide answers? Which question has the highest nonresponse rate?
Please explain proper steps by Step and Do Not Give Solution In Image Format ? And Fast Answering Please ?
The table below summarizes the data that may be useful for evaluating one of the suppliers, Ling Ling Inc. If Ling Ling's competing supplier quotes a price of $46, what is the total evaluation score for Ling Ling Inc. using the weighted point method? Factor Weights Method of measurement | Supplier performance (past 12 months) Quality 40 1% defective, subtract 5% 0.8% defective Delivery 30 1 day late, subtract 1% Average 2 days late Price 20 Lowest price paid or price charged $50 Service 10 Good 70%; Fair = 70%; Poor = 40% | Fair = 70% (a) 89.7 (b) 93.2 (c) Neither 89.7 nor 93.2 (d) Cannot determine from the above information because it cannot be compared to another supplier's performance rating
izzo Goal Inc. produces and sells hockey equipment, often custom made for online orders. The company has the following performance metrics on its balanced scorecard: days from ordered to delivered, number of shipping errors, customer retention rate, nd market share. A measure map illustrates that the days from ordered to delivered and the number of shipping errors are both expected to directly affect the customer retention rate, which affects market share. Additional internal analysis finds that: Every shipping error over three shipping errors per month reduces the customer retention rate by 1.5%. On average, each day above three days from ordered to delivered yields a reduction in the customer retention rate of 1%. Each day before three days from order to delivery yields an increase in the customer retention rate of 1%, on average. Rizzo Goal Inc.'s current customer retention rate is 60%. The company estimates that for every 1% increase or decrease in the customer retention rate,…
Please answer all parts with detailed calculations and good formatting and make sure the answer is 100% correct, else leave it for the other tutor to answer. Otherwise i will downvote the answer and report it for uprofessionalism for sure. Please don't use AI or Chat GPT also make sure there is no plagiari.sm.
Meagher Solutions Inc. manufactures memory chips for personal computers. An activity analysis was conducted, and the following activity costs were identified with the manufacture and sale of memory chips: a. Identify the cost of quality classification for each activity. Quality Activities Correct shipment errors Disposing of scrap Emergency equipment maintenance Employee training Final inspection Inspecting incoming materials Preventive equipment maintenance Processing customer returns Scrap reporting Supplier development Warranty claims. Total Quality Cost Classification Prevention b. Prepare a cost of quality report. Assume that the sales for the period were $4,000,000. If required, round percents to one decimal place. Activity Cost Appraisal Internal failure External failure Total $150,000 95,000 125,000 50,000 80,000 60,000 40,000 90,000 45,000 15,000 250,000 $1,000,000 Meagher Solutions Inc. Cost of Quality Report Percent of Total Quality Cost Quality Cost % % % % Quality Cost…
In a manufacturing process the assembly line speed (feet per minute) was thought to affect the number of defective parts found during the inspection process. To test this theory, managers devised a situation in which the same batch of parts was inspected visually at a variety of line speeds. They collected the following data: Develop a scatter chart with line speed as the independent variable. What does the scatter chart indicate about the relationship between line speed and the number of defective parts found? Use the data to develop an estimated regression equation that could be used to predict the number of defective parts found, given the line speed. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the number of defective parts found for the sample data does the model you estimated in part (b) explain?
My formular function was wrong in cell C5 in contribution sheet. Please give me the right solution. Instruction: Enter a SUMIFS function into cell C5 on the Contribution worksheet that sums the Sales Revenue on the Sales and Cost Data worksheet based on the year that is entered into cell B1 on the Contribution worksheet. The data to be summed is in Column E on the Sales and Cost Data worksheet. The function should find a match in the Year column on the Sales and Cost Data worksheet to the year entered in cell B. The function should also find a match to the item in cell A5 (Sales Revenue) in Column C on the Sales and Cost Data worksheet. Add cell capacity to include Row 100 on the Sales and Cost Data worksheet.