Cost of sales Food and beverages $500,000 Shirts and caps $25,000 Other Expenses Administrative $30,000 Phone and internet $12,000 Advertising Repair and maintenance Utilities Payroll-restaurant employees Payroll-souvenir employees $150,000 $50,000 $40,000 $200,000 $9,000 $10,000 $60,000 Rent Property taxes Insurance $15,000 Interest $16,000 Depreciation $33,000 Revenue Restaurant revenue $1,500,000 Souvenir revenue $50,000 Using MS Excel arrange the above financial information for Jill's Restaurant into a summary operating statement for the year ending December 31, 2016.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question
Jill's Restaurant operates two profit centres. The first profit centre, restaurant, sells
200 flavors of chicken wings. The second profit centre, souvenir, sells T-shirts and
caps with the restaurant logo on them. Jill's Restaurant is a sole proprietorship, thus
the company is not responsible for paying income taxes. Jill Akerley, the owner of the
restaurant, does all of the administrative work and does not deduct payroll for
herself. Payroll expenses are paid only to the employees that Jill hires to work in the
restaurant and souvenir departments. Jill Akerley incurred the following revenue and
expenses for the year ending December 31, 2016.
Cost of sales
Food and beverages
$500,000
Shirts and caps
$25,000
Other Expenses
Administrative
$30,000
Phone and internet
$12,000
Advertising
$150,000
Repair and maintenance
Utilities
Payroll-restaurant employees
Payroll-souvenir employees
$50,000
$40,000
$200,000
$9,000
Rent
$10,000
Property taxes
$60,000
Insurance
$15,000
Interest
$16,000
Depreciation
$33,000
Revenue
Restaurant revenue
Souvenir revenue
$1,500,000
$50,000
Using MS Excel arrange the above fınancial information for Jill's Restaurant into a
summary operating statement for the year ending December 31, 2016.
Transcribed Image Text:Jill's Restaurant operates two profit centres. The first profit centre, restaurant, sells 200 flavors of chicken wings. The second profit centre, souvenir, sells T-shirts and caps with the restaurant logo on them. Jill's Restaurant is a sole proprietorship, thus the company is not responsible for paying income taxes. Jill Akerley, the owner of the restaurant, does all of the administrative work and does not deduct payroll for herself. Payroll expenses are paid only to the employees that Jill hires to work in the restaurant and souvenir departments. Jill Akerley incurred the following revenue and expenses for the year ending December 31, 2016. Cost of sales Food and beverages $500,000 Shirts and caps $25,000 Other Expenses Administrative $30,000 Phone and internet $12,000 Advertising $150,000 Repair and maintenance Utilities Payroll-restaurant employees Payroll-souvenir employees $50,000 $40,000 $200,000 $9,000 Rent $10,000 Property taxes $60,000 Insurance $15,000 Interest $16,000 Depreciation $33,000 Revenue Restaurant revenue Souvenir revenue $1,500,000 $50,000 Using MS Excel arrange the above fınancial information for Jill's Restaurant into a summary operating statement for the year ending December 31, 2016.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Statements
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