Login

Complete the following six month merchandise plan using the criteria below use the following...

60.1K

Verified Solution

Question

Accounting

Complete the following six month merchandise plan using the criteria below use the following chart or if you chose to use excel, make sure to format it to one page $($ or one mark deduction $)$ with title on spreadsheet.

$1 .$ Sales PLAN for the season: $ $777, 777$ with the following monthly sales PLAN percentages: $13 %, 15 %, 15 %, 16 %, 24 %, 17 %,$

fill in monthly PLAN sales $ and total PLAN $

$2 .$ P $6$ EOM PLAN $ $452, 600$

$3 .$ Monthly Reductions PLAN are $12.54 %, 12.48 %, 12.19 %, 11.8 %, 11.65 %, 13.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 P $1 -$ P $3$ are $- 13.23 %, - 9.76 %, - 6 %,$

Fill in P $1 -$ P $3$ ACTUAL sales $ $(1)$

Forecast P $4 -$ P $6$ ACTUAL sales $ $(1)$

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

$6 .$ Complete the BOM & EOM Plan $(1)$

$7 .$ Complete average inventory for the season $(6$ months $) (1)$

$8 .$ complete inventory turnover for the season $(1)$

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

Answer & Explanation Solved by verified expert

answer-section

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Other questions asked by students

Chemistry

1.2K views

Calculate the pH of each of the solutions and the change in pH to 0.01 pH...

Chemistry

1.2K views

Compare and contrast Native -PAGE, SDS-PAGE, size-exclusion chromatography, and affinity chromatography, ion exchange chromatography. How are components...

Physics

1.2K views

1) a car battery is rated at 90 amphour. How much charge is available in the...

Electrical Engineering

1.2K views

write a matlab code of current distribution in wire antenna using method of moments (pocklington)

Psychology

1.2K views

The NASW Code of Ethics makes a number of statements about social workersâ€™ responsibility to study,...

Accounting

1.2K views

Please provide your classmates with an example of one item for each of the three sections...

Geometry

1.2K views

1945 1950 1955 1960 1965 1970 1975 1980 1985 1990 1995 2000 2005 2011 48384...

Accounting

1.2K views

The amount the taxpayers qualify to claim for the Earned Income Tax Credit (EITC) is

Accounting

1.2K views

Pls enter answers as formulas for Excel. You have just graduated from college, and...

Finance

1.2K views

#36 with these ratios listed in picture 3 Cash Accounts receivable Inventory Total...

Accounting

1.2K views

Combat Fire, Inc, manufactures steel cylinders and nozzles for two models of fire extinguishers: (1)...

Accounting

1.2K views

Kristina and Sameera are partners. Kristina is allocated 60% of profits and losses and has...

1 Answer

$0.99

~~$1.99~~

(Save $1 )

One time Pay

No Ads
Answer to 1 Question
Get free Zin AI - 50 Thousand Words per Month

Best

Unlimited

$4.99*

~~$9.99~~

(Save $5 )

Billed Monthly

No Ads
Answers to Unlimited Questions
Get free Zin AI - 3 Million Words per Month

*First month only

Free

$0

Get this answer for free!
Sign up now to unlock the answer instantly

You can see the logs in the Dashboard.

Sign In

Don't have an account? Sign Up