Question: Using the popularity indexes calculated in Question 6, predict the sales for each item if total sales for all items are expected to be 149

  1. Using the popularity indexes calculated in Question 6, predict the sales for each item if total sales for all items are expected to be 149 by filling in the cells with question marks. Round all adjusted portions forecast calculations to whole numbers:

Item Forecasted total sales

Popularity Index

(in decimal)

 Adjusted portion forecast
A 149 ? ?
B 149 ? ?
C 149 ? ?
D 149 ? ?
E 149 ? ?
TOTAL 149

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!

Q:

1-5 1. Compute the popularity index/menu mix for the following items. Round each percentage to the nearest 1 percent. 2. Using the popularity indexes calculated in Question 1a, predict the sales for...

Q:

do in the same format as the first Food Sales Num of Covers Average Check 1 Day Total Weekly Total Monthly Total Yearly Total % Gross Sales Lunch Dinner Take-out TOTAL Liquor Sales p/pl 310 550 210...

Q:

1. Calculate the popularity index for the following sales in Excel. Round each result to two decimals. a. Item Portions sold 75 B 35 80 D 40 b. Item Portions sold 30 B 40 70 D 125 C. Item Portions...

Q:

1. Calculate the popularity index for the following sales in Excel . Round each result to two decimals. a. Item Portions sold A 75 B 35 C 80 D 40 b. Item Portions sold A 30 B 40 C 70 D 125 c. Item...

Q:

Calculate the popularity index for the following sales in Excel. Round each result to two decimals. Item Portions sold A 6 0 B 3 5 C 8 0 D 4 0 Item Portions sold a 4 3 b 6 0 c 7 0 d 1 2 5 Item...

Q:

204. Cost Control. Term 1, 2023 Assignment 1 makeup Submission date: Sunday, March 12, 23:59 PM PST Student name Student ID Lesson 5. Chapter 6 1. Complete the butcher test below by inserting the...

Q:

ralrulato tha nnnularitu indav far tho fallnwina sales in Excel. Round each result to two decimals. 2. Using the popularity indexes calculated in Question 1a, predict the sales for each item if total...

Q:

Short answer. If a manager of a restaurant wanted to control excessive food costs, would void sheets used in portion control be of any use? Why? (A few sentences will be enough) Explain the value of...

Q:

1. Compute the popularity index for the following sales. Round each per- centage to the nearest 1 percent. a. Item Portions sold ABCD A 60 20 80 D 40 b. Item Portions sold ABCD 30 42 73 115 C. Item...

Q:

a. 1. Compute the popularity index for the following sales. Round each per- centage to the nearest 1 percent. Item Portions sold A 60 B 20 80 D 40 Item Portions sold 30 42 C 73 115 20 OU OUA 2. Using...

Q:

The inventory of 3T Company on December 31, 2008, consists of these items. Instructions (a) Determine the inventory as of December 31, 2008, by the lower-of-cost-or-market method, applying this...

Q:

Mary Harrington is calculating the trade discount on a dog kennel with a list price of $269 and a trade discount series of 10/10/10. What is the trade discount? What is the net price for the kennel?

Q:

Carrying debt today is limiting your financial options in the future. True False

Q:

If the following join statement is used to join two tables in a query, which of the following tables would all of the tuples in the relation appear in results? left join university.students on...