Week 1 2 3 4 5 6 7 8 9 10 Requirement 30 12 72 11 24 42 35 30 75 68 Opening Inv 0 0 0 0 0 0 0 0 0 0 Lot for Lot production 30 12 72 11 24 42 35 30 75 68 Closing Inv 0 0 0 0 0 0 0 0 0 0 Avg Inv 0 0 0 0 0 0 0 0 0 0 Holding cost (0 6 per unit per week) 0 0 0 0 0 0 0 0 0 0 Setup cost (132 production) 132 132 132 132 132 132 132 132 132 132 Total cost (Setup Holding cost) 132 132 132 132 132 132 132 132 132 132 The total cost across 10 weeks 1320 Week 1 2 3 4 5 6 7 8 9 10 Requirement 30 12 72 11 24 42 35 30 75 68 Opening Inv 0 369 357 285 274 250 208 173 143 68 One time production 399 0 0 0 0 0 0 0 0 0 Closing Inv 369 357 285 274 250 208 173 143 68 0 Avg Inv 369 541 5 463 5 416 5 387 333 277 229 5 139 5 34 Holding cost (0 6 per unit per week) 221 4 324 9 278 1 249 9 232 2 199 8 166 2 137 7 83 7 20 4 Setup cost (132 production) 132 0 0 0 0 0 0 0 0 0 Total cost (Setup Holding cost) 353 4 324 9 278 1 249 9 232 2 199 8 166 2 137 7 83 7 20 4 The total cost across 10 weeks 2046 3 b) Assume now that production capacity in any period is limited to a maximum production amount of 100 Create a feasible production plan with setups in periods 1, 3, 6, 8 and 10 considering this restriction What is the cost of this plan What happens if the maximal production is less than 40

The Answer is in the image, click to view ...

Question: Week 1 2 3 4 5 6 7 8 9 10 Requirement 30 12 72 11 24 42 35 30 75 68 Opening Inv. 0

Week	1	2	3	4	5	6	7	8	9	10
Requirement	30	12	72	11	24	42	35	30	75	68
Opening Inv.	0	0	0	0	0	0	0	0	0	0
Lot for Lot production	30	12	72	11	24	42	35	30	75	68
Closing Inv.	0	0	0	0	0	0	0	0	0	0
Avg. Inv	0	0	0	0	0	0	0	0	0	0
Holding cost (0.6 per unit per week)	0	0	0	0	0	0	0	0	0	0
Setup cost (132/production)	132	132	132	132	132	132	132	132	132	132
Total cost (Setup + Holding cost)	132	132	132	132	132	132	132	132	132	132

The total cost across 10 weeks = 1320

Week	1	2	3	4	5	6	7	8	9	10
Requirement	30	12	72	11	24	42	35	30	75	68
Opening Inv.	0	369	357	285	274	250	208	173	143	68
One time production	399	0	0	0	0	0	0	0	0	0
Closing Inv.	369	357	285	274	250	208	173	143	68	0
Avg. Inv	369	541.5	463.5	416.5	387	333	277	229.5	139.5	34
Holding cost (0.6 per unit per week)	221.4	324.9	278.1	249.9	232.2	199.8	166.2	137.7	83.7	20.4
Setup cost (132/production)	132	0	0	0	0	0	0	0	0	0
Total cost (Setup + Holding cost)	353.4	324.9	278.1	249.9	232.2	199.8	166.2	137.7	83.7	20.4

The total cost across 10 weeks = 2046.3

b) Assume now that production capacity in any period is limited to a maximum production amount of 100. Create a feasible production plan with setups in periods 1, 3, 6, 8 and 10 considering this restriction. What is the cost of this plan? What happens if the maximal production is less than 40?

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!

Lot sizing A producer with one product faces the following forecasted demand for the next 10 weeks: week 1. 2. 3. 4. 5. 6. 7. 8. 9. 10 Requirement 30 12 72 11 24 42 35 30 75 68 Assume furthermore...

Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 20 20 27 38 24 30 37 20 24 30...

I do not know how to solve the problem about scatterplots. If you need assistance using Excel, you can access a tutorial that is appropriate for your experience level and your version of Excel....

I dont understand this. Could someone explain this to me? Thank you Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table...

Complete the MPS record below for an end item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Order Policy: 100 units Lead Time: 2 weeks Quantity on...

Assignment 1 Questions Q1: Cost behaviour and Cost Profit Volume Analysis Moderna Co is developing a second vaccine for the new strain of Covid 19 which has appeared in Africa. The company has...

Hi can you please help with this ASAP? I would immensely appreciate it. I will attach the file itself also. For each of the following security combinations draw a graph to show what the payoff would...

3. Suppose Macarrys Bicycle managers discover that a major competitor has had to shut down their production for the next three months due to a major fire. The Macarrys managers fully expect that many...

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

Understanding Statistics in the Behavioral Sciences by Robert R. Pagano (z-lib.org).pdf Questions 12, A statistics professor conducts a study to investigate the relationship between the performance...

Edward Jones Investments has offered you an investment opportunity that will provide you with an 18-year cash flow stream (payment is made at the end of every year). The cash flow stream is expected...

Choose any scene from the first portion of the Glory movie, describe it, and analyze how the African American soldiers were treated by their white counterparts. Then choose any scene later in the...

The formula to calculate the depletion rate of a natural resource is the depletion base divided by the Multiple choice question. estimated extractable amount of natural resource. estimated cost per...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...