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.

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.