Case Project #1

Case Project #1 - Milligan’s Backyard Storage Kits Annual...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Milligan’s Backyard Storage Kits Annual Inventory Analysis February 11, 2008 Group Seven Group #7: Kyle Demeniuk Sara Gugin Erin Prasnjak Austin Rys Case Project #1: Milligan Backyard Storage Kits Information Specifications 1: The items that have a markup price of less than thirty percent are: the 6’ x 6’ Cedar Garden Hut, 8’ x 10’ Aluminum Barn, 12’ x 8’ Double-door Aluminum Shed, 10’ Octagon Cedar Gazebo, 12’ Cedar Octagon Gazebo, 6’ x 10’ Cedar Garden Hut, and the 6’ x 20’ Covered Bridge. A00210 8' x 10' Aluminum Barn 25.00% A00310 12' x 8' Double Door Aluminum Shed 25.00% A00610 10' Octagon Cedar Gazebo 20.00% A00620 12' Cedar Octagon Gazebo 15.76% A00730 6' x 10' Cedar Garden Hut 18.94% A00750 6' x 6' Cedar Garden Hut 8.04% A00810 6' x 20' Covered Bridge 12.08% I.S. 2: In terms of annual sales the 4’ Windmill had the lowest amount of all the products with $9243.99. Item No. Description Annual Sales A00100 8' x 6' Aluminum Shed $99,995.00 A00110 10' x 8' Aluminum Shed $99,996.00 A00120 12' x 20' Aluminum Shed $146,324.25 A00130 6' x 4' Aluminum Shed $125,221.19 A00140 8' x 4' Aluminum Shed $133,461.25 A00150 10' x 14' Aluminum Shed $300,000.00 A00210 8' x 10' Aluminum Barn $212,219.18 A00310 12' x 8' Double Door Aluminum Shed $393,949.94 A00320 16' x 10' Double Door Aluminum Shed $75,362.00 A00410 8' x 10' Wood Barn $563,143.00 A00420 8' x 12' Wood Barn $139,998.60 A00430 10' x 16' Wood Barn $80,624.25 A00510 8' x 10' Picnic Table $129,996.75 A00520 3' by 7' Picnic Table $254,991.50 A00530 8' Child's Picnic Table $55,105.43 A00610 10' Octagon Cedar Gazebo $449,998.50 A00620 12' Cedar Octagon Gazebo $133,808.61 A00710 4' x 6' Cedar Shed $100,000.00 A00720 8' x 10' Cedar Shed $127,724.25 A00730 6' x 10' Cedar Garden Hut $236,250.00 A00740 8' x 10' Cedar Cabana Shed $218,686.64 A00750 6' x 6' Cedar Garden Hut $309,003.50 A00810 6' x 20' Covered Bridge $105,074.25 A00820 8' x 40' Covered Bridge $9,400.00 A00910 Wagon Planter $14,391.00 A00920 Mailbox Planter $23,651.55 A00930 4' Windmill $9,243.99 A00940 6' Windmill $18,345.22 A00950 6' Wishing Well $62,392.20 A00960 12' Wishing Well $28,810.53 Group #7: Kyle Demeniuk Sara Gugin Erin Prasnjak Austin Rys I.S. 3: In terms of annual sales Mr. Milligan’s best selling items were: the 8’ x 10’ Wood Barn with $563,143.00, the 10’ Octagon Cedar Gazebo with $449,998.50, the 12’ x 8’ Double-door Aluminum Shed with $393,949.94, the 6’ x 6’ Garden Hut with $309,003.50, and finally the 10’ x 14’ Aluminum Shed with $300,000.00. Item No. Description Annual Sales A00100 8' x 6' Aluminum Shed $99,995.00 A00110 10' x 8' Aluminum Shed $99,996.00 A00120 12' x 20' Aluminum Shed $146,324.25 A00130 6' x 4' Aluminum Shed $125,221.19 A00140 8' x 4' Aluminum Shed $133,461.25 A00150 10' x 14' Aluminum Shed $300,000.00 A00210 8' x 10' Aluminum Barn $212,219.18 A00310 12' x 8' Double Door Aluminum Shed...
View Full Document

This note was uploaded on 03/30/2008 for the course BIS 255 taught by Professor Bradisphillips during the Spring '08 term at Central Mich..

Page1 / 9

Case Project #1 - Milligan’s Backyard Storage Kits Annual...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online