Create a popularity index for the sales history given below. Menu Item Number Sold Popularity Index...

Create a popularity index for the sales history given below.

Menu Item	Number Sold	Popularity Index

Veal Marsala	375
Strip Steak	330
Roast Chicken	125
Stuffed Shrimp	160
Pasta Alfredo	130
Pork Chops	80
Saute Liver	90
Beef Stew	170
Deluxe Burger	405
Grill Swordfish	135
Totals		100%

8. (10 points) Now complete a production schedule using the popularity index and accounting for a 10% increase in sales that the chef expects due to a holiday.

Menu Item	Total Forecast	x	P.I.	=	Portion Forecast	x	% adjustment	=	Adjusted Portion Forecast

Veal Marsala
Strip Steak
Roast Chicken
Stuffed Shrimp
Pasta Alfredo
Pork Chops
Saute Liver
Beef Stew
Deluxe Burger
Grill Swordfish
Totals	1500	100%

Solutions

Expert Solution

Production Schedule using Popularity Index and Accounting
Menu Item	Number Sold	Popularity Index (In %)	Portion Forecast (In Nos.)	% Adjustment (10% Increase in sales)	Adjusted Portion Forecast (In Nos.)
A	*B = (A/2000 100)**	*C = (1500 B)**	*D = (C 10%)**	E = (C + D)
Veal Marsala	375	18.75%	281	28	309
Strip Steak	330	16.50%	248	25	272
Roast Chicken	125	6.25%	94	9	103
Stuffed Shrimp	160	8.00%	120	12	132
Pasta Alfredo	130	6.50%	98	10	107
Pork Chops	80	4.00%	60	6	66
Saute Liver	90	4.50%	68	7	74
Beef Stew	170	8.50%	128	13	140
Deluxe Burger	405	20.25%	304	30	334
Grill Swordfish	135	6.75%	101	10	111
Total	2000	100.00%	1500	150	1650

Note : 1.	Popularity Index is the ratio of portion sales for given menu item to total portion sales for all menu items i.e.
	Popularity index =	Portion sales for item	x 100
			Total portion sales for all menu items

Note : 2.	Portion Forecast is the total sale forecast by the chef multipied by the popularity index of the the given menu item as calculated in Columb - C of the above table.

Note : 3.	The chef is expecting the 10% rise in sales of the item, so we multipied the portion forecast by 10% as shown in Columb - D of the above table.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

The rising popularity of bubble and squeak as a breakfast item on the menu has resulted...

The rising popularity of bubble and squeak as a breakfast item on the menu has resulted in a steady demand for peas. Over the course of the past week, 228 customers have ordered the hearty breakfast containing a cup of English peas. It costs $0.04 to hold a cup of peas in inventory for a year and $3 to place an order. It takes two weeks to ship a container from England loaded with peas. Assume that each year has...

Q] The historical actual sales of an item purchased by a factory is given below. What...

Q] The historical actual sales of an item purchased by a factory is given below. What would have been the forecast had the manager a) used 3 period moving average to make the forecast in the past, and b) used exponential smoothing with alpha=0.2 to make the forecast in the past. Show all calculations. PLEASE PROVIDE TABULATED EXCEL CALCULATIONS. Month Actual Sales 1 45 2 48 3 37 4 40 5 43 6 37 7 46 8 48 9 42...

A company has the following history of sales for an item. Month Sales Volume Jan. ...

A company has the following history of sales for an item. Month Sales Volume Jan. 120 Feb. 90 Mar. 100 Apr. 75 May 110 Jun. 50 Jul. 75 Aug. 130 Sep. 110 Oct. 90 Compute the monthly demand forecast for April through November using a 3-month moving average. Compute the monthly demand forecast for June through November using a 5-month moving average. Compute the monthly demand forecast for April through November...

The quarterly sales (number of books sold) over the past 3 years are as shown below....

The quarterly sales (number of books sold) over the past 3 years are as shown below. Year Quarter Period Sales 1 1 1 1700 1 2 2 1000 1 3 3 2700 1 4 4 2500 2 1 5 1800 2 2 6 900 2 3 7 2900 2 4 8 2400 3 1 9 1800 3 2 10 1100 3 3 11 2900 3 4 12 2600 Construct a time series plot for this data. Paste the time series...

Below is a potential menu for the stadium’s concession stand. ITEM Selling Price Variable Cost Percent...

Below is a potential menu for the stadium’s concession stand. ITEM Selling Price Variable Cost Percent of Revenue Hot Dog $3.00 $2.00 15% Hamburger $4.00 $2.50 15% French Fries $4.50 $3.25 20% Pizza $5.00 $4.00 5% Nachos $4.25 $2.75 10% Pretzel $2.75 $2.00 15% Soda/Water $3.00 $1.00 25% how do you calculate the Fixed cost for each item?

Location is known to affect the number, of a particular item, sold by an automobile dealer....

Location is known to affect the number, of a particular item, sold by an automobile dealer. Two different locations, A and B, are selected on an experimental basis. Location A was observed for 18 days and location B was observed for 13 days. The number of the particular items sold per day was recorded for each location. On average, location A sold 39 of these items with a sample standard deviation of 8 and location B sold 49 of these...

Write a menu driven C++ program that prints the day number of the year , given...

Write a menu driven C++ program that prints the day number of the year , given the date in the form of month-day-year. For example , if the input is 1-1-2006 , then the day number is 1. If the input is 12-25- 2006 , the day number is 359. The program should check for a leap year. A year is leap if it is divisible by 4 but not divisible by 100. For example , 1992 , and 2008...

A recreational drug combination that is gaining popularity is ketamine and heroin. Given the data below,...

A recreational drug combination that is gaining popularity is ketamine and heroin. Given the data below, describe a solid phase extraction procedure for separating the two components. Ketamine, pKa= 7.45 Heroin, pKa= 9.1 It is relevant to know that both molecules are relatively non-polar, with ketamine being the less polar of the two. A complete answer will include: identification of the stationary phase relative polarity, all solvents, and the conditions for 1. loading the sample and 2. extracting the two...

Given the data provided below, calculate the control limits (X-bar and r-chart, Capability Index, create a...

Given the data provided below, calculate the control limits (X-bar and r-chart, Capability Index, create a control chart, and calculate the percentage of units that are expected to be out of spec (z-value). Please show all work for how all calculations were computed. Filling Line Checks - ounces Specification: 12 ounces min; max - 15 ounces Sample Sample Times Number 1pm 2pm 3pm 4pm 5pm 6pm 7pm 8pm 1 12.5 12.4 12.4 12.8 13 12.8 12.8 13 2 12.4 12.4...

The accompanying table gives the number of a popular household item sold by a store over...

The accompanying table gives the number of a popular household item sold by a store over 30 consecutive days 28 32 46 33 39 40 47 53 56 40 44 21 38 62 57 48 36 22 53 34 24 29 32 38 18 37 46 36 37 45 1. Construct a group frequency distribution of the above data comprising 6 classes of equal width. Let 15 be the lower limit of the initial class 2. Use the grouped data...

Subjects