3) Refer to this product tree:А (3)В 4)C (6)M (3)N (4)C (2)D (5)If 24 Ps are needed, and there are 6 Bs on hand, how many Cs will be needed? (use excel to showformulas for your calculations)

Given data; ITEM USAGE End - P 1 A 3 M 3 N 4 B 4 C 2…

Answered: 3) Refer to this product tree: A (3)…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Given the following parents and components, construct a product tree. Figures inparentheses show the quantities per item. How many Gs are needed to make one A?
please explain and answer , thank you
“means-ends analysis”. Provide an ORIGINAL example in which you state and illustrate the three steps involved
Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order-Processing Costs 3,000 $ 165,400 1,500 100,750 4,400 241,400 2,800 163,800 2,300 139,550 1,200 86,200 2,000 125,000 1 2 3 4 5 6 7 Required (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. $ 28,000 + $48.5 X (b.) Plot the data on a scatter diagram. Using the information from representative high-and low-volume months, develop a cost estimating equation for monthly order-processing costs. If needed, an Excel worksheet is provided in the following link in order to create the scatter diagram: Scatter_Diagram $ 15,000 X+ $53.14 X X
2. Perform an ABC analysis for the data provided. Clearly explain why you classified items as A, B, or C. Annual Unit Item Usage 2400 Cost $19.51 $32.60 $10.20 $6.80 2 6200 3 8500 4 3200 6000 $4.50 $55.70 $3.60 $44.90 $35.62 750 7 8200 8 9000 5800 10 820 $82.60 $40.50 11 500 12 2000 $15.40 $14.60 $35.80 13 2400 14 6300 15 4750 $17.30 2700 $51.75 $42.90 $25.30 16 17 1600 18 1350 19 5000 $67.00 20 1000 $125.00
Q4) A manufacturer provides specialized microchips. During the next 3 months its sales, costs, and available time are shown in the table. Month 1 Month 2 Month 3 There are no chips in stock at the beginning of the first month. It takes 1.5 hr of production time to produce a chip and costs $5 to store a chip from one month to the next. Determine a production schedule that meets the demand requirements, does not exceed the monthly production time limitations, and minimizes cost. Note that no chips should be in stock at the end of the 3 months. Use fmincon. Chips required Cost regular time ($/chip) Cost overtime ($/chip) Regular operation time (hr) Overtime (hr) 1000 100 110 2500 100 120 2200 120 130 2400 2400 720 2400 720 720
Fat(g) Item cost($) $0.25 $0.15 $0.10 $0.09 $0.03 $0.04 $0.02 $0.04 Item Sodium(mg) Calories Beef Ratty.m 50 17 220 260 330 310 Bun Cheese 70 Onions 1 10 Pickles 260 5 wer Lettuce 3 4 Ketchup 160 20 Tomato 3 As the owner of a fastfoad restaurant with declining sales, your customers are looking for something new and exciting on the menu. Your market research indicates that they want a burger that is loaded with everything as long as it meets certain health requirements. Money is no object to them. The ingredient list in the table shows what is available to include on the burger. You must include at least one of each item and no more than five of each item. You must use whole items (for example, no half servings of cheese). The final burger must contain less than 3000 mg of sodium, less than 150 grams of fat, and less than 3000 calories. To maintain certain taste quality standards you'll need to keep the servings of ketchup and lettuce the same. Also, you'll need to keep the servings of…
Answer 12.7a-c Please show detailed calculations or software output
Draw the PLC chart/diagram and briefly explain each stage by giving an example. Discuss the extra 3Ps for ‘Services’ on Al Bustan Palace Hotel expansion strategy
Adidas is an athletic company designs and manufacturesseveral athletic things. Football is one of the company'sproducts that sells for $40 per unit. Total fixed costs relatedto the manufacturing of the football are $150,000 per monthand variables costs involved in manufacturing are $ 15 perunit. 1- Compute the break- even point of the football in unitsand dollars?
Refer to this product tree If 17 Ps are needed, and no on-hand inventory exists for any items, how many Cs will be needed?
a. Construct:i. ABC analysis by annual dollar usageii. ABC analysis by current inventory value(Performing the tables and charts in excel)b. Based on these analyses, do you think the firm is stocking the correct inventories?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

3) Refer to this product tree: A (3) В(4) C (6) М (3) N (4) C(2) D (5) If 24 Ps are needed, and there are 6 Bs on hand, how many Cs will be needed? (use excel to show formulas for your calculations)|