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.

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.

Essentials Of Business Analytics

1st Edition

ISBN:9781285187273

Author:Camm, Jeff.

Publisher:Camm, Jeff.

Chapter6: Data Mining

Section: Chapter Questions

Problem 20P

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?
You are the newly appointed Records Manager of Transgenerational Thinkers International (GTI).After previewing the structure of the company you realized that it doesn’t have a proper database.Due to this hidden setback, the company always fails to meet its expected profit margin.Develop a comprehensive database to remedy this issue.The database should include;A. i) Customer table andii) Customer registration formB. Fill the table with 30 records.C. The fields of the table should be the same as the forms.Footnotes:D. Your table should include the following fields as headingsI) CustomerID ( eg. CID101, CID102, CID103…………….CID130) II) Surname III) OtherName IV) V) VI) VII) VIII) GenderProductID (eg. P01, P02……………P30)ProductNameProduct Photo (just type in product image)Contact IX) Location X) Date of registration XI) Email XII) Customer photo ( just type in customer image) 3E. Click on insert, select textbox to develop the form below, apply a fill colour for all the…
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…
d) Discuss how allocation of customer-related overhead cost can lead to better decision making within firms with reference to the case below. 'An insurance company, A-Insure Limited, decided to use CPA to identify profitable and non-profitable customers after it grew concerned about the poor financial performance of one of its policy options. A-Insure collected customer data through original policy proposal forms which were stored electronically in a customer database. It was able to conduct a complex cross correlation between known cost drivers and the demographic and other characteristics of policy holders. The cost drivers were: • commission payments to financial advisers who sold the policy early surrender of the policy by the policy holder changing of bank details and consequent chasing of missed premiums responding to customer queries. The analysis identified that the policy was unprofitable when sold to recently retired clients but was profitable when sold to other client…
Which of the following are common use cases for VLOOKUP? (Check all that apply) Check All That Apply Finding a customer's name based on their ID Calculating the total sales of a specific product Looking up a product's price in a price list Retrieving an employee's phone number from a database Returning values from a different sheet in the same workbook.
Retail companies with today’s online, as well as in-store sales have a lot of data to keep track of! Keeping track of sales, costs, and profits daily is essential to making the most of a business. This exercise illustrates how to use the skills presented in this Module to generate the data needed daily by a retail company. Create the following calculated columns. a) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product Cost based on the Product Sold column which lists an ID number. [Hint: The Product Table sheet lists the Price and Cost] If any error messages appear, check the Range Lookup. b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product Cost)*Units Sold Format columns I, J, and K as currency with two decimal places. Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly. a) What was the…
Summarize on what you understand from the purchase cycle system above
Answer this
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,…
Your company is evaluating two cloud-based secured data storage services. "Great Sky," the newer service, claims its uploading and downloading speeds are faster than the older service, "Clear and Steady Skies." You need to make a decision based on published access times for both services at different times and for varying file sizes. To make your decision, you purchase two statistical studies from which you discover the average download time for Great Sky is 0.67 sec. per MB and for Clear Steady Skies is 0.84. Additionally, the studies indicate the following sample information: NGS = 60 ncss = 50, SGS = 0.25 and scss = 0.55. Use a = .05, and the five step hypothesis testing procedure to make the appropriate decision.
In the evaluation of sales transaction processing and control design in the following information:(a)identify two or three potential weaknesses. breifly explain the potential mistatement, recommended correction and possible weakness of all two or three potential weaknesses identified. Marco uses the PC network to manage inventory, sales requisitions, and sales orders. Salesclerks who can read the perpetual inventory records via their PCs take customer orders. Most orders originate from phone requests, but a few arrive on a walk-in basis and some occasionally come in the mail. Usually, building contractors or their representatives call to get current price quotes and find out if specific appliances are in stock. When goods are available and the price is satisfactory, a salesclerk originates a sales requisition and the process of approving and filling it begins if customers plan to pick up their order the same day. Orders received after 4:00 PM cannot be delivered the same day; buyers…
A wide range of accounting information system (AIS) software programs are available in the marketplace. Businesses select one that fits their needs based on budget and systems requirements. Do some research to understand the differences between the way systems process accounting information and produce reports. Choose two types of software from the following list to compare: QuickBooks, Peachtree, Oracle NetSuite, SAP, or MS Access. compare these aspects of each software program: Compare the pros and cons of each system to show the system's benefits and drawbacks for businesses in the way they handle transaction processing for accounting cycles. Discuss the way artificial intelligence (AI) or machine learning is utilized in the system and how these tools elevate data processing and data analytics.