Jane and John's Goodie Baskets was a business that catered to university and college students in Southern Ontario that were away at post-secondary school. Jane and John's Goodie Baskets created gift baskets for students that parents, grandparents and friends could send to the students away at school. These unique customized baskets served a unique market niche. Business was growing. Their competitive advantage was response to the customer. They had a very agile operation and could complete orders on short notice. They had 10 people full time who together could do 1300 baskets per week. Their employees were an integral part of Jane and John's Goodie Baskets success, to recognize their commitment employees received quarterly profit sharing cheques. Flexible work schedules were also encouraged because Jane and John's Goodie Baskets recognized that a motivated, fulfilled employee helped to improve customer relations and in turn their collective success and profitability. These employees enjoyed their work so much that employees did not leave and a "waiting list" of sorts was prepared of interested applicants to get a job when one opened. There was not much training required as assembling baskets was pretty easy work and people were trained very quickly. New design ideas came mostly from employees so creativity and an artistic flair were important characteristics for employees. Each employee was paid $14 an hour and benefits added on another 36% for close to a $19/hour wage. Employees could do on average 3.25 baskets per hour. They also had a list of homemakers that were willing to take on making baskets on short notice. Some of these homemakers were on the "waiting list" for jobs. They paid these homemakers $6 per basket. Some of the post-secondary schools had approached Jane and John's Goodie Baskets about raising money for relief efforts in the Philippines after the Typhoon Kammuri. They were willing to assemble baskets and the wages they were paid were going to be donated to the Red Cross. They would put a team together on short notice and assemble the baskets in the school gym. They would include a note in each assembled basket about the donation to Red Cross Relief Efforts. They had a newer facility that had 2000 square feet. Of that, 1000 feet was storage space, 500 square feet was office space and 500 square feet was assembly space. The storage space could hold about 7000 baskets. It costs $2 per basket per semester to hold inventory in the warehouse. At times when inventory is higher than 7000, it costs an extra $600 for every 1000 extra baskets to store offsite per semester. The offsite warehouse requires a minimum amount of space to be rented. This means increments of 1000 baskets, as an example 2000 baskets, the cost would be $1200. Jane and John's Goodie Baskets was approaching another year-end. It was time to review what had happened over the past year and set a budget for the next fiscal year. The company had one major product family which was Baskets.05- Bill of Material Form (12 marks) a) Prepare a bill of material for each end item. Continue on to prepare a master production schedule by end item for the months of September and October which are both 4 week months. Prepare a Material plan for component parts and include procurement lead-time where applicable. Include crew size required. (9 marks) b) When would the first parts need to be received at Jane and John's Goodie Baskets facility (1 mark)? c) How many people in total would be required for final assembly? Do you see a problem based on the case information? Hint- do not use regular rounding rules here, give me a well thought out answer. (2 marks)Part # 1561- Exam Care Package Parts List Item # Part # Lead Time Unit UOM Part Description Proc Qty Cat. 1 1000 1 1 Set Packaging Assembly P 2 1200 1 3 Each Red Bull P 3 1300 2 1 Each Starbucks Gift Card $25 P 4 6000 2 2 Each Toblerone Chocolate Bar P Part # 4575- We Miss You Package Parts List Item # Part # Lead Time Unit UOM Part Description Proc Qty Cat. 1 1000 1 1 Set Packaging Assembly P 2 3000 1 1 Each No Frills Gift Card $25 P 3 3100 2 3 Each Apples P 4 6000 2 2 Each Toblerone Chocolate Bar P Part # 1234 Let Them Down Gently (Break up) Parts List Item # Part # Lead Time Unit UOM Part Description Proc Qty Cat. 1 1000 1 Set Packaging Assembly P 2 2100 1 2 Each Tissue P 3 6000 2 3 Each Toblerone Chocolate Bar P 4 5200 3 2 Each Breath Mints P 5 1800 2 1 Each LCBO Gift Card $10 P Assembly Time per Basket The internal procurement lead time IS Exam Care Package 0.3 hours 1) 1 week PR/PO We Miss You Package 0.25 hours 2) as per BOM Let Them Down Gently (Break up) Package 0.40 hours 3) 1 week ship/receive Parts need to be in stock one-week before assembling kits. Baskets are shipped as they are made, so no shipping set back is required. Use MTS for Order Number The company works a 40 hour week, 50 weeks of the year