Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need to know HOW to solve these problems using excel Clipboard Font Alignment B32 Susie is devel lopin g a sales forecast for her

image text in transcribed

i need to know HOW to solve these problems using excel

Clipboard Font Alignment B32 Susie is devel lopin g a sales forecast for her seafood restaurant and needs to forecast her average 2 guest check. Use the information below to help her determine this information. AverageAverage Check Average Ordered Order Check Food Beverage Check Average price | Percentage | # per Point 4 Dinner 5 Food 6 Entre 7 Appetizer 8 Dessert 9 Beverages 10 Non-alcoholic 11 Liquor 12 Beer 13 Wine 14 TOTALS 15 16 How will Susie use this information to control food costs in production? What other forecasting 17 tools/calculations could she use to make sure food production levels are appropriate? 18 19 20 21 $14.99 $6.99 $4.99 100% 20% 20% $1.99 $7.59 $4.49 5799 , 20% 12% 25% 28%) 1.5 1.75

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

CPA Comprehensive Exam Review Auditing And Attestation

Authors: Nathan M. Bisk

43rd Edition

088128095X, 978-0881280951

More Books

Students also viewed these Accounting questions