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.

SWFT Comprehensive Vol 2020
43rd Edition
ISBN:9780357391723
Author:Maloney
Publisher:Maloney
Chapter5: Gross Income: Exclusions
Section: Chapter Questions
Problem 44P
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
Recommended textbooks for you
SWFT Comprehensive Vol 2020
SWFT Comprehensive Vol 2020
Accounting
ISBN:
9780357391723
Author:
Maloney
Publisher:
Cengage
SWFT Comprehensive Volume 2019
SWFT Comprehensive Volume 2019
Accounting
ISBN:
9780357233306
Author:
Maloney
Publisher:
Cengage
SWFT Essntl Tax Individ/Bus Entities 2020
SWFT Essntl Tax Individ/Bus Entities 2020
Accounting
ISBN:
9780357391266
Author:
Nellen
Publisher:
Cengage
SWFT Individual Income Taxes
SWFT Individual Income Taxes
Accounting
ISBN:
9780357391365
Author:
YOUNG
Publisher:
Cengage
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L
Income Tax Fundamentals 2020
Income Tax Fundamentals 2020
Accounting
ISBN:
9780357391129
Author:
WHITTENBURG
Publisher:
Cengage