Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone please help me fill out these formulas for the excel document thank you! B25 7. Enter formulas in cells C5:07 and C11:C15 to

can someone please help me fill out these formulas for the excel document thank you!
image text in transcribed
image text in transcribed
B25 7. Enter formulas in cells C5:07 and C11:C15 to calculate the sales values for February as follows: C5: Sales of Sandwiches sales will increase by $500 from previous month. C6: Sales of Soups will increase 5% from previous month. C7: Sales of Desserts will increase 7% from previous month. 011: Sales of Coffee will increase by 3% from previous month. C12: Sales of Tea will not change from previous month. C13: Sales of Beer/Wine will decrease by 5% from previous month. C14: Sales of Julces will increase by 10% from previous month. C15: Sales of Soft Drinks will increase by $1000 from previous month. 2 Pre 3 4 5 6 7 8 9 10 11 12 nity David Se April January February March May June Food Sales Sandwiches Soups Desserts Total Food Sales 83000 38000 44000 Beverage Sales Coffee Tea Beer/Wine Juice Soft Drinks Total Beverage Sales 68000 30000 24000 10000 14000 Ingredient Costs Food Cost Beverage Costs Net Revenue 30% 15%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Message Brand And Dollars Auditing Marketing Operations

Authors: J. Mike Jacka, Peter R. Scott

1st Edition

163454000X, 9781634540001

More Books

Students also viewed these Accounting questions

Question

If there were no law against it, would it be OK to blind someone?

Answered: 1 week ago