Assume that 5til water Designs produces two automotive subwoofers: 5121.7 and $1215. The 51217 selis for $475, and the 5121.5 selis for $300. Projected sales (number of spenkers) for thi coming fwe quarters are ss follows: The vice president of sales believes that the projected sales are reslistic and can be achieved by the company. Sthwater Designs needs a production bodget for each prodoct (represeming the amount that must be outsourced to outside manufacturers). Beginning inventory of 512L7 for the first quarter of 20y1 was 340 boxes. The companys policy is to have 20% of the next quarter's sales of 512L7 in ending inventory. Beginning inventory of S12L5. was 170 boxes. The company's policy is to have 30% of the next quarter's sales of 51245 in ending inventory. Required: Prepare a production budget for esch quarter for 20Yl. and for the year in total. Assume that 5til water Designs produces two automotive subwoofers: 5121.7 and $1215. The 51217 selis for $475, and the 5121.5 selis for $300. Projected sales (number of spenkers) for thi coming fwe quarters are ss follows: The vice president of sales believes that the projected sales are reslistic and can be achieved by the company. Sthwater Designs needs a production bodget for each prodoct (represeming the amount that must be outsourced to outside manufacturers). Beginning inventory of 512L7 for the first quarter of 20y1 was 340 boxes. The companys policy is to have 20% of the next quarter's sales of 512L7 in ending inventory. Beginning inventory of S12L5. was 170 boxes. The company's policy is to have 30% of the next quarter's sales of 51245 in ending inventory. Required: Prepare a production budget for esch quarter for 20Yl. and for the year in total