Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. complete the following six month merchandise plan

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

70.2K

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. P6 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 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)
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
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