Hi, my math is (retail math) which I couldn't find, so I have to choose accounting, but I am not sure if it is right or wrong. If it is wrong, please tell me which correct course should I chose for these questions. Thanks

if you know the answer then, You have to answer all these 8 questions according to the chart above.

Please write everything step-by-step, because my teacher will ask me how I solve all these questions. Thank you, and please do it as soon as possible.

Thanks

I am trying to upload the example which will help you a lot but I do know why I can't upload it, so sorry you have to do it this way. If you know other way to uplode more than 1 pic at a time please tell me I will do that. Thanks

1) How did the Class perform last month compared to plan and last year? (1 mark) a. Be able to show the comparison in dollars and as a %

2) a. Did the buyer achieve the desired MMU and IMU for the last 12 months? (4 marks) b. Did the buyer achieve the desired IMU for this past month? (1 mark)

3) Is the buyer taking enough MD's? Are they taking too many? (1 mark) Show how the MD% was calculated for : a. This past month (1 mark) b. This past month last year (1 mark) c. All of last year (1 mark)

4) Does the buyer have enough, too much, or not enough inventory in this class. ( 2 marks)

5) a. Show how the 90 days freshness is calculated (1 mark) b. Assuming we want a 90 day freshness of at least 75%, are the goods in this class "fresh"? How might the freshness be affecting the sales performance? (2 marks)

6) Based only on the information on the Merchandise plan, and based on your answers to questions 3, 4, & 5 above, what do you think caused the sales performance last month? (3 marks) If the sales in the class exceeded the forecast, explain why you think this happened. If the sales were below the forecast, explain why you think this happened.

7) Based on: i. the current Inventory ii. the 90 Day Freshness iii. and last month's sales performance Do you think the buyer should be taking a different amount of MD's this month than the forecast? (same, more or less?) why? (4 marks)

8) With reference to the merchandise on hand and on order: (a) How much merchandise needs to be received in March, how much in April, and how much in May? (1 mark) (b) Is all of this merchandise already on order? (1 mark) (c) Is the buyer currently overbought in any month? (1 mark) (d) If the buyer is overbought in any particular month, how much existing orders (in Retail $) should be either cancelled or shifted to a future month? Which month? (2 marks) e) After shifting any existing orders to a future month, how much additional merchandise @ retail (if any) needs to be purchased for each of March, April and/or May, in order to follow the planned Open-to-buy? (3 marks)

INFLOW DEC JAN FEB METRICS Plan 16,260 10,471 2 204 L3M LEM L12M LSM LEM L12M L3M LEM 12M On order 0 sallea 11,320 23 179 43,090 Int @ Ret 19.019 33,038 59,631 MU 31.32% 65.795 68.21% Actual 12,530 5,511 Coat of purchase 64.995% 48.69%% 43.96% Int & Cost 7,357 11,287 18.944 MMU 59.95% 63.695 56.00% 5/ 32 Class Powered by Retall Orbit @ 3/29/2017 Merchandise Plan Demo Peters Mar 2017 Accessories Necklaces (3104) Gordon Peters Forecaste FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC JAN FEB sales [Ad] 54,156 FORECAST SUMMARY Last Month Sales [Adj] 54, 152 Forecast Balee 3,412 4.495 5,361 4,332 4,441 5,037 4.387 5,091 6,499 5.686 2,437 2,979 Markdowns 4,332 Forecast mkdne 217 303 390 477 520 260 217 173 433 563 173 Inflow 6,938 Forecast Inventory 9,851 11.972 13,752 11,721 11,953 13,151 12.722 13,236 16,228 13 651 8,425 8,836 Sales Forecast Inflow plan 6,370 6.578 3,720 5,041 6,159 4,868 5,118 8,256 4,355 1.023 3,454 4, 167 Feb va. LY 6.83% on order 60 Feb ve. Forecast -0.91% open to buy retall 6,310 6.578 3,720 5,041 6,159 4,868 5,118 8,256 4,355 1.023 3,454 4, 167 2017 YTD 5,359 open to buy coat 1,939 2 027 1,146 .553 1.898 1,500 1.577 2 544 1,342 315 1,064 1,284 2016 LY YTD 3,955 SALES TOTAL 2017 YTD from LY YTD 1,404 Diff. from prev. year 425 3,108 1.173 316 1,604 137 1,419 522 1.806 3,130 1.190 979 15,809 2017 YTD from LY YTD 35.50% 2016 2,526 3,108 4 202 4,752 4.276 4.864 1001 4.989 6,350 4 513 1,429 49,038 Markdowns 2017 2,95 L 2,408 5,353 Feb LY 1.367% Forecast aales 2.972 3,412 4.495 5,361 1,332 5.037 1.387 5.091 6.409 5.686 2.437 2,979 Feb TY 0.00%% MARKDOWNS 2016 YTD 7.74% 201 47 239 358 242 230 113 645 174 259 3.284 2017 YTD 38 2017 324 324 Freshne8 8 30 60 90 Forecast mkdna 173 217 303 390 477 520 ZEO 217 173 433 563 606 173 64.22 65.18 97.89 INVENTORY KPI Performance Plan Actual Diff. from prev. year 1,449 234 10.297 3,350 1,114 2,354 2,853 2.803 1,818 3,463 2 72 4,107 Turn 4.53 4.60 - 2016 10.02 7,522 8,997 10.297 14 117 8,572 12.146 11,541 11.496 12,330 12,525 13.569 7,653 GMROI 9.81 11,770 MMT 56.73 67.17 2017 6,073 9,231 Forecast BOM 9.043 9,851 11.972 13,752 11,721 11,953 13,151 12,722 13,236 16,228 13 651 8,425 8,836 Inventory Movement Feb YTO Transfers In Forecast a/8 3.04 2.89 2.66 Transfers out Actual 8/8 2.05 LAST CURRENT RTV retall 19 NET INFLOW 5 Retall 2016 4,138 4,758 9.573 RTV cost D 8,332 4.129 5,067 4.599 5,987 8,286 3.019 2,785 60.676 22 -2.94- Netall 2017 5,928 0 89 6,017 Inv. adjustments Cost 2016 1,552 1,703 3.080 2,173 1,257 1,692 1512 2.335 182 374 18,737 Cach Margin % Cost 2017 2,074 0 28 2,102 Cash margin [16M] 56 847% Forecast Inf retall 4,045 5,750 6.578 3,720 5,041 6,159 4,868 5,118 8,256 4,355 1,023 3,454 4,167 Forecast Inf coat 1.249 1,772 2.027 1,146 1.553 1.898 1,500 1.577 2.544 1.342 315 1,064 1,284 Inv devlation retall 2,970 620 Inv deviation cost 917 191 On order ratall 60 On order coat 24 D Open to buy retall 7.015 6,310 6.578 3,720 5,041 6,159 4,868 5,118 8,256 4,355 1.023 3,454 4,167 Open to buy cost 2,165 1,939 2 027 1,146 1,553 1,898 1,500 1.57 2,544 1,342 315 1,054 1,284 Cum. margin [4M] 10,903 12,543 15,011 19,226 22,005 24,548 28,085 30.895 33,442 38,599 43.970 45,343 47.033