To pay for the new car, you've decided to start a bakery business out of your home kitchen. You have limited capital and capacity, so you need to make wise decisions about which products to bake each day. Go to the Bakery Business worksheet. Cell B1 uses a SUMPRODUCT formula to calculate profit. Carefully review the assumptions and formulas in this worksheet before entering the following Solver parameters:
Find the maximum possible profit (cell B1) by changing the values in cells C7:C10.
The working hours required (B3) must be less than or equal to the number of working hours in the day (D3).
The total cost of ingredients (B4) must be less than or equal to the available capital (D4).
For each item in the range C7:C10, the number of items baked cannot exceed the maximum capacity available per day as defined in cells F7:F10. This restriction requires four separate constraints in the Solver Parameters dialog.
The items in the variable cell range C7:C10 must be whole numbers.
There should be a total of seven constraints.
Run Solver and accept the Solver solution.