Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

we have this conversation can you decorticate it and explain the aim of it and summarize it: Sjoerd Handgraaf: [00:00:23] Welcome to Two-sided. The marketplace podcast brought to you by Sharetribe....

from the following podcast pick one of the podcasts and briefly provide some thoughts on it in the context of the topic of leadership. PODCAST Support for this podcast and the following message comes...

only this question please Question: How do you interpret the kid's advice: "You've got to know what you don't know"? The adventures of an IT leader... The Hero Called to Action that he was out of...

s ask for just cause 1. How long has the employee has been working for the company 2. Disciplinary record 3. Notice of expectations 4. Disparate treatment 5. Adequate investigation 6. Progressive...

SPEAKER 1 Awesome. Thank you. Questions Task Instructions 1. Watch the interview with the representative from the case study organisation. 2. Determine what their stated or inferred business...

Please read the question Question: What is the main points discussed and write a 1-2 paragraph summary on what is your opinion. Make sure to include a a brief description of replication and why it is...

Hello, Please answer help following question about POD Cast below Also, can you use listed refence below to help answer question number 3 1. Cite the podcast and summarize the episode's key insights,...

Topic: Drafting conclusion Conclusion type: Summary (plus) You might view a conclusion as an introduction in reverse: a bridge from the world of your paper back to the world of your reader. The...

I have an exam 2, and I want someone to help me with Acct 5100 I had uploaded. If there is TB that would be great.2 ACCT 5100 Exam 2 Study Guide - Preliminary The exam will consist of 33...

Compare and contrast LANs, MANs, and WANs. Use the following organizer for your answer. Compare (Same) and Contrast (Different)

Three substitution products and three elimination products are obtained from the following reaction: Account for the formation of these products. HC CH OCH3 CH3 OCH3 Br + CH3OH - CH3 CH3 CH3 CH3

What are the criticisms of using the HDI as a measure of standards of living?

which toc operational measure is used to describe it in its current state?

(Appendices) How do the periodic and perpetual inventory accounting systems differ from each other? LO64

(Appendices) Write the formulas for the calculation of accounts receivable turnover and inventory turnover. What do these calculations tell us about accounts receivable and inventory? LO53

(Appendices) EFFECTS OF SALES DISCOUNTS. Castore Security Systems makes all sales on credit, with terms 2/10, n/30. During 19x9, the list price (prediscount) of goods sold was $720,000. Customers...