HTM $341$ Name:

EX$7$

$1.$ Use the following sales history to calculate the popularity index for Oct. $5($Friday$).$

Sales History $-$ Portions Sold For the Period Oct $1-7$

Weather Fair Snow Cold Fair Fair Fair Cold Popularity Index, $($Oct $5)$

Day M T W H F S S

Date $1234567$

Item

NY Strip Steak $16151317222314$

Pork Ribs $1110912131411$

Manicotti $7586789$

Chicken Breasts $14131512121314$

Tea$-$Smoked Salmon $13141516151312$

Totals

$2.$ Forecast the portion sales for next Friday, Oct. $12.$

a$.$ If we assume the market and weather condition will be the same as this week, which of the following will be a better forecast for next Friday$$s portion sales? This Friday$$s portion sales or the average of this week$$s portion sales?

b$.$ There will be a trade show on Oct. $12.$ The sales usually increase by $10\%$ during a trade show period. What is the adjusted forecast of total portion sales for Oct. $12?$ Round your answer to nearest integer.

What is the portion forecast of each menu items on Oct. $12$ using the popularity index based on Oct. $5?.$ Write your answers in the Portion Forecast column. Round your answer to nearest integer.

Volume Forecast

Menu Item Adjusted Forecast x P$.$I. $=$ Portion Forecast Adjusted Portion Forecast

NY Strip Steak

Pork Ribs

Manicotti

Chicken Breasts

Tea$-$Smoked Salmon

Totals

d$.$ A tradeshow attendee phoned in and ordered $3$ pork ribs for take$-$outs on Oct. $12.$ No information for other menu items. What are the adjusted portion forecasts on Oct. $12?$ Write your answers in the Adjusted Portion Forecast column.