FIGURE 3-27 Visual Workshop Create the six-month budget shown in FIGURE 3-27 for Solar Solutions, a small consulting company that advises consumers and businesses about solar power options. Set up the workbook in Landscape orientation; apply the Headlines theme, fill cell Al with Aqua, Accent 1, Lighter 80\%; enter values as shown in FIGURE 3-27; enter formulas to calculate total revenue, total expenses, and profit/loss; apply the Comma or Accounting styles to cells as shown; then add shading using variations of Aqua, Accent 1 for revenue, Gold, Accent 3 for expenses, and Purple, Accent 5 for Profit/Loss. Save the budget as PR 3-Solar Solutions Budget to the location where you save the files for this book, then answer the following What-If questions or make up your own What-If questions and apply them to the worksheet: 1. In February, you estimate that three new businesses will ask for consultations at an average rate of $1,200 per consultation. These contracts are in addition to the current revenue for consultations. You project that the contract revenue generated in February will increase by 5 percent in March, 10 percent in April, then 20 percent in May and June. Calculate all increases based on February revenue. Hint: The formula for cell D6 is =$C$61.05. Remember to use absolute cell references when you copy the formula and to change the percentages. What is the total revenue for consulting in cell H6? Enter the cell address H6 in cell B20. 2. Make the salaries expense for both May and June $15,000. What is the total salaries expense in cell H11? Enter the cell address of the value in cell B21. 3. Increase the advertising costs for March by 30% of the costs for February. Hint: The required formula is =C141.3. Enter the cell address H14 in cell B22. 4. Double the equipment leases for March. What is the total projected profit in cell H18? Enter the cell address of the value in cell B23. Save the workbook, preview it, make sure the worksheet fits on one page in Landscape orientation and is centered horizontally, add your name to the center section of the header, save the workbook and submit a copy to your instructor, then close the workbook and Excel