muhammadzargham_83411_5323954_SCM402HOMEWORK02.xlsx - Problem 2.12 A company wants to develop a level production plan for a family of products The

muhammadzargham_83411_5323954_SCM402HOMEWORK02.xlsx -...

This preview shows page 1 - 103 out of 103 pages.

Problem 2.12- A company wants to develop a level production plan for a family of products. The opening The demand for each of the months is given in what follows. How much should the company produce eac Month Jan Feb March Apr May Working Days 20 22 20 20 18 Forecast Demand 1200 1300 800 700 700 Planned Production 17333 19067 17333 17333 15600 Planned Invenotry 600 16733 34500 51033 67667 82567 Problem 2.15 The opening backlog is 900 units. Forecast demand is shown in the following. Calculate the week Week 1 2 3 4 5 6 Forecast Demand 600 700 700 700 600 500 Planned Production 750 750 750 750 750 750 Projected Backlog 750 700 650 600 450 200 opening backlog 900 Total production 4500 Weekly production 750 Total weeks 6 Ending backlog 200 2.18 For the following data, calculate the number of workers required for level production and the resulting m Why is it not possible to reach the ending inventory target? Month 1 2 3 4 5 Working days 20 24 12 22 20 Forecast Demand 2800 3000 2700 3300 2900 Planned production 3020 3624 1812 3322 3020 Planned Inventory 1000 1220 1844 956 978 Ending Inventory Total Production=Total forecast + Ending Inventory - Opening Inventory
Image of page 1
Image of page 2
Image of page 3
Image of page 4
Image of page 5
Image of page 6
Image of page 7
Image of page 8
Image of page 9
Image of page 10
Image of page 11
Image of page 12
Image of page 13
Image of page 14
Image of page 15
Image of page 16
Image of page 17
Image of page 18
Image of page 19
Image of page 20
Image of page 104

You've reached the end of your free preview.

Want to read all 103 pages?

  • Spring '14

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors