Question
Delisshious Toasty Chocolates Company primarily produces two types of chocolate bars, Almond Tasty and Cashew Crunchy. The personnel costs incurred per day to produce the
Delisshious Toasty Chocolates Company primarily produces two types of chocolate bars, Almond Tasty and Cashew Crunchy. The personnel costs incurred per day to produce the two types of chocolate bars are $100 and $120, respectively. The production cost per chocolate bar is $2 for Almond Tasty and $2.5 for Cashew Crunchy. The daily production capacities of Almond Tasty and Cashew Crunchy chocolate bars are 1100 and 1250, respectively. Only one type of bar can be produced on a given day since only one machine is available.
Let C1 = the number of Almond Tasty chocolate bars produced
C2 = the number of Cashew Crunchy chocolate bars are produced
Y1 = 1 if the machine produces Almond Tasty; 0, otherwise
Y2 = 1 if the machine produces Cashew Crunchy; 0, otherwise
a. Write a constraint that sets the next days maximum production of Almond Tasty to 1100.
b. Write a constraint that sets the next days maximum production of Cashew Crunchy to 1250.
c. Write a constraint that requires that production be set up for exactly one of the two chocolates bars.
d. Write the cost function to be minimized.
please solve on excel spreadsheet and attach explanation to make it clear
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