Set up the entire 6 month plan using the following 6 month plan with the following information
Question:
Set up the entire 6 month plan using the following 6 month plan with the following information and Use formula’s to calculate the remaining values:
1. Sales PLAN: $333,333
2. monthly sales PLAN percentages: 13%, 15%, 15%, 16%, 24%, 17%, fill in monthly PLAN sales $ and total
3. Jan EOM PLAN $152,600
4. Monthly Reductions PLAN are 2.54%, 2.48%, 2.19%, 1.8%, 1.65%, 3.22%, fill in PLAN monthly and total reduction $ and the total %
5. S-S ratio PLAN: 3.68, 4.2, 3.84, 2.8, 3, 3.96
6. Fill in the planned purchases
7. ACTUAL sales variance for August – October are -13.23%, -9.76%, -6%, Fill in P1-P3 ACTUAL sales $
8. Forecast P4-P6 ACTUAL sales $ and variance to plan % with totals (based on your forecast )
9. Complete the BOM & EOM Plan
10. Complete the WEEKLY SALES PLAN $ for each month.
Economics Principles and Policy
ISBN: 978-0538453653
12th edition
Authors: William J. Baumol, Alan S. Blinder