Question

A manufacturer is trying to determine the combination of two products, A and B, that should...

A manufacturer is trying to determine the combination of two products, A and B, that should be produced. Each product passes through a three-stage production process: Stage I, II, III. For product A Stage I takes three hours of labour, Stage II four hours and Stage III one hour. For product B the comparable data is four hours, two hours and two hours. Labour hours currently cost £4.50 per hour. Product A sells for £38 a unit and B for £40. At present 11 people are employed on Stage I, 12 on Stage II and 10 on Stage III, with all employees working 40 hours each week.

The manufacturer depicted above initially decides to find a product mix that maximizes revenue. What will be the combination of products produced that maximizes revenue? A second study is undertaken to find the mix of products that maximizes profits. Using solver on Excel, find the combination of products A and B to be produced that will maximize profits. What is the significant difference in these results? Why are they different? Which approach would you recommend? Explain your response.

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

Total labour hrs required for product in all stages A= 3+4+1 = 8 Hrs

Total labour hrs required for product in all stages B= 4+2+2 = 8 Hrs

A B C F 1 2. Labour Total Labour Hrs 3 Stage 1 4 Stage 2 5 Stage 3 11 12 10 440 480 400 D E Labour Hrs utilised Product A ProE13 X fi с D F Total Labour Hrs =B3*40 =B4*40 =B5*40 E Labour Hrs utilised Product A Productb B =$D$9*B9 =$E$9*C9 =$D$9*B10 |Solver Parameters X Set Objective: SCS18 To: Max Min O Value Of: 0 By Changing Variable Cells: SD$9:$E$9 17 Subject to the CoA B с F 1 Total Labour Hrs 440 480 400 E Labour Hrs utilised Product A Productb B 0 440 0 220 0 220 0 880 440 220 220 Product

Add a comment
Know the answer?
Add Answer to:
A manufacturer is trying to determine the combination of two products, A and B, that should...
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
  • Testbank, Question 109 Horton and Associates produces two products named BigBlast and Little Blast. Last month...

    Testbank, Question 109 Horton and Associates produces two products named BigBlast and Little Blast. Last month 4,000 units of BigBlast and 1,000 units of Little Blast were produced and sold. Following are average prices and costs for last month: Selling price Direct materials Direct labour Variable overhead Product line fixed costs Corporate fixed costs Average margin per unit BigBlast $100 (25) (15) (5) (10) (25) $20 Little Blast $200 (75) (35) (30) (40) (25) $(5) The production lines for both...

  • The owner of a shop manufactures two products: Product B (B) and Product C (C). Each...

    The owner of a shop manufactures two products: Product B (B) and Product C (C). Each Product B requires 6 ounces of ingredient I, 1 gram of ingredient II and 2 tablespoons of ingredient III. A Product C requires 3 ounces of ingredient I, 1 gram of ingredient II and 4 tablespoons of ingredient III. The company has 6600 ounces of ingredient I, 1400 grams of ingredient II and 4800 tablespoons of ingredient III. Profits for Product B are $0.20...

  • Harper Ltd is a manufacturer of rowing boats. It has designed a new boat called the...

    Harper Ltd is a manufacturer of rowing boats. It has designed a new boat called the Seafarer and expects to produce the Seafarer in a continuous operation over an 18 month period During this period, it is expected that a total of sixteen Seafarer's will be produced and sold. The production of the Seafarer is a labour intensive operation and units are produced one after another The costs of producing the first Seafarer are as follows Skilled Labour 1,000 hours...

  • Question 3 Not yet answered Marked out of 4.00 A company manufactures products A, B and...

    Question 3 Not yet answered Marked out of 4.00 A company manufactures products A, B and C. Each product is processed in three departments I, II and III. The total available labour-hours per week for departments I, II and III are 900, 1080 and 840, respectively. The time required (in hours per unit) and profit per unit for each product are as follows: 1 A B C 2 2 II 3 2 2 2 1 Profit $ 18 $ 12...

  • Austin Enterprises makes and sells two types of phones. Management is trying to determine the most...

    Austin Enterprises makes and sells two types of phones. Management is trying to determine the most profitable mix. Sales prices, demand and use of manufacturing inputs follows: Sales Price: Standard Premium $400 $540 Input requirements per unit: Direct Material $20 $40 Direct labor (hours) 1.2 2.0 Machine Hours 1.5 1.0 Costs: Variable Costs Direct Labor (cost per hour) 25 Factory Overhead(per MH) 3 Marketing (percent of sales price) 10% Fixed Costs: Manufacturing $230,000 Marketing 80,000 Administration 120,000 The company faces...

  • Edgerron Company is able to produce two products, G and B, with the same machine in...

    Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Selling price per unit Variable costs per unit Contribution margin per unit Machine hours to produce 1 unit Maximum unit sales per month Product G $ 50 10 $ 40 Product B $ 80 48 $ 32 1.0 hours 200 units 0.4 hours 600 units The company presently operates the machine for a single eight-hour shift for...

  • Harrison Company makes two products and uses a conventional costing system in which a single plantwide,...

    Harrison Company makes two products and uses a conventional costing system in which a single plantwide, predetermined overhead rate is computed based on direct labour-hours. Data for the two products for the upcoming year follow: Rascon 5 29.60 $ 14.70 70 29,000 Parcel $ 23.00 $ 4.20 Direct materials cost per unit Direct labour cost per unit Direct labour-hours per unit Number of units produced 40 120.000 These products are customized to some degree for specific customers. Required: 1. The...

  • 1)Jay Co. is a contract manufacturer that produces two products, Prod A and Prod B; and...

    1)Jay Co. is a contract manufacturer that produces two products, Prod A and Prod B; and supply the two products to various retailers. The numbers of units for Prod A and Prod B that Jay Co is contracted to supply for next four months are given in the following table: Month 1 Month 2 Month 3 Month 4 PROD A 1000 4000 1000 3000 PROD B 500 1500 250 1500 The production processes for Prod A and Prod B are...

  • Colt Company owns a machine that can produce two specialized products Production time for Product TLX...

    Colt Company owns a machine that can produce two specialized products Production time for Product TLX is three units per hour and for Product MTV is four units per hour. The machine's capacity is 2,100 hours per year. Both products are sold to a single customer who has agreed to buy all of the company's output up to a maximum of 3,570 units of Product TLX and 4,010 units of Product MTV. Selling prices and variable costs per unit to...

  • I need the answer to include solver and excel. Thank you. A Company produces two products....

    I need the answer to include solver and excel. Thank you. A Company produces two products. Relevant information for each product is shown in the Table below. The company has a goal of $48 in profits and incurs $1 penalty for each dollar it falls short of this goal. A total of 32 hours of labor are available. A $2 penalty is incurred for each hour of overtime (labor over 32 hours) used, and $1 penalty is incurred for each...

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