The Bag Corporation is a distributor of high-end golf bags. In the past, The Bag Corporation produced and sold the golf bags. Over time, they realized it was cheaper to buy the golf bags fully assembled and resell them to the public, therefore eliminating their need for a manufacturing plant. The Bag Corporation pays $80 per golf bag and sells them for $200.

Prepare a 2024 Purchases Budget (for units and cost) for The Bag Corporation. They plan to have 5,000 golf bags on hand at December 31, 2023. The Bag Corporation purchases golf bags once a month and bases their purchase on 95% of the next months projected sales. (In December 2023, The Bag Corporation plans to sell 5,500 golf bags and will purchase 5,700 golf bags [January 2024 projected sales of 6,000 golf bags x 95%]. In January 2024, The Bag Corporation plans to sell 6,000 golf bags and will purchase 5,757 golf bags [February 2024 projected sales of 6,060 golf bags x 95%]).

NOTES:

1. Partial golf bags cannot be purchased or sold; therefore, you should round up and use whole numbers for all budget calculations. 2. Spreadsheet software must be used. Calculations must be done using the spreadsheet software using formulas. Do not plug in numbers.