Create the six-month budget shown in FIGURE 3-27 for Solar Solutions, a small consulting company that...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Managerial Economics and Business Strategy
ISBN: 978-0071267441
7th Edition
Authors: Michael R. baye
Posted Date:
Students also viewed these finance questions
-
If the pattern shown in Figure 3 is continued indefinitely what fraction of the original square will eventually be painted? Figure 3
-
The heart pumps blood at an average rate of 5 L/min. The gauge pressure on the venous (intake) side is 0 mm Hg and that on the arterial (discharge) side is 100 mm Hg. Energy is supplied to the heart...
-
The heart pumps blood at an average rate of 5 L/min. The gauge pressure on the venous (intake) side is 0 mm Hg and that on the arterial (discharge) side is 100 mm Hg. Energy is supplied to the heart...
-
8 Assume a company reported the following results: Sales Net operating income Average operating assets Margin Turnover Return on investment (ROI) What is the return on investment? ? $ 120,000 $...
-
Calculate the missing numbers for a, b, c, and d to analyze the waste time for the following orders. Comment on yourfindings. Production Cycle Time Average Process Time Average Setup Time Name of...
-
Both the capital asset pricing model and the arbitrage pricing theory rely on the proposition that a no-risk, no-wealth investment should earn, on average, no return. Explain why this should be the...
-
(PV annuity) Your uncle has just announced that hes going to give you $10,000 per year at the end of each of the next 4 years. If the relevant interest rate is 7%, whats the value today of this...
-
Houston North Hospital is trying to improve its image by providing a positive experience for its patients and their relatives. Part of the image program involves providing tasty, inviting patient...
-
You are a financial analyst at Berkeley Capital, a major investment banking firm. Your supervisor has just handed you a difficult assignment. You must review the work of an intern, who after given...
-
Jackson Manufacturing holds a 150-day note of $10,000 that has an interest rate of 7% annually. After 90 days, the note is sold to a bank at a discount rate of 6% annually. Find the proceeds on the...
-
II. ESSAY. Answer the question in no more than 10 sentences. 21. Jhong, Vhong, and Anne borrowed P900,000.00 from Vice. They committed to pay on June 22, 2019, but defaulted. Vice absolved Vhong and...
-
Submit TB Problem 10-215 (Algo) Cool Globe Incorporated entered... Cool Globe Incorporated entered into two transactions, as follows: 1. Purchased equipment paying $19,300 at the date of purchase and...
-
The heat equation, as given in the introduction, can also be rearranged to calculate the mass or temperature change for a substance. Follow the same steps used to calculate the quantity of heat...
-
a) e c) -H a) Draw the Conjugate Acid of each structure below. Include all lone pairs. d) H b) 4) (4 pts) Draw the Conjugate base of each structure below. Include all lone pairs. H Se H c) b) :0:
-
3. Given a five-integer array, write a C program to finish ONE of the following tasks: a. If the last digit of your PantherID is an odd number (1, 3, 5, 7, 9), find the max integer in this array. b....
-
In DoD contracting, for a contract that was competitively awarded, what method should you use to negotiate profit on a subsequent contract modification that requires certified cost or pricing data?
-
General Santa Anna's attack on the Alamo proved costly to him because his army was badly defeated. the delay allowed other Texans to organize effective resistance. reaction in Mexico City was so hosti
-
What is the difference between adsorption and absorption?
-
You are the manager of BlackSpot Computers, which competes directly with Condensed Computers to sell high-powered computers to businesses. From the two businesses perspectives, the two products are...
-
Seventy-two percent of the members of the United Food and Commercial Workers Local 655 voted to strike against Stop n Shop in the St. Louis area. In fear of similar union responses, two of Stop n...
-
Under what conditions might the Justice Department approve a merger between two companies that operate in an industry with a premerger Herfindahl-Hirschman index of 2,900 if the postmerger index is...
-
Can you think of any drawbacks in providing interim financial statements for users? R3
-
A year ago Pod Limited bought 225,000 1 fully paid ordinary shares of Pea Limited for a consideration of 500,000. Pea Limiteds share capital and share premium were each the same as at todays date....
-
Segmental information relating to Dali pic for the year to 31 December 2012 is shown below. Required: Analyse the performance of each of the three main business segments for the year and comment on...
Study smarter with the SolutionInn App