Based on the scenario provided, estimate project costs for a Family Garden Project. Your assignment should include the following:

1. Develop cost estimates using a bottom-up estimating technique.
2. aggregated budget for each level (three of them) in the WBS.
3. similar to Exhibit 10.9 in the text using the work packages for the Family Garden Project.

Hint: Submit one MS Excel document for each of the three problems in this assignment. Within each MS Excel document, use multiple tabs to present your results.

Tiller Honda Tillers . Perfect for tilling small areas around the garden Protective front engine guard Reinforced engine bed and handlebar . Commercial-grade fenders; 3-position handle Engine: 5.5 HP Speed: 78 RPM GO Tilling Width: 26.4" Fuel Capacity: 2.8 qt Safety Requirements: Always wear eye protection and safety gloves. See operator's manual. Reference photo and specifications take from: http://www.homedepot.com/c/lawn rental equipment#row3 * estimated 49.95 for 8 hour rentalEstimated Labor Estimated Estimated Estimated Level 2 Cost WBS ID# Task Name Description of Work Responsible Person Acceptance Criteria Garden Plot Preparation Resources Required (Hours) Labor Cost Jill (Sponsor) Activities Design garden, acquire HOA approval, purchase Material Cost (Labor plus Material) See WBS Dictionary Tab 1.1 See WBS Dictionary Tab 1.1 materials, rent equipment, and prepare soil for See WBS Dictionary Tab 1.1 1.1 planting. 1.2 crop Planting and Maintenance Planting and maintenance of crop. ill (Sponsor) See WBS Dictionary Tab 1.2 See WBS Dictionary Tab 1.2 See WBS Dictionary Tab 1.2 1.3 Crop Harvest Harvest and delivery produce to home. Jack (PM) See WBS Dictionary Tab 1.3 see WBS Dictionary Tab 1.3 See WBS Dictionary Tab 1.3 1.4 Garden Plot Winterization Preparation of garden plot for winter. ack (PM) See WBS Dictionary Tab 1.4 See WBS Dictionary Tab 1. See WBS Dictionary Tab 1.4 1.5 Project Management Deliverables associated with management of the Jill (Sponsor) See WBS Dictionary Tab 1.5 See WBS Dictionary Tab 1.5 See WBS Dictionary Tab 1.5 project Votes and Assumptions: 1. Items cost is calculated upon consumption. If the item has a useful life it's cost is calculated upon first use and not calculated again. 2. Basic items like paper and pencil are assumed to be owned before project. Other large items are noted if they are owned by the family before undertaking the Garden Project |3. Gasoline is calculated at $4.00 Per Gallon 4 . Water is calculated 2.00 Per Gallon but is not constrained by the $250.00 budget cap because it worst case drought condition. 5. Tiller is assumed to cost 49.95 to rent based on internet search. Price varies. See Part 2 Attachment for constraints and background information (Click)WBSID# Task Name Description of Work Responsible Person Acceptance Criteria Deliverable(s) Activities Materials Required Resourced Assigned Adult = $8 Estimated Estimated Estimated Activity Child = $2 La Labor (Hours) Labor Cost Material Cost 1. Research Garden Design Internet ( No Cost) 8.00 $ 16.00 imensions and location of garden must 1. Sketch of Garden 2. Sketch Garden Location and Size Pencil and Paper Jill $ 8.00 2 5 16.00 5 1.1.1 Garden Plan Plan the location, size, and design Jill (Sponsor) meet site constraints the non sell ace 2. List of Desired Vegetables nternet (No Cost must meet family member requirements ; (click for Vegetableslist) Pencil and Paper Jill $ 8.00 5 16.00 Information from Henrick Gibbons 3. Information from Henrick Gibbons (Garden Shop Owner) $ 8.00 4. Consult Henrick Gibbons Pencil and Paper 5 8.00 5 . Submit draft garden desig envelope and Stamp (Owned) Jill $ 8.00 0.5 5 4.00 5 2 . Revise and Re-submit Get approval from Ms. Setback of Envelope and Stamp (Owned) Jill $ 8.00 1 5 8.00 5 1.1.2 HOA Plan Approval Written Approval of Garden and Location of location amtired Gift setback. Jill (Sponsor) Garden from HOA (Ms. Setback) 1. Written Approval of garden 3. Obtain Written Approval from Ms Setback Jill $ 8.00 0.25 5 2.00 5 5 - 0 5 1. Generate list of items needed Pencil and Paper Jack $ 8.00 5 8.00 5 obtained all items needed for construction | 1. List of items required for the garden 2 . Driveto Store Gas (1/2 Gallon) Jack $ 8.00 0.5 2.00 1.1.3 Procurements urchase seeds and other gardening ( Materials) essentials from local store Jack (PM and maintenance of the garden project are 3. Purchase Items purchased Click for Garden Supply List) Material cost calculated on consumption) Jack $ 8.00 2. Items required for the garden 1 5 8.00 5 4. Drive Home Gas (1/2 Gallon) Jack $ 8.00 0.5 4.00 5 2.00 6.00 5. Unpackitems Items shack 5.00 5.00 1. Driveto Store Gas (1/2 Gallon) Jack 8.00 0.5 5 4.00 5 2.00 6.00 2 . Sign Rental Contract Pen Jack 5 8.00 0.5 4.00 5 Jack ( PM ) Obtain a rotary tiller from store to till 4.00 1.1.4 Equipment Rental Rent Gasoline Powered Rotary Tiller garden soil for one day 1. Rotary Tiller . Load Tiller Rotary Tiller Jack 5 8.00 0.5 4.00 5 49.95 53.95 . Drive Home as (1/2 Gallon) Jack $ 8.00 0.5 4.00 2.00 6.00 5. Unload Tiller Lavern 5.00 5.00 1. Mark garden area with paint Paint (click for Garden Supply List) Jack 8.00 0.5 4.00 5 5.27 9.27 2. Mow Area Mower(Owned) and Gas (1/4 Gallon) 1. Prepared Garden for Planting Jack $ 8.00 0.5 4.00 5 1.00 5.00 1.1.5 Site Preparation Mow, clear and remove rocks, and til garden area to prepare for planting. Jack (PM) Mowed, cleared of rocks, and tilled garden area and erected fencing. 3. Remove Rocks from Area Jack 5 8.00 0.5 5 400 5 4.00 3. Till Area Rented Equipment (see 1.1.4) and Gas (1/4 Gallon) Jack 8.00 1.00 5 9.00NBS ID# Task Name Description of Work esponsible Person Acceptance Criteria Deliverable (s) Activities Materials Required Resourced Assigned Pay Rate Adult = $8 Estimated Estimated Estimated Estimated Activity Child = $2 Labor (Hours) Labor Cost Material Cost Cost 1. Install Fence encing (click for Garden Supply List) Jack 8.00 8.00 5 29.85 5 37.85 1.2.1 Garden Fencing Erect small fence to keep pests out of the Jack (PM) Fence is erected and stable. Probably garden designed to keep out small varmints. 1. Fence 1. Look at Sketch Sketch of Garden Shirley 200 $ 2.50 5 Plant seeds according to instructions on 2. Plant seeds in ground Hand Rake and Garden Spade (click for Garden 2.50 package and according to garden Jill (Sponsor) Seeds are planted per instruction on package 2:00 25.88 5 1.2.2 Crop Seeding following the design of the garden 1. Seeded Garden Seeds (see Vegetables List) Shirley $ 10.00 5 54.49 Hose and Sprayer (click for Garden Supply List) designed according to design 3 . Water garden 20.61 Water (2 Gallons of Water) Shirley 2.00 0.5 $ 1.00 5 4.00 30.96 S 1. Spray insecticides on plants Insecticide (click for Garden Supply List) Jill Lavern 2:00 $ 180.00 5 23.88 5 203.88 Crop Insect Spray insecticide on plants over the 1.2.3 Management growing Season (Once A Week From July Jill ( PM) 1st to October 26th) (18 times) Insecticides sprayed on plants in garden 1. Insect free garden . Remove weeds from garden gloves and Garbage Bags (click for Garden Supply List Sack 8 108 18 $ 180.00 5 10.07 5 190.07 1.2.4 Crop Weed Remove weeds from garden area to Management nsure crop success (Once A Week From Jack (PM) July 1st to October 26th) (18 times) Weeds removed from garden 1. Weed free garden 1. Water and Fertilize Garden Fertilizer and Fertilizer Sprayer (click for Garden Supp Lavern later (2 Gallons of Water per time; total of 108 Gallon Shirley 356.04 Water and Water and Fertilize Garden (3 Times A 1.2.4 Fertilizer Week From July 1st to October 26th) (27 1. Watered Garden Management Jack (PM) Garden is adequately watered and fertilized times) 2. Fertilized GardenWBS ID# Task Name Description of Work Responsible Person Acceptance Criteria Deliverable(s) Pay Rate Activities Materials Required Resourced Assigned Adult = $8 Estimated Estimated Estimated Estimated Activity Child = $2 abor (Hours) Labor Cost Material Cost Cost 1. Collect Vegetables Gloves, Shears and Basket (click for Jill 8.00 Garden Supply List) Lavern S 2.00 $ 40.00 $ 15.91 $5.91 Harvest the vegetables as they are egetables are removed from 8.00 0 the plant in a safe and 1.3.1 Crop Harvest ipened and ready to be consumed 1. Vegetables in basket Occurs 4 Times from July, August, Jill (Sponsor) effective manner that insures S 8,00 0 September and October the quality of the vegetables and the plant S 8.00 0 S - 0 S 1. Deliver vegetables Gloves, Shears, and Basket (click for Jill 8.00 Garden Supply List) Shirley S 2.00 $ 40.00 $ 40.00 Harvested vegetables are delivered to 1.3.2 1. Vegetables in home 0 $ $ Crop Delivery | the home. Occurs 4 Times from July, Jill (Sponsor) Vegetables moved to the August, September and October home for consumption 0 $WBS ID# Task Name Description of Work Responsible Person Acceptance Criteria Deliverable ( s ) Activities Materials Required Pay Rate Estimated Resourced Assigned Adult = $8 Estimated | Estimated Estimated Activity Child = $2 (Hours) Labor Cost Cost Cost 1 . Pull out fence around garden Gloves (click for Garden Supply List) Jack $ 8.00 1 Laver $ 10.00 $ 2.00 10.00 2. Clean and store fence Gloves (click for Garden Supply List) Jack 8.00 0.5 ence removed from the garder 1. Fence free garden Shirley $ 2.00 0.5 $ 5.00 5 5.00 1.4.1 Fence Removal Remove the fence around the garden to prepare for winterization Jack (PM) area and saved for the next growing season . 0 1. Removing vegetables Gloves, Shears, and Basket (click for Garden Supply. Jack 2 8.00 LIST Shirley 5 2.00 $ 10.00 $ 10.00 2. Remove Plants Gloves, Shears, and Garbage Bag (click for Garden s Remove any remaining vegetables and $ 10.00 $ All plants and vegetables have 1. Ground that is free from Supply List) Shirley S 10.00 1.4.2 Vegetable Removal then remove all the plants from the Jack (PM) been removed from the garden plants and ready for winter garden areaWBS ID# Task Name Description of Work Responsible Person Acceptance Criteria Deliverable(s) Activities Materials Required Pay Rate Estimated Estimated Estimated Resourced Assigned Adult = $8 Labor Estimated Activity Child = $2 ( Hours) Labor Cost Material Cost Cost 1. Gather all stakeholder requirements and create scope statement $ 8.00 1 8.00 $ Create baselines for the Project plan addressed all elements 1. Project Management Plan that 2. Complete bottom-up cost estimate 8.00 Jack $ 8.00 1 $ 8.00 5 1.5.1 Project Plan Scope, Budget, and Schedule or scope, budget, schedule, and risk includes: 1) scope statement, 2) PMBOK Se , Office Eq 8.00 and identify any risks and ack (PM) planning in accordance with the budget baseline, 3) schedule baseline , and 4 ) risk re 3. Develop Project Schedule as Gantt chart Supplies; they may be addressed. PMBOK 5e Jack $ 8.00 1 $ 8.00 $ management plan 8.00 4. Develop risk register and Risk Management Plan Jack $ 8.00 8.00 5 8.00 1. Hold Kick Off Meeting All $ 20.00 0.5 $ 10.00 5 10.00 2 . Assign roles 1.5.2 Project Kick-Off Hold Kick Off Meeting (June Meeting is held; 100% attendance; All 15th) roles are assigned; sch 1. Meeting Minutes for Kick Off $ 20.00 0.5 $ 10.00 5 ack (PM) understood Meeting 3. Distribute Schedule 10.00 All $ 20.00 0.5 $ 10.00 5 10.00 All 4. Record meeting minutes Pen and Paper $ 20.00 0.5 $ 10.00 5 10.00 $ 1. Hold Progress Meeting All $ 20.00 1.5 $ 30.00 5 30.00 ALL 1.5.3 Project Progress Hold a Progress Meeting (3 2. Record Meeting Minutes Pen and Paper Meetings times ) July 1 st, August 15th , Meeting is held; 100% attendance; 1 . Meeting Minutes for Progress $ 20.00 1.5 $ 30.00 5 ack (PM) 30.00 and October 1st. Progress is updated Meetings $ 1. Hold Progress Meetings All $ 20.00 0.5 5 10.00 $ . Record Meeting Minutes 10.00 Project Closeout - Hold Project Closeout Pen and Paper All 1.5.4 Lessons Learned Jack (PM) Meeting is held; 100% attendance; 1. Meeting Minutes for Closeout $ 20.00 0.5 5 10.00 5 10.00 Meeting Meeting ( November 7th) Project success is discussed Meeting S S 0Vegetable List Vegetable Seed Packs Seed Cost (per Pack) Seed Cost Reference Link 1 Green Beans 0.79 $ 3.16 http://www.homedepot.com/p/Burpee-Bean-Bush-Snap-Stringless-Green-Pod-Seed-56473/100390226 2 Carrots 0.94 $ 2.82 http://www.homedepot.com/p/Burpee-Carrot-Short-N-Sweet-Seed-66654/100390978 Corn 1.24 $ 7.44 http://www.homedepot.com/p/Bur Corn-White-Butter-Cream-Hybrid-WP-Seed-59744/204729810 Tomatoes 5 0.94 $ 4.70 http:/www.homedepot.com/p/Burpee-Tomato-Roma-Organic-Seed-60708/204729793 Peppers 0.83 $ 2.49 Total 21 $ 20.61Garden Supply List # Item Quantity Cost PerItem Total Reference Link 1 Marking Paint $ 5.27 $ 5.27 http://www.homedepot.com/p/Rust-Oleum-Professional-15-oz-Flat-Fluorescent-Green-Inverted-Marking-Paint-207464/100123129 Hand Rake 5.97 $ 11.94 http://www.homedepot.com/p/Fiskars-12-25-in-Softouch-Hand-Cultivator-706469351/20268153 Garden Spade 5.97 $ 11.94 http:/www.homedepot.com/ and-Transplanter-70636935J/202681519 4 Hose 50ft 19.97 $ 19.97 http://www.hom m/p/Miracle-Gro-Element-Soaker-PRO-3-8-in-x-50-ft-Advance-Hose-MGCPA38050FM/204298325 5 Spray Nozzle 5.99 $ 5.99 http:/www.homedepot.com/p/Melnor-Mid-size-metal-multi-pattern-gun-1151-10/203136370 6 Fertilizer 10.78 $ 21.56 http://www.homede om/p/Miracle Purpose-Plant-Food-1001232/100035250 7 Fertilizer Sprayer 0.48 $ 10.48 http:/www.homedepot.com/p/Miracle-Gro-Next-Generation-Garden-Feeder-100410/100464913 8 Fence 50ft 5.97 $ 29.85 http:/www.homedepot.com/p/Unbranded-18-in-x-10-ft-Cathedral-Folding-Fence-21900/100538371 9 Seeds by list (see Vegetables List) 20.61 $ 20.61 |see Vegetable List 10 Insecticide 5.97 $ 23.88 http://www.homedepot.com/p/Ortho-32-oz-Flower-Fruit-and-Vegetable-Insect-Killer-0331320/202601868 11 Gloves 1.97 $ 7.88 http://www.homedepot.com/p/West-Chester-Split-Leather-Palm-with-Canvas-Back-Large-Work-Gloves-HD71020-LEPP$72/100196984 12 Basket 2.47 $ 4.94 http://www.homedepot.com/p/Total-Pond-10-in-Square-Plant-Basket-A16501/202290235 13 Garbage Bag 2.19 $ 2.19 http://www.homedepot.com/p/Ultrasac-39-gal-Lawn-and-Leaf-Trash-Bags-6-Count-39100806/204859956 14 Shears 10.97 $ 10.97 http://www.homedepot.com/p/Fiskars-Softouch-Bypass-Pruner-792369661/100117986 Total $ 187.47Level 1 Level 2 Level 3 Dates 1 - Family Garden 1.1 - Garden Plot Preparation 1.1.1-Garden Plan February 1.1.2- HOA Plan Approval March 1.1.3 - Procurements (Materials May 1.1.4- Equipment Rental June 1.1.5-Site Preparation June 1.2 - Crop Planting and Maintenance 1.2.1 - Garden Fencing April 1.2.2 - Crop Seeding June 1.2.3 - Crop Insect Management (18 times) June, July, August, September, and October 1.2.4 - Crop Weed Management (18 Times) June, July, August, September, and October 1.2.5- Water and Fertilizer Management (27 Times June, July, August, September, and October 1.3 - Crop Harvest 1.3.1 - Crop Harvest (4 Times) July, August, September, and October 1.3.2 - Crop Delivery (4 Times) July, August, September, and October 1.4 - Garden Plot Winterization 1.4.1 - Fence Removal October 1.4.2 - Vegetables Removal October 1.5 - Project Management 1.5.1 - Project Plan January 1.5.2-Project Kick-off June 15th 1.5.3 - Project Progress Meetings (3 Times) July 1st, August 15th, and October 1st 1.5.4- Project Closeout - Lessons Learned Meeting November 7th Notes and Assumptions 1. Level 3 tasks 1.2.3, 1.2.4, 1.2.5, 1.3.1, and 1.3.2 will occur during the growing and harvest season from June 15th till October 31 as required. Given the weather and growing conditions may change they may be done more or less frequently.EXHIBIT 10.9 AGGREGATION OF PROJECT BUDGET FEB MAR APR MAY JUN WP 1221 WP 1222 WP 1231 WP 1232 WP 1233 WP 1241 WP 1221 ($10,000) $10,000 WP 1222 ($10,000) $5,000 $5,000 WP 1231 ($45,000) $15,000 $30,000 WP 1232 ($20,000) $20,000 WP 1233 ($15,000) $15,000 WP 1241 ($20,000) $10,000 $10,000 Cost per month $15,000 $20,000 $50,000 $25,000 $10,000 Cumulative cost $15,000 $35,000 $85,000 $110,000 $120,000 $120K $100K $80K $60K $40K $20K 0