Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please solve this question in an excel sheet ? 1 a

PLEASE SOLVE THIS QUESTION IN AN EXCEL SHEET ? 1 a. Given that food sales are $450,000...

Free

60.1K

Verified Solution

Question

Accounting

PLEASE SOLVE THIS QUESTION IN AN EXCEL SHEET ?

1 a. Given that food sales are$450,000 for the year and beverages sales are 80,000,prepare   a statement of income forMavericks Restaurant using the expenses below. (Use Figure 1.1 onpg 5 as a guide). Hint: Remember “controllablefixed” costs fall under Other Controllable Expenses. (roundto two decimal points)

Administrative Expenses     $4,000

Employee Benefits $27,550

Cost of food sold $140,000

Salaries and wages $120,000

Utilities $26,000

Depreciation on equipment $14,100

Cost of beverages sold $16,230

Interest expense     $3,100

Occupancy costs $33,200

Advertising     $5,000

b. Based on the figures above, calculate:

Prime cost percent

Overhead cost percent

Profit percent

(Remember to ensure they equal up to 100%)

Labor cost percent

Food cost percent

Answer & Explanation Solved by verified expert
3.9 Ratings (435 Votes)

1a) INCOME STATEMENT: Amount $
Sales revenue:
Food 450000
Beverage 80000
Total Sales revenue 530000
Cost of Sales
Cost of food sold 140000
Cost of beverages sold 16230
Total Cost of Sales 156230
Gross Profit 373770
Less: Controllable Costs:
Salaries and Wages 130000
Employee Benefits 27550
Utilities 26000
Advertising 5000
Total Controllable costs 188550
Income before Non-Controllable costs: 185220
Less: Non Controllable Costs:
Occupancy costs 33200
Interest 3100
Depreciation on equipment 14100
Total Non-Controllable costs 50400
Restaurant Income 134820
b.)
Prime cost percent Cost of sales / Sales = 156230/530000= 29.48%
Overhead percent (Controllable + Non-Controllable costs)/Sales
(188550+50400)/530000 = 45.08%
Profit persent Restaurant Income / Sales = 134820/530000 = 25.44%
Labor cost percent (Salaries & wages exp. + employee benefits)/Sales
(130000+27550)/530000 = 29.73%
Food cost percent Cost of food sold / Sales = 140000/530000 = 26.41%

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Explain process operations and the way they differ from joborder operations in 250 words...

Accounting
Q

the future earnings, dividends, and common stock price of Callahan Technologies Inc. are expected to grow...

Finance
Q

what type of research thesis in business? I am doing thesis research of feasibility framework for...

Finance
Q

QUESTION 12 What stops or slows down an unprepared cell?

Biology
Q

As a CEO in a newly founded company, what are the benefits of implementing Current Engineering (Simultaneous...

Mechanical Engineering
Q

a. Which sex is typically assigned at birth to an individual with XXY chromosomes?b. If...

Biology
Q

H3 OA 3 37 Select the graph that represents the point OB 5 O C...

Basic Math
Q

Find an equation of the form y ab csin a b X C y To...

Basic Math
Q

loh A survey asked 32 145 people how much confidence they had in educational institutions...

Statistics
Q

times and her results had a standard deviation of 1 33 The same sample was...

Statistics
Q

Write each of the following expressions in simplified exponential form b 5 x e 27...

Algebra
Q

(###17)No chat gpt answers & don't copy from chegg or else I'll give 5 downvotes...

Accounting