Question: 3. For the part given below, net requirements are provided for 12 weeks. The fixed ordering cost is $540 and the holding cost per item

For the part given below, net requirements are provided for 12 weeks. The fixed ordering cost is $540 and the holding cost per item per week is $4 charged to average inventory level.

3. For the part given below, net requirements are

a. Fill the table using Lot-for-Lot lot sizing procedure. Calculate the total cost.

b.Fill the table using Economic Order Quantity (EOQ) lot sizing procedure. Calculate the totalcost.

c.Using the EOQ calculate an economic time between orders(TBO)

d.Fill the tablewith Periodic Order Quantity lot sizing procedure. Calculate the totalcost.

3. For the part given below, net requirements are provided for 12 weeks. The fixed ordering cost is $540 and the holding cost per item per week is $4 charged to average inventory level. (4 Points) 12 2 62 3 12 4 130 5 154 6 129 7 88 8 52 9 124 10 160 11 238 10 Period (weeks) Net Requirements Order Quantity Beginning Inventory Ending Inventory Setup/Ordering Costs Holding Costs a. Fill the table using Lot-for-Lot lot sizing procedure. Calculate the total cost. b. Fill the table using Economic Order Quantity (EOQ) lot sizing procedure. Calculate the total cost. c. Using the EOQ calculate an economic time between orders (TBO) d. Fill the table with Periodic Order Quantity lot sizing procedure. Calculate the total cost

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!

Not: Please solve this question by explaining in the excel, thanks. Q2) The time-phased net requirements over the next 6 weeks, the setup cost and the holding cost per unit of a product per week are...

Not: Please solve this question by explaining in the excel, thanks. 02) The time-phased net requirements over the next 6 weeks, the setup cost and the holding cost per unit of a product per week are...

Part 1 - EOQ and Newsvendor Examples (20 points) Question 1 (10 points) Give an example (not mentioned in class) of a real-world problem that fits the EOQ model. You can draw from your personal...

Suppose that an auto part in a manufacturer s inventory has the following characteristics: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -...

Puppy Food Inc. (PFI) sells a very popular blend of dog food. Demand for the dog food has a Normal distribution with a mean 220 bags per week and a standard deviation of 30 bags per week. PFI orders...

Lend Time Service Level Lead Time Service Level Lead Time Service Level Lead Time Service Level E2 21 EL 2 ELA -2.00 2800 2119 7881 9.20 38 1600 2238 112 104 S8 3100 212 DIS 41 -22 - 2.23 -2.24 -...

Problem 3. (Chapter 9: Inventory Policy Decisions) Suppose that an auto part in a manufacturer's inventory has the following characteristics: Forecast of demand = 900 cases per week Forecast error,...

In a factory producing tables, the orders are determined using an MRP format. Component XX used in producing the final product "Table" is procured from a supplier with a fixed ordering cost of 100 TL...

The yields on the us treasury notes are as follows: date 10/1/2030 1 year. 4.05 2 year 3.95 3 year 3.90 5 year 3.69 7 year 3.62 10 year 3.49 20 year 3.77 30 year 3.52 what is the 1 year rate in year...

Budget data for Product USA are as follows: Sales (100 units at $100/unit) COGS: Direct Labor Direct Materials Used Variable Factory OH Fixed Factory OH Gross Profit Total COGS Marketing Expenses:...

Case: Trader Joe s ( HBS # 9 - 7 1 4 - 4 1 9 ) What do the results say about how firms in this industry can deliver strong financial returns in different ways?

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...