Question: I NEED ASAP. CLEAR EXPLANATION. ONLY EXCEL SOLUTION NEEDED. The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead

I NEED ASAP. CLEAR EXPLANATION. ONLY EXCEL SOLUTION NEEDED.

The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is $9. There is a carrying cost of $0.010 per unit per week. Beginning inventory is 75 units.

WEEK
1 2 3 4 5 6 7 8 9 10
Gross requirements 30 35 10 25 75 85 20 65 220 55

Use the least total cost and the least unit cost lot-sizing method to determine what quantity the first order should be released and for which period.

Quantity Ordered Period
Least total cost (Click to select) 4 to 6, 4 to 7, 4 to 8, 4 to 9, 4 to 10, 9, 4, 4 to 5, 9 to 10
Least unit cost (Click to select)9 to 10, 4 to 7, 4 to 6, 4, 4 to 8, 4 to 5, 9, 4 to 9, 4 to 10

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!

Q:

Problem 9-10 (Algo) In the following MRP planning schedule for Item J, Indicate the correct net requirements, planned-order receipts, and planned-order releases to meet the gross requirements. Lead...

Q:

The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is R10. There is a carrying cost of R0.1 per unit per week. Beginning...

Q:

The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is $9. There is a carrying cost of $0.010 per unit per week. Beginning...

Q:

Problem 9-20 The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is $10. There is a carrying cost of $0.01 per unit per week....

Q:

ANSWER PERIODS COVERED AND QUANTITY ORDERED! The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is $10. There is a carrying cost...

Q:

The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is $12. There is a carrying cost of $0.015 per unit per week. Beginning...

Q:

The MRP gross requirements for item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is $10. There is a carrying cost of $0.010 per unit per week. Beginning...

Q:

The MRP gross requirements for item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is $10. There is a carrying cost of $0.010 per unit per week. Beginning...

Q:

Use Economic order quantity (EOQ) as the production number to find the total cost of the production shown. Please show all work. The MRP gross requirements for Item A are shown here for the next 10...

Q:

The MRP gross requirements for Item X are shown here for the next 10 weeks. Lead time for A is two weeks, and setup cost is $10. There is a carrying cost of $0.02 per unit per week. Beginning...

Q:

Waterways is thinking of mass-producing one of its special-order sprinklers. To do so would increase variable costs for all sprinklers by an average of $0.70 per unit. The company also estimates that...

Q:

What is sustainable agriculture? What are some features of a sustainable farm?

Q:

The maximum number of elements of a two - dimensional truss that can be sectioned when using the method of sections is: Multiple choice question. four. two. one. three.

Q:

Financial Statements and Closing Entries Last Chance Company offers legal consulting advice to prison inmates. Last Chance Company prepared the end-of-period spreadsheet that follows at June 30,...