Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions