Question 1 (40 marks) Four grams of copper are need for each water bottle. The cost of copper is $2 per gram. Budgeted production of water bottles is given below by quarters for Year 2 and for the first quarter of Year 3: Year 2 First Second Third Fourth Budgeted production in bottles 120,000 160,000 260,000 180,000 Year 3 First 180,000 Copper is a usual ingredient and it is necessary to carry large inventories as a safety against stock-outs. For this reason, the inventory of copper at the end of a quarter must be of the following quarter's production needs. Some 100,000 grams of copper will be on hand to start the first quarter of Year 2. Required: Prepare a direct materials budget for copper by quarter and in total, for Year 2