Question: SHOW WORK AND USE SOLVER IN EXCEL ! please show work in excel , explain steps used if any formulas ate used show also. Use
please show work in excel , explain steps used if any formulas ate used show also. Use SOLVER in excel DATA to solve . Nola Company produces two types of cookies: French and Quarter. French cookies go through the Mixing and Baking departments, and Quarter cookies go through the Mixing, Baking, and Icing departments. Maximum demand per day is 100 French cookies and 75 Quarter cookies. The time required per cookie in each department and the total time available per day are as follows: French Cookie Quarter Cookie Department Time in Minutes Mixing Department Baking Department Icing Department 3 2 Total time available per day 400 500 100 The selling price and cost per cookie are as follows: Selling Price Cost French Cookie $5.00 $3.00 Quarter Cookie 57.00 $3.50 1. How many of each cookie should Nola produce to maximize their daily profit? 2. Create the answer report. 3. Based on the answer report, which department(s) should be expanded in order to increase daily profit? Why
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
