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?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbd9974c8-4445-42ab-bc2e-9d576aa3cc73%2F421b7781-6544-4e64-b0d5-fb446078fb4f%2F01ze0fl_processed.jpeg&w=3840&q=75)
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
Knowledge Booster
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.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education