Group worksheets for Rosie’s Flowers Quarters 1-4 and calculate the following: REVENUE, COSTS, NET INCOME (net income=revenue-costs). Costs are 40% of revenue, as referenced in cell B9. Create a summary sheet that shows totals for the entire year. The layout/design should be the same as the Qtr 1- 4 worksheets. Adjust the heading.Using formulas, static consolidation, or dynamic consolidation, calculate yearly totals for Rosie in all areas. In cell A14 on the summary sheet, indicate which method you used to calculate totals. In cell A15, enter your name. %24%24Rosie's FlowersRosie's Flowers1st Quarter 20182nd Quarter 2018RegularMother's DayBirthdayBirthdayRegularMother's DaySales Volume:450675550Sales Volume:009Selling Price:45 $5252$ 09Selling Price:45 $2$$ 09RevenueRevenueCosts%00Costs%00Net IncomeNet IncomeRosie's FlowersRosie's Flowers3rd Quarter 2018RegularMother's DayBirthday4th Quarter 2018Sales Volume:450625RegularMother's DayBirthday550Sales Volume:575425Selling Price:45 $52$ 0952Selling Price:45 $2$$ 09RevenueRevenueCosts%0Costs%0Net IncomeNet Income

Revenue = Sales Volume x Selling Price Cost = 40% x Revenue Income = Revenue - Cost

Answered: Group worksheets for Rosie’s Flowers…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Question

Group worksheets for Rosie’s Flowers Quarters 1-4 and calculate the following: REVENUE, COSTS, NET INCOME (net income=revenue-costs). Costs are 40% of revenue, as referenced in cell B9.

Create a summary sheet that shows totals for the entire year. The layout/design should be the same as the Qtr 1- 4 worksheets. Adjust the heading.

Using formulas, static consolidation, or dynamic consolidation, calculate yearly totals for Rosie in all areas. In cell A14 on the summary sheet, indicate which method you used to calculate totals. In cell A15, enter your name.

%24
%24
Rosie's Flowers
Rosie's Flowers
1st Quarter 2018
2nd Quarter 2018
Regular
Mother's Day
Birthday
Birthday
Regular
Mother's Day
Sales Volume:
450
675
550
Sales Volume:
009
Selling Price:
45 $
52
52
$ 09
Selling Price:
45 $
2$
$ 09
Revenue
Revenue
Costs
%00
Costs
%00
Net Income
Net Income
Rosie's Flowers
Rosie's Flowers
3rd Quarter 2018
Regular
Mother's Day
Birthday
4th Quarter 2018
Sales Volume:
450
625
Regular
Mother's Day
Birthday
550
Sales Volume:
575
425
Selling Price:
45 $
52
$ 09
52
Selling Price:
45 $
2$
$ 09
Revenue
Revenue
Costs
%0
Costs
%0
Net Income
Net Income

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 10 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions