Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 1: Buy plan 25 pts The knit department will be running an ad on short sleeve cotton tee shirts. The buyer estimates she will

Part 1: Buy plan 25 pts
The knit department will be running an ad on short sleeve cotton tee shirts. The buyer estimates she
will need 1,200 units for her ten stores. She must maintain the department mark up goal of 52%.
Her past selling indicates the following % of selling for each color:
Color %
White 30%
Black 20%
Red 15%
Navy 15%
Gree 10%
Pink 10%
Total 100%
She has noticed that white tee shirt sales have been dropping off, she would like to increase her sales in black
and red. However, the cost is higher in the dark colors. Will she be able to maintain her department's plan
markup of 52% if she changes her purchase to plan for 23% of her sales in black and 17% of her sales in red,
lowering her white to 25% of sales? She is going to retail all colors at $20.00.
What is the most she will be able to pay for the assorted colors and maintain her markup plan?
The same percent by color will be maintained.
Cost price: Color Unit price ea
White $9.00
Black $9.80
Asst. Color ???
Using the chart below, plan for a purchase of 1,200 units with new sales plan percents by color.
1. Units by color
2. Calculate total cost dollars by color and department total
3. Calculate total retail dollars by color and department total
4. Calculate markup % by color
5. Calculate markup % by total department
Dept Goals
and/or plan Units Cost EA Cost $ Total Retail EA Retail $ Total MU% C%
White
Black
Red
Navy Blue
Green
Pink
Dept Goal
Total 0 $0.00 $0.00 54% 0%
Yes, she would maintain markup
Part 2: Purchase Order: 30 pts
Use the purchase order below to place an order for the tee shirt promotion.
AAU Retail Store Purchase Order
79 New Montgomery St P.O. NUMBER
San Francisco, CA 94105
Vendor Name and Address Ship To
PURCHASE ORDERS Department Department # Start Ship Cancellation FOB Terms
PO Date
Style Number Color Units * Unit Cost Total Cost Unit Retail Total Retail Markup %
TOTALS 0 $0.00 $0.00
Buyer Signature DMM Signature
*Purchase orders can also be divided by specific quantities by store location. orders can also be divided by specific quantities by store location.
Part 3: Additional calculations: 10 points
Using the information from your purchase order you will calculate the amount you will submit to vendor for purchase order #12392, the vendor prepaid the shipping amount of $158.00
The freights terms are FOB Factory
1. Calculate a discount of 10% on the order, which you negotiated on the first cost.
New Total Cost:______________________
2. Calculate the revised markup percent for the order before payment terms are applied.
Revised Markup percent based on discount:________________________
3. Calculate the cash discount to be received if the order is received on March 10th and paid on April 10th. _____________________________________
With terms of 8/10EOM
4. How much will the freight amount be for order #12392?______________________________
5. Determine the amount to be paid to the vendor for order #12392______________________
__________________________________________________________________________________
Part 4: Markdowns and Maintained Markup 25 points
SKU Cost $ Retail $ IMU% Unit Buy Initital Cost Initial Retail Unit Sales Dollar sales Sell Through Units to be Units sold at Dollar Sales Markdown $ Balance on Dollar Sales Markdown $ Balance on Dollar Sales Markdown $ Total Dollar Total dollar
Style #71553 $ Total $ Total Full Price at full price % Markdown 30% off at 30% off at 30% off Hand at 50% off at 50% off Hand at 70% off at 70% off Sales Markdown
White $20.00 36 152 112 10
Black $20.00 24 128 124 24
Red $20.00 18 86 100 20
Navy $20.00 16 78 86 38
Green $20.00 10 42 68 20
Pink $20.00 13 46 61 21
Total
Part 5: Conclusion 10 pts.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions