A C Constants: 8 Total shelf space available (feet) 300 9 Tax rate 0 78 10 Selling Prices, per loaf. 11 Rye 2 25 12 Wheat 2 15 13 Pumpernickel 2.5 14 Variable Costs, per loaf. 15 Rya 1 25 16 Wheat 1.15 17 Pumpernickel 1.6 18 Min Production (day) 19 Rye 100 20 Wheat 100 21 Pumpernickel 50 22 Max Production (day): 23 Rye 300 24 Wheat 300 25 Pumpernickel 150 26 Fixed Costs (day). 100 27 Net Income to Revenue ratio target 0.15 Shelf space used par Inaf 28 (decimal portion of a foot): 29 Rye 0.75 30 Wheat 09 31 Pumpernickel 0.6 32 Max Loaves that could be made, all types 380 FIGURE 8-4 Constants section Min Production The minimum number of loaves to make Max Production - The maximum number of loaves to make Fixed Costs (day) - The daily expenses that would be inour Net Income to Revenue ratio target - The ratio of net incon be at least 0.15. Shelf space used per loaf - The shelf space for each kind Max Loaves that could be made, all types- You cannot m Calculations Section Your spreadsheet should calculate the amounts shown in Figure 8-5.' ment section and/ or the constraints. Calculated values are based on other calculated values. An explanation of the line items follows the fla