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

Statistics
1.2K views

Determine if the following is an example of descriptive or inferential statistics 300 female Osprey...

Basic Math
1.2K views

A device is used in many kinds of systems. Assume that all systems have either 1,...

Accounting
1.2K views

The Perez Company has the opportunity to invest in one of two mutually exclusive machines that...

Biology
1.2K views

Question 8 All of the following are examples of

Biology
1.2K views

51 What is the term for money that is given to candidates for any use...

Biology
1.2K views

se the correct answer When you need most of the ideas of the writer you...

Basic Math
1.2K views

Given that 3-4i is a zero, factor the following polynomial function completely. Use the Conjugate...

Algebra
1.2K views

Let A be a 3 x 8, B be a 8 x 7 and C...

Algebra
1.2K views

Question 1 25 points Shortest Route Algorithm What is the length of the shortest path...

Accounting
1.2K views

Problem 3 (10 points). Anson, Inc. sells a single...

Accounting
1.2K views

Standard Rate = OMR 5 per hour Actual production = 1000 units Actual Hours Used...

Accounting
1.2K views

Oriole Company sold $3,140,000,9%,10-year bonds on January 1,2025. The bonds were dated January 1,2025, and...