show working for imu and otb cost

PART 1: Markdowns and IMU% (10pts): With the following figures, calculate the new IMU% for the department. Your IMU% will be used in various parts of this assignment (For help, review the lecture notes and HW from Chapter 5). Complete this calculation in sheet lof your excel template Planned Sales S175,000 Total Markdowns ? (see below) Profit $25,000 Cash Discounts 8.50% Expenses 35.57% Employee Discounts $1,500 Shortages $750 Determine the total markdowns and the markdown persent for woman's department this month If actual sales were $100,000 and the buyer took the following markdowns. Quantity Original Price Markdown Price 112 tops 523 $14 $19 213 dresses $45 $29 260 jackets $30 $22 54 Athletic jog sets $49 528 PART II: OPEN-TO-BUY Budget (10pts): In order to place an order for the upcoming spring season, next you will need to calculate your open to buy for the department, Complete an OTB spreadsheet using the given figures below and the Markdowns and Planned sales given in Part 1. Once completed, you will use the available OTB at cost dollar amount as the budget for this wholesale buy with your vendor. Use the IMU% calculated in Part 1. (For help. review the lecture notes from Chapter 9). Complete this calculation in sheet 1 of your excel template. October 31- stock 5387,500 November 30 stock S305,300 Os Order $7.900 98 pants $35