a. Calculate the budgeted cash disbursements during the month of February. b. Calculate the budgeted cash collection during the month of January c. Calculated budgeted number of units of inventory to be purchased during the month of March Metlock State sells electronic products. The controller is responsible for preparing the master budget and has accumulated the information below for the months of January, February, and March. Balances at January 1 are expected to be as follows: Cash $5,720 Inventories Accounts receivable 432,700 Accounts payable The budget is to be based on the following assumptions: 1 Each month's sales are billed on the last day of the month. Customers are allowed a 3% discount if their payment is made within 10 days after the billing date. Receivables are booked at gross. The company collects 60% of the billings within the discount period, 25% by the end of the month after the date of sale, and 9% by the end of the second month after the date of sale; 6% prove uncollectible. It pays 54% of all materials purchases and the selling, general, and administrative expenses in the month purchased and the remainder in the following month. Each month's units of ending inventory are equal to 130% of the next month's units of sales. The cost of each unit of inventory is $20. 5. 6. Selling, general, and administrative expenses, of which $2,100 is for depreciation, are equal to 15% of the current month's sales. 7. Actual and projected sales are as follows: 2 3. 4. Month Sales November $369,000 12,300 December 378,000 12,600 January 372,000 12,400 February 357,000 11,900 375,000 12,500 March April 381,000 Units $321,800 138,400 12,700

I need answer typing clear urjent no chatgpt used i will give upvotes

Required information [The following information applies to the questions displayed below.] Consider the following narrative describing the process of filling a customer's order at a Starbucks branch: Identify the start and end events and the activities in the following narrative, and then draw the business process model using BPMN: the Starbucks customer entered the drive-through lane and stopped to review the menu. He then ordered a Venti coffee of the day and a blueberry muffin from the barista. The barista recorded the order in the cash register. While the customer drove to the window, the barista filled a Venti cup with coffee, put a lid on it, and retrieved the muffin from the pastry case and placed it in a bag. The barista handed the bag with the muffin and the hot coffee to the customer. The customer has an option to pay with cash, credit card, or Starbucks gift card. The customer paid with a gift card. The barista recorded the payment and returned the card along with the…

how do you calculat mpg in excel?