Sales Price and Quality Metrics for Product Decisions

Sales Price Legend Great Good Below Avg Quality Legend (Colors) Great Very Good Good Information From Contract Bids With Clients - Enter Data Here Delivery Materials Decisio Turn # Product Customer Quantity Sales Price Material Required Quality See Legend Above # Wks To Deliver (Due / Lead Time) Projected Lead Time (Weeks) Required # Pcs Material

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Lower REP 1 Source NO! ons Machine Purchase Decisions HR Sales Pressing Dyeing Embroidery Maximum Material Quality Heat Transfer Customer Service Training? Shipping Training? Revenue / Contract Value Average Sales Price

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

ENTER CURRENT MACHINE LEVEL HERE --> 1 1 Product Material # Pieces Cutting Sewing Pressing Bermuda Shorts $ 12.00 Khaki 2 Err:504 Err:504 $0.00 Boxer Shorts $ 15.00 Silk 1 Err:504 Err:504 $0.00 Chiffon Dress $ 50.00 Silk 4 Err:504 Err:504 $0.15 Coaches Jacket $ 30.00 Nylon 3 Err:504 Err:504 $0.00 Colored T-Shirts $ 8.00 Cotton 2 Err:504 Err:504 $0.15 Denim Jacket $ 35.00 Denim 3 Err:504 Err:504 $0.00 Designer Jeans $ 30.00 Denim 2 Err:504 Err:504 $0.00 Dress Socks $ 2.00 Cotton 1 Err:504 Err:504 $0.00 Graphic T-Shirt $ 10.00 Cotton 1 Err:504 Err:504 $0.15 Heavy Socks $ 3.00 Wool 1 Err:504 Err:504 $0.15 Hunting Pants $ 30.00 Wool 3 Err:504 Err:504 $0.15 Low Rise Jeans $ 25.00 Denim 2 Err:504 Err:504 $0.00 Plain T-Shirts $ 5.00 Cotton 2 Err:504 Err:504 $0.15 Polo Shirts $ 15.00 Cotton 3 Err:504 Err:504 $0.15 Safari Jacket $ 40.00 Khaki 4 Err:504 Err:504 $0.15 Slacks $ 20.00 Khaki 2 Err:504 Err:504 $0.15 Sports Pants $ 15.00 Nylon 2 Err:504 Err:504 $0.00 Sports Shorts $ 10.00 Nylon 1 Err:504 Err:504 $0.00 Sweaters $ 20.00 Wool 2 Err:504 Err:504 $0.15 Tie $ 20.00 Silk 1 Err:504 Err:504 $0.15 White Socks $ 1.00 Cotton 1 Err:504 Err:504 $0.00 Windbreaker $ 20.00 Nylon 3 Err:504 Err:504 $0.00 Production ENTER MACHINE LEVEL HERE -If no machine highlighted in this sh Cutter, Sewer, and Packer a Average Sale Price / 1 Unit

1 Dyeing Heat Transfer Embroidery Packing $0.15 $0.00 $0.00 Err:504 Err:504 $0.00 $0.00 $0.00 Err:504 Err:504 $0.15 $0.00 $0.00 Err:504 Err:504 $0.00 $0.25 $0.00 Err:504 Err:504 $0.15 $0.00 $0.00 Err:504 Err:504 $0.15 $0.00 $0.30 Err:504 Err:504 $0.15 $0.00 $0.30 Err:504 Err:504 $0.15 $0.00 $0.00 Err:504 Err:504 $0.15 $0.25 $0.00 Err:504 Err:504 $0.00 $0.00 $0.00 Err:504 Err:504 $0.15 $0.00 $0.00 Err:504 Err:504 $0.15 $0.00 $0.00 Err:504 Err:504 $0.00 $0.00 $0.00 Err:504 Err:504 $0.15 $0.00 $0.30 Err:504 Err:504 $0.00 $0.00 $0.30 Err:504 Err:504 $0.00 $0.00 $0.00 Err:504 Err:504 $0.00 $0.00 $0.00 Err:504 Err:504 $0.00 $0.00 $0.00 Err:504 Err:504 $0.15 $0.00 $0.00 Err:504 Err:504 $0.00 $0.00 $0.00 Err:504 Err:504 $0.00 $0.00 $0.00 Err:504 Err:504 $0.00 $0.25 $0.00 Err:504 Err:504 n Machinery and Sequence e purchased yet, the table defaults to level 1, but cell will be heet. Verify on the KPI Tracker sheet . always present and always start at level 1. Total Production Cost

Where Placed Potential Hire Weekly Salary Abdul Anwar $ 400 Adrian Garcia $ 340 Aiko Chan $ 500 Aleksander Batalev $ 340 Ali Ismail $ 830 Barrett Martin $ 400 Ben Porter $ 420 Brian Thompson $ 420 Brijo Malik $ 700 Calvin Escobar $ 300 Chip Stafford $ 420 Chris Miller $ 340 Darrel Smith $ 290 David Gao $ 440 Derek Kaiser $ 450 Dewie Frondel $ 540 Drew Rhoades $ 910 Francis Lopez $ 350 Gareth Holmes $ 270 Irwinn Gruppe $ 490 Joe Lopez $ 340 Jonathan Cincade $ 490 Joshua Moore $ 320 Larry Martin $ 340 Marco Andreini $ 320 Mike Peterson $ 420 Ming Zhou $ 450 Normand Hoaglin $ 320 Oliver Stuckey $ 420 Rafferty Lewington $ 260 Use this sheet to keep track of hiring and training. Cells that are highlighted are those wher track of the total number of trainings conducted in each area of the operation, also highligh NOTE 1: If you hire someone you must take two actions: 1. Enter "a" in the "Hired?" colum NOTE 2: In "Training Record - Update Each Time Trained" columns you will enter the numb you train that person, then 2 the second time. You will update that person's training each Hired? (Enter "a" if yes) Receiving (Enter "a" if yes) Shipping (Enter "a" if yes) Machine Operations (Enter "a" if yes)

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Robert Johnson $ 400 Rolph Jaworski $ 420 Sahil Siddhartha $ 400 Sandeep Patel $ 410 Shea Spradley $ 530 Skippy Winters $ 300 Stasu Malinowski $ 330 Steven Giarman $ 300 Tedmund Guzzetti $ 440 Thomas Potter $ 430 Tom OLeary $ 950 Vishal Prakash $ 350 0 0 0 Weekly Capacity With Curre Base Capacity Client 1 1 0 100 75 Production 1 1 0 Sorting 100 350 75 Packing 75 1000 500 Sorting Shipping Average Costs of Labor Per Deliverd Product - Current Run $0.00 $0.00 Capacity Per Additional Person Additional capacity per training Sorting (Pieces of Material) Shipping (Pounds)

Standard Costs of Labor Per Deliverd Product - Historical $0.00 #DIV/0!

Labor / Salary Receiving Shipping re data can be entered. Typing the letter "a" in the highligted cells in the main table below ("Hire hted indicating a data-entry cell. mn for that person, and, 2. Enter "a" in the appropriate "Where Placed" column. The letter mu ber of trainings each time you select a training for a person. For example, if you hire Abdul Anw h time you train them. Training Record - Upda Client Relations (Enter "a" if yes) Machine Operations Client Relations Receiving (# times trained) Shipping (# times trained)

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

0 0 0 0 0 0 0 ent Headcount and Training Training Costs - Tabl Wkly Pay 1 1 All Areas 1200 2800 1 260 $5,880 $7,480 1 270 $6,060 $7,660 1 290 $6,420 $8,020 3 300 $6,600 $8,200 Production Client 3 320 $6,960 $8,560 $0.00 $0.00 1 330 $7,140 $8,740 Production (# of products) Client (# Bids) (Hire 1, train to 4 Stars) # of Employees At Pay Level Total Cost 1 to 2 Stars Total Cost 1 to 3 Stars

#DIV/0! #DIV/0! 5 340 $7,320 $8,920 2 350 $7,500 $9,100 4 400 $8,400 $10,000 1 410 $8,580 $10,180 6 420 $8,760 $10,360 1 430 $8,940 $10,540 2 440 $9,120 $10,720 2 450 $9,300 $10,900 2 490 $10,020 $11,620 1 500 $10,200 $11,800 1 530 $10,740 $12,340 1 540 $10,920 $12,520 1 700 $13,800 $15,400 1 830 $16,140 $17,740 1 910 $17,580 $19,180 1 950 $18,300 $19,900 Mo

Training Costs Training Receiving Shipping ed?", and "Where Placed" columns) allows for labor cost tracking. Below the main table is an are ust be a lower case "a" ("a", not "A") war into Shipping and train him in turn 7, then train him again in turn 15, you will enter "1" the ate Each Time Trained Machine Operations (# times trained) Client Relations (# times trained) Machine Operations Client Relations Shipping Star Level

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

0 0 0 0 0 0 le Includes Training Cost Plus Salary for 18 Weeks 4800 1600 3600 2000 a $9,480 $6,280 $8,280 $6,680 18 $9,660 $6,460 $8,460 $6,860 ^--# Wks After Training--^ $10,020 $6,820 $8,820 $7,220 $10,200 $7,000 $9,000 $7,400 $10,560 $7,360 $9,360 $7,760 $10,740 $7,540 $9,540 $7,940 Total Cost 1 to 4 Stars Total Cost 2 to 3 Stars Total Cost 2 to 4 Stars Total Cost 3 to 4 Stars If 50 Turn Run, type "a" below If 96 Turn Run, type "a" below

$10,920 $7,720 $9,720 $8,120 $11,100 $7,900 $9,900 $8,300 $12,000 $8,800 $10,800 $9,200 $12,180 $8,980 $10,980 $9,380 $12,360 $9,160 $11,160 $9,560 $12,540 $9,340 $11,340 $9,740 $12,720 $9,520 $11,520 $9,920 $12,900 $9,700 $11,700 $10,100 $13,620 $10,420 $12,420 $10,820 $13,800 $10,600 $12,600 $11,000 $14,340 $11,140 $13,140 $11,540 $14,520 $11,320 $13,320 $11,720 $17,400 $14,200 $16,200 $14,600 $19,740 $16,540 $18,540 $16,940 $21,180 $17,980 $19,980 $18,380 $21,900 $18,700 $20,700 $19,100 ost Likely Scenario of Star Level Hire in S/R & CS

Potential Employees Sorted Alphabetically - For Reference g Level Star Levels at Hiring Potential Hire Weekly Salary Abdul Anwar $ 400 2 2 2 Adrian Garcia $ 340 1 2 2 Aiko Chan $ 500 3 3 3 Aleksander Batalev $ 340 2 2 2 Ali Ismail $ 830 2 2 3 Barrett Martin $ 400 2 2 2 Ben Porter $ 420 2 2 3 Brian Thompson $ 420 2 2 3 Brijo Malik $ 700 1 2 2 Calvin Escobar $ 300 2 2 2 Chip Stafford $ 420 2 2 3 Chris Miller $ 340 1 2 3 Darrel Smith $ 290 1 1 1 David Gao $ 440 3 3 2 Derek Kaiser $ 450 3 3 2 Dewie Frondel $ 540 3 2 4 Drew Rhoades $ 910 1 2 3 Francis Lopez $ 350 1 2 2 Gareth Holmes $ 270 1 2 2 Irwinn Gruppe $ 490 3 3 2 Joe Lopez $ 340 2 1 1 Jonathan Cincade $ 490 2 3 3 Joshua Moore $ 320 1 2 2 Larry Martin $ 340 1 2 2 Marco Andreini $ 320 2 2 2 Mike Peterson $ 420 3 2 3 Ming Zhou $ 450 2 3 1 Normand Hoaglin $ 320 1 2 2 Oliver Stuckey $ 420 2 2 3 Rafferty Lewington $ 260 3 2 2 ea to keep first time Client Relations Star Level Receiving & Shipping Machine Operations Client Relations

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Robert Johnson $ 400 3 2 3 Rolph Jaworski $ 420 2 2 3 Sahil Siddhartha $ 400 2 3 2 Sandeep Patel $ 410 1 2 1 Shea Spradley $ 530 3 3 3 Skippy Winters $ 300 1 1 1 Stasu Malinowski $ 330 1 1 2 Steven Giarman $ 300 3 3 2 Tedmund Guzzetti $ 440 2 3 2 Thomas Potter $ 430 2 3 3 Tom OLeary $ 950 3 2 3 Vishal Prakash $ 350 2 3 1 Median Pay 405 13 4 6 Mode Pay 420 18 26 20 11 12 15 0 0 1 All Areas 600 800 1000 Per Week Cost 1 to 2 Stars Per Week Cost 2 to 3 Stars Per Week Cost 3 to 4 Stars

Receiving and Shipping Client Operations / Customer Service 18 Wks Salary + To 2-Star To 3-Star To 4-Star To 2-Star To 3-Star To 4-Star Shipping 0 1600 3600 0 1600 3600 $ 10,800 1200 2800 4800 0 1600 3600 $ 10,920 0 0 2000 0 0 2000 $ 11,000 0 1600 3600 0 1600 3600 $ 9,720 0 1600 3600 0 0 2000 $ 18,540 0 1600 3600 0 1600 3600 $ 10,800 0 1600 3600 0 0 2000 $ 11,160 0 1600 3600 0 0 2000 $ 11,160 1200 2800 4800 0 1600 3600 $ 17,400 0 1600 3600 0 1600 3600 $ 9,000 0 1600 3600 0 0 2000 $ 11,160 1200 2800 4800 0 0 2000 $ 10,920 1200 2800 4800 1200 2800 4800 $ 10,020 0 0 2000 0 1600 3600 $ 9,920 0 0 2000 0 1600 3600 $ 10,100 0 0 2000 0 0 0 $ 11,720 1200 2800 4800 0 0 2000 $ 21,180 1200 2800 4800 0 1600 3600 $ 11,100 1200 2800 4800 0 1600 3600 $ 9,660 0 0 2000 0 1600 3600 $ 10,820 0 1600 3600 1200 2800 4800 $ 9,720 0 1600 3600 0 0 2000 $ 12,420 1200 2800 4800 0 1600 3600 $ 10,560 1200 2800 4800 0 1600 3600 $ 10,920 0 1600 3600 0 1600 3600 $ 9,360 0 0 2000 0 0 2000 $ 9,560 0 1600 3600 1200 2800 4800 $ 11,700 1200 2800 4800 0 1600 3600 $ 10,560 0 1600 3600 0 0 2000 $ 11,160 0 0 2000 0 1600 3600 $ 6,680 # Wks Salary After Training

0 0 2000 0 0 2000 $ 9,200 0 1600 3600 0 0 2000 $ 11,160 0 1600 3600 0 1600 3600 $ 10,800 1200 2800 4800 1200 2800 4800 $ 12,180 0 0 2000 0 0 2000 $ 11,540 1200 2800 4800 1200 2800 4800 $ 10,200 1200 2800 4800 0 1600 3600 $ 10,740 0 0 2000 0 1600 3600 $ 7,400 0 1600 3600 0 1600 3600 $ 11,520 0 1600 3600 0 0 2000 $ 11,340 0 0 2000 0 0 2000 $ 19,100 0 1600 3600 1200 2800 4800 $ 9,900 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - 0 0 0 0 0 0 $ - <---# at 1 Star <---# at 2 Stars <---# at 3 Stars <---# at 4 Stars

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

18 + Train to 4 Stars Client Relations Shipping Rank $ 10,800 19 26 $ 9,720 23 19 $ 11,000 24 29 $ 9,720 8 19 $ 16,940 39 39 $ 10,800 19 26 $ 9,560 30 15 $ 9,560 30 15 $ 16,200 38 38 $ 9,000 2 4 $ 9,560 30 15 $ 8,120 23 0 $ 10,020 11 22 $ 11,520 10 32 $ 11,700 12 34 $ 9,720 35 19 $ 18,380 41 40 $ 9,900 25 21 $ 8,460 6 2 $ 12,420 20 36 $ 10,920 8 28 $ 10,820 37 27 $ 9,360 15 8 $ 9,720 23 19 $ 9,360 4 8 $ 9,560 5 15 $ 12,900 34 37 $ 9,360 15 8 $ 9,560 30 15 $ 8,280 0 1 Ranking for S/R & Cst Svc Manipulated Ranking Customer Service / Client Relations Rank

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

$ 9,200 3 5 $ 9,560 30 15 $ 10,800 19 26 $ 12,180 36 35 $ 11,540 33 33 $ 10,200 13 23 $ 9,540 16 9 $ 9,000 1 4 $ 11,520 32 32 $ 9,740 31 20 $ 19,100 40 41 $ 11,100 9 30 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

ITCC LOGM267 Materials and Suppliers Information Practice Operations Material Quality by Material By Supplier Material Alpine Freeway Owens Preston Red Maple Reliable Tigerlily United Cotton 25 50 80 35 60 70 Denim 25 50 40 35 70 Khaki 60 50 80 35 70 Nylon 60 50 80 35 70 Silk 50 80 40 35 60 70 Wool 60 25 50 35 60 70 Product Hunting Pants Wool $30.00 Sweaters Wool $20.00 Designer Jeans Denim $30.00 Low Rise Jeans Denim $25.00 Denim Jacket Denim $35.00 Tie Silk $20.00 Graphic T-Shirt Cotton $10.00 Polo Shirts Cotton $15.00 Coaches Jacket Nylon $30.00 Boxer Shorts Silk $15.00 Base Materia l Average Sales Value (Sales Price Per Unit)

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

ITCC LOGM267 Materials and Suppliers Information Practice Operations Sports Shorts Nylon $10.00 Chiffon Dress Silk $50.00 Safari Jacket Khaki $40.00 Colored T-Shirts Cotton $8.00 Slacks Khaki $20.00 Sports Pants Nylon $15.00 Windbreaker Nylon $20.00 Plain T-Shirts Cotton $5.00 Bermuda Shorts Khaki $12.00 Heavy Socks Wool $3.00 Dress Socks Cotton $2.00 White Socks Cotton $1.00

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

ITCC LOGM267 Materials and Suppliers Information Practice Operations Max Quality 80 40 50 70 80 70 40 50 60 70 80 40 50 70 80 80 40 50 70 80 80 40 50 70 80 70 40 50 60 70 Optimal Quality Bid Level Material Quality Level Acceptable Quality Bid Level Material Quality Level

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

ITCC LOGM267 Materials and Suppliers Information Practice Operations

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Customer Profitability and Order Size Analysis Table Practice Operations - Product Gross Profit Reference Table Order Sizes Contract Value Product Hunting Pants Wool $ 30.00 $ 21.08 25 400 250 725 $ 12,000 $ 7,500 $ 21,750 Designer Jeans Denim $ 30.00 $ 25.12 25 800 475 1450 $ 24,000 $ 14,250 $ 43,500 Sweaters Wool $ 20.00 $ 18.98 17 500 300 900 $ 10,000 $ 6,000 $ 18,000 Low Rise Jeans Denim $ 25.00 $ 25.95 25 650 400 1175 $ 16,250 $ 10,000 $ 29,375 Denim Jacket Denim $ 35.00 $ 39.54 17 450 275 800 $ 15,750 $ 9,625 $ 28,000 Tie Silk $ 20.00 $ 10.17 34 950 575 1700 $ 19,000 $ 11,500 $ 34,000 Boxer Shorts Silk $ 15.00 $ 11.30 36 650 400 1175 $ 9,750 $ 6,000 $ 17,625 Graphic T-Shirt Cotton $ 10.00 $ 9.62 17 550 325 1000 $ 5,500 $ 3,250 $ 10,000 Polo Shirts Cotton $ 15.00 $ 15.27 24 850 500 1525 $ 12,750 $ 7,500 $ 22,875 Coaches Jacket Nylon $ 30.00 $ 53.31 24 400 250 725 $ 12,000 $ 7,500 $ 21,750 Chiffon Dress Silk $ 50.00 $ 53.97 36 750 450 1350 $ 37,500 $ 22,500 $ 67,500 Sports Shorts Nylon $ 10.00 $ 11.51 24 750 450 1350 $ 7,500 $ 4,500 $ 13,500 Safari Jacket Khaki $ 40.00 $ 58.30 12 800 475 1450 $ 32,000 $ 19,000 $ 58,000 Slacks Khaki $ 20.00 $ 28.01 50 600 350 1075 $ 12,000 $ 7,000 $ 21,500 Sports Pants Nylon $ 15.00 $ 24.89 34 400 250 725 $ 6,000 $ 3,750 $ 10,875 Colored T-Shirts Cotton $ 8.00 $ 9.83 24 550 325 1000 $ 4,400 $ 2,600 $ 8,000 Windbreaker Nylon $ 20.00 $ 34.71 34 400 250 725 $ 8,000 $ 5,000 $ 14,500 Plain T-Shirts Cotton $ 5.00 $ 8.96 67 850 500 1525 $ 4,250 $ 2,500 $ 7,625 Bermuda Shorts Khaki $ 12.00 $ 25.04 48 550 325 1000 $ 6,600 $ 3,900 $ 12,000 Heavy Socks Wool $ 3.00 $ 6.40 48 450 275 800 $ 1,350 $ 825 $ 2,400 Dress Socks Cotton $ 2.00 $ 5.38 96 800 475 1450 $ 1,600 $ 950 $ 2,900 White Socks Cotton $ 1.00 $ 4.73 96 1000 600 1800 $ 1,000 $ 600 $ 1,800 Base Material Average Sales Value (Sales Price Per Unit) Operating Costs (Receiving / Sorting, Production, Packing / Shipping) Average Number of Bid Opportunities in 48 Weeks Average Order Size Smallest Order Size Largest Order Size Average Contract Value Smallest Contract Value Largest Contract Value

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Customer Profitability and Order Size Analysis Table Practice Operations - Product Gross Profit Reference Table Product Hunting Pants Wool $ 30.00 $ 21.08 Designer Jeans Denim $ 30.00 $ 25.12 Sweaters Wool $ 20.00 $ 18.98 Low Rise Jeans Denim $ 25.00 $ 25.95 Denim Jacket Denim $ 35.00 $ 39.54 Tie Silk $ 20.00 $ 10.17 Boxer Shorts Silk $ 15.00 $ 11.30 Graphic T-Shirt Cotton $ 10.00 $ 9.62 Polo Shirts Cotton $ 15.00 $ 15.27 Coaches Jacket Nylon $ 30.00 $ 53.31 Chiffon Dress Silk $ 50.00 $ 53.97 Sports Shorts Nylon $ 10.00 $ 11.51 Safari Jacket Khaki $ 40.00 $ 58.30 Slacks Khaki $ 20.00 $ 28.01 Sports Pants Nylon $ 15.00 $ 24.89 Colored T-Shirts Cotton $ 8.00 $ 9.83 Windbreaker Nylon $ 20.00 $ 34.71 Plain T-Shirts Cotton $ 5.00 $ 8.96 Bermuda Shorts Khaki $ 12.00 $ 25.04 Heavy Socks Wool $ 3.00 $ 6.40 Dress Socks Cotton $ 2.00 $ 5.38 White Socks Cotton $ 1.00 $ 4.73 Base Material Average Sales Value (Sales Price Per Unit) Operating Costs (Receiving / Sorting, Production, Packing / Shipping) Contract Gross Profit - Forecast - $ Stallion Apparel Taff $ 3,568 $ 2,230 $ 6,468 250 $ 28.50 $ 7,125 26.0% 475 $ 28.50 $ 3,907 $ 2,320 $ 7,082 475 $ 28.50 $ 13,538 11.9% 950 $ 28.50 $ 511 $ 307 $ 920 300 $ 19.00 $ 5,700 0.1% 600 $ 19.00 $ (615) $ (379) $ (1,113) 400 $ 23.75 $ 9,500 -9.3% 775 $ 23.75 $ (2,044) $ (1,249) $ (3,633) 275 $ 33.25 $ 9,144 -18.9% 550 $ 33.25 $ 9,341 $ 5,654 $ 16,715 575 $ 19.00 $ 10,925 46.5% 1150 $ 19.00 $ 2,403 $ 1,479 $ 4,344 400 $ 14.25 $ 5,700 20.7% 775 $ 14.25 $ 208 $ 123 $ 378 325 $ 9.50 $ 3,088 -1.3% 650 $ 9.50 $ (226) $ (133) $ (406) 500 $ 14.25 $ 7,125 -7.1% 1025 $ 14.25 $ (9,324) $ (5,828) $ (16,900) 250 $ 28.50 $ 7,125 -87.1% 475 $ 28.50 $ (2,976) $ (1,786) $ (5,357) 450 $ 47.50 $ 21,375 -13.6% 900 $ 47.50 $ (1,130) $ (678) $ (2,034) 450 $ 9.50 $ 4,275 -21.1% 900 $ 9.50 $ (14,643) $ (8,694) $ (26,540) 475 $ 38.00 $ 18,050 -53.4% 950 $ 38.00 $ (4,806) $ (2,803) $ (8,610) 350 $ 19.00 $ 6,650 -47.4% 725 $ 19.00 $ (3,954) $ (2,471) $ (7,167) 250 $ 14.25 $ 3,563 -74.6% 475 $ 14.25 $ (1,004) $ (593) $ (1,825) 325 $ 7.60 $ 2,470 -29.3% 650 $ 7.60 $ (5,884) $ (3,677) $ (10,664) 250 $ 19.00 $ 4,750 -82.7% 475 $ 19.00 $ (3,368) $ (1,981) $ (6,043) 500 $ 4.75 $ 2,375 -88.7% 1025 $ 4.75 $ (7,170) $ (4,237) $ (13,036) 325 $ 11.40 $ 3,705 -119.6% 650 $ 11.40 $ (1,529) $ (934) $ (2,718) 275 $ 2.85 $ 784 -124.5% 550 $ 2.85 $ (2,703) $ (1,605) $ (4,899) 475 $ 1.90 $ 903 -183.1% 950 $ 1.90 $ (3,728) $ (2,237) $ (6,711) 600 $ 0.95 $ 570 -397.7% 1200 $ 0.95 Average Contract Gross Profit ($) Smallest Contract Gross Profit ($) Largest Contract Gross Profit ($) Averge Order Size Average Ask Price Average Contract Value Average Gross Margin Averge Order Size Average Ask Price

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Customer Profitability and Order Size Analysis Table Practice Operations - Product Gross Profit Reference Table Product Hunting Pants Wool $ 30.00 $ 21.08 Designer Jeans Denim $ 30.00 $ 25.12 Sweaters Wool $ 20.00 $ 18.98 Low Rise Jeans Denim $ 25.00 $ 25.95 Denim Jacket Denim $ 35.00 $ 39.54 Tie Silk $ 20.00 $ 10.17 Boxer Shorts Silk $ 15.00 $ 11.30 Graphic T-Shirt Cotton $ 10.00 $ 9.62 Polo Shirts Cotton $ 15.00 $ 15.27 Coaches Jacket Nylon $ 30.00 $ 53.31 Chiffon Dress Silk $ 50.00 $ 53.97 Sports Shorts Nylon $ 10.00 $ 11.51 Safari Jacket Khaki $ 40.00 $ 58.30 Slacks Khaki $ 20.00 $ 28.01 Sports Pants Nylon $ 15.00 $ 24.89 Colored T-Shirts Cotton $ 8.00 $ 9.83 Windbreaker Nylon $ 20.00 $ 34.71 Plain T-Shirts Cotton $ 5.00 $ 8.96 Bermuda Shorts Khaki $ 12.00 $ 25.04 Heavy Socks Wool $ 3.00 $ 6.40 Dress Socks Cotton $ 2.00 $ 5.38 White Socks Cotton $ 1.00 $ 4.73 Base Material Average Sales Value (Sales Price Per Unit) Operating Costs (Receiving / Sorting, Production, Packing / Shipping) ffy's $ 13,538 26.0% $ 27,075 11.9% $ 11,400 0.1% $ 18,406 -9.3% $ 18,288 -18.9% $ 21,850 46.5% $ 11,044 20.7% $ 6,175 -1.3% $ 14,606 -7.1% $ 13,538 -87.1% $ 42,750 -13.6% $ 8,550 -21.1% $ 36,100 -53.4% $ 13,775 -47.4% $ 6,769 -74.6% $ 4,940 -29.3% $ 9,025 -82.7% $ 4,869 -88.7% $ 7,410 -119.6% $ 1,568 -124.5% $ 1,805 -183.1% $ 1,140 -397.7% Average Contract Value Average Gross Margin

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Practice Operations Decision Tools - Transitional V1 -Fall 2023

Related Documents