Question about Vivendi Excel@ Mathematics Study Skills (71101) for PC, Mac

1 Answer

The Belvedere Arms takes £11,800 in drink sales and £5,600 in food sales in a week. In the same week the pub delivers £8,496 profit on drink and £3,640 profit on food. The week's sales budget is £16,200. This question must be completed Required What are: (To the nearest whole number) a) Total Sales £17,400 £12,136 £21,300 £29,536 £18,500 This question must be completed Required b) Performance against Sales Budget Up by 6.9% Down by 7.4% Flat Up by 7.4% Down by 6.9% This question must be completed Required c) Food GP% 56% 153% 65% 178% Impossible to say This question must be completed Required d) Drink GP% 72% 49% 151% 138% Impossible to say This question must be completed Required e) Total GP% 143% 127% 62% 70% Impossible to say

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 282 Answers

Assuming the Belvedere Arms sells only food and drink:
a) Total sales for the week is the sum of the drink sales and food sales, £11,800 + £5,600 = £17,400
b) Sales budget is £16,200, so performance is (17,400-16,200)/16,200 = 1200/16200 = .074 which is up by 7.4%
c) Profit on food is £3,640 on total food sales of £5,600. 3640/5600 = .65 or 65%
d) Profit on drink is £8,496 on total drink sales of £11,800. 8496/11,800 = .72 or 72%
e) Total profit is £12,036 on total sales of £17,400. 12,136/17,400 = .697 or 70%

Posted on Mar 10, 2011

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

I want the lyrics of Mario Lanza DRINKING SONG


Google it we do not have them here on this repair site

Dec 21, 2016 | Computers & Internet

1 Answer

I have loss of taste buds for more than a week.Everything I eat or drink taste bitter or like metal.


It has been almost a month since this was posted. Hoping your taste changed back to normal or you contacted your doctor, naturopath, homeopath or acupuncturist. Hoping you are enjoying food and drink again, and most importantly, you are healthy.

Dec 30, 2014 | Home

1 Answer

If sales were $5,000 and operating expenses were $2,700 - what is the net profit as a percentage of sales?


Profit =5 000 -2 700=?
As a percentage of sales:
Percentage = 100%*(5000 -2700)/5000=?

Sep 30, 2014 | Office Equipment & Supplies

1 Answer

Singer user guide starlet 496


Many Singer machine manuals are available here: http://www.singerco.com/support/instruction-manuals . The 496 is not available. However, the manual for the Starlet 495 is available: http://www.singerco.com/uploads/download/8a78e29267b106e9d2902ac0f6758edf694e6d61.pdf . Since Singer doesn't change the machines significantly, this manual may help you.

If the 495 manual isn't enough, this site seems to have the manual for sale: http://www.manualsdrive.com/captching.php?lang=en&search=SINGER+STARLET+496+USERS+GUIDE .

I hope this helps.

Cindy Wells

Sep 01, 2012 | Singer Sewing Machines

1 Answer

We have a Dito Dean Food Prep EM30 Mixer that we use at a camp for children! We are a non-profit group! Our mixer flat beater part # 30 273 has broken. We tried to find one at a restaurant supply but were...


Here's the contact info for the company that made that mixer.

The Electrolux Professional Inc. headquarter
are located in Charlotte, NC at:

10200 David Taylor Drive
Charlotte, NC 28262

Phone: 866-449-4200
Fax: 704-547-7401

I hope this helps you.

Bobya.

Jul 01, 2011 | Dito Dean Food Prep EM-30 Stand Mixer

2 Answers

My Miele dishwasher is about 16 months old. Initially it was awesome. Now it doesn't get anything truly clean on any rack. Every item has scum and traces of food or drink left on it. I've cleaned the...


Hi bjw.... clean the dishwasher by putting 2 cups of vinegar into an empty dishwasher and running the longest and hottest cycle.

Repeat this washing as needed but generally at least once a month. Joe

Thanks for choosing Fixya!

Feb 27, 2011 | Miele G880 Dishwasher

1 Answer

Ibico 1232 desk calc. How do i calculate gp


Is this a trick question, were you sleeping in class, or did you forget how to use a search engine??

Gross Profit = Sales - CGS.
Gross Profit Margin = Gross Profit / Total Sales

Company A has sales of $80,000 and a CGS of $60,000. GP=$20,000 and GPM = 25%

Carl

Oct 01, 2010 | Office Equipment & Supplies

3 Answers

How to do profit and loss a/c in ms excel


Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Description
Amount
Formula
Sales Product A
1,000.00

Sales Product B
1,000.00

Total Sales
2,000.00
SUM(C1:C2)
Cost of Sales Product A
500.00

Cost of Sales Product B
200.00

Total Cost of Sales
700.00
SUM(C5:C6)
Gross Profit
1,300.00
SUM(C4-C7)



Auto
25.00

Utilities
50.00

Payroll
300.00

Office Supplies
20.00

Total Expenses
395.00

Net Profit
905.00
SUM(C8-C14)


I hope this helps

Mark

Jan 05, 2009 | Microsoft Computers & Internet

Not finding what you are looking for?
Vivendi Excel@ Mathematics Study Skills (71101) for PC, Mac Logo

Related Topics:

4,276 people viewed this question

Ask a Question

Usually answered in minutes!

Top Vivendi Computers & Internet Experts

Bapco

Level 2 Expert

282 Answers

k24674

Level 3 Expert

8016 Answers

Stitch85

Level 1 Expert

27 Answers

Are you a Vivendi Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...