put it pdf form or excel

The Bag Corporation is a distributor of high-end golf bags. In the past, The Bag Corporation produce and sold the golf bags. Over time, they realized it was cheaper to buy the golf bags fully assembled a resell them to the public, therefore eliminating their need for a manufacturing plant The Bag Corporation pays $60 per golf bag and sells them for $180. 1. Prepare a 2023 (January - December) Revenue Budget (for units and sales dollars) for T Bag Corporation. They anticipate selling 6,000 golf bags in January 2023 and increasing that number by 1% each month. 2. Prepare a 2023 Purchases Budget (for units and cost) for The Bag Corporation. They pla to have 5,000 golf bags on hand at December 31, 2022. The Bag Corporation purchases go bags once a month and bases their purchase on 95% of the next months projected sales. December 2022, The Bag Corporation plans to sell 5,500 golf bags and will purchase 5,704 golf bags [January 2023 projected sales of 6,000 golf bags x 95%). In January 2023, The B Corporation plans to sell 6,000 golf bags and will purchase 5,757 golf bags (February 202 projected sales of 6,060 golf bags x 95%]). Prepare a 2023 Cash Collections Budget for The Bag Corporation. 70% of The Bag Corporation sales are cash sales and 30% are credit sales. The credit sales are collected tl following month. 3. 4. Prepare a 2023 Operating Expenses Budget for The Bag Corporation. Administrative Expenses are $300,000 per month and are fixed. Marketing Expenses are 4% of the curre month's sales. Storage/Distribution Expenses are $6 per golf bag sold in each month. 5. Prepare a 2023 Cash Disbursements Budget for The Bag Corporation. The Bag Corporation pays for the golf bags on credit but must make full payment within 30 days. Administrative, Marketing and Storage/Distribution expenses are paid in the current month. 6. Prepare a Budgeted Income Statement for the year ended December 31, 2023. 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. 3. You must include a total column for all 12 months for each budget 146 Maphs