Budget Project Welcome to Desire, Incl You have just been hired as the managerial account for the newly formed Desire, Inc. Desire will begin operations on October 1st Year 1 (ie, they did not exist before this date). Desire is a merchandising company that retails sporting goods. Your job is to prepare a master budget for Desire for the quarter consisting of October, November, and December Year 1. As part of the budgeting process, you will need to complete the following budget schedules for each of the three months of the quarter: a. Sales Budget b. Schedule of Cash Receipts C. Inventory Purchases Budget d. Schedule of Cash Payments for Inventory Purchases e. Selling and Administrative Expense Budget f. Schedule of Cash Payments for Selling and Admin. Expenses g. Cash Budget h. Pro-forma Income Statement i. Pro-forma Balance Sheet Desire anticipates total sales to be $295,000 for October. o 40% of sales made each month are cash sales. The rest of sales are made on account (Accounts Receivable). O Total sales are expected to increase each month by 17%. O Cash from cash sales is collected immediately in the month of the sale). All cash from sales made on account is collected in the month following the sale. o Desire predicts that total sales in January of Year 2 will be $246,000. Desire anticipates Cost of Goods Sold for each month to be 72% of total sales for that month. o Desire requires that ending inventory for each month be 20% of the next month's expected cost of goods sold. o Because Desire is set to begin operations on October 1", they did not have any beginning inventory at the beginning of October. Desire makes all their inventory purchases on account. They will pay for 35% of inventory purchases in the month of purchase, and they will pay for the rest (65%) in the month following the purchase. Selling and Administrative Expenses are as follows: O Total salaries expense is $25,000 each month, and Desire pays this expense in the month it is incurred o Desire has a sales commission expense equal to 3% of total sales for the month. They do not pay their salespeople the commission until the month following when the sales are made. Supplies expense is 2% of total sales for the month and is paid for in the month of the sale. Utilities expense is expected to be $2,250 each month. Utilities are not paid until the month after the expense is incurred