Result
Total demand | 8227 | |||||||||
Mean demand | 350 | Total ordered | 8000 | |||||||
Stdev of demand | 75 | Selling price | $2,300.00 | Total sold | 8000 | |||||
Order Quantity | 1000 | Purchase cost | $1,200.00 | Total holding cost | $ 77,659.69 | |||||
Reorder Point | 100 | Order Cost | $100.00 | Total ordering cost | $ 800.00 | |||||
Initial Inventory | 400 | Holding Cost | $12.00 | Profit | $8,721,540 | |||||
Beg | Order | Units | End | Order | Inv | Hold | Order | |||
Month | Inv | Rec'd | Rec'd | R.N. | Dmd | Inv | Placed? | Pos | Cost | Cost |
1 | 400 | 0 | 0.688 | 387 | 13 | YES | 1013 | $ 159.23 | $ 100.00 | |
2 | 13 | YES | 1000 | 0.411 | 333 | 680 | NO | 680 | $ 8,162.27 | $ - |
3 | 680 | 0 | 0.959 | 480 | 200 | NO | 200 | $ 2,401.42 | $ - | |
4 | 200 | 0 | 0.913 | 452 | -252 | YES | 748 | $ - | $ 100.00 | |
5 | -252 | YES | 1000 | 0.392 | 330 | 419 | NO | 419 | $ 5,025.94 | $ - |
6 | 419 | 0 | 0.095 | 252 | 167 | NO | 167 | $ 2,003.36 | $ - | |
7 | 167 | 0 | 0.017 | 191 | -24 | YES | 976 | $ - | $ 100.00 | |
8 | -24 | YES | 1000 | 0.402 | 331 | 644 | NO | 644 | $ 7,730.88 | $ - |
9 | 644 | 0 | 0.349 | 321 | 323 | NO | 323 | $ 3,879.98 | $ - | |
10 | 323 | 0 | 0.547 | 359 | -35 | YES | 965 | $ - | $ 100.00 | |
11 | -35 | YES | 1000 | 0.107 | 257 | 708 | NO | 708 | $ 8,494.40 | $ - |
12 | 708 | 0 | 0.899 | 446 | 262 | NO | 262 | $ 3,145.23 | $ - | |
13 | 262 | 0 | 0.709 | 391 | -129 | YES | 871 | $ - | $ 100.00 | |
14 | -129 | YES | 1000 | 0.730 | 396 | 475 | NO | 475 | $ 5,696.43 | $ - |
15 | 475 | 0 | 0.919 | 455 | 20 | YES | 1020 | $ 238.43 | $ 100.00 | |
16 | 20 | YES | 1000 | 0.752 | 401 | 619 | NO | 619 | $ 7,427.01 | $ - |
17 | 619 | 0 | 0.069 | 239 | 380 | NO | 380 | $ 4,561.18 | $ - | |
18 | 380 | 0 | 0.034 | 213 | 167 | NO | 167 | $ 2,007.41 | $ - | |
19 | 167 | 0 | 0.685 | 386 | -219 | YES | 781 | $ - | $ 100.00 | |
20 | -219 | YES | 1000 | 0.037 | 216 | 565 | NO | 565 | $ 6,781.60 | $ - |
21 | 565 | 0 | 0.669 | 383 | 182 | NO | 182 | $ 2,186.95 | $ - | |
22 | 182 | 0 | 0.307 | 312 | -130 | YES | 870 | $ - | $ 100.00 | |
23 | -130 | YES | 1000 | 0.732 | 396 | 474 | NO | 474 | $ 5,683.67 | $ - |
24 | 474 | 0 | 0.256 | 301 | 173 | NO | 173 | $ 2,074.29 | $ - |
14. The monthly demand for the latest computer at Newland Computers follows a normal distribution with a mean of 350 an...
7. The Cramer Computer Company has the following projected demand for the next 6 months: Month No. of Working days in Month Demand 2.600 3,100 3,700 4,300 3,500 3,300 There are currently 100 workers, each working a normal 8-hour shift, 5 days a week. They can work an extra 10 hours a week in overtime, but it costs the com- pany an extra $10 per hour in overtime costs. One of the computers takes 5 hours of worker time to...
John knows that monthly demand for his product follows a normal distribution with a mean of 2,500 units and a standard deviation of 425 units. Given this, please provide the following answers for John. a. What is the probability that in a given month demand is less than 3,000 units? b. What is the probability that in a given month demand is greater than 2,200 units? c. What is the probability that in a given month demand is between 2,200...
John knows that monthly demand for his product follows a normal distribution with a mean of 2,500 units and a standard deviation of 425 units. Given this, please provide the following answers for John. a. What is the probability that in a given month demand is less than 3,000 units? b. What is the probability that in a given month demand is greater than 2,200 units? c. What is the probability that in a given month demand is between 2,200...
1. Normal distribution, Re-order Point (6 Marks) During the summer, the demand for electric fans at Courts is quite strong. The company tracks inventory using a computer system so that it knows how many fans are in the inventory at any time. The policy is to order a new shipment of 500 fans when the inventory levels falls to the re-order point which is 100. However this policy has resulted in frequent shortages, resulting in lost sales because both lead-time...
Product Costing in a JIT/Lean Environment Doll Computer manufactures laptop computers under its own brand, but acquires all the components from outside vendors. No computers are assembled until the order is received online from customers, so there is no finished goods inventory. When an order is received, the bill of materials required to fill the order is prepared automatically and sent electronically to the various vendors. All components are received from vendors within three days and the completed order is...
Inventory Analysis QT, Inc. and Elppa Computers, Inc. compete with each other in the personal computer market. QT assembles computers to customer orders, building and delivering a computer within four days of a customer entering an order online. Elppa, on the other hand, builds computers for inventory prior to receiving an order. These computers are sold from inventory once an order is received. Selected financial information for both companies from recent financial statements follows (in millions): QT Elppa Sales $39,420...
The Austin, Texas plant of Computer Products produces disk units for personal and small business computers. Gerald Knox, the plant’s production planning director, is looking over next year’s sales forecasts for these products and will be developing an aggregate capacity plan for the plant. The quarterly sales forecasts for the disk units are as follows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 2,310 1,980 1,980 2,340 Ample machine capacity exists to produce the forecast. Each disk unit takes an...
Product Costing in a JIT/Lean Environment Doll Computer manufactures laptop computers under its own brand, but acquires all the components from outside vendors. No computers are assembled until the order is received, the bill of materials required to fill the order is prepared automatically and sent electronically to the various vendors. All components are received from vendors within three days and the completed order is shipped to the customer immediately when completed, usually on the same day the components are...
A company believes that its demand for the next six months is as follows ota ont eman The output per worker per month is 100 units. The per worker hiring and lay off costs are $1,500 and $3,500, respectively. There is no beginning inventory, and the starting workforce is 135. It cost the company $25 to carry an item in inventory each month, and the stockout costs is estimated to be $25 per unit. Develop a level sales and operations...
please showing working.. formulas 10. A company produces sofas. The manager wants to prepare a 0. am for the next six months using the following information: plan Month 2 3 456 160 150 160 180 170 140 recast demand For Cost Per Unit Regular time $100 Overtime $150 Part-time $120 Inventory, per month $10 Back order, per month $50 There are five workers, each making 30 sofas a month. The maximum number of sofas produced during overtime is 30 per...