Answered step by step
Verified Expert Solution
Question
1 Approved Answer
just answer part ONE. using linear programming. please show work on excel thank you briefly 11-40 Theory of constraints, contribution margin, sensitivity analysis. Talking Toys
just answer part ONE. using linear programming. please show work on excel thank you briefly 11-40 Theory of constraints, contribution margin, sensitivity analysis. Talking Toys (TT) produces dolls in two processes: molding and assembly. TT is currently producing two models: Chatty Chelsey and Talking Tanya. Production in the molding department is limited by the amount of materials available. Production in the assembly department is limited by the amount of trained labor available. The only variable costs are materials in the molding department and labor in the assembly department. Following are the requirements and limitations by doll model and department: Molding Materials 2 pounds per doll 3 pounds per doll 36,000 pounds $8 per pound Chatty Chelsey Talking Tanya Materials/Labor Available Cost Assembly Time 15 minutes per doll 20 minutes per doll 8,500 hours $12 per hour Selling Price $39 per doll $50 per doll Required The following requirements refer only to the preceding data. There is no connection between the requirements. 1. If there were enough demand for either doll, which doll would TT produce? How many of these dolls would it make and coll? 2 If TT sells three Chatty Chelseys for each Talking Tanya, how many dolls of each type would it produce and sell? What would be the total contribution margin? 3. If TT sells three Chatty Chelseys for each Talking Tanya, how much would production and contribution margin increase if the molding department could buy 900 more pounds of materials for $8 per pound? 4. If TT sells three Chatty Chelseys for each Talking Tanya, how much would production and contribution margin increase if the assembly department could get 65 more labor hours at $12 per hour? forrstinn has four operating divisions. The budgeted revenues
just answer part ONE. using linear programming. please show work on excel thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started