Practice Problem #2: Desired Net Income: Owners want a 23% after tax return on a $250,000 investment of new FF&E • Income Tax Rate: 37% of operating income before tax • Depreciation of 10% of the book value of the $250,000 of FF&E • Annual Costs: Rent=$50,000, Insurance/Licenses=$6,000, Utilities/Maintenance=$7,500, Administrative=$15,500, • Variable Costs-cos Food and Beverage 41% (Too High!), Labor=31%, Other=6% Management Salary=$40,000 1 Identify Projected Costs Desired Net Income after Tax Income Tax: Known Annual Costs ($5): Depreciation Rent Insurance License Utilities/Maintenance Administrative Management Salary Total Known Annual Costs Variable Costs (% of Sales) COS - Food and Beverage Labor Other Operating Variable Costs

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
AutoSave
Bottoms Up Pricing Worksheet
Compatibility Mode – Saved to my Mac
OFF
W
Home
Insert
Draw
Design
Layout
References
Mailings
Review
View
Grammarly
Tell me
Share
Comments
A A
abc
Аa v
AaBbCcDdE AaBb
Arial
11
AaBbCcDdEe
AaBbCcD
AaBbCcDdEe
AaBbCcDdEe
AaBbCcDdE€
AaBbCcDdEe
AaBbCcDdEe
Subtle Emph...
Styles
Pane
Dictate
Оpen
Grammarly
Paste
A
No Spacing
Heading 1
Heading 2
Title
Subtitle
Emphasis
Intense Emp..
I
U
v ab x,
Normal
Managerial Accounting - Bottoms Up Approach to Pricing
Page 4
#2 Prepare Projected Income Statement (Incomplete)
$$
Sales Revenue
COS - Food and Beverage
Unknown
100%
Labor
Other Operating VC
Total Variable Cost %
Depreciation
Rent
Insurance /License
Utilities/Maintenance
Administrative
Management Salary
Income Tax
Net Income
Total
Total Costs as a % Sales Rev
100%
# 3 Prepare Condensed Projected Income Statement
Sales Revenue
Variable Costs (Food, Bev, Labor,
Other)
Contribution Margin
Total Operating Costs
Operating Income (BT)
Income Tax
Net Income
# 4 Solve for Average Check Projections by Meal Period to support projected Sales Revenue
Knowing the forecasted sales revenue allows businesses to accurately forecast overall average check and average check by meal
period. This is critical information needed for the budgeting process and selecting strategic pricing strategies.
Average Check by Meal Period = (Revenue generated from meal period / Seats x T/O x number days open)
Seat Turnover = # guests or covers / # seats in operation or available_(Can be calculated by Meal Period or Day)
Managerial Accounting - Bottoms Up Approach to Pricing
Page 5
Practice Problem #3:
Page 4 of 8
1075 words
English (United States)
EO Focus
+
120%
B
Transcribed Image Text:AutoSave Bottoms Up Pricing Worksheet Compatibility Mode – Saved to my Mac OFF W Home Insert Draw Design Layout References Mailings Review View Grammarly Tell me Share Comments A A abc Аa v AaBbCcDdE AaBb Arial 11 AaBbCcDdEe AaBbCcD AaBbCcDdEe AaBbCcDdEe AaBbCcDdE€ AaBbCcDdEe AaBbCcDdEe Subtle Emph... Styles Pane Dictate Оpen Grammarly Paste A No Spacing Heading 1 Heading 2 Title Subtitle Emphasis Intense Emp.. I U v ab x, Normal Managerial Accounting - Bottoms Up Approach to Pricing Page 4 #2 Prepare Projected Income Statement (Incomplete) $$ Sales Revenue COS - Food and Beverage Unknown 100% Labor Other Operating VC Total Variable Cost % Depreciation Rent Insurance /License Utilities/Maintenance Administrative Management Salary Income Tax Net Income Total Total Costs as a % Sales Rev 100% # 3 Prepare Condensed Projected Income Statement Sales Revenue Variable Costs (Food, Bev, Labor, Other) Contribution Margin Total Operating Costs Operating Income (BT) Income Tax Net Income # 4 Solve for Average Check Projections by Meal Period to support projected Sales Revenue Knowing the forecasted sales revenue allows businesses to accurately forecast overall average check and average check by meal period. This is critical information needed for the budgeting process and selecting strategic pricing strategies. Average Check by Meal Period = (Revenue generated from meal period / Seats x T/O x number days open) Seat Turnover = # guests or covers / # seats in operation or available_(Can be calculated by Meal Period or Day) Managerial Accounting - Bottoms Up Approach to Pricing Page 5 Practice Problem #3: Page 4 of 8 1075 words English (United States) EO Focus + 120% B
AutoSave
Bottoms Up Pricing Worksheet
Compatibility Mode – Saved to my Mac
OFF
W
Home
Insert
Draw
Design
Layout
References
Mailings
Review
View
Grammarly
Tell me
Share
Comments
A A
abc
Аa v
AaBbCcDdE AaBb
Arial
11
AaBbCcDdEe
AaBbCcD
AaBbCcDdEe
AaBbCcDdEe
AaBbCcDdE€
AaBbCcDdEe
AaBbCcDdEe
Subtle Emph...
Styles
Pane
Dictate
Оpen
Grammarly
Paste
I
U
v ab x,
A
Normal
No Spacing
Heading 1
Heading 2
Title
Subtitle
Emphasis
Intense Emp..
Practice Problem #2:
Desired Net Income: Owners want a 23% after tax return on a $250,000 investment of new FF&E
Income Tax Rate: 37% of operating income before tax
Depreciation of 10% of the book value of the $250,000 Of FF&E
Annual Costs: Rent=$50,000, Insurance/Licenses=$6,000, Utilities/Maintenance=$7,500, Administrative=$15,500,
Management Salary=$40,000
Variable Costs=COS Food and Beverage 41% (Too High!), Labor=31%, Other=6%
#1 Identify Projected Costs
Desired Net Income after Tax:
Income Tax:
Known Annual Costs ($$):
Depreciation
Rent
Insurance /License
Utilities/Maintenance
Administrative
Management Salary
Total Known Annual Costs
Costs (% of Sales)
Food and Beverage
Variab
COS
Labor
Other Operating Variable Costs
Managerial Accounting - Bottoms Up Approach to Pricing
Page 4
#2 Prepare Projected Income Statement (Incomplete)
$$
Sales Revenue
Unknown
100%
COS - Food and Beverage
Labor
Other Operating VC
Total Variable Cost %
Depreciation
Pent
Page 3 of 8
1075 words
English (United States)
EO Focus
+
120%
B
Transcribed Image Text:AutoSave Bottoms Up Pricing Worksheet Compatibility Mode – Saved to my Mac OFF W Home Insert Draw Design Layout References Mailings Review View Grammarly Tell me Share Comments A A abc Аa v AaBbCcDdE AaBb Arial 11 AaBbCcDdEe AaBbCcD AaBbCcDdEe AaBbCcDdEe AaBbCcDdE€ AaBbCcDdEe AaBbCcDdEe Subtle Emph... Styles Pane Dictate Оpen Grammarly Paste I U v ab x, A Normal No Spacing Heading 1 Heading 2 Title Subtitle Emphasis Intense Emp.. Practice Problem #2: Desired Net Income: Owners want a 23% after tax return on a $250,000 investment of new FF&E Income Tax Rate: 37% of operating income before tax Depreciation of 10% of the book value of the $250,000 Of FF&E Annual Costs: Rent=$50,000, Insurance/Licenses=$6,000, Utilities/Maintenance=$7,500, Administrative=$15,500, Management Salary=$40,000 Variable Costs=COS Food and Beverage 41% (Too High!), Labor=31%, Other=6% #1 Identify Projected Costs Desired Net Income after Tax: Income Tax: Known Annual Costs ($$): Depreciation Rent Insurance /License Utilities/Maintenance Administrative Management Salary Total Known Annual Costs Costs (% of Sales) Food and Beverage Variab COS Labor Other Operating Variable Costs Managerial Accounting - Bottoms Up Approach to Pricing Page 4 #2 Prepare Projected Income Statement (Incomplete) $$ Sales Revenue Unknown 100% COS - Food and Beverage Labor Other Operating VC Total Variable Cost % Depreciation Pent Page 3 of 8 1075 words English (United States) EO Focus + 120% B
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Capital Budgeting
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