Diane Simpson, Inc., sells two popular brands of cookies: Diane's Delight and Billie's Bourbon. Diane's Delight...

Transcribed Image Text:

Diane Simpson, Inc., sells two popular brands of cookies: Diane's Delight and Billie's Bourbon. Diane's Delight goes through the Mixing and Baking departments, and Billie's Bourbon, a filled cookie, goes through the Mixing, Filling, and Baking departments. Michael Shirra, vice president for sales, believes that at the current price, Diane Simpson can sell all of its daily production of Diane's Delight and Billie's Bourbon. Both cookies are made in batches of 3,500. | (Click the icon to view the time required per batch and the total time available.) (Click the icon to view the revenue and cost data.) Read the requirements. Data table Revenue and cost data for each type of cookie are as follows: A = + Requirement 1. Using D to represent the batches of Diane's Delight and B to represent the batches Begin by determining the linear function. Total contribution margin B Diane's Delight del. Billie's Bourbon 1 Revenue per batch 550 $ 475 2 Variable cost per batch 225 200 Next specify the constraints for each department. (If an input field is not used in the table, leave the Mixing Department: 3 Contribution margin per batch $ 325 $ 275 S + Filling Department: Monthly fixed costs (allocated to 4 each product) $ 18,500 $ 22,450| + Baking Department: S VI + Requirement 2. Compute the optimal number of batch Calculate the total contribution margin for each corner Total Trial Corner (D,B) Contribution Margin 1 (0,0) 2 (23,0) 3 (18,10) 4 (11,14) Data table Print Done In each department, the time required per batch and the total time available each day are as follows: d.) A B C 1 Department Minutes 2 Mixing Filling Baking 3 Diane's Delight 28 0 8 4 Billie's Bourbon 14 14 14 Next 5 Total available per day 644 196 284 Diane Simpson, Inc., sells two popular brands of cookies: Diane's Delight and Billie's Bourbon. Diane's Delight goes through the Mixing and Baking departments, and Billie's Bourbon, a filled cookie, goes through the Mixing, Filling, and Baking departments. Michael Shirra, vice president for sales, believes that at the current price, Diane Simpson can sell all of its daily production of Diane's Delight and Billie's Bourbon. Both cookies are made in batches of 3,500. | (Click the icon to view the time required per batch and the total time available.) (Click the icon to view the revenue and cost data.) Read the requirements. Data table Revenue and cost data for each type of cookie are as follows: A = + Requirement 1. Using D to represent the batches of Diane's Delight and B to represent the batches Begin by determining the linear function. Total contribution margin B Diane's Delight del. Billie's Bourbon 1 Revenue per batch 550 $ 475 2 Variable cost per batch 225 200 Next specify the constraints for each department. (If an input field is not used in the table, leave the Mixing Department: 3 Contribution margin per batch $ 325 $ 275 S + Filling Department: Monthly fixed costs (allocated to 4 each product) $ 18,500 $ 22,450| + Baking Department: S VI + Requirement 2. Compute the optimal number of batch Calculate the total contribution margin for each corner Total Trial Corner (D,B) Contribution Margin 1 (0,0) 2 (23,0) 3 (18,10) 4 (11,14) Data table Print Done In each department, the time required per batch and the total time available each day are as follows: d.) A B C 1 Department Minutes 2 Mixing Filling Baking 3 Diane's Delight 28 0 8 4 Billie's Bourbon 14 14 14 Next 5 Total available per day 644 196 284