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?
Using the Microsoft 10K for the Fiscal Year ended June 30, 2018 to answer questions: 1. Interpret the results of 2018 "above the line" compared to 2017 "above the line" and then 2017 "below the line" and 2017 "below the line". 2. What is the revenue and cost streams of MSFT using the 10K. How are the costs allocated between the product and service streams? 3. What are the revenue recognition policy of MSFT?4. What are some examples of the revenue recognition for each area as mentioned in the report?5. What is the EBIT and EBITDA for MSFT for 2018 and 2017? How did you calculate this? 6. Using the MSFT financial statements, what is the variance for the balances listed below). The answer must include: % change from 2017 to 2018$ change from 2017 to 2018please state whether it is a favorable or unfavorable variance from 2017 to 2018 Cost of services Selling, general, administration and other Gross Profit of services Gross Profit of products 7. In the financial statement, what is the…
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 ?
B1. Account
Performance Task #2. Case Study Instructions: Analyze the given situations and prepare what is asked for you to compute. Answers must be in a paragraph form. Place your output in your notebook. God bless! You are auditing the financial statements of Sakura Store, a retailer of sporting goods, appliances, and electronics. During the prior years' audits of Sakura Store, you noticed that management was less concerned about the timely recording of liabilities and expenses than assets and revenues. As a result, very little of Sakura Store's internal control resources were expended in assuring an accurate and timely recording of accounts payable. You also believed that Sakura Store's management may be motivated to delay recording its liabilities at year end, so you are currently approaching the search for unrecorded liabilities with caution. Questions: a. Wha are the substantive auditing procedures would you perform in searching for Sakura's unrecorded liabilities? 109 6. How would the…
Measure Maps 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 20. 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 55. Every error over the erroneous shipments target results in a 0.5 point decrease in the online customer satisfaction rating and an added future financial loss of $800. The company estimates that for every 1% decrease in the percentage of…
Measure Maps 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 30. 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 55. 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 $600. The company estimates that for every 1% decrease in the percentage of…
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,…
The following list gives a number of measures associated with the Balanced Scorecard:a. Number of new customersb. Percentage of customer complaints resolved with one contactc. Unit product costd. Cost per distribution channele. Suggestions per employeef. Warranty repair costsg. Consumer satisfaction (from surveys)h. Cycle time for solving a customer problemi. Strategic job coverage ratioj. On-time delivery percentagek. Percentage of revenues from new productsRequired:1. Classify each performance measure as belonging to one of the following perspectives:financial, customer, internal business process, or learning and growth.2. Suggest an additional measure for each of the four perspectives.
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.