Question: Require formulas as well.. Question 6. Find out how much and when the final product A and components B, C, D, E and F must

Require formulas as well..

Question 6. Find out how much and when the final product A and components B, C, D, E and F must be ordered over the next eight weeks. The product structure is shown in the diagram below, the number in the parenthesis indicates how many of the components in question are needed at a higher level per product. Please note that the same parts are needed in several places. D (2) C (3) 8 (2) E (1) F (2) D (1) E (1) F (2) Demand for end product A is shown in the table below. Weeks 1 2 3 4 5 6 7 8 9 Demand 0 0 120 0 120 120 0 0 120 Further information Lot for lot 1 week Batch size Delivery time Projected inventory Scheduled receipt Stock at the end of week o B Lot for lot 3 week 0 150 week 2 700 3 week 0 450 week 2 D 700 4 week 0 700 week 1 E Lot for lot 2 week 50 0 F Lot for lot 1 week 0 1400 week 1 OO 0 125 235 235 750 0

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!

I need the attached questions answered. I have attached the answer sheet as well. Thank you Acct 221Final Exam Student Name: Question 1: 30 points a. General Journal Entries Date Account Debit Credit...

rect Question 6 ACME wants to have a new, innovative software product developed by a third-party software development vendor in the next 12 months. ACME management felt that requirements developed by...

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

i just need to complete the excel Frenchies Signature Assignment Joseph Preimesberger posted on Nov 8, 2021 9:35 AM Edited This is a shortened assignment, so just complete the three Excel tabs given...

Please provide summary of the above text (More than 3000 words) **There should be no plagiarism. If you provide wrong solution then i will dislike and report you abusive and spam. Don't waste my...

Unit 2: Designing the Operations Designing the operations of an organization or your department - precedes operational management. For .ll _ . example, suppose a wallet manufacture's mission is to '...

i just need to know how to do the excel sheets with formulas please. sorry for all of the pictures! im not positive whats important! thank you! this is everything i know Frenchies: Creating and using...

I have attached the discussion board 6 questions,scenario. and lectures for yourreview and response. I will submit a students questions for a response when I receive one. Thank You MKT500 Discussion...

To be solved by DKetan. Using Chapter 7 of your text as a reference, define a standard cost and explain what constitutes the components of a standard cost. Describe the advantages and disadvantages...

(a) Explain why in a gas of N molecules, the number of molecules having speeds in the finite interval u to u + u is N = N f uu + uf(u) du. (b) If u is small, then f (u) is approximately constant over...

Jun Hsieh, a 38-year-old widowed mother of three children (ages 12, 10, and 4), works as a product analyst for Panama Hats. Although shes covered by a group life insurance policy at work, she feels,...

The term " S corp" comes from: the Internal Revenue Code. the FTC rules. the U . S . Constitution state corporate law.

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