alaxy Candy Company manufactures two popular candy bars, the Eclipse bar and the Nova bar. Both candy bars go through a mixing operation where the various ingredients are combined, and the Coating Department where the bars from the Mixing Department are coated with chocolate. The Eclipse bar is coated with both white and dark chocolate to produce a swirled effect. A material shortage of an ingredient in the Nova bar limits production to 300 batches per hour. Production and sales data are presented in the following table.                                                                                                Mixing                     Coating Available capacity in hours                                                      525                         500 Use of capacity in hours per batch of product:                         Eclipse                                                               1.5                           2.0                         Nova                                                                  1.5                           1.0 Management believes that Galaxy can sell all of its daily production of both the Eclipse and Nova bars. Other data follow:                                                                                               Eclipse                        Nova Selling price per batch                                                           P600                        P700 Variable cost per batch                                                            200                          450 REQUIRED: a. Formulate the objective function and all of the constraints in order to maximize contribution margin.  b. How many batches of each type of candy bar (Eclipse and Nova) should be produced to maximize the total contribution margin?  c. Calculate the contribution margin at the optimal solution

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...
icon
Related questions
Question

Galaxy Candy Company manufactures two popular candy bars, the Eclipse bar and the Nova bar. Both candy bars go through a mixing operation where the various ingredients are combined, and the Coating Department where the bars from the Mixing Department are coated with chocolate. The Eclipse bar is coated with both white and dark chocolate to produce a swirled effect. A material shortage of an ingredient in the Nova bar limits
production to 300 batches per hour. Production and sales data are presented in the following table.
                                                                                               Mixing                     Coating
Available capacity in hours                                                      525                         500
Use of capacity in hours per batch of product:
                        Eclipse                                                               1.5                           2.0
                        Nova                                                                  1.5                           1.0
Management believes that Galaxy can sell all of its daily production of both the Eclipse and Nova bars. Other data follow:
                                                                                              Eclipse                        Nova
Selling price per batch                                                           P600                        P700
Variable cost per batch                                                            200                          450

REQUIRED:
a. Formulate the objective function and all of the constraints in order to maximize contribution margin. 
b. How many batches of each type of candy bar (Eclipse and Nova) should be produced to maximize the total contribution margin? 
c. Calculate the contribution margin at the optimal solution

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 8 images

Blurred answer
Knowledge Booster
Integers
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.