Question: The demand for a cellphone for the next 12 weeks is 75 units in weeks 1, 4, 5, and 10; 30 units in weeks 2,

The demand for a cellphone for the next 12 weeks is 75 units in weeks 1, 4, 5, and 10; 30 units in weeks 2, 6, 7, 11 and 12; and 55 units in weeks 3, 8, and 9. Initial on-hand inventory is 120 units. Another 90 units are scheduled for receipt in period 2. The lot size is 90 units and the lead-time is 2 weeks. Also, there is a safety stock requirement of 30 units. (a) Develop the gross and net requirements report for the 12-week period. (b) If the ordering cost $100 per order and the carrying cost is $15/unit- week, determine the total cost of this arrangement

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 General Management Questions!

Reyes Rides is owned by Jason Reyes. The company has an August 31 fiscal year end and prepares adjustments on an annual basis. The following is an alphabetical list of its accounts at August 31,...

Problem 1. The demand for a cellphone for the next 12 weeks is 55 units in weeks 1,4,5, and 10;45 units in weeks 2,6 , and 7 ; and 50 units in weeks 3,8,9,11 and 12 . Initial on-hand inventory is 110...

Problem 5. The demand for a cellphone for the next 12 weeks is 60 units in weeks 1, 4, 5, and 10; 50 units in weeks 2, 6, and 7; and 55 units in weeks 3, 8, 9, 11 and 12. Initial on-hand inventory is...

the demand for a particular item for next 1 2 weeks is 2 0 units in week 7 and 8 ; 2 5 units in weeks 1 , 2 , 3 , 5 , and 6 ; and 3 0 units in weeks 4 , 9 , 1 0 , 1 1 and 1 2 . initial on - hand...

It's the homework of production planning and control course Problem 1. The demand for a particular item for the next 12 weeks is 45 units in weeks 2, 5, 11 and 12: 50 units in weeks 1, 3, 4, 6, 7 and...

Pregunta 13 17.5 pts Demand for a product for the next 12 weeks is forecast as follows: Week 1 3 4 5 6 7 8 9 10 11 12 N Demand 20 32 16 28 35 42 38 28 18 34 40 18 Initial inventory is 45 units. Find...

Please solve the following problem showing all steps, using what is asked in thr question. Also add screenshots of the data from the software or program used. Inventory - Lot Sizing - AMPL Consider a...

1450 Midland Ave Suite 200 & 300 Scarborough, ON M1P 4Z8 (416) 290-0200 Case Study Macarrys Bicycle Company Macarrys Bicycle Company makes and sells high-quality bicycles, primarily to larger North...

Sheet1 Sheet2 Historical sales data 9 3 2231 976 4 2861 677 12 1986 1067 UAE Oman Kuwait KSA Bahrain 1 1864 1411 649 4620 361 2 2489 1014 500 5518 490 Week 6 1347 926 $21 1370 632 5 2144 686 566 S017...

Macarrys Bicycle Company makes and sells high-quality bicycles, primarily to larger North American bicycle retail outlets and to some wholesalers for smaller retail shops. They have several models,...

1 Give at least three arguments in favor of each of the three basic methods of inventory valuation (FIFO, LIFO and WAC). 2 Provide at least three arguments in favor of perpetual and three for...

BAP Corporation is reviewing an investment proposal. The initial cost and estimates of the book value of the investment at the end of each year, the net cash flows for each year, and the net income...

17. In the No_reset program, what key combination will actually boot the computer?

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...