Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using last year's figures for a hardware department, plan a 12% increase for next year, maintaining the same monthly sales percentages, the same stock-to-stock ratios,

image text in transcribed

image text in transcribed

image text in transcribed

Using last year's figures for a hardware department, plan a 12% increase for next year, maintaining the same monthly sales percentages, the same stock-to-stock ratios, and the same markdown percents as last year. A six-month plan is completed below. Last year's spring season figures were as follows: Markdowns $4,560 $2,361 $6,438 $6,892 $4,650 $2,005 OM Stocks $97,800 $124,590 $115,410 $103,830 $102,280 $91,730 $104,400 Sales Volume $42,700 $55,600 $51,700 $63,100 $45,500 $33,000 February March April May June July August Last year's departmental markup was 48%. Analyze the information below and answer the questions underneath the plan. Departmental Name: No. IThie Yoar) n/a (Last Yoar). n/a Workroom Cost Cash Discount % Shortage/Overage % Average Stock Season Stock Turnover SIX-MONTH n/a n/a MERCHANDISING PLAN n/a n/a $118,439 $105,720 Departmental Markup 2.76 2.76 Actual Last Year Plan Overall Markdown% 9.23% 9.23% 48.0% 48.0% Spring 20 Fall 20 Sales Percent Each Month May June Dec. Feb. Mar. Apr. Oct 18% July Season Total Aug 15% 42,700 Sept Nov. Jan. 100% 291,600 326,592 22% 16% 11% 19% 33,000 36,960 55,600 62,272 45,500 50,960 63,100 Last Year 51,700 57,904 47,824 70,672 Sales Plan $ Revised Actual 124,590 139,489 97,800 109,517 115,410 102,280 114,660 91,730 102,749 103,830 116,609 Last Year Retail 129, 126 Stock Plan (OM) $ Revised Actual 6,438 7,209 12.45% 12.45% 4,560 5,108 10.68% 10.68% 2,361 6,892 7,717 26,906 30,136 4,650 5,208 10.22% 10.22% 2,005 2,247 Last Year Plan (dollars) 2,647 4.25% 4.25% Markdowns 10.92% 6.08% Last Year Monthly % 10.92% 6.08% Plan Monthly % Actual Dollars 325,106 364,131 74,050 82,904 48,781 54,556 46,558 52,596 68,442 76,440 47,675 53,378 39,600 44,257 Last Year Plan Retail Purchases Revised Actual 35,589.84 39,748.80 52.0% 38,506.00 Plan 43,110.08 25,366.12 28,369.12 24,210.16 27,349.92 24,791.00 27,756.56 169,055.12 189,348.12 20,592.00 23,013.64 Last Year Cost Purchases Revised Actual EOM 124,590 139,489 102,280 114,660 91,730 102,749 35.8% 115,410 103,830 104,400 116,920 Last Year Stock 129,126 116,609 Plan July 31 & Jan 31 Revised Actual SRESteck Last Year 2.29 2.24 2.23 1.65 2.25 2.78 Sales 1.65 2.29 2.24 2.23 2.25 2.78 Plan Patio Merchandise Manager Department Buyer Controller What is the sum of the sales percentages from February to July? Explain, in words, how to calculate the sales percentage for each month. Which month during this season had the highest sales last year? The stock-to-sales ratio for the month of May was 1.65 last year. Explain, in words, what this means. Explain how to calculate last year's markdown percentage for the entire season. Then, calculate this percentage Compare the result from #5 to last year's markdown percentage for May. Provide one possible scenario that would cause this. Explain how to calculate the retail purchases for each month. The EOM for the month of March is the same as the BOM for the month of Using last year's figures for a hardware department, plan a 12% increase for next year, maintaining the same monthly sales percentages, the same stock-to-stock ratios, and the same markdown percents as last year. A six-month plan is completed below. Last year's spring season figures were as follows: Markdowns $4,560 $2,361 $6,438 $6,892 $4,650 $2,005 OM Stocks $97,800 $124,590 $115,410 $103,830 $102,280 $91,730 $104,400 Sales Volume $42,700 $55,600 $51,700 $63,100 $45,500 $33,000 February March April May June July August Last year's departmental markup was 48%. Analyze the information below and answer the questions underneath the plan. Departmental Name: No. IThie Yoar) n/a (Last Yoar). n/a Workroom Cost Cash Discount % Shortage/Overage % Average Stock Season Stock Turnover SIX-MONTH n/a n/a MERCHANDISING PLAN n/a n/a $118,439 $105,720 Departmental Markup 2.76 2.76 Actual Last Year Plan Overall Markdown% 9.23% 9.23% 48.0% 48.0% Spring 20 Fall 20 Sales Percent Each Month May June Dec. Feb. Mar. Apr. Oct 18% July Season Total Aug 15% 42,700 Sept Nov. Jan. 100% 291,600 326,592 22% 16% 11% 19% 33,000 36,960 55,600 62,272 45,500 50,960 63,100 Last Year 51,700 57,904 47,824 70,672 Sales Plan $ Revised Actual 124,590 139,489 97,800 109,517 115,410 102,280 114,660 91,730 102,749 103,830 116,609 Last Year Retail 129, 126 Stock Plan (OM) $ Revised Actual 6,438 7,209 12.45% 12.45% 4,560 5,108 10.68% 10.68% 2,361 6,892 7,717 26,906 30,136 4,650 5,208 10.22% 10.22% 2,005 2,247 Last Year Plan (dollars) 2,647 4.25% 4.25% Markdowns 10.92% 6.08% Last Year Monthly % 10.92% 6.08% Plan Monthly % Actual Dollars 325,106 364,131 74,050 82,904 48,781 54,556 46,558 52,596 68,442 76,440 47,675 53,378 39,600 44,257 Last Year Plan Retail Purchases Revised Actual 35,589.84 39,748.80 52.0% 38,506.00 Plan 43,110.08 25,366.12 28,369.12 24,210.16 27,349.92 24,791.00 27,756.56 169,055.12 189,348.12 20,592.00 23,013.64 Last Year Cost Purchases Revised Actual EOM 124,590 139,489 102,280 114,660 91,730 102,749 35.8% 115,410 103,830 104,400 116,920 Last Year Stock 129,126 116,609 Plan July 31 & Jan 31 Revised Actual SRESteck Last Year 2.29 2.24 2.23 1.65 2.25 2.78 Sales 1.65 2.29 2.24 2.23 2.25 2.78 Plan Patio Merchandise Manager Department Buyer Controller What is the sum of the sales percentages from February to July? Explain, in words, how to calculate the sales percentage for each month. Which month during this season had the highest sales last year? The stock-to-sales ratio for the month of May was 1.65 last year. Explain, in words, what this means. Explain how to calculate last year's markdown percentage for the entire season. Then, calculate this percentage Compare the result from #5 to last year's markdown percentage for May. Provide one possible scenario that would cause this. Explain how to calculate the retail purchases for each month. The EOM for the month of March is the same as the BOM for the month of

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Health And Safety Environment And Quality Audits A Risk-based Approach

Authors: Stephen Asbury

2nd Edition

0415508118, 978-0415508117

More Books

Students also viewed these Accounting questions