Question: PLEASE JUST DO THE BONUS Complete the following six month merchandise plan using the criteria below: 1.Sales PLAN for the season: $777,777 -monthly sales PLAN

PLEASE JUST DO THE BONUS

Complete the following six month merchandise plan using the criteria below:

1.Sales PLAN for the season: $777,777

-monthly sales PLAN percentages: 13%, 15%, 15%, 16%, 24%, 17%,

fill in monthly PLAN sales $ and total PLAN $

2. P6 EOM PLAN $452,600

3.Monthly Reductions PLAN are 2.54%, 2.48%, 2.19%, 1.8%, 1.65%, 3.22%,

fill in PLAN monthly amounts AND TOTAL amount $ and total % (1)

4.S-S ratio PLAN: 3.68, 4.2, 3.84, 2.8, 3, 3.96

Fill in the planned purchases (1)

5.ACTUAL sales variance for P1-P3 are -13.23%, -9.76%, -6%,

Fill in P1-P3 ACTUAL sales $ (1)

Forecast P4-P6 ACTUAL sales $ (1)

Complete variance to plan % with TOTAL (based on your forecast (1)

6. Complete the BOM & EOM Plan (1)

BONUS: Complete the WEEKLY SALES PLAN $ for each month.(1)

Complete the following six month merchandise plan using the criteria below:

1.Sales PLAN for the season: $777,777

-monthly sales PLAN percentages: 13%, 15%, 15%, 16%, 24%, 17%,

fill in monthly PLAN sales $ and total PLAN $

2. P6 EOM PLAN $452,600

3.Monthly Reductions PLAN are 2.54%, 2.48%, 2.19%, 1.8%, 1.65%, 3.22%,

fill in PLAN monthly amounts AND TOTAL amount $ and total % (1)

4.S-S ratio PLAN: 3.68, 4.2, 3.84, 2.8, 3, 3.96

Fill in the planned purchases (1)

5.ACTUAL sales variance for P1-P3 are -13.23%, -9.76%, -6%,

Fill in P1-P3 ACTUAL sales $ (1)

Forecast P4-P6 ACTUAL sales $ (1)

Complete variance to plan % with TOTAL (based on your forecast (1)

6. Complete the BOM & EOM Plan (1)

BONUS: Complete the WEEKLY SALES PLAN $ for each month.(1)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!