What will the total cost be? (nearest whole number) Develop a lot-for-lot solution and calculate total...

Question

Question

What will the total cost be? (nearest whole number)

Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table. Period

business Operations-Management

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Answer: Total cost is $140+ $1400= $1540

Period		1	2	3	4	5	6	7	8	9	10	11	12	Total cost
	Gross requirements GR	20	0	40	0	40	60	30	0	10	80	0	50
	Projected inventory on hand PIOH	20	20	0	0	0	0	0	0	0	0	0	0
IOH= 140	inventory on hand IOH	40	20	20	0	0	0	0	0	0	0	0	0
	Net requirements NR	-20	-20	20	0	40	60	30	0	10	80	0	50
Q = L4L	Planned order receipts (PR)	0	0	20	0	40	60	30	0	10	80	0	50
Lead Time LT=1	Planned order releases POR	0	20	0	40	60	30	0	10	80	0	50	0
	Holding cost	70	70	0	0	0	0	0	0	0	0	0	0	140
	setup cost (whenever there is new order reciept)	0	0	200	0	200	200	200	0	200	200	0	200	1400

repeat these steps for every week

	steps
step 1	IOH=	PIOH of last week
step 2	NR=	GR -IOH
step 3	PR=	in L4L PR=NR
step 4	projected inventory on hand PIOH=	IOH+PR-GR
step 5	POR=	PR of preceding week
step 6 (After completing whole MRP)	Holding cost=	3.5$*PIOH

Excell Formula

C

D

E

F

G

H

I

J

K

labor cost

material cost

N

O

128

Period

1

2

3

4

5

6

7

8

9

10

11

12

Total cost

129

Gross requirements GR

20

0

40

0

40

60

30

0

10

80

0

50

130

Scheduled receipts SR

0

131

Projected inventory on hand PIOH

=D132+D134-D129

=E132+E134-E129

=F132+F134-F129

=G132+G134-G129

=H132+H134-H129

=I132+I134-I129

=J132+J134-J129

=K132+K134-K129

=L132+L134-L129

=M132+M134-M129

=N132+N134-N129

=O132+O134-O129

132

IOH= 140

inventory on hand IOH

40

=D131

=E131

=F131

=G131

=H131

=I131

=J131

=K131

=L131

=M131

=N131

133

Net requirements NR

=D129-D132

=E129-E132

=F129-F132

=G129-G132

=H129-H132

=I129-I132

=J129-J132

=K129-K132

=L129-L132

=M129-M132

=N129-N132

=O129-O132

134

Q = L4L

Planned order receipts (PR)

0

20

=G133

=H133

=I133

=J133

=K133

=L133

=M133

=N133

=O133

135

Lead Time LT=1

Planned order releases POR

=E134

=F134

=G134

=H134

=I134

=J134

=K134

=L134

=M134

=N134

=O134

=P134

136

Holding cost

=3.5*D131

=3.5*E131

=3.5*F131

=3.5*G131

=3.5*H131

=3.5*I131

=3.5*J131

=3.5*K131

=3.5*L131

=3.5*M131

=3.5*N131

=3.5*O131

=SUM(D136:O136)

setup cost (whenever there is new order reciept)

0

200

0

200

0

200

0

200

=SUM(D137:O137)

Add a comment

Answer 2

Similar Homework Help Questions

The total cost is $____ )enter your response as a whole number) Develop a lot-for-lot solution and calculate total rele...

The total cost is $____ )enter your response as a whole number) Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 6 11 12 2 4 7 8 10 Gross requirements 30 70 30 10 80 20 30 60 Holding cost= $3.50/unit/week; setup cost = $150; lead time= week; beginning inventory 40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 6 7 10 12...
Problem 14.22 Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the follo...

Problem 14.22 Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table Period 1 2 3 4 5 6 789 10 11 12 Gross requirements 30 40 40 70 20 10 80 60 Holding cost$1.50unit/week; setup cost $150; lead time 1 week; beginning inventory 40 Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 78 9 0 11 12 Gross requirements 40 40 70 20...
second question to this is What is the total cost? thank you. Develop a lot-for-lot solution...

second question to this is What is the total cost? thank you. Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table" Period 12 3 4 5 6 7 8 9 10 11 12 Gross requirements20 30 40 60 20 10 80 60 Holding cost $2.50/unit/week, setup cost $150; lead time 1 week, beginning inventory 40 Develop a lot-for-lot solution (enter your responses as whole numbers). Period Gross requirements On-hand at beginning of...

Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following...

Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period | 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements | 30 40 30 70 30 20 70 50 *Holding cost = $3.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40. Develop a lot-for-lot solution (enter your responses as whole numbers). 2 4 8 11 3 40 5 30 6 70 7...
3. Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the...

3. Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table" Period 1 2 3 4 5 6 789 10 12 Gross requirements20 40 40 70 30 10 70 50 Holding cost- $3.50/unit/week; setup cost $150; lead time 1 week; beginning inventory 40 Develop a lot-for-lot solution (enter your responses as whole numbers) Period Gross 3 4 5 6 9 20 40 40 70 30 10 uirements On-hand at beginning of On-hand at...
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table Per...

Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table Period 1 23 4 5 6 7 89 10 12 Gross requirements 30 40 40 70 20 10 80 60 Holding cost $1.50/unit/week; setup cost $150; lead time 1 week; beginning inventory 40 Develop a lot-for-lot solution (enter your responses as whole numbers) Period 1 2 3 45 6 7 8 9 10 111 Gross requirements 30 40 40 70 20 10 80...

B. TOTAL COST________ Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements...

B. TOTAL COST________ Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements | 30 30 30 60 20 20 70 60 *Holding cost = $1.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40. Develop a lot-for-lot solution (enter your responses as whole numbers). 11 9 20 10 70 12 60 Period 1...
Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven...

Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven assembly with a minimum cost possible. Following table show gross requirements of their product for twelve weeks. Develop a Part Period Balancing (PPB) solution and calculate the total relevant costs for the plan. Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 40 60 20 10 80 40 Also, for this plan the Holding cost =$2.50/unit/week;...
Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven...

Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven assembly with a minimum cost possible. Following table show gross requirements of their product for twelve weeks. Develop a Part Period Balancing (PPB) solution and calculate the total relevant costs for the plan Week 1 2 3 4 5 6 8 10 11 12 7 Gross requirements 20 40 40 70 30 10 80 40 Also, for this plan the Holding cost $2.50/unit/week; setup...

Sigma Electronics produces telephone cameras for cell phone. The production manager would like to create an...

Sigma Electronics produces telephone cameras for cell phone. The production manager would like to create an MRP for their cell phone cameras with a minimum cost possible. The following table show gross requirements of the product Develop a Part Period Balancing (PPB) solution and calculate the total relevant costs for the MRP. 2 4 8 11 Period Gross requirements 1 20 3 40 5 40 6 60 7 30 9 20 10 70 12 50 Also, for this plan the...

What will the total cost be? (nearest whole number) Develop a lot-for-lot solution and calculate total...

Homework Answers

Add Answer to:
What will the total cost be? (nearest whole number) Develop a lot-for-lot solution and calculate total...

Post as a guest

Earn Coins

The total cost is $____ )enter your response as a whole number) Develop a lot-for-lot solution and calculate total rele...

Problem 14.22 Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the follo...

second question to this is What is the total cost? thank you. Develop a lot-for-lot solution...

Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following...

3. Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the...

Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table Per...

B. TOTAL COST________ Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements...

Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven...

Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven...

Sigma Electronics produces telephone cameras for cell phone. The production manager would like to create an...

What will the total cost be? (nearest whole number) Develop a lot-for-lot solution and calculate total...

Homework Answers

Add Answer to: What will the total cost be? (nearest whole number) Develop a lot-for-lot solution and calculate total...

Post as a guest

Earn Coins

Add Answer to:
What will the total cost be? (nearest whole number) Develop a lot-for-lot solution and calculate total...