Question: Please do the weekly sales plan P1 13% P2 15% P3 15% P4 16% P5 24% P6 17% Season Total 100% Monthly % sales PLAN

Please do the weekly sales plan

P1 13% P2 15% P3 15% P4 16% P5 24% P6 17% Season Total 100% Monthly % sales PLAN Sales $ PLAN 101111 116667 116667 124444 186667 132222 777,777 Sales $ ACTUAL 87734.01 105280.3 109666.98 124444 194133.68 761414.29 140155. 32 6% -13.23% -9.76% -6% 0% 4% 2.1% % Variance to sales plan 2.54% 2.48% 2.19% 1.8% 1.65% 3.22% 2.31 Reduction % PLAN Reduction $ PLAN 2568 2893 2893 2240 3080 4258 17932 BOM $ Plan 372089 490001 448001 348443 560001 523599 EOM $ Plan 490001 448001 348443 560001 523599 452600 PLAN Purchase $ 221591 77560 20002 338242 153345 65481 876221 S-S Ratio PLAN 3.68 4.2 3.84 2.8 3 3.96 Weekly sales PLANS P1 13% P2 15% P3 15% P4 16% P5 24% P6 17% Season Total 100% Monthly % sales PLAN Sales $ PLAN 101111 116667 116667 124444 186667 132222 777,777 Sales $ ACTUAL 87734.01 105280.3 109666.98 124444 194133.68 761414.29 140155. 32 6% -13.23% -9.76% -6% 0% 4% 2.1% % Variance to sales plan 2.54% 2.48% 2.19% 1.8% 1.65% 3.22% 2.31 Reduction % PLAN Reduction $ PLAN 2568 2893 2893 2240 3080 4258 17932 BOM $ Plan 372089 490001 448001 348443 560001 523599 EOM $ Plan 490001 448001 348443 560001 523599 452600 PLAN Purchase $ 221591 77560 20002 338242 153345 65481 876221 S-S Ratio PLAN 3.68 4.2 3.84 2.8 3 3.96 Weekly sales PLANS

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!

When you create a class from which you will instantiate objects to store in an ArrayList, _________________. a. You must create a toString() method b. You must create a compare To () method c. You...

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

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

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%,...

Task DIRECTION: Based on the information below and the attached financial statements, prepare the following: 1. Value Added Tax Return -1st quarter 2021 2. Income Tax Return-Taxable year 2021 COMPANY...

***VIEW ONLINE THE EXCEL SHEET IS MORE VISIBLE*** A B C D E H 1 TY-PLAN F G Department Name and # LY-LAST YEAR Average Stock $ 147,913 Tumover Rate 222 Overall Markdown % 10.03% ACTUAL ACTUAL...

Please do the CPU Scheduler Problem in Problems 3 and 4. Please answer quickly. Due Soon! Thank you for your time. Requirements: Charts: 1. Language that will be used 2. Implementation plan...

The questions under the case study below which i need to be answered based on this study with reference to the case study: Which can be found in the Total Quality Management and Operational...

Answer the following Questions: 1. Tierra Company prepared the following preliminary forecast concerning Product X for 2017 assuming no expenditure for advertising: Selling price per unit P10 Unit...

Using the data and result of Exercise 61, calculate the pressure difference between the two areas of the aorta. (Blood density: = 1.05 x 103 kg/m3.) In exercise The blood flow speed through an aorta...

Shown below is a contingency table of probabilities for television viewing and income. What is the joint probability of "High Income and "Occasional" VIEWING FREQUENCY HIGH INCOME MIDDLE INCOME LOW...

Oxen Corporation incurs the following transactions. Net income from operations $ 1 0 0 , 0 0 0 Interest income from savings account 3 , 0 0 0 Long - term capital gain from sale of securities 1 0 , 0...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Technology. Access a videotape or webcast of a recently delivered speech on a business-related subject that is of interest to you. The library at your school is a good resource for videotaped...

Read the paragraph in Exercise 4 three times. Each time, vary your posture so you are (a) standing, head low, shoulders curved forward; (b) seated, almost reclining, with legs extended and crossed at...

Discuss the role an emcee plays in the success of an event. (Objective 7)