# Project #95199 - Six Month Budget

Classwork: Based on the last year’s figures develop a dollar plan forecasts for (ALREADY COMPLETED)

1. Spring-Summer season: (Worksheet-1: Spring Summer)

• Use S-S ratio method for stock planning.

• Calculate average retail stock and stock turnover after calculating BOMs and EOMs

• Dollar plan should be complete with LY (last year) figures and PL (Planned) figures.

• Use Paste Link option to link estimate figures to the  dollar plan (as demonstrated in class)

• Use appropriate month labels for the season.

• Add another worksheet, rename it as ‘Fall winter) and use that to complete homework exercise given below

• Homework submission should include 3 worksheets: estimates, fall-winter and spring-summer.

Homework: Based on the last year’s figures develop a dollar plan forecasts for

1. Fall-winter season: (Worksheet-2: Fall-Winter)

• Use S-S ratio method for stock planning.

• Calculate average retail stock and stock turnover after calculating BOMs and EOMs

• Dollar plan should be complete with LY (last year) figures and PL (Planned) figures.

• Use Paste Link option to link estimate figures to the  dollar plan (as demonstrated in class)

• Use appropriate month labels for the season.

Review all concepts in Chapter 8 before developing the plan- you will need a good understanding of the formulas for correct estimates.

Classwork:

Correct Figures linked to the main plan: 2 pts

Correct figures/embedded formulas including planned purchases @ retail and @ cost: 5 pts

Correct formatting: 3 pts

Homework:

Correct Figures linked to the main plan: 2 pts

Correct figures/embedded formulas including planned purchases @ retail and @ cost: 5 pts

Correct formatting: 3 pts

 Subject Mathematics Due By (Pacific Time) 11/21/2015 11:30 pm
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews