Create the six-month budget shown in FIGURE 3-27 for Solar Solutions, a small consulting company that...

   

Transcribed Image Text:

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 A1 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 consulta- tion. 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$6*1.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 =C14*1.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. FIGURE 3-27 D F H. Solar Solutions 1 2 Six-Month Budget: January to June, 2017 4 January February March April May June Totals 5 REVENUE 6 Consultant Fees 7 Product Sales 8 Total Revenue $ 10,000.00 $ 10,000.0o $ 15,000.00 $ 15,000.00 $ 15,000.00 1,800.00 $ 12,000.0o $ 77,000.00 1,200.00 1,000.00 1,500.00 1,400.00 4,000.00 10,900.00 $ 11, 200.00 $ 11,000.00 $ 16,500.00 $ 16,800.00 $ 16,400.00 $ 16,000.00 $ 87,900.00 10 EXPENSES 11 Salaries 12 Rent 13 Equipment Leases 14 Advertising 15 Operating Costs 16 Total Expenses 8,000.00 $ 8,000.00 $ 8,000.00 $ 8,000.00 $ 8,000.00 $ 8,000.00 $ 48,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 12,000.00 800.00 800.00 800.00 800.00 800.00 800.00 4,800.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 6,000.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 9,000.00 13.300.00 $ 13,300.00 $ 13,300.00 $ 13,300.00 $ 13,300.00 $ 13,300.00 $ 79,800.00 17 18 PROFIT/LOSS (2,100.00) $ (2,300.00) $ 3,200.00 24 3.500.00 $ 3,100.00 2,700.00 8,100.00 19 20 Question1 Answer 21 Question 2 Answer 22 Question 3 Answer 23 Question 4 Answer 24 25 Sheet1 AutoSave PR 3-Solar Solutions Budg. - Saved - O Search File Home Insert Draw Page Layout Formulas Data Review View Help Corbel - 11 - A A" ab Wrap Text General Paste Conditional Format. BI U - E - EEEEE Merge & Center v $ - % 9 58 98 00 0 Formatting Table Clipboard a Font Alignment Number Styles M21 fe A B D E G H 3 4 January February March April May June Totals 5 REVENUE 6 Consultant Fees 7 Product Sales 8 Total Revenue 24 10,000.00 $ 13,600.00 $ 14,280.00 $ 14,960.00 $ 16,320.00 $ 16,320.00 $ 85,480.00 1,200.00 1,000.00 1,500.00 1,80০.০০ 1,400.00 4,000.00 10,900.00 $ 11,200.00 $ 14,600.00 $ 15,780.00 $ 16,760.00 $ 17,720.00 $ 20,320.00 $ 96,380.00 9 10 EXPENSES 11 Salaries $ 8,000.00 $ 8,000.00 8,000.00 $ 8,000.00 $ 15,00o.00 $ 15,000.00 $ 62,000.00 12 Rent 2,০০০.০০ 2,০০০.০০ 2,০০০.০০ 2,000.00 2,০০০.০০ 2,০০০.০০ 12,0০०.০০ 13 Equipment Leases 800.00 800.00 1,600.00 800.00 800.00 800.00 5,600.00 6,3००.०० 14 Advertising 15 Operating Costs 16 Total Expenses 1,০০০.০০ 1,০০০.০০ 1,30०.० 1,000.00 1,000.00 1,000.00 1,500.00 1,50०.০০ 1,500.00 1,500.00 1,500.00 1,500.00 9.০০०.০০ $ 13,300.00 $ 13,300.00 $ 14,400.00 $ 13,300.00 $ 20,300.00 $ 20,300.00 $ 94,900.00 17 18 PROFIT/LOSS $ (2,100.00) $ 1,300.00 $ 1,38o.00 $ 3,460.00 $ (2,580.00) $ 20.00 $ 1,48o.00 19 20 Question 1 Answer $ 85,480.00 $ 62,000.00 21 Question 2 Answer 22 Question 3 Answer 23 Question 4 Answer 6,300.00 1,480.00 24 24 24 Sheet1 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 A1 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 consulta- tion. 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$6*1.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 =C14*1.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. FIGURE 3-27 D F H. Solar Solutions 1 2 Six-Month Budget: January to June, 2017 4 January February March April May June Totals 5 REVENUE 6 Consultant Fees 7 Product Sales 8 Total Revenue $ 10,000.00 $ 10,000.0o $ 15,000.00 $ 15,000.00 $ 15,000.00 1,800.00 $ 12,000.0o $ 77,000.00 1,200.00 1,000.00 1,500.00 1,400.00 4,000.00 10,900.00 $ 11, 200.00 $ 11,000.00 $ 16,500.00 $ 16,800.00 $ 16,400.00 $ 16,000.00 $ 87,900.00 10 EXPENSES 11 Salaries 12 Rent 13 Equipment Leases 14 Advertising 15 Operating Costs 16 Total Expenses 8,000.00 $ 8,000.00 $ 8,000.00 $ 8,000.00 $ 8,000.00 $ 8,000.00 $ 48,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 12,000.00 800.00 800.00 800.00 800.00 800.00 800.00 4,800.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 6,000.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 9,000.00 13.300.00 $ 13,300.00 $ 13,300.00 $ 13,300.00 $ 13,300.00 $ 13,300.00 $ 79,800.00 17 18 PROFIT/LOSS (2,100.00) $ (2,300.00) $ 3,200.00 24 3.500.00 $ 3,100.00 2,700.00 8,100.00 19 20 Question1 Answer 21 Question 2 Answer 22 Question 3 Answer 23 Question 4 Answer 24 25 Sheet1 AutoSave PR 3-Solar Solutions Budg. - Saved - O Search File Home Insert Draw Page Layout Formulas Data Review View Help Corbel - 11 - A A" ab Wrap Text General Paste Conditional Format. BI U - E - EEEEE Merge & Center v $ - % 9 58 98 00 0 Formatting Table Clipboard a Font Alignment Number Styles M21 fe A B D E G H 3 4 January February March April May June Totals 5 REVENUE 6 Consultant Fees 7 Product Sales 8 Total Revenue 24 10,000.00 $ 13,600.00 $ 14,280.00 $ 14,960.00 $ 16,320.00 $ 16,320.00 $ 85,480.00 1,200.00 1,000.00 1,500.00 1,80০.০০ 1,400.00 4,000.00 10,900.00 $ 11,200.00 $ 14,600.00 $ 15,780.00 $ 16,760.00 $ 17,720.00 $ 20,320.00 $ 96,380.00 9 10 EXPENSES 11 Salaries $ 8,000.00 $ 8,000.00 8,000.00 $ 8,000.00 $ 15,00o.00 $ 15,000.00 $ 62,000.00 12 Rent 2,০০০.০০ 2,০০০.০০ 2,০০০.০০ 2,000.00 2,০০০.০০ 2,০০০.০০ 12,0০०.০০ 13 Equipment Leases 800.00 800.00 1,600.00 800.00 800.00 800.00 5,600.00 6,3००.०० 14 Advertising 15 Operating Costs 16 Total Expenses 1,০০০.০০ 1,০০০.০০ 1,30०.० 1,000.00 1,000.00 1,000.00 1,500.00 1,50०.০০ 1,500.00 1,500.00 1,500.00 1,500.00 9.০০०.০০ $ 13,300.00 $ 13,300.00 $ 14,400.00 $ 13,300.00 $ 20,300.00 $ 20,300.00 $ 94,900.00 17 18 PROFIT/LOSS $ (2,100.00) $ 1,300.00 $ 1,38o.00 $ 3,460.00 $ (2,580.00) $ 20.00 $ 1,48o.00 19 20 Question 1 Answer $ 85,480.00 $ 62,000.00 21 Question 2 Answer 22 Question 3 Answer 23 Question 4 Answer 6,300.00 1,480.00 24 24 24 Sheet1

Answer rating: 100% (QA)

Based on the provided figure I can help you answer the WhatIf questions 1 In February you estimate that three new businesses will ask for consultations at an average rate of 1200 per consultation Thes... View the full answer