Homework Help is Here – Start Your Trial Now!
Business
Accounting
Create the six-month budget as shown below for Web Wonders, a new company that provides Internet users with quick and easy access to the World Wide Web. Save the budget as Web Wonders Budget, then answer the following questions. 1 2 4 3 6 REVENUE 7 Internet Subscriptions s Homepage Server Space 9 Total Revenue 10 11 EXPENSES 12 Salaries Web Wonders Proposed Six-Month Budget: January to June 2019 [Current Date] 23 Rent 14 Equipment Leases 15 Advertising 16 Operating Costs 17 Total Expenses 14 19 PROFIT 20 *Sheet! January February March April heata 4500 1500 1000 150 350 May G H June Totals 4500 4500 7000 7000 4500 1500 1500 3500 3500 3500 1000 1000 2500 2500 2500 150 150 1200 1200 3500 350 350 780 780 780 1. In January you estimate that 1000 Internet subscribers will join Web Wonders at a cost of P30 per subscriber. You project that the subscription revenue generated in January will increase 5% in February, 10% in March, then 20% for each of the remaining months. Calculate all increases based on January revenue. What is the total revenue in cell H9? 2. In January you estimate that 50 subscribers will purchase space on the server for their homepages at a cost of P100 each. This revenue should increase by 30% each month to June. What is the total revenue in cell H9? 3.Triple the April Salaries and Advertising expenses for May and June. What is the total Salaries expense? What is the total revenue in cell H9? 4. Quadruple the April equipment lease for May and June. What is the total Equipment Lease expense? 5. What is the total projected profit in cell H19?

Create the six-month budget as shown below for Web Wonders, a new company that provides Internet users with quick and easy access to the World Wide Web. Save the budget as Web Wonders Budget, then answer the following questions. 1 2 4 3 6 REVENUE 7 Internet Subscriptions s Homepage Server Space 9 Total Revenue 10 11 EXPENSES 12 Salaries Web Wonders Proposed Six-Month Budget: January to June 2019 [Current Date] 23 Rent 14 Equipment Leases 15 Advertising 16 Operating Costs 17 Total Expenses 14 19 PROFIT 20 *Sheet! January February March April heata 4500 1500 1000 150 350 May G H June Totals 4500 4500 7000 7000 4500 1500 1500 3500 3500 3500 1000 1000 2500 2500 2500 150 150 1200 1200 3500 350 350 780 780 780 1. In January you estimate that 1000 Internet subscribers will join Web Wonders at a cost of P30 per subscriber. You project that the subscription revenue generated in January will increase 5% in February, 10% in March, then 20% for each of the remaining months. Calculate all increases based on January revenue. What is the total revenue in cell H9? 2. In January you estimate that 50 subscribers will purchase space on the server for their homepages at a cost of P100 each. This revenue should increase by 30% each month to June. What is the total revenue in cell H9? 3.Triple the April Salaries and Advertising expenses for May and June. What is the total Salaries expense? What is the total revenue in cell H9? 4. Quadruple the April equipment lease for May and June. What is the total Equipment Lease expense? 5. What is the total projected profit in cell H19?

Quickbooks Online Accounting
Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter8: Budgets And Bank Reconciliations
Section: Chapter Questions
Problem 1.4C
See similar textbooks
icon
Related questions
Question
Create the six-month budget as shown below for Web Wonders, a new company that provides Internet users with quick and easy access to the World Wide Web. Save the budget as Web Wonders Budget, then answer the following questions. * REVENUE 7 Internet Subscriptions s Homepage Server Space Total Revenue Web Wonders Proposed Six-Month Budget: January to June 2019 [Current Date] 11 EXPENSES $ 12 Salaries 23 Rent 14 Equipment Leases 15 Advertising 16 Operating Costs Total Expenses 39 19 PROFIT NNN www January February March April May June Totals 4500 150 4500 7000 7000 1500 1000 1000 150 G 3500 3500 3500 2500 2500 1200 3500 780 780 780 Bingka 1. In January you estimate that 1000 Internet subscribers will join Web Wonders at a cost of P30 per subscriber. You project that the subscription revenue generated in January will increase 5% in February, 10% in March, then 20% for each of the remaining months. Calculate all increases based on January revenue. What is the total revenue in cell H9? 2. In January you estimate that 50 subscribers will purchase space on the server for their homepages at a cost of P100 each. This revenue should increase by 30% each month to June. What is the total revenue in cell H9? 3.Triple the April Salaries and Advertising expenses for May and June. What is the total Salaries expense? What is the total revenue in cell H9? 4. Quadruple the April equipment lease for May and June. What is the total Equipment Lease expense? 5. What is the total projected profit in cell H19?
Transcribed Image Text:Create the six-month budget as shown below for Web Wonders, a new company that provides Internet users with quick and easy access to the World Wide Web. Save the budget as Web Wonders Budget, then answer the following questions. * REVENUE 7 Internet Subscriptions s Homepage Server Space Total Revenue Web Wonders Proposed Six-Month Budget: January to June 2019 [Current Date] 11 EXPENSES $ 12 Salaries 23 Rent 14 Equipment Leases 15 Advertising 16 Operating Costs Total Expenses 39 19 PROFIT NNN www January February March April May June Totals 4500 150 4500 7000 7000 1500 1000 1000 150 G 3500 3500 3500 2500 2500 1200 3500 780 780 780 Bingka 1. In January you estimate that 1000 Internet subscribers will join Web Wonders at a cost of P30 per subscriber. You project that the subscription revenue generated in January will increase 5% in February, 10% in March, then 20% for each of the remaining months. Calculate all increases based on January revenue. What is the total revenue in cell H9? 2. In January you estimate that 50 subscribers will purchase space on the server for their homepages at a cost of P100 each. This revenue should increase by 30% each month to June. What is the total revenue in cell H9? 3.Triple the April Salaries and Advertising expenses for May and June. What is the total Salaries expense? What is the total revenue in cell H9? 4. Quadruple the April equipment lease for May and June. What is the total Equipment Lease expense? 5. What is the total projected profit in cell H19?
Expert Solution
steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Decision to Sell before or after additional processing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
SEE MORE TEXTBOOKS