Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are managing a computer store and are trying to determine the number of computers to keep in stock. Your current policy is to order
You are managing a computer store and are trying to determine the number of computers to keep in stock. Your current policy is to order 1100 computers whenever end-of-month inventory is 400 computers or less. Each time an order is placed a fixed cost of $600 and a variable cost of $1500 per computer is incurred. Your store sells the computers for $2800 each. If you don't have any computers in stock a customer buys a computer from a competitor. At the end of each month, there is a holding cost of $10 for each computer in stock. Orders are placed at the end of a month and are delivered in approximately 4 weeks. For example, if you order at the end of Month 1, the delivery will take place at the end of Month 2, and the new computers can be sold starting in Month 3 (the computers will be added to the stock before inventory is taken at the end of Month 2 - the holding cost applies to all inventory at the end of the month). Assume that demand for computers each month is a random variable that is normally distributed with mean 400 and standard deviation 100 and at the beginning of Month 1 you have 200 computers. A simulation model has been created for evaluating this inventory restocking policy for the next 2 years assuming that salvage value for items that remain in stock at the end of month 24 is 0 . What formula should appear in cell I10? All blanks are cell index. Write down the cell index without any space. For example, write down $F$1 instead of $F$1. The formula should be able to use the drag and fill functionality in Excel. Question 11 IF>0,1,0) The formula of cell G10 should be D10*\$G $4. True False Question 12 3 pts The formula in cell H10 should be E10$G$6 True False
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started