I need help with Part 2,3 4 5

Part 1Buyer's Worksheet, 25 Points

a) Using the attached spreadsheet, calculate the number of units you need in basic and fashion colors to maintain departmental markup goals with respect to annual purchase plans.

Part 2Purchase Order, 30 Points

a) Complete the Purchase Order portion of the spreadsheet, using the color breakdowns, cost by style, and unit retail that you calculated on the Buyer's Worksheet.

b) Include any information for vendor terms, ship dates, and/or shipping points.

c) Enter the purchase from the Buyer's Worksheet, and demonstrate how the purchase will be marked up to meet to the departments markup percentage goals.

d) Calculate the cash discount you'll receive if you pay your bills according to the given terms.

e) Evaluate the purchase and the terms negotiated. Is the purchase favorable to the buyer or vendor?

f) Recalculate your markup, applying a 10 percent discount off the cost of all goods.

g) Use the following information to complete the Purchase Order spreadsheet.

Purchase Order #12392

Department #530, Contemporary Knits

Vendor: Pop Tops, 1234 E. 9th Avenue, Los Angeles CA, 90084

Ship To: AAU Retail Stores, 180 New Montgomery, San Francisco CA, 94105

Date of Purchase Order: November 1, 2012

Ship Date: February 25, 2013

Part 3Additional Calculations, 10 Points

a) Using the information from your purchase order, calculate the amount you will submit to the vendor for purchase order #12392, assuming that the vendor prepaid the shipping amount of $158.00.

Calculate a 10 percent discount on the order. Give the new total cost.

Based on discount, calculate the revised markup for the order, before the terms are applied.

Calculate the cash discount to be received if the order is received March 10th and paid April 10th.

What are the freight costs for order #12392?

Determine the amount to be paid to the vendor for order #12392.

Part 4Markdowns and Maintained Markup, 25 Points

a) Using the Style Analysis spreadsheet, complete the Total Sales, Markdown Dollars, and Sell-Through Percentages for each color. Then calculate and answer the following:

Calculate Total Sales for style #71553.

Calculate Total Markdown Dollars for style #71553.

Calculate Total Markdown Percentage and Maintained Markup Percentage.

Part 5Conclusion, 10 Points

a) Offer your analysis of the plan, purchase, and sales for style #71553.

How was the buy plan successful in terms of individual color?

What could you negotiate with the vendor to improve profitability?

How could you have improved sales at regular price to reduce markdowns?

Note : Terms are 3/10-35X with a 3% cash discount