ation models the future, where the price of flour is expected to rise 25 perce the results of the two cases will help you plan your future production and jus ASSIGNMENT 1 CREATING A SPRE DECISION SUPPORT In this assignment, you will produce a spreadsheet that models the business will create a Solver spreadsheet to model the base case. In Assignment sheet to model the extension 1B case. In Assignment 2, you will use the spread mation needed to recommend a production plan to your baker, and to the banker. In Assignment 3, you in a memorandum recommendations an oral presentation. First, you must create the spreadsheet models of the decision. ing sections: Changing Cells Constants Calculations Income Statement Your Your Solver spreadsheets will also include the decision constraints. A base case spreadsheet skeleton is available to you, so you do not ne the spreadsheet skeleton, go to your data files, select Case 8, and then sele 8 1A: Creating the Spreadsheet Assignment for the Base Case You will model the bakery shelf space problem described in the Backgrou will tell your baker how many loaves of each kind of bread to bake. A discussion of each spreadsheet section follows. For each section, you be set up, and (2) the logic of the sections' cell formulas. Changing Cells Section Your spreadsheet should have the changing cells shown in Figure 8-3. B THE BAKERY SHELF SPACE PROBLEM