Case: Lukes Diner has planned sales of $375, 000 for the upcoming spring/summer season. This is a 2% sales increase that could be attained this year due to the introduction and addition of a new beverage and snack line. The turnover goal for the season is 1.6. Reductions are planned to come in at 10%, Operating Expenses at 40%, cash discounts of 0.8% and a profit for the department of 4.5%. Please show your work. Total 100pts.

Month (Spring/Summer Season)	% of Seasons Sales	% of Seasons Reductions
February	12%	15%
March	14%	17%
April	17%	14%
May	21%	21%
June	24%	18%
July	12%	15%

Your task is to prepare a merchandise budget plan for Lukes Diner.

1. Total Seasonal Sales Forecast (2pts) = $____________________________________________
2. Total LY Seasons Sales (2pts) = $_________________________________________________

3. Monthly Sales Forecast Breakdown for the Season (6pts)

Month (Spring/Summer Season)	% of Season Sales	Monthly Sales Forecast TY
February	16
March	15
April	16
May	17
June	19
July	17

4. Total Season Reduction Forecast TY(2pts) = $_________________________________________

5. Forecast Reductions Breakdown for the Season (6pts)

Month (Spring/Summer Season)	% of Seasons Reductions	Monthly Reductions
February	15
March	18
April	15
May	20
June	16
July	16

6. Forecasted BOM (Beginning of the Month) for Season. Include any additional calculation steps for the BOM. (12pts)

Planned Sales by Month	Forecasted Sales	BOM calculation	BOM
February
March
April
May
June
July

7. Forecasted EOM (End of the Month) for the Season. Include calculation or reasoning for July EOM. (3pts)

Month	EOM
February
March
April
May
June
July

8. Forecasted Planned Purchases or Additions to Stock for the Season (13pts)

Month	Planned Purchases Calculation	Monthly Planned Purchases
February
March
April
May
June
July
Total Planned Purchases			$

1. Total Planned Purchases at Cost for Season (2pts) = $ _________________________________ Please include any calculations used here.

10. Transfer all the information above and fill in the merchandise plan below. Please add additional calculations as needed. (55pts)