Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I can't figure out this answer Exhibit 1 13 Month Open To Buy Total Store Next future months Dec Jan Feb Mar May June July

image text in transcribedimage text in transcribed

I can't figure out this answer

image text in transcribedimage text in transcribedimage text in transcribed
Exhibit 1 13 Month Open To Buy Total Store Next future months Dec Jan Feb Mar May June July Aug Sept Oct Nov Dec Jan 22,000 27,000 35,000 40,000 35,000 35,000 30,000 35,000 40,000 36,000 50,000 Projected Markdowns ,300 2,700 4,200 6,000 7,000 8,750 3,000 3,500 6,000 5,400 8.000 7,500 Forecasted BOM Inventory 85,000 105,000 20,000 120,000 120,000 110,000 115,000 115,000 Open to Buy @ Retail 50,000 35,000 20,300 29,700 59,200 61,000 42,000 43,750 23.000 43,500 51,400 73,000 2,500 25.00% Next future months Dec Jan Feb Mar Apr May June July Oct Nov Dec Jan Projected Sales 5,500 6,750 750 8,750 8,750 8,750 10,000 10,000 12,500 Projected Markdowns 825 675 1,500 1,750 2,188 750 875 500 350 2,000 ,875 Forecasted BOM Inventory 22,500 21,250 21,250 30,000 30,000 30,000 27,500 28,750 28,750 31,250 37,500 Open to Buy @ Retail 3,750 5,075 7,425 14,800 10,500 5,750 12,850 18,250 625 20.00% Next future months Dec Jan Feb Apr May July Aug Sept Oct Nov Projected Sales Dec Jan 4,400 5,400 7,000 8,000 7,000 7,000 6,000 7,000 8,000 7,200 8,000 Projected Markdowns 660 540 840 1,200 1,400 1,750 700 1,200 1,080 1,600 1,500 Forecasted BOM Inventory 18,000 17,000 17,000 21,000 24,000 24,000 24,000 22,000 23,000 23,00 25,000 30,00 19,000 Open to Buy @ Retail 7,000 4,060 5,940 11,840 8,400 8,750 4,600 8,700 9,200 500 Dresses Next future months Dec Jan Feb Mar Apr May July Sept Oct Nov Dec Jan 7,700 12,250 12,250 2,250 12,600 14,000 Projected Markdowns , 155 945 1,470 2,100 2,450 3,062 1,050 1,225 890 2,800 Forecasted BOM Inventory 31,500 2,625 29,750 29,750 42,000 40,250 33,250 Open to Buy @ Retail 43,750 12,250 7,105 20,720 14,700 15,312 8,050 15,225 16,100 17,990 25,550 875 10.00% Next future months Dec Jan Feb Mar Apr May July Sept Oct Nov Dec Projected Sales Jan 2,200 2,700 3,500 4,000 3,500 3,500 3.000 3,500 4,000 3,600 4,000 5,000 Projected Markdowns 330 270 700 875 300 600 800 750 Forecasted BOM Inventory 9,000 8,500 8,50 0,500 12,00 12,000 12,000 11,500 11,500 9.500 Open to Buy @ Retail 11,000 15,000 3.500 2,030 2,970 5.920 5,100 4.200 4,375 2,300 4.350 4.600 5,140 7,300 250Sweaters 5.00% Next future months Dec Jan Feb Mar Apr May June Projected Sales July Aug 1,100 Sept 1,350 Oct 1,750 Nov 2,000 1,750 Dec 1,750 Jan Projected Markdowns 1,500 1,750 2,000 165 1,800 135 210 2,000 300 2,500 350 438 150 Forecasted BOM Inventory 175 300 0 4,500 4,250 270 400 4,250 5,250 375 6,000 6,000 Open to Buy @ Retail 6,000 5,500 1,750 1,015 5,750 1,485 2,960 5,750 3.050 5,250 2,100 7,500 4,750 2,188 1,150 2,175 2,300 2,570 3,650 125 Accessories 5.00% Next future months Dec Jan Feb Mar Apr May June Projected Sales July Aug 1,100 1,350 Sept 1,750 Oct 2,000 Dec 1,750 Nov 1,750 Jan Projected Markdowns 1,500 1,750 165 2,000 135 1,800 210 2,000 300 350 2,500 438 150 Forecasted BOM Inventory 175 300 0 4,500 270 400 4,250 4,250 5,250 375 5,000 6,000 5,000 Open to Buy @ Retail 5,500 5,750 1,750 1,015 1,485 5,750 5,250 2,960 3,050 2,100 7,500 4,750 2,188 1,150 2,175 2,300 2,570 3,650 12512 13 Dec Jan Feb March Total 14 Tops $35,000 $20,300 $29,700 $59,200 $144,200 15 Bottoms 7,000 4,060 5,940 11,840 288,40 16 Dresses 12,250 7,105 10,395 20,720 $50,470 17 Jackets $3,500 $2,030 $2,970 $5,920 $64,890 18 Sweaters $1,750 $1,015 $1,485 $2,960 $8,695 19 Accessories $1,750 $1,015 $1,485 $2,960 $8,695 20 Total $61,250 $35,525 $51,975 $103,600 $252,350 21 22 23 2) Based on the required MMU in the decision criteria above, and the Planned Markdowns from the OTB 24 Plan (Exhibit 1), show how the Required IMU of 53.2% is calculated 25 26 IMU= MMU%+DISC% MMU%--> 46.00% 27 100%+DISC% 100% --> 1 0 28 21 - F. L:Lia o 104\\ P. .L:Lin inn inal Ir. L:Li a inn inal -L IA AI

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_2

Step: 3

blur-text-image_3

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

Financial Accounting with International Financial Reporting Standards

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

4th edition

1119504309, 1-119-50340-8, 9781119503408 , 978-1119504306

More Books

Students also viewed these Accounting questions