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

# 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

• 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

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

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).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### 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

### 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

### 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.

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

### 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

### 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

### 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

## Open Questions:

#### Related Topics:

4,276 people viewed this question

Level 2 Expert

Level 3 Expert