Question

A company makes four products: Product A sells for $50 but needs $10 of materials; Product...

A company makes four products: Product A sells for $50 but needs $10 of materials; Product B sells for $75 but needs $30 of materials; Product C sells for $100 but needs $50 of materials; Product D sells for $150 but needs $75 of materials. The labor cost is $15/hr. The processing requirements for each product on each of the four machines are shown in the table.

Table 6

Work Center Processing Time (min/unit)
A B C D
W 3 5 7 8
X 7 4 4 11
Y 9 12 7 6
Z 5 7 0 2

Work centers W, X, Y, and Z are available for 40 hours per week and have no setup time when switching between products. Market demand for each product is 80 units per week.

Use the information in Table 6. Using the bottleneck method, what is the profit if the company manufactures the optimal product mix?

a. Less than or equal to $ 12,000

b. Greater than $12,000 but less than or equal to $ 13,000

c. Greater than $13,000 but less than or equal to $14,000

d. Greater than $14,000 but less than or equal to $15,000

e. Greater than $15,000

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Workcenter Decision Variables No.of units of Product No.of units 11-89(50-10)+C9(75-30l+D9%100.50HE9(150-75HSUMPRODU 12 13 SUMPRODUCTISB$9 ŞES9,B2 E21/60 14 -SUMPRODUCT($B$9 $ES9,53 E3)/60 15 SUMPRODUCTISB$9:$E$9,84 E41/60 16 SUMPRODUCTISBŞ9 $EŞ9,B5 E5)/60 17 B9 18 C9 19 D9 20 E9 21 TB9:E9,B2E21+SUMPRODUCT(89:E9B3:E31+SUMPRODUCT(B4E489:E9ASUMPROD B9:E9,BS:ES)) 15/60 Constraints

c. Greater than $13000 but less than or equal to $14000

Add a comment
Know the answer?
Add Answer to:
A company makes four products: Product A sells for $50 but needs $10 of materials; Product...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2. King Supply makes four different types of plumbing fixtures: W, X, Y and Z. The...

    2. King Supply makes four different types of plumbing fixtures: W, X, Y and Z. The contribution margins for these products are: $70 for Product W, 560 for Product X, $90 for Product Y and S100 for Product Z. Fixed overhead is estimated at S5,500 per week. The manufacture of each fixture requires four machines, Machines #1, 2, 3 and 4, Each of the machines is available for 40 hours a week and there is no setup time required when...

  • Jordan Company makes and sells a single product. It takes four pounds of direct materials to...

    Jordan Company makes and sells a single product. It takes four pounds of direct materials to produce one unit of this product. The budgeted units to be produced for the next three months is given below: Budgeted Units to be Produced September 22,400 units October 31,900 units November 26,100 units Jordan Company wants to maintain monthly ending inventories of direct materials that are equal to 18% of the following month's production needs. The cost of direct materials is $2.75 per...

  • Problem 2 Schmidt Industries makes four different snake traps; the Harlan, the Gaylen, the Leah and...

    Problem 2 Schmidt Industries makes four different snake traps; the Harlan, the Gaylen, the Leah and the Matthew. The Harlan sells for $200 and has $80 in parts; the Gaylen sells for $150 and requires $60 in parts; the Leah sells for $100 and has $40 in parts; and the Matthew sells for $75 but requires $20 of parts. Schmidt Industries has four machines (we'll call them A, B, C, and D for convenience) that are used in the production...

  • A company would like to determine the best production schedule using a manufacturing process with four...

    A company would like to determine the best production schedule using a manufacturing process with four machines: W, X, Y, and Z. Each machine can be used for 2400 minutes per week. The weekly demands and the processing time on machines are shown below. Product A, 150 units/week, 6, 10, 6, 0 minutes; Product B, 90 units/week, 0, 9, 7, 8 minutes; Product C, 120 units/week, 8, 8, 7, 5 minutes; Product D, 130 units/week, 7, 0, 5, 8 minutes....

  • Jordan Company makes and sells a single product. It takes four pounds of direct materials to produce one unit of this pr...

    Jordan Company makes and sells a single product. It takes four pounds of direct materials to produce one unit of this product. The budgeted units to be produced for the next three months is given below: Budgeted Units to be Produced September 22,400 units October 31,900 units November 26,100 units Jordan Company wants to maintain monthly ending inventories of direct materials that are equal to 18% of the following month's production needs. The cost of direct materials is $2.75 per...

  • Orr Company makes and sells a single product call ed a Bik. It takes four yards...

    Orr Company makes and sells a single product call ed a Bik. It takes four yards of Material A to make one Bik. Budget ed production of Biks for the next three months is as follows: February March April Budgeted Biks to be produced 21,000 units 26,000 units 33,000 units The company wants to maintain monthly ending inve ntories of Material A equal to 29% of the next month's production needs • Material A costs $1.75 per yard. The company...

  • Jordan Company makes and sells a single product. It takes five pounds of direct materials to...

    Jordan Company makes and sells a single product. It takes five pounds of direct materials to produce one unit of this product. The budgeted units to be produced for the next four months is given below: September October November December Budgeted Units to be Produced 31,900 units 22,400 units 26,100 units 34,600 units Jordan Company wants to maintain monthly ending inventories of direct materials that are equal to 24% of the following month's production needs. The cost of direct materials...

  • Jordan Company makes and sells a single product. It takes five pounds of direct materials to...

    Jordan Company makes and sells a single product. It takes five pounds of direct materials to produce one unit of this product. The budgeted units to be produced for the next four months is given below: September October November December Budgeted Units to be Produced 31,900 units 22,400 units 26,100 units 34,600 units Jordan Company wants to maintain monthly ending inventories of direct materials that are equal to 24% of the following month's production needs. The cost of direct materials...

  • Jordan Company makes and sells a single product. It takes five pounds of direct materials to...

    Jordan Company makes and sells a single product. It takes five pounds of direct materials to produce one unit of this product. The budgeted units to be produced for the next four months is given below: Budgeted Units to be Produced September 31,900 units October 22,400 units November 26,100 units December 34,600 units Jordan Company wants to maintain monthly ending inventories of direct materials that are equal to 24% of the following month's production needs. The cost of direct materials...

  • Jordan Company makes and sells a single product. It takes five pounds of direct materials to...

    Jordan Company makes and sells a single product. It takes five pounds of direct materials to produce one unit of this product. The budgeted units to be produced for the next four months is given below: September October November December Budgeted Units to be produced 31,900 units 22,400 units 26,100 units 34,600 units Jordan Company wants to maintain monthly ending inventories of direct materials that are equal to 24% of the following month's production needs. The cost of direct materials...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT