• 100% Satisfaction Guarantee

the-pc-guy, Engineer
Category: Homework
Satisfied Customers: 1088
Experience:  10 Years as a tutor helping people with their Computer Programming and Networking Assignments
the-pc-guy is online now

# As buyer of for the Media Loft New York Cafe, you have just

### Resolved Question:

As buyer of for the Media Loft New York Cafe, you have just been informed by your supplier that the cost of your coffee, tea, cream, milk, and sugar will go up 15% on April 1, 2000. The store manager has asked you to complete the budget calculations for the year taking into consideration the new pricing and showing comparative data by March 1, 2000 .

Download Project file Excel_B21.xlsx, , then save the workbook as: YourName_Budget B2.
Change the date in cell F1 to today's date.
Type your name in cell A30.
In cell A23, add a label called Potential Cost Increase and enter the proposed increase in cell A24 as 15%.
In cell B23, create a formula adding cells B14 through B16 and then multiplying that answer by the proposed increase in A24.
Create a formula in cell F6 to add the salaries.
Create a formula in F4 to add the Net Sales using the AutoSum button.
Copy the formula in cell F4 to F10 through F17 using the Office Clipboard.
In B17, create a formula to add the Qtr1 expenses, and using the fill handle, copy the formula to cell E17*.
In B19, create a formula subtracting the Total Expenses from the Net Sales, and using a fill handle, copy it to cell F19.
Make the A24 cell reference in the formula in cell B23 absolute.
Copy the formula in B23 to all the cells to F23 using the fill handle.
In cell A26, create a label Adjusted Income.
In cell B26, create a formula subtracting the Proposed Increase amount from the Net Income.
Copy that formula from B26 to cell F26.
Save it and close Excel.
Submit the file in the Excel drop box labeled Assignment # XXXXX - Excel 2010.
* Be sure that you don't include the Salary in the Total Expenses.
Submitted: 1 month ago.
Category: Homework
Expert:  the-pc-guy replied 1 month ago.

The-PC-Guy :

The-PC-Guy :

The-PC-Guy :

can you provide a copy of your workbook?

The-PC-Guy :

are you with me?

Expert:  the-pc-guy replied 1 month ago.
Our chat has ended, but you can still continue to ask me questions here until you are satisfied with your answer. Come back to this page to view our conversation and any other new information.

What happens now?

Expert:  the-pc-guy replied 1 month ago.

can you provide a copy of your workbook?

www.wikisend.com

Paste that ID# XXXXX

The-PC-Guy41576.6181822685
Customer: replied 1 month ago.

hey

Expert:  the-pc-guy replied 1 month ago.
hi,

can you provide a copy of your workbook per the instructions above so I can assist you

here they are again in case you missed them

www.wikisend.com

Paste that ID# XXXXX

Customer: replied 1 month ago.

• File ID: 335486

Expert:  the-pc-guy replied 1 month ago.
Maylin Lara, I have the file.

What do you need help with where are you stuck?

Customer: replied 1 month ago.

I did 1 through 3 , I need help with everything else

Expert:  the-pc-guy replied 1 month ago.
ok

give me a few minutes and I will take care of it
Customer: replied 1 month ago.

take your time I have till 5:00 P.M

Thank you so much!

Expert:  the-pc-guy replied 1 month ago.
You can view this answer by clicking here to Register or Login and paying \$3.
the-pc-guy, Engineer
Category: Homework
Satisfied Customers: 1088
Experience: 10 Years as a tutor helping people with their Computer Programming and Networking Assignments
Expert:  the-pc-guy replied 1 month ago.

Please feel free to request me again in the future if you need my help.

---------------------------------------------------------------------------------------------------------------

if you have any questions in the future you can visit my profile

and ask a question right in my box,

also you can put "PC Guy only" in your question title if you want to get to me.
Customer: replied 1 month ago.
Hi , I have a question why did you change b15 and 16 to 1000 instead 4250 and 300 . Thanks
Customer: replied 1 month ago.

Hi , I have a question why did you change b15 and 16 to 1000 instead 4250 and 300 ????Thanks

Expert:  the-pc-guy replied 1 month ago.
I am sorry I did not respond sooner.

I could not, do to a communications hookup

but that is straitened out

I didn't change anything.

I just followed the instructions

Is there something that needs to be fixed?

Customer: replied 1 month ago.

 MediaLoft NYC Café Budget as of 11/2/2013 Qtr1 Qtr2 Qtr3 Qtr4 Total Net Sales 53,000 76,000 64,000 80,000 273,000 Salary Total Salaries 52,000 Judith Motenegro 6500 6500 6500 6500 Elizabeth Emery 6500 6500 6500 6500 Expenses Rent 3,500 3,500 3,500 3,500 14,000 Advertising 3,600 8,000 16,000 20,000 47,600 Cleaners 1,500 1,500 1,500 1,500 6,000 Pastries 2,500 2,500 2,500 2,500 10,000 Milk/Cream 1,000 1,000 1,000 1,000 4,000 Coffee/Tea 1,000 4,250 4,250 4,250 13,750 Sweetners 1,000 300 300 300 1,900 Total Expenses 14,100 21,050 29,050 33,050 97,250 Net Income 38,900 54,950 34,950 46,950 175,750 Potential Cost Increase 450 833 833 833 2,948 15% Adjusted Income 38,450 54,118 34,118 46,118 172,803 Maylin Lara
Customer: replied 1 month ago.

I just need to know why those numbers are different Coffee /Tea 4250 and Sweeteners 300 . (Those are my initials numbers) and now I have 1000 in both . Why??

Thank you

Attachments are only available to registered users.

Register Here

Expert:  the-pc-guy replied 1 month ago.
Sorry,

Any values in those rows were your original values, nothing I did changed those particular values, I just followed your instructions.

If you need to change those values you can do so without effecting anything else
Customer: replied 1 month ago.

Thank you

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
• Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
• He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX

• ### Manal Elkhoshkhany

#### Satisfied Customers:

4514
More than 5000 online tutoring sessions.
< Last | Next >

### Manal Elkhoshkhany

#### Satisfied Customers:

4514

More than 5000 online tutoring sessions.

### Linda_us

#### Satisfied Customers:

3099

Post Graduate Diploma in Management (MBA)

### Lani S.

#### Satisfied Customers:

2453

Registered Nurse, Internet Researcher, Private Tutor

### Chris M.

#### Satisfied Customers:

2258

Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

### LogicPro

#### Satisfied Customers:

2193

Expert in Java C++ C C# VB Javascript Design SQL HTML

### F. Naz

#### Satisfied Customers:

1962

Experience with chartered accountancy