Question: 1 . Determine the minimum and maximum inventory levels. 2 . Determine the minimum and maximum daily sales. 3 . Determine the number of occurrences

1. Determine the minimum and maximum inventory levels. 2. Determine the minimum and maximum daily sales. 3. Determine the number of occurrences of each inventory level. One way is to use np.unique function. 4. Compute the frequency (probability) of each inventory level. 5. Compute the probability that the inventory level is greater than 15.6. Compute the expected inventory level. 7. Compute the expected inventory holding cost per year (based on beginning of day inventory) if the inventory carrying cost is 15% per year and the average cost of an item is $22.50.8. Compute the expected sales per day. 9. How many days were there potentially lost sales due to insufficient inventory?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

B Sales Day lInventory 1 11 7 9 Nm 2 Nm 0 0 0 11 7 9 19 5 22 4 19 5 5 6 22 7 16 4 8 4 4 8 8 8 4 10 10 11 a 12 10 10 13 to 33 13 10. 11 11 12 12 13 to 14 17 15 15 16 10 17 1 18. 10 19 19 14 +7 15 19...

Q:

For each day over the last year data is available ( in the spreadsheet Problem 1 in the ISE 3 6 2 F 2 0 2 3 _ HW 2 Data.xlsx file ) on the beginning of day inventory of a particular SKU ( column B )...

Q:

the last question i dont understand * Exercise 15-24 (similar to) Question Help Nunavut Mining Company (NMC) mines coal, puts it through a one-step crushing process, and loads the bulk raw coal onto...

Q:

Chapter 9 Compensation and Incentives Diane Bigda/Photodisc/Getty Images Learning Objectives After reading this chapter, you should be able to do the following: Discuss various psychological...

Q:

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Q:

I need help answering these accounting questions. The questions are attached in the doc A worker-machine operation was found to involve 3.5 minutes of machine time per cycle in the course of 40...

Q:

1) Find all real solutions of: 4 2 2 x + x =3 2 x 4 + x23=0 4 2 2 2 x 2 x +3 x 3=0 x ( 21)=0 2 x 2 ( x 21)+ 3 ( 2 x2 +3 ) ( x 21 ) =0 ( 2 x2 +3 ) =0 2 2 x =3 3 x 2= 2 3 x= 2 3 x= i 2 2) Given the...

Q:

PART 1 - There are a number of interesting differences between Sunbeam's 1997 and 1996 balance sheets (e.g., receivables increased by $82 million, inventories increased by $94 million, and prepaid...

Q:

For Part II question 1 please do question according to point 15 - ping -a -A -c count -f -s packetSize destination Text copy of file - Part II: 14 marks For this assignment you are assigned one of...

Q:

Probability and Statistics - Problem Set c Keith M. Chugg October 2, 2015 1 Preliminaries, Combinatorics, Set Probability 1.1. A number of bats are in a cave. 2 bats can see out of their left eye. 3...

Q:

A Pizzeria offers M different kinds of pizzas (let's assume that the pizza kind is a number between 0 and M-1). In order to serve its clients quickly, the pizzeria cooks pizzas in advance. Let's say...

Q:

1. Why does Porsche face more operating exposure than Mercedes or BMW? 2. Is Porsche really fully hedged through July 31, 2007? Suppose that gains on all its outstanding options were included in...

Q:

An auditor must obtain written client representations that might be signed by all but which of the following

Q:

An accounting information system (AIS) is an integral part of the total management information system (MIS) of an organization. The AIS is usually manned by accounting and finance professionals who...

Q:

6. The length of the program is specified. Mentor and protg are encouraged to pursue the relationship beyond the formal time period.

Q:

3. Mentors are chosen on the basis of their past record in developing employees, their willingness to serve as a mentor, and evidence of positive coaching, communication, and listening skills.

Q:

5. The purpose of the program is clearly understood. Projects and activities that the mentor and protg are expected to complete are specified.