Question

In: Accounting

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.

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...
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...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT