Homework Help is Here – Start Your Trial Now!
Business
Accounting
This is Wacky Entertainment's media sales report for the year 2022. The quarterly sales for the respective sub-category items have been included. Replicate the table format and using formulas, fill in the accordingly Sum total sales of each category under each quarter (01-04) Sum total sales of every item for the year (2022-Actual) Difference between the yearly total sales of 2021 and 2022 (Var. USS) Percentage of the year over year variance (Var. %6) [YOY variance (This year's sales- last year's sales)/ last year's sales x 100) Sum total revenue of each quarter (TOTAL REVENUE) The average, lowest, and highest values for every item (Average, Lowest, Highest) Audio Entertainment -Music Festivals -Physical Media Cinema -Cinema Advertising -Box Office Video games -Advertising -Boxed PC Games -Mobile Games TOTAL REVENUE QUARTERLY Audio Entertainment -Music Festivals -Physical Media Cinema -Cinema Advertising -Box Office Video games - Advertising -Boxed PC Games -Mobile Games Q1 697,251 747,883 200,410 215,229 157,182 259,641 Media Sales Report 2022 - Wacky Entertainment Inc Q2 Q3 Q4 7,780 85,503 14,682 663,889 243,565 153,110 112,434 315,785 311,660 10,555 8,541 113,116 128,476 31,315 23,609 Average Lowest Highest 797,622 184,913 201,214 304,569 7,359 128,438 25,843 2022-Actual 2021-Actual 3,271,362 2,400,759 870,603 1,550,867 530,348 1,020,519 576,890 31,026 449,066 96,798 5,399,119 Var. US$ Var. %

This is Wacky Entertainment's media sales report for the year 2022. The quarterly sales for the respective sub-category items have been included. Replicate the table format and using formulas, fill in the accordingly Sum total sales of each category under each quarter (01-04) Sum total sales of every item for the year (2022-Actual) Difference between the yearly total sales of 2021 and 2022 (Var. USS) Percentage of the year over year variance (Var. %6) [YOY variance (This year's sales- last year's sales)/ last year's sales x 100) Sum total revenue of each quarter (TOTAL REVENUE) The average, lowest, and highest values for every item (Average, Lowest, Highest) Audio Entertainment -Music Festivals -Physical Media Cinema -Cinema Advertising -Box Office Video games -Advertising -Boxed PC Games -Mobile Games TOTAL REVENUE QUARTERLY Audio Entertainment -Music Festivals -Physical Media Cinema -Cinema Advertising -Box Office Video games - Advertising -Boxed PC Games -Mobile Games Q1 697,251 747,883 200,410 215,229 157,182 259,641 Media Sales Report 2022 - Wacky Entertainment Inc Q2 Q3 Q4 7,780 85,503 14,682 663,889 243,565 153,110 112,434 315,785 311,660 10,555 8,541 113,116 128,476 31,315 23,609 Average Lowest Highest 797,622 184,913 201,214 304,569 7,359 128,438 25,843 2022-Actual 2021-Actual 3,271,362 2,400,759 870,603 1,550,867 530,348 1,020,519 576,890 31,026 449,066 96,798 5,399,119 Var. US$ Var. %

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
3. This is Wacky Entertainment's media sales report for the year 2022. The quarterly sales for the respective sub-category items have been included. Replicate the table format and using formulas, fill in the accordingly: Sum total sales of each category under each quarter (01-04) Sum total sales of every item for the year (2022-Actual) 0 0 0 Difference between the yearly total sales of 2021 and 2022 (Var. US$) Percentage of the year over year variance (Var. %) [YoY variance = (This year's sales - last year's sales) / last year's sales x 100] Sum total revenue of each quarter (TOTAL REVENUE) The average, lowest, and highest values for every item (Average, Lowest, Highest) Audio Entertainment - Music Festivals - Physical Media Cinema -Cinema Advertising - Box Office Video games - Advertising -Boxed PC Games -Mobile Games TOTAL REVENUE QUARTERLY Audio Entertainment - Music Festivals - Physical Media Cinema -Cinema Advertising - Box Office Video games - Advertising -Boxed PC Games - Mobile Games Q1 697,251 200,410 157,182 259,641 Media Sales Report 2022-Wacky Entertainment Inc Q2 Q3 Q4 2022-Actual Average 747,883 215,229 663,889 797,622 243,565 184,913 153,110 112,434 315,785 311,660 8,541 7,780 10,555 85,503 113,116 128,476 14,682 31,315 23,609 Lowest Highest . . 201,214 304,569 7,359 128,438 25,843 . 2021-Actual 3,271,362 2,400,759 870,603 1,550,867 530,348 1,020,519 576,890 31,026 449,066 96,798 5,399,119 Var. US$ Var. %
Transcribed Image Text:3. This is Wacky Entertainment's media sales report for the year 2022. The quarterly sales for the respective sub-category items have been included. Replicate the table format and using formulas, fill in the accordingly: Sum total sales of each category under each quarter (01-04) Sum total sales of every item for the year (2022-Actual) 0 0 0 Difference between the yearly total sales of 2021 and 2022 (Var. US$) Percentage of the year over year variance (Var. %) [YoY variance = (This year's sales - last year's sales) / last year's sales x 100] Sum total revenue of each quarter (TOTAL REVENUE) The average, lowest, and highest values for every item (Average, Lowest, Highest) Audio Entertainment - Music Festivals - Physical Media Cinema -Cinema Advertising - Box Office Video games - Advertising -Boxed PC Games -Mobile Games TOTAL REVENUE QUARTERLY Audio Entertainment - Music Festivals - Physical Media Cinema -Cinema Advertising - Box Office Video games - Advertising -Boxed PC Games - Mobile Games Q1 697,251 200,410 157,182 259,641 Media Sales Report 2022-Wacky Entertainment Inc Q2 Q3 Q4 2022-Actual Average 747,883 215,229 663,889 797,622 243,565 184,913 153,110 112,434 315,785 311,660 8,541 7,780 10,555 85,503 113,116 128,476 14,682 31,315 23,609 Lowest Highest . . 201,214 304,569 7,359 128,438 25,843 . 2021-Actual 3,271,362 2,400,759 870,603 1,550,867 530,348 1,020,519 576,890 31,026 449,066 96,798 5,399,119 Var. US$ Var. %
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Horizontal Analysis
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS