Final answer:
To calculate Cherboneau Novelties' targeted coaster production for the coming year, add expected sales to desired ending inventory and subtract initial inventory to get 620,000 units. To find the needed cork purchase, consider units to produce, cork per unit, and adjust for beginning and ending inventory, which results in a requirement of 321,250 pounds of cork.
Step-by-step explanation:
Calculating Production and Cork Requirements
To compute the total targeted production of finished coasters for the coming year (year 1), we need to account for expected sales and desired ending inventory. The formula is: Targeted Production = Expected Sales + Ending Inventory - Beginning Inventory. Expected sales for year 1 are 572,000 units. The ending inventory for each month should be equal to the next month's sales, which means the ending inventory for year 1 should be the same as the sales for the first month of year 2. Since sales are evenly distributed, the first month of year 2 is 1/12 of the annual sales for year 2, so the target ending inventory for year 1 is 816,000 units / 12 = 68,000 units. However, the expected beginning inventory is only 20,000 units. Therefore, the targeted production for the coming year is 572,000 + 68,000 - 20,000 = 620,000 units.
The formula to compute the required amount of cork to be purchased for the coming year is: Required Cork Purchase = (Units Production Requirement x Cork Per Unit) + Ending Cork Inventory - Beginning Cork Inventory. Each unit requires 0.5 pounds of cork, and the target ending cork inventory is half of the next month's sales requirement. Thus, 620,000 units x 0.5 pounds/unit = 310,000 pounds of cork needed for production. The target ending cork inventory for year 1 should be half of the first month's sales for year 2 in cork weight, which equates to (816,000 units / 12) x 0.5 pounds/unit = 34,000 pounds. The beginning cork inventory is 22,750 pounds. Hence, the required cork purchase for the coming year is 310,000 + 34,000 - 22,750 = 321,250 pounds of cork.